odbtools/odbctest/mql/uino/075.subquery.limit.mql

/**
scope(file)
timeout(60m)
**/
;

SELECT  ID,name FROM /cq_post_demo/qx qx WHERE 
totalaum.time('2025-10-01 00:00:00','2025-10-31 23:59:59').find(name = 'cl').unit('avg', '1M').assert($1 > 0)  
AND balance.time('2025-10-01 00:00:00','2025-10-31 23:59:59').find(name = 'cl').unit('avg', '1M').assert($1 > 0) limit -1
/**
output()
count(39)
**/
;

SELECT  ID,name FROM /cq_post_demo/qx qx WHERE 
totalaum.time('2025-10-01 00:00:00','2025-10-31 23:59:59').find(name = 'cl').unit('avg', '1M').assert($1 > 0) limit -1
/**
output()
count(39)
**/
;

SELECT  ID,name FROM /cq_post_demo/qx qx WHERE 
balance.time('2025-10-01 00:00:00','2025-10-31 23:59:59').find(name = 'cl').unit('avg', '1M').assert($1 > 0) limit -1
/**
output()
count(39)
**/
;

SELECT  ID,name,totalaum,balance FROM /cq_post_demo/qx qx WHERE 
totalaum.time('2025-10-01 00:00:00','2025-10-31 23:59:59').find(name = 'cl').unit('avg', '1M').assert($1 > 0) limit -1
/**
output()
count(39)
**/
;

SELECT  ID,name,totalaum,balance FROM /cq_post_demo/qx qx WHERE 
 balance.time('2025-10-01 00:00:00','2025-10-31 23:59:59').find(name = 'cl').unit('avg', '1M').assert($1 > 0) limit -1
/**
output()
count(39)
**/
;

SELECT  ID,name,totalaum,balance FROM /cq_post_demo/qx qx WHERE 
totalaum.time('2025-10-01 00:00:00','2025-10-31 23:59:59').find(name = 'cl').unit('avg', '1M').assert($1 > 0)  
AND balance.time('2025-10-01 00:00:00','2025-10-31 23:59:59').find(name = 'cl').unit('avg', '1M').assert($1 > 0) limit -1
/**
output()
count(39)
**/
;