kingbase兼容MySQL insert on DUPLICATE KEY UPDATE c3=values(c3)；

1==============================
mysql创建测试表：
CREATE TABLE t2 (
c1 char(2) NOT NULL,
c2 int(11) DEFAULT NULL,
c3 varchar(5) DEFAULT NULL,
PRIMARY KEY (c1)
);

kingbase创建测试表：
CREATE TABLE t2 (
c1 char(2),
c2 int,
c3 varchar(5),
PRIMARY KEY (c1)
);

2==============================
MySQL insert 测试数据：
insert into t2 values (‘aa’,1,‘aa’),(‘bb’,2,‘bb’),(‘cc’,2,‘cc’);
mysql> select * from t2;
±—±-----±-----+
| c1 | c2 | c3 |
±—±-----±-----+
| aa | 1 | aa |
| bb | 2 | bb |
| cc | 2 | cc |
±—±-----±-----+
3 rows in set (0.01 sec)

kingbaseES insert 测试数据：
test=# insert into t2 values (‘aa’,1,‘aa’),(‘bb’,2,‘bb’),(‘cc’,2,‘cc’);
INSERT 0 3
test=# select * from t2;
c1 | c2 | c3
----±—±—
aa | 1 | aa
bb | 2 | bb
cc | 2 | cc
(3 rows)

3==============================
mysql insert on DUPLICATE KEY UPDATE语句：
mysql> insert into t2 values (‘aa’,1,‘ee’),(‘bb’,2,‘ff’),(‘cc’,3,‘gg’) on DUPLICATE KEY UPDATE c3=values(c3);
Query OK, 6 rows affected (0.00 sec)
Records: 3 Duplicates: 3 Warnings: 0

mysql> select * from t2;
±—±-----±-----+
| c1 | c2 | c3 |
±—±-----±-----+
| aa | 1 | ee |
| bb | 2 | ff |
| cc | 2 | gg |
±—±-----±-----+
3 rows in set (0.00 sec)

kingbase insert ON CONFLICT(c1) do UPDATE set语句：
test=# insert into t2 values (‘aa’,1,‘ee’),(‘bb’,2,‘ff’),(‘cc’,3,‘gg’) ON CONFLICT(c1) do UPDATE set c3=excluded.c3;
INSERT 0 3
test=# select * from t2;
c1 | c2 | c3
----±—±—
aa | 1 | ee
bb | 2 | ff
cc | 2 | gg
(3 rows)