odbtools/odbctest/mql/basic/11cncachedb/36between.mql

select id,整数,大整数,浮点,自定义类型,字符串 from /test/测试缓存库 where 整数 between 1 and 5
/**
output()
count(5)
**/
;

select id,整数,大整数,浮点,自定义类型,字符串 from /test/测试缓存库 where 整数 between 1 and ?
/**
output()
params(1)
count(4)
**/
;

select id,整数,大整数,浮点,自定义类型,字符串 from /test/测试缓存库 where 整数 between ? and 5
/**
output()
params(5)
count(1)
**/
;

select id,整数,大整数,浮点,自定义类型,字符串 from /test/测试缓存库 where 整数 between ? and ?
/**
output()
params(1,5)
count(5)
**/
;