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


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 v_date from  ( select v_date from /test/delete) where v_date = '2019-10-22'
/**
output()
match("v_date", "2019-10-22T08:00:00+08:00")
**/
;