odbtools/odbctest/mql/test/mpartition/3.valid.mql

-- { sleep(3s) }
;

select * from /test/mpartition refresh
-- { output() count(3) matchcount(mv_varchar, 1, v_text, "hello word 2003 123-456-789 中华人民共和国是中国的唯一合法政府，台湾是中国一部分。  Mercury\u002c Venus2，Earch%。Mars$Uranus CeresAndJupiterOrSaturn #Neptune Pluto_Charon\"\\\"\"", 1)}
;

select count(*) as count from /test/mpartition where v_int = 1
-- { equal(0,count,3) }
;

select count(*) as count from /test/mpartition where v_int > 0
-- { equal(0,count,3) }
;

select count(*) as count from /test/mpartition where v_int < 2
-- { equal(0,count,3) }
;

select count(*) as count from /test/mpartition where v_int >= 1
-- { equal(0,count,3) }
;

select count(*) as count from /test/mpartition where v_int > 1
-- { equal(0,count,0) }
;

select count(*) as count from /test/mpartition where v_bool = true
-- { equal(0,count,2) }
;

select count(*) as count from /test/mpartition where v_bool = false
-- { equal(0,count,1) }
;

select count(*) as count from /test/mpartition where v_float >= 1.1
-- { equal(0,count,3) }
;

select count(*) as count from /test/mpartition where v_float > 1
-- { equal(0,count,3) }
;

select count(*) as count from /test/mpartition where v_float = 1.1
-- { equal(0,count,3) }
;

select count(*) as count from /test/mpartition where v_float < 2
-- { equal(0,count,3) }
;


select count(*) as count from /test/mpartition where v_float <= 1.1
-- { equal(0,count,3) }
;



select count(*) as count from /test/mpartition where v_double >= 1.1234567890123456
-- { equal(0,count,3) }
;


select count(*) as count from /test/mpartition where v_smalldouble >= 1.123456
-- { equal(0,count,3) }
;

select count(*) as count from /test/mpartition where v_double > 1
-- { equal(0,count,3) }
;

select count(*) as count from /test/mpartition where v_double = 1.1234567890123456
-- { equal(0,count,3) }
;

select count(*) as count from /test/mpartition where v_double < 2
-- { equal(0,count,3) }
;

select count(*) as count from /test/mpartition where v_double <= 1.1234567890123456
-- { equal(0,count,3) }
;


select count(*) as count from /test/mpartition where v_text='*hell*'
-- { equal(0,count,1) }
;

select count(*) as count from /test/mpartition where v_text='*20*'
-- { equal(0,count,1) }
;

select count(*) as count from /test/mpartition where v_text='*123-456*'
-- { equal(0,count,1) }
;

select count(*) as count from /test/mpartition where v_text='*中*'
-- { equal(0,count,1) }
;

select count(*) as count from /test/mpartition where v_text='*magni*'
-- { equal(0,count,1) }
;


select count(*) as count from /test/mpartition where v_text='hello'
-- { equal(0,count,1) }
;

select count(*) as count from /test/mpartition where v_text='2003'
-- { equal(0,count,1) }
;

select count(*) as count from /test/mpartition where v_text='123-456-789'
-- { equal(0,count,1) }
;

select count(*) as count from /test/mpartition where v_text='中国'
-- { equal(0,count,1) }
;

select count(*) as count from /test/mpartition where v_text='magnitude'
-- { equal(0,count,1) }
;