odbtools/odbctest/mql/0/0.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()
match("v_timestamp", "2019-10-22T23:59:59+08:00")
**/
;


select * from  ( select * from /test/delete) vv where vv.v_timestamp = '2019-10-22 23:59:59'
/**
output()
match("v_timestamp", "2019-10-22T23:59:59+08:00")
**/
;

select v_timestamp from  ( select v_timestamp from /test/delete) vv where vv.v_timestamp = '2019-10-22 23:59:59'
/**
output()
match("v_timestamp", "2019-10-22T23:59:59+08:00")
**/
;

select v_timestamp from  ( select v_timestamp from /test/delete) where v_timestamp = '2019-10-22 23:59:59'
/**
output()
match("v_timestamp", "2019-10-22T23:59:59+08:00")
**/
;

select vtime from /test/delete 
/**
output()
**/
;

select vtime from (select vtime from /test/delete)
/**
output()
**/
;

select vtime from (select * from /test/delete)
/**
output()
**/
;