odbtools/odbctest/mql/basic/10basic/17.int.mql

select v_varchar, v_text, v_int from /test/basic limit -1
/**
output()
count(3)
**/
;

select * from /test/basic where v_int = 1
/**
count(3)
**/
;

select * from /test/basic where v_int > 0
/**
count(3)
**/
;

select * from /test/basic where v_int < 2
/**
count(3)
**/
;

select * from /test/basic where v_int >= 1
/**
count(3)
**/
;

select * from /test/basic where v_int <= 1
/**
count(3)
**/
;

select * from /test/basic where v_int >= 1.1
/**
count(0)
**/
;

select * from /test/basic where v_int > 1
/**
count(0)
**/
;