odbtools/odbctest/mql/basic/11cacheonly/33update.mql

update /test/cacheonly set v_text=NULL where v_varchar!='3'
/**
onerror(must,"can't update primary key")
**/
;

select class,id,vtime,v_varchar,v_string from /test/cacheonly where v_varchar!='3'
/**
output()
count(3)
**/
;

update /test/cacheonly set v_string=NULL where v_varchar!='3'
;

select class,id,vtime,v_varchar,v_string from /test/cacheonly where v_varchar!='3'
/**
output()
matchcount(v_string,null,3)
**/
;

update /test/cacheonly set v_string='test update null' where v_varchar!='3'
;

select class,id,vtime,v_varchar,v_string from /test/cacheonly where v_varchar!='3'
/**
output()
matchcount(v_string,"test update null",3)
**/
;