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

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

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

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

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

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

select * from /test/delete
/**
count(1)
**/
;