odbtools/odbctest/mql/test/select/1.select.mql

select count(*) from /test/malert_status
-- { output() }
;

select id,identifier,day,vtime from /test/malert_status order by identifier limit -1
-- { outputcount() retry(3) }
;

select id,identifier,day,vtime from /test/malert_status limit 09999,2
-- { output() count(2) loop(10) loopfrom(0) loopstep(2) }
;

select id,identifier,day,vtime from /test/malert_status order by identifier limit 09999,2
-- { output() count(2) loop(10) loopfrom(0) loopstep(2) }
;

select id,identifier,day,vtime from /test/malert_status limit 20,2
-- { outputcount() count(2) }
;

select id,identifier,day,vtime from /test/malert_status limit 10,2
-- { outputcount() count(2) }
;

-- select * from /   limit 09999, 1
-- -- { output() loop(3) xparallel(10) }
-- ;


-- sql: select * from /test/malert_status
-- -- { output() }
-- ;


-- sql: select * from /test/alert_status
-- -- { output() }
-- ;