-
Notifications
You must be signed in to change notification settings - Fork 320
Closed
Description
Steps:
mysql> create table test_global (id int(11),R_REGIONKEY int(11) primary key,R_NAME varchar(50),R_COMMENT varchar(50));
Query OK, 0 rows affected (0.03 sec)
mysql> insert into test_global values(1,1,1,1);
Query OK, 1 row affected (0.02 sec)
mysql> insert ignore into test_global values(1,1,1,1);
ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'
general.log:
170907 17:25:01 87 Query SET autocommit=0;
87 Query insert into test_global(id,R_REGIONKEY,R_NAME,R_COMMENT,_dble_op_time) values(1,1,1,1,1504776265121)
91 Query insert into test_global(id,R_REGIONKEY,R_NAME,R_COMMENT,_dble_op_time) values(1,1,1,1,1504776265121)
91 Query rollback
87 Query rollback