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

SELECT id,prom.last(20d).find(name='test1').unit('count','1d') FROM /test/bucketpromdb where id='bucketpromdb:wecisen1'
/**
output()
matchcount(id, "bucketpromdb:wecisen1", "prom.1.2", 288, 1)
**/
;

SELECT id,prom.date('2024-01-02').find(name='test1') FROM /test/bucketpromdb where id='bucketpromdb:wecisen1'
/**
output()
matchcount(id, "bucketpromdb:wecisen1", "prom.len", 2880, 1)
**/
;

SELECT id,prom.date('2024-01-01', '2024-01-03').time('09:00:00','19:00:00').find(name='test1') FROM /test/bucketpromdb where id='bucketpromdb:wecisen1'
/**
output()
matchcount(id, "bucketpromdb:wecisen1", "prom.len", 2400, 1)
**/
;

SELECT id,prom.time('2024-01-02 00:00:00', '2024-01-04 00:00:00').find(name='test1') FROM /test/bucketpromdb where id='bucketpromdb:wecisen1'
/**
output()
matchcount(id, "bucketpromdb:wecisen1", "prom.len", 5760, 1)
**/
;

SELECT id,prom.date('2024-01-02').time('09:09:00','09:19:00').find(name='test1') FROM /test/bucketpromdb where id='bucketpromdb:wecisen1'
/**
output()
matchcount(id, "bucketpromdb:wecisen1", "prom.len", 20, 1)
**/
;

SELECT id,prom.date('2024-01-02').time('09:09:00','10:19:00').find(name='test1') FROM /test/bucketpromdb where id='bucketpromdb:wecisen1'
/**
output()
matchcount(id, "bucketpromdb:wecisen1", "prom.len", 140, 1)
**/
;


SELECT id,prom.time('2024-01-01 09:09:09.090', '2024-01-03 19:19:19.191').find(name='test1') FROM /test/bucketpromdb where id='bucketpromdb:wecisen1'
/**
output()
matchcount(id, "bucketpromdb:wecisen1", "prom.len", 6980, 1)
**/
;