odbtools/odbctest/mql/test/basic/91.clear.mql

select count(*) from /oktest/basic
/**
output()
**/
;

select count(*) from /oktest/basic with version
/**
output()
**/
;

select count(*) from /oktest/basic where v_int>1000400
/**
output()
**/
;

delete from /oktest/basic where v_int>1000400
;

select count(*) from /oktest/basic where v_int>1000400
/**
output()
**/
;

select count(*) from /oktest/basic where v_int>1000500 with version
/**
output()
**/
;

delete from /oktest/basic where v_int>1000500 with version
;

select count(*) from /oktest/basic where v_int>1000500 with version
/**
output()
**/
;

select count(*) from /oktest/basic
/**
output()
**/
;

delete from /oktest/basic
;

select count(*) from /oktest/basic
/**
output()
**/
;

select count(*) from /oktest/basic with version
/**
output()
**/
;

delete from /oktest/basic with version
;

select count(*) from /oktest/basic with version
/**
output()
equal(0,count,0)
**/
;