这是其中的一段升级日志
update edt_site set edt_site_id=edt_site_id+10000
--ERROR -100
--ERMSG 标准表达式中数据类型不匹配。
update edt_site set edt_site_id=1 where edt_site_id='C1G1'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=1 where parent_site_id='C1G1'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=1 where edt_site_id='C1G1'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=2 where edt_site_id='C1G1-L1W1'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=2 where parent_site_id='C1G1-L1W1'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=2 where edt_site_id='C1G1-L1W1'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=3 where edt_site_id='C1G1-L1W2'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=3 where parent_site_id='C1G1-L1W2'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=3 where edt_site_id='C1G1-L1W2'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=4 where edt_site_id='C1G1-L1W3'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=4 where parent_site_id='C1G1-L1W3'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=4 where edt_site_id='C1G1-L1W3'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=5 where edt_site_id='C1G1-L1W4'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=5 where parent_site_id='C1G1-L1W4'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=5 where edt_site_id='C1G1-L1W4'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=6 where edt_site_id='C1G1-L1W5'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=6 where parent_site_id='C1G1-L1W5'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=6 where edt_site_id='C1G1-L1W5'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=7 where edt_site_id='C1G1-L2W1'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=7 where parent_site_id='C1G1-L2W1'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=7 where edt_site_id='C1G1-L2W1'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=8 where edt_site_id='C1G1-L2W2'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=8 where parent_site_id='C1G1-L2W2'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=8 where edt_site_id='C1G1-L2W2'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=9 where edt_site_id='C1G1-L2W3'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=9 where parent_site_id='C1G1-L2W3'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=9 where edt_site_id='C1G1-L2W3'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=10 where edt_site_id='C1G1-L2W4'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=10 where parent_site_id='C1G1-L2W4'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=10 where edt_site_id='C1G1-L2W4'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=11 where edt_site_id='C1G1-L2W5'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=11 where parent_site_id='C1G1-L2W5'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=11 where edt_site_id='C1G1-L2W5'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=12 where edt_site_id='C1G1-L3W1'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=12 where parent_site_id='C1G1-L3W1'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=12 where edt_site_id='C1G1-L3W1'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=13 where edt_site_id='C1G1-L3W2'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=13 where parent_site_id='C1G1-L3W2'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=13 where edt_site_id='C1G1-L3W2'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=14 where edt_site_id='C1G1-L3W3'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=14 where parent_site_id='C1G1-L3W3'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=14 where edt_site_id='C1G1-L3W3'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=15 where edt_site_id='C1G1-L3W4'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=15 where parent_site_id='C1G1-L3W4'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=15 where edt_site_id='C1G1-L3W4'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=16 where edt_site_id='C1G1-L3W5'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=16 where parent_site_id='C1G1-L3W5'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=16 where edt_site_id='C1G1-L3W5'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=17 where edt_site_id='C1G1-L4W1'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=17 where parent_site_id='C1G1-L4W1'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=17 where edt_site_id='C1G1-L4W1'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=18 where edt_site_id='C1G1-L4W2'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=18 where parent_site_id='C1G1-L4W2'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=18 where edt_site_id='C1G1-L4W2'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=19 where edt_site_id='C1G1-L4W3'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=19 where parent_site_id='C1G1-L4W3'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=19 where edt_site_id='C1G1-L4W3'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=20 where edt_site_id='C1G1-L4W4'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=20 where parent_site_id='C1G1-L4W4'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=20 where edt_site_id='C1G1-L4W4'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=21 where edt_site_id='C1G1-L4W5'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=21 where parent_site_id='C1G1-L4W5'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=21 where edt_site_id='C1G1-L4W5'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=22 where edt_site_id='C1G2'
--NOT DONE, PRE ERROR
updateedt_site set parent_site_id=22 where parent_site_id='C1G2'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=22 where edt_site_id='C1G2'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=23 where edt_site_id='C1G2-L1W1'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=23 where parent_site_id='C1G2-L1W1'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=23 where edt_site_id='C1G2-L1W1'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=24 where edt_site_id='C1G2-L1W2'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=24 where parent_site_id='C1G2-L1W2'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=24 where edt_site_id='C1G2-L1W2'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=25 where edt_site_id='C1G2-L1W3'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=25 where parent_site_id='C1G2-L1W3'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=25 where edt_site_id='C1G2-L1W3'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=26 where edt_site_id='C1G2-L1W4'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=26 where parent_site_id='C1G2-L1W4'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=26 where edt_site_id='C1G2-L1W4'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=27 where edt_site_id='C1G2-L1W5'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=27 where parent_site_id='C1G2-L1W5'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=27 where edt_site_id='C1G2-L1W5'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=28 where edt_site_id='C1G2-L2W1'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=28 where parent_site_id='C1G2-L2W1'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=28 where edt_site_id='C1G2-L2W1'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=29 where edt_site_id='C1G2-L2W2'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=29 where parent_site_id='C1G2-L2W2'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=29 where edt_site_id='C1G2-L2W2'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=30 where edt_site_id='C1G2-L2W3'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=30 where parent_site_id='C1G2-L2W3'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=30 where edt_site_id='C1G2-L2W3'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=31 where edt_site_id='C1G2-L2W4'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=31 where parent_site_id='C1G2-L2W4'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=31 where edt_site_id='C1G2-L2W4'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=32 where edt_site_id='C1G2-L2W5'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=32 where parent_site_id='C1G2-L2W5'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=32 where edt_site_id='C1G2-L2W5'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=33 where edt_site_id='C1G2-L3W1'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=33 where parent_site_id='C1G2-L3W1'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=33 where edt_site_id='C1G2-L3W1'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=34 where edt_site_id='C1G2-L3W2'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=34 where parent_site_id='C1G2-L3W2'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=34 where edt_site_id='C1G2-L3W2'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=35 where edt_site_id='C1G2-L3W3'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=35 where parent_site_id='C1G2-L3W3'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=35 where edt_site_id='C1G2-L3W3'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=36 where edt_site_id='C1G2-L3W4'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=36 where parent_site_id='C1G2-L3W4'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=36 where edt_site_id='C1G2-L3W4'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=37 where edt_site_id='C1G2-L3W5'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=37 where parent_site_id='C1G2-L3W5'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=37 where edt_site_id='C1G2-L3W5'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=38 where edt_site_id='C1G2-L4W1'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=38 where parent_site_id='C1G2-L4W1'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=38 where edt_site_id='C1G2-L4W1'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=39 where edt_site_id='C1G2-L4W2'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=39 where parent_site_id='C1G2-L4W2'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=39 where edt_site_id='C1G2-L4W2'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=40 where edt_site_id='C1G2-L4W3'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=40 where parent_site_id='C1G2-L4W3'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=40 where edt_site_id='C1G2-L4W3'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=41 where edt_site_id='C1G2-L4W4'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=41 where parent_site_id='C1G2-L4W4'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=41 where edt_site_id='C1G2-L4W4'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=42 where edt_site_id='C1G2-L4W5'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=42 where parent_site_id='C1G2-L4W5'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=42 where edt_site_id='C1G2-L4W5'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=43 where edt_site_id='C1G3'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=43 where parent_site_id='C1G3'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=43 where edt_site_id='C1G3'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=44 where edt_site_id='C1G3-L1W1'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=44 where parent_site_id='C1G3-L1W1'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=44 where edt_site_id='C1G3-L1W1'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=45 where edt_site_id='C1G3-L1W2'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=45 where parent_site_id='C1G3-L1W2'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=45 where edt_site_id='C1G3-L1W2'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=46 where edt_site_id='C1G3-L1W3'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=46 where parent_site_id='C1G3-L1W3'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=46 where edt_site_id='C1G3-L1W3'
--NOT DONE, PRE ERROR
update edt_site set edt_site_id=47 where edt_site_id='C1G3-L1W4'
--NOT DONE, PRE ERROR
update edt_site set parent_site_id=47 where parent_site_id='C1G3-L1W4'
--NOT DONE, PRE ERROR
update edt_site_res set edt_site_id=47 where edt_site_id='C1G3-L1W4'
--NOT DONE, PRE ERROR |
