odbtools/odbctest/mql/basic/13delete/98.subqueryconds.mql

-- select * from /test/delete
-- /**
-- output()
-- count(3)
-- **/
-- ;


-- select * from  ( select * from /test/delete) vv
-- /**
-- output()
-- count(3)
-- **/
-- ;


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


select * from  ( select * from /test/delete) vv where v_timestamp = '2019-10-22 23:59:59'
/**
output()
**/
;


select * from  ( select * from /test/delete) vv where vv.v_timestamp = '2019-10-22 23:59:59'
/**
output()
**/
;