odbtools/odbctest/mql/basic/35mpartition/19update.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)
**/
;

/**
sleep(1s)
**/
;

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(1s)
**/
;

select * from /test/mpartition
/**
output()
**/
;

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

select * from / where mv_varchar= '1' and v_int=1
/**
output()
**/
;

update / set tags=tags+'hello' where mv_varchar= '1' and v_int=1
/**
output()
matchcount("success", 1, 1)
**/
;

update /test/ set tags=tags+'world' where mv_varchar= '1' and v_int=1
/**
output()
matchcount("success", 1, 1)
**/
;