Skip to content

query insert+ignore on global table return error #250

@FlyingMao

Description

@FlyingMao

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

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions