odbtools/odbctest/mql/basic/16alter/11data.mql

insert into /test/alter (v_varchar, v_map, v_list, v_set, v_type ) values ('1', {"map1": "val1", "map2":"2"}, ["list1", "list2"], ["set1", "set2"], "4"  )
;

insert into /test/alter (v_varchar, v_map, v_list, v_set, v_type ) values ('2', {"map1": "val2", "map2":"2"}, ["list1", "list2"], ["set1", "set2"], "shell脚本"  )
;

insert into /test/alter (v_varchar, v_map, v_list, v_set, v_type ) values ('3', {"map1": "val3", "map2":"2"}, ["list1", "list2"], ["set1", "set2"], "2"  )
;

insert into /test/alter (v_varchar, v_map, v_list, v_set, v_type ) values ('4', {"map1": "val3", "map2":"2"}, [], ["set1", "set2"], "3"  )
;

insert into /test/movefield (mv_varchar, mv_map, mv_list, mv_set, mv_type ) values ('m1', {"map1": "mval1", "map2":"m2"}, ["list1", "mlist2"], ["set1", "mset2"], "4"  )
;

insert into /test/movefield (mv_varchar, mv_map, mv_list, mv_set, mv_type ) values ('m2', {"map1": "mval2", "map2":"m2"}, ["list1", "mlist2"], ["set1", "mset2"], "shell脚本"  )
;

insert into /test/movefield (mv_varchar, mv_map, mv_list, mv_set, mv_type ) values ('m3', {"map1": "mval3", "map2":"m2"}, ["list1", "mlist2"], ["set1", "mset2"], "2"  )
;

insert into /test/movefield (mv_varchar, mv_map, mv_list, mv_set, mv_type ) values ('m4', {"map1": "mval3", "map2":"m2"}, [], ["set1", "mset2"], "3"  )
;

alter class /test/alter modify v_type merge enum { "5": [ "测试", "测试" ] }
;

alter class /test/alter modify v_type merge enum { "0": [] }
;

alter class /test/alter add index column v_text text
/**
onerror(continue,"already exist")
**/
;

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

update /test/alter set v_text="testtext"
;