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

insert into /test/mpartition (mv_varchar, v_int, v_float, v_text, v_bool) values(?, ?, ?, ?, ?) on conflict update v_bool=v_bool, v_float=v_float+1
-- { params("test001", 1, 1.1, "hello", true) }
;


insert into /test/mpartition (mv_varchar, v_int, v_float, v_text, v_bool) values(?, ?, ?, ?, ?) on conflict update v_bool=v_bool, v_float=v_float+1
-- { params("test001", 1, 12, "hello", false) }
;


-- { sleep(3s) }
;

select v_bool, v_float from /test/mpartition where mv_varchar='test001' and v_int=1 and v_text='hello'
-- { output() matchcount(v_bool, true, v_float, 2.1, 1) }
;


update /test/mpartition/ set tags=tags+'partition' where mv_varchar= '1' and v_int=1
-- { equal(0, success, 1) }
;


update /test/ set tags=tags+'world' where mv_varchar= '1' and v_int=1
-- { equal(0, success, 1) }
;


-- { equal(0, success, 1) }
update / set tags=tags+'hello' where mv_varchar= '1' and v_int=1
;



-- { sleep(3s) }
;