odbtools/odbctest/mql/basic/24bucket_promdb/1094.subquery.mql

-- select count(id), id.count() from /test/bucketpromdb
-- /**
-- timeout(60m)
-- output()
-- **/
-- ;


-- select id.count(),prom.count(),prom from (
-- SELECT id,prom.time('2024-01-02 00:00:00', '2024-01-10 00:00:00').find(name='test1').unit('sum','1d') FROM /test/bucketpromdb
-- ) group by prom
-- /**
-- timeout(60m)
-- output()
-- match(id, 3, "prom.0.2", 0)
-- match(id, 1, "prom.0.2", 8)
-- **/
-- ;


-- select count(id),prom from(SELECT id,prom.time('2024-01-02 00:00:00', '2024-01-10 00:00:00').find(name='test1').unit('sum','1d') FROM /test/bucketpromdb)group by prom
-- /**
-- timeout(60m)
-- output()
-- **/
-- ;

-- select id,prom.time('2024-01-02 00:00:00', '2024-01-10 00:00:00').find(name='test1').unit('sum','1d') 
-- FROM (
-- SELECT id,prom FROM /test/bucketpromdb
-- )
-- group by prom
-- /**
-- timeout(60m)
-- output()
-- **/
-- ;