odbtools/odbctest/mql/aaa/12search/15between.mql

-- ============================================================
-- Between 查询测试
-- ============================================================

-- 1. int between
select * from /test/aaa/test_search where s_int between 10 and 30
/**
output()
match("search_int_001")
match("search_int_002")
match("search_int_003")
**/
;

-- 2. int between 边界
select * from /test/aaa/test_search where s_int between 50 and 60
/**
output()
match("search_int_004")
match("search_int_005")
**/
;

-- 3. float between
select * from /test/aaa/test_search where s_float between 10.0 and 30.0
/**
output()
**/
;

-- 4. double between
select * from /test/aaa/test_search where s_double between 0.001 and 10.0
/**
output()
**/
;

-- 5. bigint between
select * from /test/aaa/test_search where s_bigint between 100 and 500
/**
output()
**/
;

-- 6. timestamp between
select * from /test/aaa/test_search where s_ts between 1700000000000 and 1720000000000
/**
output()
**/
;

-- 7. between 无匹配
select * from /test/aaa/test_search where s_int between 9999 and 99999
/**
output()
count(0)
**/
;