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('2025-01-02 00:00:00', '2025-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 id,prom
-- FROM (
-- SELECT * FROM /test/bucketpromdb
-- )
-- /**
-- timeout(60m)
-- output()
-- **/
-- ;






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



-- select id,prom.avg().groupby(name) from(
--     SELECT id,prom.time('2025-01-02 00:00:00', '2025-01-10 00:00:00')
--     FROM /test/bucketpromdb
--     WHERE  prom.time('2025-01-03 00:00:00', '2025-01-08 00:00:00').avg().groupby(name).assert($1=1)
-- )
-- /**
-- timeout(60m)
-- output()
-- match("prom.0.0","test1","prom.0.3",1)
-- **/
-- ;