odbtools/odbctest/mql/basic/10memdb/36between.mql

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

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

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

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