Bug #17385 duplicate key error interchangeble refers to attribute name name and number
Submitted: 14 Feb 2006 15:39 Modified: 22 Feb 2006 18:46
Reporter: Tomas Ulin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.1.7 src OS:
Assigned to: Elliot Murphy CPU Architecture:Any

[14 Feb 2006 15:39] Tomas Ulin
Description:
binlog_row_insert_select       [ fail ]

Errors are (from /export/home/mysqldev/pb/mysql-5.1-new/push-gluh@mysql.com-20060214095121.info/mysql-5.1.7-beta-standard/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/binlog_row_insert_select.result	Tue Feb 14 12:21:52 2006
--- r/binlog_row_insert_select.reject	Tue Feb 14 13:52:58 2006
***************
*** 4,10 ****
  insert into t2 values(1),(2);
  reset master;
  insert into t1 select * from t2;
! ERROR 23000: Duplicate entry '2' for key 1
  show binlog events;
  Log_name	Pos	Event_type	Server_id	End_log_pos	Info
  master-bin.000001	4	Format_desc	1	102	Server ver: VERSION, Binlog ver: 4
--- 4,10 ----
  insert into t2 values(1),(2);
  reset master;
  insert into t1 select * from t2;
! ERROR 23000: Duplicate entry '2' for key 'a'
  show binlog events;
  Log_name	Pos	Event_type	Server_id	End_log_pos	Info
  master-bin.000001	4	Format_desc	1	102	Server ver: VERSION, Binlog ver: 4
***************
*** 19,25 ****
  insert into t1 values(1),(1);
  reset master;
  create table t2(unique(a)) select a from t1;
! ERROR 23000: Duplicate entry '1' for key 1
  show binlog events;
  Log_name	Pos	Event_type	Server_id	End_log_pos	Info
  master-bin.000001	4	Format_desc	1	102	Server ver: VERSION, Binlog ver: 4
--- 19,25 ----
  insert into t1 values(1),(1);
  reset master;
  create table t2(unique(a)) select a from t1;
! ERROR 23000: Duplicate entry '1' for key 'a'
  show binlog events;
  Log_name	Pos	Event_type	Server_id	End_log_pos	Info
  master-bin.000001	4	Format_desc	1	102	Server ver: VERSION, Binlog ver: 4
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

rpl_row_basic_2myisam          [ fail ]
rpl_row_basic_3innodb          [ fail ]

rpl_row_create_table           [ fail ]

How to repeat:
see above
[17 Feb 2006 20:01] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2825
[17 Feb 2006 20:20] Elliot Murphy
re-enabled test case as it was passing. Fixed by a push from Ingo yesterday for WL#1563.
Probably no documentation needed, this was an internal test failure.
[22 Feb 2006 18:46] Mike Hillyer
Closing as it seems this did not exist in a production version.