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

select id,v_int,v_bigint,v_float,v_double,v_varchar from /test/cacheonly
/**
output()
count(4)
**/
;

select id,v_int,v_bigint,v_float,v_double,v_varchar from /test/cacheonly where v_int between 1 and 4
/**
output()
count(4)
**/
;

select id,v_int,v_bigint,v_float,v_double,v_varchar from /test/cacheonly where v_int between 1 and ?
/**
output()
params(4)
count(4)
**/
;

select id,v_int,v_bigint,v_float,v_double,v_varchar from /test/cacheonly where v_int between ? and 5
/**
output()
params(1)
count(4)
**/
;

select id,v_int,v_bigint,v_float,v_double,v_varchar from /test/cacheonly where v_int between ? and ?
/**
output()
params(1,5)
count(4)
**/
;