odbtools/odbctest/mql/basic/23bucket_tsdb/13valid.mql

SELECT bk2 FROM /test/buckettsdb
/**
output()
**/
;

SELECT bk2[-1 - 1] FROM /test/buckettsdb
/**
output()
**/
;

SELECT bk2[1 - -1] FROM /test/buckettsdb
/**
output()
**/
;

SELECT bk2[ 4-3] FROM /test/buckettsdb
/**
output()
**/
;

SELECT bk2[ 'iparam1', 3-1, 4] FROM /test/buckettsdb
/**
output()
**/
;

SELECT bk2[ 'iparam1', 1-3, 4] FROM /test/buckettsdb
/**
output()
**/
;

SELECT bk2[ 'iparam1', 'iparam2', 2-3, 4 ].time('2022-04-22 08:10', '').(iparam1=1).count()  as iparam1  FROM /test/buckettsdb 
/**
output()
match('iparam1.0.0',21)
**/
;

SELECT bk2[  3-4, 5 ].time('2022-05-23 22:24:15', '').([1]=1).title()  FROM /test/buckettsdb 
/**
output()
match('bk2.len',22,'bk2.0.len',4)
**/
;

SELECT bk2[ 'iparam1', 1-3, 4 ].time('2022-04-22', '').find(fparam1 >= 0.992315).find(iparam1 = 56).find(fparam2 != 0.418309)  as iparam1  FROM /test/buckettsdb 
/**
output()
**/
;

SELECT bk2.time('2022-04-22', '').find(fparam1 >= 0.992315).find(iparam1 = 56).find(fparam2 <> 0.418309)  as iparam1  FROM /test/buckettsdb 
/**
output()
**/
;

SELECT bk2.time('2022-04-22', '').(fparam1 >= 0.992315).(iparam1 in [56,99]) FROM /test/buckettsdb 
/**
output()
**/
;

SELECT bk2[-1 - 1].time("2022-07-24", '').find(fparam1 >= 0.992315).count() as iparm1 FROM /test/buckettsdb 
/**
output()
match('iparm1.0.0',26)
**/
;

SELECT id, bk2 FROM 	/test/buckettsdb 
/**
output()
**/
;

SELECT bk2[-1 - 1].date('2022-07-24').find(fparam1=3.3) FROM /test/buckettsdb 
/**
output()
match('bk2.len',10,'bk2.0.len',6)
**/
;

SELECT bk2.date("2022-07-24") FROM /test/buckettsdb 
/**
output()
match('bk2.len',10,'bk2.0.len',7)
**/
;

SELECT id FROM /test/buckettsdb where bk2.date("2022-07-24").assert(iparam1=1)
/**
output()
**/
;

SELECT bk64 FROM /test/buckettsdb64
/**
output()
**/
;

SELECT bk64[-1 - 1] FROM /test/buckettsdb64
/**
output()
**/
;

SELECT bk64[1 - -1] FROM /test/buckettsdb64
/**
output()
**/
;

SELECT bk64[ 4-3] FROM /test/buckettsdb64
/**
output()
**/
;

SELECT bk64[ 'iparam1', 3-1, 4] FROM /test/buckettsdb64
/**
output()
**/
;

SELECT bk64[ 'iparam1', 1-3, 4] FROM /test/buckettsdb64
/**
output()
**/
;

SELECT bk64[ 'iparam1', 'iparam2', 2-3, 4 ].time('2022-04-22 08:10', '').(iparam1=1).count()  as iparam1  FROM /test/buckettsdb64 
/**
output()
match('iparam1.0.0',8)
**/
;

SELECT bk64[  3-4, 5 ].time('2022-05-23 22:24:15', '').([1]=1).title()  FROM /test/buckettsdb64 
/**
output()
match('bk64.len',9,'bk64.0.len',4)
**/
;

SELECT bk64[ 'iparam1', 1-3, 4 ].time('2022-04-22', '').find(fparam1 >= 0.992315).find(iparam1 = 56).find(fparam2 != 0.418309)  as iparam1  FROM /test/buckettsdb64 
/**
output()
**/
;

SELECT bk64.time('2022-04-22', '').find(fparam1 >= 0.992315).find(iparam1 = 56).find(fparam2 <> 0.418309)  as iparam1  FROM /test/buckettsdb64 
/**
output()
**/
;

SELECT bk64.time('2022-04-22', '').(fparam1 >= 0.992315).(iparam1 in [56,99]) FROM /test/buckettsdb64 
/**
output()
**/
;

SELECT bk64[-1 - 1].time("2022-07-24", '').find(fparam1 >= 0.992315).count() as iparm1 FROM /test/buckettsdb64 
/**
output()
match('iparm1.0.0',13)
**/
;

SELECT id, bk64 FROM 	/test/buckettsdb64 
/**
output()
**/
;

SELECT bk64[-1 - 1].date('2022-07-24').find(fparam1=3.3) FROM /test/buckettsdb64 
/**
output()
match("bk64.len",10,"bk64.0.len",6)
**/
;

SELECT bk64.date("2022-07-24") FROM /test/buckettsdb64 
/**
output()
match("bk64.len",10,"bk64.0.len",7,"bk64.9.6","abcdefghhhhh")
**/
;

SELECT id FROM /test/buckettsdb64 where bk64.date("2022-07-24").assert(iparam1=1)
/**
output()
match("id", "buckettsdb64:wecise")
**/
;