Description:
Adding by:
http://bugs.mysql.com/bug.php?id=11890

bag script ( error: "DUPLICATE ENTRY '7' FOR KEY 1") 

How to repeat:
USE test;

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (
  ID  INT UNSIGNED  NOT NULL  AUTO_INCREMENT,
  Text  VARCHAR(255)  NOT NULL,
  PRIMARY KEY (ID)
)
ENGINE = MyISAM;

DROP TABLE IF EXISTS t2;

CREATE TABLE t2 (
  ID  INT UNSIGNED  NOT NULL  AUTO_INCREMENT,
  Text  VARCHAR(255)  NOT NULL,
  PRIMARY KEY (ID)
)
ENGINE = MyISAM;

INSERT INTO
  t1 (Text)
VALUES
 ('Test1'), ('Test2'), ('Test3');

INSERT INTO
       t2 (  ID, Text )
VALUES ( 7, 'test' );

DROP PROCEDURE IF EXISTS testproc;

DELIMITER //

CREATE PROCEDURE testproc ()
SQL SECURITY INVOKER
DETERMINISTIC
BEGIN

  INSERT INTO t1 (Text)
  SELECT Text
  FROM t1;

  INSERT INTO t2 (Text)
  SELECT Text
  FROM t1;

END; //

DELIMITER ;

CALL testproc ();

I've had this problem on Windows XP as well in 5.0.15

I'm having the same problem to, on Linux 2.6.13, MySQL 5.0.15 source, with InnoDB engine

The patch submitted on IRC has been approved by email.

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/internals/32899

fixed in 5.0.17

Noted in 5.0.17 changelog.

Bug#11890 is marked as duplicate of this bug.