odbtools/odbctest/mql/basic/36prepare/13int.mql

select count(*) as count from /test/prepare where v_int = 1
/**
matchcount("count", 3, 1)
**/
;

select count(*) as count from /test/prepare where v_int > 0
/**
matchcount("count", 3, 1)
**/
;

select count(*) as count from /test/prepare where v_int < 2
/**
matchcount("count", 3, 1)
**/
;

select count(*) as count from /test/prepare where v_int >= 1
/**
matchcount("count", 3, 1)
**/
;

select count(*) as count from /test/prepare where v_int <= 1
/**
matchcount("count", 3, 1)
**/
;

select count(*) as count from /test/prepare where v_int >= 1.1
/**
matchcount("count", 0, 1)
**/
;

select count(*) as count from /test/prepare where v_int > 1
/**
matchcount("count", 0, 1)
**/
;