odbtools/odbctest/mql/test/update/4.mql

-- { scope(file) loop(1000000000) }
;
delete from /m3event/entity/node where ip='1.1.1.1'
;
insert into /m3event/entity/node (ip,port,status) values('1.1.1.1',0,0)
;
update /m3event/entity/node set port=9999,status=5 where ip='1.1.1.1'
;
SELECT port, status FROM /m3event/entity/node where ip='1.1.1.1'
-- { output() equal(0,port,9999,status,5) sleep(1s)}
;
update /m3event/entity/node set status=3 where ip='1.1.1.1'
;
SELECT port, status FROM /m3event/entity/node where ip='1.1.1.1'
-- { output() equal(0,port,9999,status,3, 1) sleep(1s)}
;
update /m3event/entity/node set port=1111 where ip='1.1.1.1'
;
SELECT port, status FROM /m3event/entity/node where ip='1.1.1.1'
-- { output() equal(0,port,1111,status,3) sleep(1s)}
;
update /m3event/entity/node set status=4 where ip='1.1.1.1'
;
SELECT port, status FROM /m3event/entity/node where ip='1.1.1.1'
-- { output() equal(0,port,1111,status,4) sleep(1s)}
;
update /m3event/entity/node set port=2222 where ip='1.1.1.1'
;
SELECT port, status FROM /m3event/entity/node where ip='1.1.1.1'
-- { output() equal(0,port,2222,status,4) sleep(1s)}
;