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()
-- **/
-- ;