odbtools/odbctest/mql/test/errinfo/0.errinfo.mql

-- { onerror(continue) scope(file) loop(1) }
;

delete from /test/raise_error with version
-- { onerror(continue) noerrinfo() }
;

drop class if exists /test/raise_error;

create class if not exists /test/raise_error (
    zxid     varchar    "zxid",
    zxname   varchar    "zxname",
    msg      varchar    "msg",
    tally    int        "tally",
    keys(zxid)
);

insert into /test/raise_error (zxid,zxname,msg,tally) values('{%d,mqli}', '{%d,mqli}', '{%d,mqli}: ...32 Bytes...',1)
on conflict
update tally = tally + 1
-- { onerror(continue) }
;

-- insert into /test/raise_error (zxid,zxname,msg) values('{%d,mqli}', '{%d,mqli}', '{%d,mqli}: ...32 Bytes...')
-- on conflict
-- update tally = tally + 1
-- -- { onerror(continue) sleep(1s) }
-- ;

-- insert into /test/raise_error (zxid,zxname,msg) values('{%d,mqli}', '{%d,mqli}', '{%d,mqli}: ...32 Bytes...')
-- on conflict
-- update tally = tally + 1
-- -- { onerror(continue) }
-- ;

-- { onerror(continue) sleep(1s) }
;

select zxid,zxname,msg,tally from /test/raise_error refresh
-- { output() }
;