odbtools/odbctest/mql/basic/24bucket_promdb/1093valid.mql

SELECT id,prom.date('{%2006-01-02,ct}').find(name='test1').sum() FROM /test/bucketpromdb where id='bucketpromdb:wecisen1'
/**
set(ct,"2024-01-02 00:00:00")
beforerun(
    add(ct,3600,second)
)
loop(100)
parallel(100)
output()
match("prom.0.2",2880)
**/
;


SELECT id,prom.date('{%2006-01-02,ct}').find(name='test1').avg().min().max().sum().count() FROM /test/bucketpromdb where id='bucketpromdb:wecisen1'
/**
set(ct,"2024-01-02 00:00:00")
beforerun(
    add(ct,3600,second)
)
loop(100)
parallel(100)
output()
match("prom.0.2",1,"prom.0.5",1,"prom.0.8",1,"prom.0.11",2880,"prom.0.14",2880)
**/
;