odbtools/odbctest/mql/basic/49mix/0151bucket.mql

select * from /mix/mtx where xprom is null
/**
output()
onerror(continue,"has't index")
**/
;

select * from /mix/mtz where zprom is null
/**
output()
onerror(continue,"has't index")
**/
;


select id,xprom.time('2025-01-02','2025-01-04').find(name='mtx').count() from /mix/mtx
where id="mtx:x5" and xprom.time('2025-01-02','2025-01-04').find(name='mtx').count().assert($1=96)
/**
output()
match("id","mtx:x5","xprom.0.2",96)
**/
;

select id,zprom.time('2025-01-02','2025-01-04').find(name='mtz').count() from /mix/mtz
where id="mtz:z5" and zprom.time('2025-01-02','2025-01-04').find(name='mtz').count().assert($1=96)
/**
output()
match("id","mtz:z5","zprom.0.2",96)
**/
;