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

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