odbtools/odbctest/mql/basic/13delete/23delete.mql

select * from /test/delete2 where v_date = '2019-10-20'
/**
count(1)
**/
;

delete from /test/delete2 where v_date = '2019-10-20'
;

select * from /test/delete2 where v_date = '2019-10-20'
/**
count(0)
**/
;

select * from /test/delete2 where v_timestamp = '2019-10-21 23:59:59'
/**
count(1)
**/
;

select * from /test/delete2 where v_timestamp = '2019-10-21 23:59'
/**
count(2)
**/
;

select * from /test/delete2 where v_timestamp = '2019-10-21 23:'
/**
count(3)
**/
;

select * from /test/delete2 where v_timestamp = '2019-10-21'
/**
count(4)
**/
;

delete from /test/delete2 where v_timestamp = '2019-10-21 23:59:59'
;

select * from /test/delete2 where v_timestamp = '2019-10-21 23:59:59'
/**
count(0)
**/
;

delete from /test/delete2 where v_timestamp = '2019-10-21 23:59'
;


select * from /test/delete2
/**
count(3)
**/
;