dws-pg空串转换问题ZCBUS-30001

1. 问题（故障）描述

[LV0] LOAD THD[10] loading FULL message 25, table[public.empdayread_test10] topic[10265.public.empdayread_test10.s.2] offset[27]...
[LV0] LOAD THD[10]: multi-insert mode.
[LV0] LOAD THD[10]: 2021-05-31 17:07:57: table[public.empdayread_test10] bsd data time[2021-05-31 15:05:42], delay 7335 s.
error at file[pg.c] line[923], ZCBUS-30001: exec sql failed: ERROR:  dn_6035_6036: duplicate key value violates unique constraint "empdayread_test10_pkey"
DETAIL:  Key (id, org_no, data_date)=(51091507, 654030115, 2021-05-29 00:00:00) already exists.

[WAN] LOAD THD[10]: insert error, affect rows -1 != 4096, delete and insert...
error at file[pg.c] line[923], ZCBUS-30001: exec sql failed: ERROR:  dn_6003_6004: null value in column "org_no" violates not-null constraint
DETAIL:  Failing row contains (0, null, 2021-05-23 00:00:00, 588.20000, 0.00000, 0, 2021-05-31 13:40:28, 2021-05-31 13:40:28, 2021, 202105, 20210523, 1).
（新疆电力测试发现的问题）

2. 问题（故障）原因

因为目标库是dws-pg9.2.4库，dws库处理空串时，会把’’转成null

3. 解决

v2.0.1版本已经解决，升级即可

4. 参考