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('2025-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('2025-01-01', '2025-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('2025-01-02 00:00:00', '2025-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('2025-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('2025-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('2025-01-01 09:09:09.090', '2025-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)
**/
;


SELECT id,prom.count() FROM /test/bucketpromdb
/**
output()
match(id, "bucketpromdb:wecisen1", "prom.0.2", 31680)
match(id, "bucketpromdb:wecise", "prom.0.2", 63)
retry(100)
**/
;

SELECT id,prom.limit(1).count() FROM /test/bucketpromdb
/**
output()
match(id, "bucketpromdb:wecisen1", "prom.0.2", 1)
match(id, "bucketpromdb:wecise", "prom.0.2", 1)
**/
;

SELECT id,prom FROM /test/bucketpromdb
where prom.count().assert($1>0)
/**
output()
count(2)
match(id, "bucketpromdb:wecisen1", "prom.len", 1)
match(id, "bucketpromdb:wecise", "prom.len", 1)
**/
;


SELECT id,prom FROM /test/bucketpromdb
where prom.limit(1).count().assert($1>0)
/**
output()
count(2)
match(id, "bucketpromdb:wecisen1", "prom.len", 1)
match(id, "bucketpromdb:wecise", "prom.len", 1)
**/
;