MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Jim Winstead Date:June 6 2007 5:57pm
Subject:bk commit into 5.1 tree (jimw:1.2545) BUG#28842
View as plain text  
Below is the list of changes that have just been committed into a local
5.1 repository of jimw. When jimw does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2007-06-06 10:57:07-07:00, jimw@rama.(none) +58 -0
  Bug #28842  Different 'duplicate key' error code between 5.0 and 5.1
  
    The patch for WL 1563 added a new duplicate key error message so that the
    key name could be provided instead of the key number. But the error code
    for the new message was used even though that did not need to change.
  
    This could cause unnecessary problems for applications that used the old
    ER_DUP_ENTRY error code to detect duplicate key errors.

  mysql-test/extra/binlog_tests/insert_select-binlog.test@stripped, 2007-06-06 10:48:49-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/extra/binlog_tests/mix_innodb_myisam_binlog.test@stripped, 2007-06-06 10:48:49-07:00, jimw@rama.(none) +9 -9
    Update ER_DUP_ENTRY-related error message values

  mysql-test/extra/rpl_tests/rpl_auto_increment.test@stripped, 2007-06-06 10:48:51-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/extra/rpl_tests/rpl_foreign_key.test@stripped, 2007-06-06 10:48:52-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/extra/rpl_tests/rpl_insert_delayed.test@stripped, 2007-06-06 10:48:52-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/extra/rpl_tests/rpl_insert_id.test@stripped, 2007-06-06 10:48:52-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/extra/rpl_tests/rpl_insert_id_pk.test@stripped, 2007-06-06 10:48:52-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/extra/rpl_tests/rpl_loaddata.test@stripped, 2007-06-06 10:48:52-07:00, jimw@rama.(none) +3 -3
    Update ER_DUP_ENTRY-related error message values

  mysql-test/extra/rpl_tests/rpl_row_basic.test@stripped, 2007-06-06 10:48:52-07:00, jimw@rama.(none) +3 -3
    Update ER_DUP_ENTRY-related error message values

  mysql-test/extra/rpl_tests/rpl_stm_EE_err2.test@stripped, 2007-06-06 10:48:53-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/extra/rpl_tests/rpl_trig004.test@stripped, 2007-06-06 10:48:53-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/include/mix1.inc@stripped, 2007-06-06 10:48:33-07:00, jimw@rama.(none) +7 -7
    Update ER_DUP_ENTRY-related error message values

  mysql-test/include/mix2.inc@stripped, 2007-06-06 10:48:33-07:00, jimw@rama.(none) +14 -14
    Update ER_DUP_ENTRY-related error message values

  mysql-test/include/ps_modify.inc@stripped, 2007-06-06 10:48:33-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/include/query_cache.inc@stripped, 2007-06-06 10:48:33-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/include/varchar.inc@stripped, 2007-06-06 10:48:34-07:00, jimw@rama.(none) +6 -6
    Update ER_DUP_ENTRY-related error message values

  mysql-test/r/create.result@stripped, 2007-06-06 10:48:21-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/r/rpl_sp.result@stripped, 2007-06-06 10:48:28-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/r/sp.result@stripped, 2007-06-06 10:48:29-07:00, jimw@rama.(none) +8 -8
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/auto_increment.test@stripped, 2007-06-06 10:48:04-07:00, jimw@rama.(none) +5 -5
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/create.test@stripped, 2007-06-06 10:48:05-07:00, jimw@rama.(none) +10 -10
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/create_select_tmp.test@stripped, 2007-06-06 10:48:05-07:00, jimw@rama.(none) +4 -4
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/ctype_ucs2_def.test@stripped, 2007-06-06 10:48:06-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/ctype_utf8.test@stripped, 2007-06-06 10:48:06-07:00, jimw@rama.(none) +45 -45
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/delayed.test@stripped, 2007-06-06 10:48:06-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/heap.test@stripped, 2007-06-06 10:48:07-07:00, jimw@rama.(none) +14 -14
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/heap_btree.test@stripped, 2007-06-06 10:48:07-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/heap_hash.test@stripped, 2007-06-06 10:48:07-07:00, jimw@rama.(none) +3 -3
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/innodb.test@stripped, 2007-06-06 10:48:07-07:00, jimw@rama.(none) +14 -14
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/insert_select.test@stripped, 2007-06-06 10:48:07-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/insert_update.test@stripped, 2007-06-06 10:48:07-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/join_outer.test@stripped, 2007-06-06 10:48:08-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/key.test@stripped, 2007-06-06 10:48:08-07:00, jimw@rama.(none) +6 -6
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/merge.test@stripped, 2007-06-06 10:48:08-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/myisam.test@stripped, 2007-06-06 10:48:08-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/ndb_basic.test@stripped, 2007-06-06 10:48:09-07:00, jimw@rama.(none) +3 -3
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/ndb_charset.test@stripped, 2007-06-06 10:48:09-07:00, jimw@rama.(none) +9 -9
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/ndb_index_unique.test@stripped, 2007-06-06 10:48:09-07:00, jimw@rama.(none) +7 -7
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/ndb_insert.test@stripped, 2007-06-06 10:48:09-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/ndb_replace.test@stripped, 2007-06-06 10:48:09-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/ndb_update.test@stripped, 2007-06-06 10:48:09-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/replace.test@stripped, 2007-06-06 10:48:10-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/rpl_err_ignoredtable.test@stripped, 2007-06-06 10:48:11-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/rpl_ndb_do_table.test@stripped, 2007-06-06 10:48:12-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/rpl_row_create_table.test@stripped, 2007-06-06 10:48:13-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/rpl_sp.test@stripped, 2007-06-06 10:48:14-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/show_check.test@stripped, 2007-06-06 10:48:14-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/sp-error.test@stripped, 2007-06-06 10:48:15-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/sp.test@stripped, 2007-06-06 10:48:15-07:00, jimw@rama.(none) +11 -11
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/sp_trans.test@stripped, 2007-06-06 10:48:15-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/sp_trans_log.test@stripped, 2007-06-06 10:48:15-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/temp_table.test@stripped, 2007-06-06 10:48:15-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/type_binary.test@stripped, 2007-06-06 10:48:15-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/type_bit.test@stripped, 2007-06-06 10:48:15-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/type_bit_innodb.test@stripped, 2007-06-06 10:48:15-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/type_blob.test@stripped, 2007-06-06 10:48:15-07:00, jimw@rama.(none) +2 -2
    Update ER_DUP_ENTRY-related error message values

  mysql-test/t/type_varchar.test@stripped, 2007-06-06 10:48:16-07:00, jimw@rama.(none) +1 -1
    Update ER_DUP_ENTRY-related error message values

  sql/handler.cc@stripped, 2007-06-06 10:49:26-07:00, jimw@rama.(none) +2 -3
    Restore use of ER_DUP_ENTRY error code even when ER_DUP_ENTRY_WITH_KEY_NAME
    error message is being used. (Bug #28842)

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	jimw
# Host:	rama.(none)
# Root:	/home/jimw/my/mysql-5.1-28842

--- 1.310/sql/handler.cc	2007-06-06 10:57:14 -07:00
+++ 1.311/sql/handler.cc	2007-06-06 10:57:14 -07:00
@@ -2053,8 +2053,7 @@
   {
     /* Key is unknown */
     str.copy("", 0, system_charset_info);
-    my_printf_error(ER_DUP_ENTRY_WITH_KEY_NAME, msg,
-		    MYF(0), str.c_ptr(), "*UNKNOWN*");
+    my_printf_error(ER_DUP_ENTRY, msg, MYF(0), str.c_ptr(), "*UNKNOWN*");
   }
   else
   {
@@ -2066,7 +2065,7 @@
       str.length(max_length-4);
       str.append(STRING_WITH_LEN("..."));
     }
-    my_printf_error(ER_DUP_ENTRY_WITH_KEY_NAME, msg,
+    my_printf_error(ER_DUP_ENTRY, msg,
 		    MYF(0), str.c_ptr(), table->key_info[key_nr].name);
   }
 }

--- 1.4/mysql-test/t/sp_trans_log.test	2007-06-06 10:57:14 -07:00
+++ 1.5/mysql-test/t/sp_trans_log.test	2007-06-06 10:57:14 -07:00
@@ -32,7 +32,7 @@
 end|
 
 reset master|
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t2 values (bug23333(),1)| 
 --replace_column 2 # 5 # 6 #
 show binlog events from 106 /* with fixes for #23333 will show there is the query */|

--- 1.34/mysql-test/include/mix1.inc	2007-06-06 10:57:14 -07:00
+++ 1.35/mysql-test/include/mix1.inc	2007-06-06 10:57:14 -07:00
@@ -649,24 +649,24 @@
 
 CREATE TABLE t1 (a int, b int);
 insert into t1 values (1,1),(1,2);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TABLE t2 (primary key (a)) select * from t1;
 # This should give warning
 drop table if exists t2;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TEMPORARY TABLE t2 (primary key (a)) select * from t1;
 # This should give warning
 drop table if exists t2;
 CREATE TABLE t2 (a int, b int, primary key (a));
 BEGIN;
 INSERT INTO t2 values(100,100);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TABLE IF NOT EXISTS t2 (primary key (a)) select * from t1;
 SELECT * from t2;
 ROLLBACK;
 SELECT * from t2;
 TRUNCATE table t2;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t2 select * from t1;
 SELECT * from t2;
 drop table t2;
@@ -674,19 +674,19 @@
 CREATE TEMPORARY TABLE t2 (a int, b int, primary key (a));
 BEGIN;
 INSERT INTO t2 values(100,100);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TEMPORARY TABLE IF NOT EXISTS t2 (primary key (a)) select * from t1;
 SELECT * from t2;
 COMMIT;
 BEGIN;
 INSERT INTO t2 values(101,101);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TEMPORARY TABLE IF NOT EXISTS t2 (primary key (a)) select * from t1;
 SELECT * from t2;
 ROLLBACK;
 SELECT * from t2;
 TRUNCATE table t2;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t2 select * from t1;
 SELECT * from t2;
 drop table t1,t2;

--- 1.105/mysql-test/t/ctype_utf8.test	2007-06-06 10:57:14 -07:00
+++ 1.106/mysql-test/t/ctype_utf8.test	2007-06-06 10:57:14 -07:00
@@ -230,9 +230,9 @@
 create table t1 (c varchar(30) character set utf8, unique(c(10)));
 insert into t1 values ('1'),('2'),('3'),('x'),('y'),('z');
 insert into t1 values ('aaaaaaaaaa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaaaaaaaaaa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaaaaaaaaaaa');
 insert into t1 values (repeat('b',20));
 select c c1 from t1 where c='1';
@@ -254,9 +254,9 @@
 --enable_warnings
 insert into t1 values ('1'),('2'),('3'),('x'),('y'),('z');
 insert into t1 values ('aaaaaaaaaa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaaaaaaaaaa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaaaaaaaaaaa');
 insert into t1 values (repeat('b',20));
 select c c1 from t1 where c='1';
@@ -276,23 +276,23 @@
 insert into t1 values ('1'),('2'),('3'),('4'),('x'),('y'),('z');
 insert into t1 values ('a');
 insert into t1 values ('aa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaa');
 insert into t1 values ('b');
 insert into t1 values ('bb');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('bbb');
 insert into t1 values ('а');
 insert into t1 values ('аа');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ааа');
 insert into t1 values ('б');
 insert into t1 values ('бб');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ббб');
 insert into t1 values ('ꪪ');
 insert into t1 values ('ꪪꪪ');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ꪪꪪꪪ');
 drop table t1;
 #
@@ -305,23 +305,23 @@
 insert into t1 values ('1'),('2'),('3'),('4'),('x'),('y'),('z');
 insert into t1 values ('a');
 insert into t1 values ('aa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaa');
 insert into t1 values ('b');
 insert into t1 values ('bb');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('bbb');
 insert into t1 values ('а');
 insert into t1 values ('аа');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ааа');
 insert into t1 values ('б');
 insert into t1 values ('бб');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ббб');
 insert into t1 values ('ꪪ');
 insert into t1 values ('ꪪꪪ');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ꪪꪪꪪ');
 drop table t1;
 #
@@ -334,14 +334,14 @@
 ) engine=heap;
 show create table t1;
 insert into t1 values ('a'),('b'),('c'),('d'),('e'),('f');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaa');
 insert into t1 values ('б');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('бб');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ббб');
 select c as c_all from t1 order by c;
 select c as c_a from t1 where c='a';
@@ -358,14 +358,14 @@
 ) engine=heap;
 show create table t1;
 insert into t1 values ('a'),('b'),('c'),('d'),('e'),('f');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaa');
 insert into t1 values ('б');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('бб');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ббб');
 select c as c_all from t1 order by c;
 select c as c_a from t1 where c='a';
@@ -383,14 +383,14 @@
 ) engine=innodb;
 --enable_warnings
 insert into t1 values ('a'),('b'),('c'),('d'),('e'),('f');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaa');
 insert into t1 values ('б');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('бб');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ббб');
 select c as c_all from t1 order by c;
 select c as c_a from t1 where c='a';
@@ -404,9 +404,9 @@
 create table t1 (c varchar(30) character set utf8 collate utf8_bin, unique(c(10)));
 insert into t1 values ('1'),('2'),('3'),('x'),('y'),('z');
 insert into t1 values ('aaaaaaaaaa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaaaaaaaaaa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaaaaaaaaaaa');
 insert into t1 values (repeat('b',20));
 select c c1 from t1 where c='1';
@@ -427,23 +427,23 @@
 insert into t1 values ('1'),('2'),('3'),('4'),('x'),('y'),('z');
 insert into t1 values ('a');
 insert into t1 values ('aa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaa');
 insert into t1 values ('b');
 insert into t1 values ('bb');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('bbb');
 insert into t1 values ('а');
 insert into t1 values ('аа');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ааа');
 insert into t1 values ('б');
 insert into t1 values ('бб');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ббб');
 insert into t1 values ('ꪪ');
 insert into t1 values ('ꪪꪪ');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ꪪꪪꪪ');
 drop table t1;
 
@@ -457,14 +457,14 @@
 ) engine=heap;
 show create table t1;
 insert into t1 values ('a'),('b'),('c'),('d'),('e'),('f');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaa');
 insert into t1 values ('б');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('бб');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ббб');
 select c as c_all from t1 order by c;
 select c as c_a from t1 where c='a';
@@ -481,14 +481,14 @@
 ) engine=heap;
 show create table t1;
 insert into t1 values ('a'),('b'),('c'),('d'),('e'),('f');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaa');
 insert into t1 values ('б');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('бб');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ббб');
 select c as c_all from t1 order by c;
 select c as c_a from t1 where c='a';
@@ -506,14 +506,14 @@
 ) engine=innodb;
 --enable_warnings
 insert into t1 values ('a'),('b'),('c'),('d'),('e'),('f');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('aaa');
 insert into t1 values ('б');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('бб');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('ббб');
 select c as c_all from t1 order by c;
 select c as c_a from t1 where c='a';

--- 1.26/mysql-test/t/heap_btree.test	2007-06-06 10:57:14 -07:00
+++ 1.27/mysql-test/t/heap_btree.test	2007-06-06 10:57:14 -07:00
@@ -143,7 +143,7 @@
 explain SELECT * FROM t1 WHERE b IS NULL;
 SELECT * FROM t1 WHERE b<=>NULL;
 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t1 VALUES (1,3);
 DROP TABLE t1;
 

--- 1.14/mysql-test/t/heap_hash.test	2007-06-06 10:57:14 -07:00
+++ 1.15/mysql-test/t/heap_hash.test	2007-06-06 10:57:14 -07:00
@@ -128,7 +128,7 @@
 explain SELECT * FROM t1 WHERE b IS NULL;
 SELECT * FROM t1 WHERE b<=>NULL;
 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t1 VALUES (1,3);
 DROP TABLE t1;
 
@@ -272,14 +272,14 @@
                 col2 VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, 
                 UNIQUE KEY key1 USING HASH (col1, col2)) ENGINE=MEMORY;
 INSERT INTO t1 VALUES('A', 'A');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t1 VALUES('A ', 'A ');
 DROP TABLE t1;
 CREATE TABLE t1(col1 VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, 
                 col2 VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, 
                 UNIQUE KEY key1 USING HASH (col1, col2)) ENGINE=MEMORY;
 INSERT INTO t1 VALUES('A', 'A');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t1 VALUES('A ', 'A ');
 DROP TABLE t1;
 

--- 1.7/mysql-test/t/ctype_ucs2_def.test	2007-06-06 10:57:14 -07:00
+++ 1.8/mysql-test/t/ctype_ucs2_def.test	2007-06-06 10:57:14 -07:00
@@ -25,7 +25,7 @@
                 col2 VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_bin NOT NULL, 
                 UNIQUE KEY key1 USING HASH (col1, col2)) ENGINE=MEMORY;
 INSERT INTO t1 VALUES('A', 'A'), ('B', 'B'), ('C', 'C');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t1 VALUES('A ', 'A ');
 DROP TABLE t1;
 

--- 1.5/mysql-test/t/type_binary.test	2007-06-06 10:57:14 -07:00
+++ 1.6/mysql-test/t/type_binary.test	2007-06-06 10:57:14 -07:00
@@ -31,7 +31,7 @@
 create table t1 (s1 binary(2) primary key);
 insert into t1 values (0x01);
 insert into t1 values (0x0120);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values (0x0100);
 select hex(s1) from t1 order by s1;
 # check index search

--- 1.38/mysql-test/r/rpl_sp.result	2007-06-06 10:57:14 -07:00
+++ 1.39/mysql-test/r/rpl_sp.result	2007-06-06 10:57:14 -07:00
@@ -107,7 +107,7 @@
 ERROR 23000: Duplicate entry '20' for key 'a'
 show warnings;
 Level	Code	Message
-Error	1582	Duplicate entry '20' for key 'a'
+Error	1062	Duplicate entry '20' for key 'a'
 select * from t2;
 a
 20
@@ -241,7 +241,7 @@
 end|
 do fn1(100);
 Warnings:
-Error	1582	Duplicate entry '100' for key 'a'
+Error	1062	Duplicate entry '100' for key 'a'
 select fn1(20);
 ERROR 23000: Duplicate entry '20' for key 'a'
 select * from t2;

--- 1.32/mysql-test/t/rpl_sp.test	2007-06-06 10:57:14 -07:00
+++ 1.33/mysql-test/t/rpl_sp.test	2007-06-06 10:57:14 -07:00
@@ -153,7 +153,7 @@
 
 delimiter ;|
 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 call foo4();
 show warnings;
 
@@ -308,7 +308,7 @@
 
 do fn1(100);
 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 select fn1(20);
 
 select * from t2;

--- 1.7/mysql-test/include/ps_modify.inc	2007-06-06 10:57:14 -07:00
+++ 1.8/mysql-test/include/ps_modify.inc	2007-06-06 10:57:14 -07:00
@@ -193,7 +193,7 @@
 execute stmt1 using @arg00;
 select a,b from t1 where b = @arg00;
 # the second insert fails, because the first column is primary key
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 execute stmt1 using @arg00;
 set @arg00=NULL ;
 prepare stmt1 from 'insert into t1 values(0, ? )';
@@ -272,7 +272,7 @@
 select * from t1 order by a;
 set @arg00=81 ;
 set @arg01=1 ;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 execute stmt1 using @arg00, @arg01;
 
 ## insert, autoincrement column and ' SELECT LAST_INSERT_ID() '

--- 1.4/mysql-test/extra/rpl_tests/rpl_insert_delayed.test	2007-06-06 10:57:14 -07:00
+++ 1.5/mysql-test/extra/rpl_tests/rpl_insert_delayed.test	2007-06-06 10:57:14 -07:00
@@ -42,7 +42,7 @@
 {
   # statement below will be converted to non-delayed INSERT and so
   # will stop at first error, guaranteeing replication.
-  --error ER_DUP_ENTRY_WITH_KEY_NAME
+  --error ER_DUP_ENTRY
   insert delayed into t1 values(10, "is Bond"), (20, "James Bond");
 }
 if (!$binlog_format_statement)
@@ -64,7 +64,7 @@
   # statement below will be converted to non-delayed INSERT and so
   # will be binlogged with its ER_DUP_ENTRY error code, guaranteeing
   # replication (slave will hit the same error code and so be fine).
-  --error ER_DUP_ENTRY_WITH_KEY_NAME
+  --error ER_DUP_ENTRY
   insert delayed into t1 values(20, "is Bond"), (10, "James Bond");
 }
 if (!$binlog_format_statement)

--- 1.15/mysql-test/t/create_select_tmp.test	2007-06-06 10:57:14 -07:00
+++ 1.16/mysql-test/t/create_select_tmp.test	2007-06-06 10:57:14 -07:00
@@ -14,19 +14,19 @@
 --enable_warnings
 CREATE TABLE t1 ( a int );
 INSERT INTO t1 VALUES (1),(2),(1);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TABLE t2 ( PRIMARY KEY (a) ) ENGINE=INNODB SELECT a FROM t1;
 --error 1146
 select * from t2;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TEMPORARY TABLE t2 ( PRIMARY KEY (a) ) ENGINE=INNODB SELECT a FROM t1;
 --error 1146
 select * from t2;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TABLE t2 ( PRIMARY KEY (a) ) ENGINE=MYISAM SELECT a FROM t1;
 --error 1146
 select * from t2;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TEMPORARY TABLE t2 ( PRIMARY KEY (a) ) ENGINE=MYISAM SELECT a FROM t1;
 --error 1146
 select * from t2;

--- 1.38/mysql-test/extra/binlog_tests/mix_innodb_myisam_binlog.test	2007-06-06 10:57:14 -07:00
+++ 1.39/mysql-test/extra/binlog_tests/mix_innodb_myisam_binlog.test	2007-06-06 10:57:14 -07:00
@@ -246,12 +246,12 @@
 CREATE TABLE t1 (a int, b int) engine=myisam;
 reset master;
 INSERT INTO t1 values (1,1),(1,2);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TABLE t2 (primary key (a)) engine=innodb select * from t1;
 # This should give warning
 DROP TABLE if exists t2;
 INSERT INTO t1 values (3,3);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TEMPORARY TABLE t2 (primary key (a)) engine=innodb select * from t1;
 ROLLBACK;
 # This should give warning
@@ -259,12 +259,12 @@
 
 CREATE TABLE t2 (a int, b int, primary key (a)) engine=innodb;
 INSERT INTO t1 VALUES (4,4);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TABLE IF NOT EXISTS t2 (primary key (a)) engine=innodb select * from t1;
 SELECT * from t2;
 TRUNCATE table t2;
 INSERT INTO t1 VALUES (5,5);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t2 select * from t1;
 SELECT * FROM t2;
 DROP TABLE t2;
@@ -274,25 +274,25 @@
 INSERT INTO t1 values (7,7);
 ROLLBACK;
 INSERT INTO t1 values (8,8);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TEMPORARY TABLE IF NOT EXISTS t2 (primary key (a)) engine=innodb select * from t1;
 COMMIT;
 INSERT INTO t1 values (9,9);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TEMPORARY TABLE IF NOT EXISTS t2 (primary key (a)) engine=innodb select * from t1;
 ROLLBACK;
 SELECT * from t2;
 TRUNCATE table t2;
 INSERT INTO t1 values (10,10);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t2 select * from t1;
 SELECT * from t1;
 INSERT INTO t2 values (100,100);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TEMPORARY TABLE IF NOT EXISTS t2 (primary key (a)) engine=innodb select * from t1;
 COMMIT;
 INSERT INTO t2 values (101,101);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TEMPORARY TABLE IF NOT EXISTS t2 (primary key (a)) engine=innodb select * from t1;
 ROLLBACK;
 SELECT * from t2;

--- 1.28/mysql-test/t/rpl_err_ignoredtable.test	2007-06-06 10:57:14 -07:00
+++ 1.29/mysql-test/t/rpl_err_ignoredtable.test	2007-06-06 10:57:14 -07:00
@@ -11,7 +11,7 @@
 create table t1 (a int primary key);
 create table t4 (a int primary key);
 # generate an error that goes to the binlog
---error 1022, ER_DUP_ENTRY_WITH_KEY_NAME
+--error 1022, ER_DUP_ENTRY
 insert into t1 values (1),(1);
 insert into t4 values (1),(2);
 save_master_pos;

--- 1.7/mysql-test/extra/binlog_tests/insert_select-binlog.test	2007-06-06 10:57:14 -07:00
+++ 1.8/mysql-test/extra/binlog_tests/insert_select-binlog.test	2007-06-06 10:57:14 -07:00
@@ -13,7 +13,7 @@
 create table t2(a int);
 insert into t2 values(1),(2);
 reset master;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 select * from t2;
 # The above should produce an error, but still be in the binlog;
 # verify the binlog :
@@ -27,7 +27,7 @@
 create table t1(a int);
 insert into t1 values(1),(1);
 reset master;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 create table t2(unique(a)) select a from t1;
 # The above should produce an error, *and* not appear in the binlog
 let $VERSION=`select version()`;

--- 1.3/mysql-test/t/rpl_ndb_do_table.test	2007-06-06 10:57:14 -07:00
+++ 1.4/mysql-test/t/rpl_ndb_do_table.test	2007-06-06 10:57:14 -07:00
@@ -32,11 +32,11 @@
 #
 connection master;
 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t1 VALUES (3, repeat('bad',1));
 
 connection slave;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t1 VALUES (3, repeat('bad too',1));
 
 # cleanup

--- 1.3/mysql-test/extra/rpl_tests/rpl_insert_id_pk.test	2007-06-06 10:57:14 -07:00
+++ 1.4/mysql-test/extra/rpl_tests/rpl_insert_id_pk.test	2007-06-06 10:57:14 -07:00
@@ -80,7 +80,7 @@
 CREATE TABLE t1 ( a INT UNIQUE );
 SET FOREIGN_KEY_CHECKS=0;
 # Duplicate Key Errors codes
---error 1022, ER_DUP_ENTRY_WITH_KEY_NAME
+--error 1022, ER_DUP_ENTRY
 INSERT INTO t1 VALUES (1),(1);
 sync_slave_with_master;
 connection master;

--- 1.2/mysql-test/extra/rpl_tests/rpl_stm_EE_err2.test	2007-06-06 10:57:14 -07:00
+++ 1.3/mysql-test/extra/rpl_tests/rpl_stm_EE_err2.test	2007-06-06 10:57:14 -07:00
@@ -19,7 +19,7 @@
 insert into t1 values(2);
 set sql_log_bin=1;
 save_master_pos;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values(1),(2);
 drop table t1;
 save_master_pos;

--- 1.6/mysql-test/extra/rpl_tests/rpl_auto_increment.test	2007-06-06 10:57:14 -07:00
+++ 1.7/mysql-test/extra/rpl_tests/rpl_auto_increment.test	2007-06-06 10:57:14 -07:00
@@ -76,7 +76,7 @@
 insert into t1 values (500),(NULL),(502),(NULL),(NULL);
 select * from t1;
 set @@insert_id=600;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values(600),(NULL),(NULL);
 set @@insert_id=600;
 insert ignore into t1 values(600),(NULL),(NULL),(610),(NULL);
@@ -119,7 +119,7 @@
 set auto_increment_offset=4;
 insert into t1 values(null);
 insert into t1 values(null);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values(null);
 select a, mod(a-@@auto_increment_offset,@@auto_increment_increment) from t1 order by a;
 

--- 1.6/mysql-test/extra/rpl_tests/rpl_foreign_key.test	2007-06-06 10:57:14 -07:00
+++ 1.7/mysql-test/extra/rpl_tests/rpl_foreign_key.test	2007-06-06 10:57:14 -07:00
@@ -22,8 +22,8 @@
 CREATE TABLE t3 ( a INT UNIQUE );
 SET FOREIGN_KEY_CHECKS=0;
 # Had to add 1022 for run with ndb as ndb uses different
-# error and error code for error ER_DUP_ENTRY_WITH_KEY_NAME. Bug 16677
---error 1022, ER_DUP_ENTRY_WITH_KEY_NAME
+# error and error code for error ER_DUP_ENTRY. Bug 16677
+--error 1022, ER_DUP_ENTRY
 INSERT INTO t3 VALUES (1),(1);
 sync_slave_with_master;
 

--- 1.16/mysql-test/extra/rpl_tests/rpl_insert_id.test	2007-06-06 10:57:14 -07:00
+++ 1.17/mysql-test/extra/rpl_tests/rpl_insert_id.test	2007-06-06 10:57:14 -07:00
@@ -97,7 +97,7 @@
 CREATE TABLE t1 ( a INT UNIQUE );
 SET FOREIGN_KEY_CHECKS=0;
 # Duplicate Key Errors
---error 1022, ER_DUP_ENTRY_WITH_KEY_NAME
+--error 1022, ER_DUP_ENTRY
 INSERT INTO t1 VALUES (1),(1);
 sync_slave_with_master;
 connection master;

--- 1.7/mysql-test/extra/rpl_tests/rpl_loaddata.test	2007-06-06 10:57:14 -07:00
+++ 1.8/mysql-test/extra/rpl_tests/rpl_loaddata.test	2007-06-06 10:57:14 -07:00
@@ -131,7 +131,7 @@
 reset master;
 eval create table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60),
 unique(day)) engine=$engine_type; # no transactions
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 load data infile '../std_data_ln/rpl_loaddata2.dat' into table t2 fields
 terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by
 '\n##\n' starting by '>' ignore 1 lines;
@@ -147,7 +147,7 @@
 alter table t2 drop key day;
 connection master;
 delete from t2;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 load data infile '../std_data_ln/rpl_loaddata2.dat' into table t2 fields
 terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by
 '\n##\n' starting by '>' ignore 1 lines;
@@ -161,7 +161,7 @@
 # BUG#17233 LOAD DATA INFILE: failure causes mysqld dbug_assert, binlog not flushed
 CREATE TABLE t1 (word CHAR(20) NOT NULL PRIMARY KEY) ENGINE=INNODB;
 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 LOAD DATA INFILE "../std_data_ln/words.dat" INTO TABLE t1;
 
 --disable warnings

--- 1.4/mysql-test/extra/rpl_tests/rpl_trig004.test	2007-06-06 10:57:14 -07:00
+++ 1.5/mysql-test/extra/rpl_tests/rpl_trig004.test	2007-06-06 10:57:14 -07:00
@@ -29,7 +29,7 @@
 
 INSERT INTO test.t2 VALUES (1, 0.0);
 # Expect duplicate error 1022 == ndb
---error 1022, ER_DUP_ENTRY_WITH_KEY_NAME
+--error 1022, ER_DUP_ENTRY
 INSERT INTO test.t2 VALUES (1, 0.0);
 
 #show binlog events; 

--- 1.5/mysql-test/extra/rpl_tests/rpl_row_basic.test	2007-06-06 10:57:14 -07:00
+++ 1.6/mysql-test/extra/rpl_tests/rpl_row_basic.test	2007-06-06 10:57:14 -07:00
@@ -195,11 +195,11 @@
 
 # First we make sure that the constraints are correctly set.
 INSERT INTO t8 VALUES (99,99,99);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t8 VALUES (99,22,33);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t8 VALUES (11,99,33);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t8 VALUES (11,22,99);
 SELECT * FROM t8 ORDER BY a;
 

--- 1.12/mysql-test/t/rpl_row_create_table.test	2007-06-06 10:57:14 -07:00
+++ 1.13/mysql-test/t/rpl_row_create_table.test	2007-06-06 10:57:14 -07:00
@@ -67,7 +67,7 @@
 
 connection master;
 # Test for erroneous constructions
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TABLE t7 (UNIQUE(b)) SELECT a,b FROM tt3;
 # Shouldn't be written to the binary log
 --replace_column 1 # 4 #
@@ -76,7 +76,7 @@
 
 # Test that INSERT-SELECT works the same way as for SBR.
 CREATE TABLE t7 (a INT, b INT UNIQUE);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t7 SELECT a,b FROM tt3;
 SELECT * FROM t7 ORDER BY a,b;
 # Should be written to the binary log

--- 1.54/mysql-test/t/ndb_basic.test	2007-06-06 10:57:14 -07:00
+++ 1.55/mysql-test/t/ndb_basic.test	2007-06-06 10:57:14 -07:00
@@ -807,7 +807,7 @@
 # insert ignore
 create table t1 (a int not null primary key, b int not null) engine=ndb;
 insert into t1 values (1,10), (2,20), (3,30);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 set a=1, b=100;
 insert ignore into t1 set a=1, b=100;
 select * from t1 order by a;
@@ -820,12 +820,12 @@
 create table t2 (c int not null primary key, d int not null) engine=ndb;
 insert into t1 values (1,10), (2,10), (3,30), (4, 30);
 insert into t2 values (1,10), (2,10), (3,30), (4, 30);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 update t1 set a = 1 where a = 3;
 select * from t1 order by a;
 update t1 set b = 1 where a > 1 order by a desc limit 1;
 select * from t1 order by a;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 update t1,t2 set a = 1, c = 1 where a = 3 and c = 3;
 select * from t1 order by a;
 update ignore t1,t2 set a = 1, c = 1 where a = 3 and c = 3;

--- 1.28/mysql-test/t/ndb_index_unique.test	2007-06-06 10:57:14 -07:00
+++ 1.29/mysql-test/t/ndb_index_unique.test	2007-06-06 10:57:14 -07:00
@@ -22,7 +22,7 @@
 insert into t1 values(7,8,3);
 select * from t1 where b = 4 order by a;
 
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 values(8, 2, 3);
 select * from t1 order by a;
 delete from t1 where a = 1;
@@ -59,7 +59,7 @@
 select * from t1 use index (bc) where b IS NULL and c = 2 order by a;
 select * from t1 use index (bc) where b < 4 order by a;
 select * from t1 use index (bc) where b IS NOT NULL order by a;
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 values(5,1,1);
 drop table t1;
 
@@ -82,7 +82,7 @@
 insert into t2 values(7,8,3);
 select * from t2 where b = 4 order by a;
 
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t2 values(8, 2, 3);
 select * from t2 order by a;
 delete from t2 where a = 1;
@@ -91,7 +91,7 @@
 
 # Bug #24818 CREATE UNIQUE INDEX (...) USING HASH on a NDB table crashes mysqld
 create unique index bi using hash on t2(b);
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t2 values(9, 3, 1);
 alter table t2 drop index bi;
 insert into t2 values(9, 3, 1);
@@ -154,7 +154,7 @@
 
 select * from t1 order by pk;
 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values (5,0);
 select * from t1 order by pk;
 delete from t1 where a = 0;
@@ -173,7 +173,7 @@
 
 select * from t2 order by pk;
 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t2 values(2,3,19,'abc');
 select * from t2 order by pk;
 delete from t2 where c IS NOT NULL;
@@ -342,7 +342,7 @@
 engine=ndb charset=utf8;
 
 insert into t1 values (1, repeat(_utf8 0xe288ab6474, 200));
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values (2, repeat(_utf8 0xe288ab6474, 200));
 select a, sha1(b) from t1;
 

--- 1.14/mysql-test/t/ndb_insert.test	2007-06-06 10:57:14 -07:00
+++ 1.15/mysql-test/t/ndb_insert.test	2007-06-06 10:57:14 -07:00
@@ -433,7 +433,7 @@
 #
 # Insert duplicate rows
 # 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t1 VALUES (1,1,1);
 
 --error 1022

--- 1.8/mysql-test/t/ndb_replace.test	2007-06-06 10:57:14 -07:00
+++ 1.9/mysql-test/t/ndb_replace.test	2007-06-06 10:57:14 -07:00
@@ -21,7 +21,7 @@
 insert into t1 (gesuchnr, benutzer_id) value (3,2);
 replace into t1 (gesuchnr,benutzer_id) values (1,1);
 replace into t1 (gesuchnr,benutzer_id) values (1,1);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 (gesuchnr,benutzer_id) values (1,1);
 replace into t1 (gesuchnr,benutzer_id) values (1,1);
 select * from t1 order by gesuchnr;

--- 1.6/mysql-test/include/mix2.inc	2007-06-06 10:57:14 -07:00
+++ 1.7/mysql-test/include/mix2.inc	2007-06-06 10:57:14 -07:00
@@ -96,7 +96,7 @@
 update t1 set parent_id=parent_id+100;
 select * from t1 where parent_id=102;
 update t1 set id=id+1000;
--- error ER_DUP_ENTRY_WITH_KEY_NAME,1022
+-- error ER_DUP_ENTRY,1022
 update t1 set id=1024 where id=1009;
 select * from t1;
 update ignore t1 set id=id+1; # This will change all rows
@@ -179,13 +179,13 @@
 select n, "after commit" from t1;
 commit;
 insert into t1 values (5);
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 values (4);
 commit;
 select n, "after commit" from t1;
 set autocommit=1;
 insert into t1 values (6);
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 values (4);
 select n from t1;
 set autocommit=0;
@@ -259,7 +259,7 @@
 
 eval CREATE TABLE t1 (id char(8) not null primary key, val int not null) engine=$engine_type;
 insert into t1 values ('pippo', 12);
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 values ('pippo', 12); # Gives error
 delete from t1;
 delete from t1 where id = 'pippo';
@@ -390,9 +390,9 @@
 
 insert into t1 (ggid,passwd) values ('test1','xxx');
 insert into t1 (ggid,passwd) values ('test2','yyy');
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 (ggid,passwd) values ('test2','this will fail');
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 (ggid,id) values ('this will fail',1);
 
 select * from t1 where ggid='test1';
@@ -401,7 +401,7 @@
 
 replace into t1 (ggid,id) values ('this will work',1);
 replace into t1 (ggid,passwd) values ('test2','this will work');
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 update t1 set id=100,ggid='test2' where id=1;
 select * from t1;
 select * from t1 where id=1;
@@ -572,7 +572,7 @@
 eval create table t1 (id int NOT NULL,id2 int NOT NULL,id3 int NOT NULL,dummy1 char(30),primary key (id,id2),index index_id3 (id3)) engine=$engine_type;
 insert into t1 values (0,0,0,'ABCDEFGHIJ'),(2,2,2,'BCDEFGHIJK'),(1,1,1,'CDEFGHIJKL');
 LOCK TABLES t1 WRITE;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values (99,1,2,'D'),(1,1,2,'D');
 select id from t1;
 select id from t1;
@@ -583,7 +583,7 @@
 insert into t1 values (0,0,0,'ABCDEFGHIJ'),(2,2,2,'BCDEFGHIJK'),(1,1,1,'CDEFGHIJKL');
 LOCK TABLES t1 WRITE;
 begin;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values (99,1,2,'D'),(1,1,2,'D');
 select id from t1;
 insert ignore into t1 values (100,1,2,'D'),(1,1,99,'D');
@@ -1513,7 +1513,7 @@
 key (rowid), unique(val)) engine=$engine_type;
 replace into t1 (val) values ('1'),('2');
 replace into t1 (val) values ('1'),('2');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 (val) values ('1'),('2');
 select * from t1;
 drop table t1;
@@ -1528,7 +1528,7 @@
 insert into t1 (val) values (1);
 update t1 set a=2 where a=1;
 # We should get the following error because InnoDB does not update the counter
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 (val) values (1);
 select * from t1;
 drop table t1;
@@ -1894,13 +1894,13 @@
 eval create table t4 (s1 char(2) binary,primary key (s1)) engine=$engine_type;
 
 insert into t1 values (0x41),(0x4120),(0x4100);
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t2 values (0x41),(0x4120),(0x4100);
 insert into t2 values (0x41),(0x4120);
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t3 values (0x41),(0x4120),(0x4100);
 insert into t3 values (0x41),(0x4100);
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t4 values (0x41),(0x4120),(0x4100);
 insert into t4 values (0x41),(0x4100);
 select hex(s1) from t1;

--- 1.143/mysql-test/r/create.result	2007-06-06 10:57:14 -07:00
+++ 1.144/mysql-test/r/create.result	2007-06-06 10:57:14 -07:00
@@ -285,7 +285,7 @@
 show warnings;
 Level	Code	Message
 Note	1050	Table 't1' already exists
-Error	1582	Duplicate entry '3' for key 'PRIMARY'
+Error	1062	Duplicate entry '3' for key 'PRIMARY'
 show status like "Opened_tables";
 Variable_name	Value
 Opened_tables	2

--- 1.30/mysql-test/t/auto_increment.test	2007-06-06 10:57:14 -07:00
+++ 1.31/mysql-test/t/auto_increment.test	2007-06-06 10:57:14 -07:00
@@ -101,10 +101,10 @@
 insert into t1 set i = null;
 select last_insert_id();
 explain extended select last_insert_id();
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 set i = 254;
 select last_insert_id();
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 set i = null;
 select last_insert_id();
 drop table t1;
@@ -122,7 +122,7 @@
 select last_insert_id();
 insert into t1 values (NULL, 15);
 select last_insert_id();
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values (NULL, 10);
 select last_insert_id();
 
@@ -277,7 +277,7 @@
 key (rowid), unique(val));
 replace into t1 (val) values ('1'),('2');
 replace into t1 (val) values ('1'),('2');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 (val) values ('1'),('2');
 select * from t1;
 drop table t1;
@@ -300,7 +300,7 @@
 CREATE TABLE t1 (t1 INT(10) PRIMARY KEY, t2 INT(10));
 INSERT INTO t1 VALUES(0, 0);
 INSERT INTO t1 VALUES(1, 1);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 ALTER TABLE t1 CHANGE t1 t1 INT(10) auto_increment;
 DROP TABLE t1;
 

--- 1.95/mysql-test/t/create.test	2007-06-06 10:57:14 -07:00
+++ 1.96/mysql-test/t/create.test	2007-06-06 10:57:14 -07:00
@@ -153,7 +153,7 @@
 
 CREATE TABLE t1 (a int not null);
 INSERT INTO t1 values (1),(2),(1);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TABLE t2 (primary key(a)) SELECT * FROM t1;
 --error 1146
 SELECT * from t2;
@@ -232,7 +232,7 @@
 create table if not exists t1 select 2;
 select * from t1;
 create table if not exists t1 select 3 as 'a',4 as 'b';
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 create table if not exists t1 select 3 as 'a',3 as 'b';
 show warnings;
 show status like "Opened_tables";
@@ -698,7 +698,7 @@
 create table if not exists t1 select 1 as a, 2 as b;
 drop table t1;
 # Finally error which happens during insert
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 create table t1 (primary key (a)) (select 1 as a) union all (select 1 as a);
 # What happens if table already exists ?
 create table t1 (i int);
@@ -712,7 +712,7 @@
 select * from t1;
 # Error which happens during insertion of rows
 alter table t1 add primary key (i);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 create table if not exists t1 (select 2 as i) union all (select 2 as i);
 select * from t1;
 drop table t1;
@@ -798,30 +798,30 @@
 
 CREATE TABLE t1 (a int, b int);
 insert into t1 values (1,1),(1,2);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TABLE t2 (primary key (a)) select * from t1;
 # This should give warning
 drop table if exists t2;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TEMPORARY TABLE t2 (primary key (a)) select * from t1;
 # This should give warning
 drop table if exists t2;
 CREATE TABLE t2 (a int, b int, primary key (a));
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TABLE IF NOT EXISTS t2 (primary key (a)) select * from t1;
 SELECT * from t2;
 TRUNCATE table t2;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t2 select * from t1;
 SELECT * from t2;
 drop table t2;
 
 CREATE TEMPORARY TABLE t2 (a int, b int, primary key (a));
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 CREATE TEMPORARY TABLE IF NOT EXISTS t2 (primary key (a)) select * from t1;
 SELECT * from t2;
 TRUNCATE table t2;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t2 select * from t1;
 SELECT * from t2;
 drop table t1,t2;

--- 1.19/mysql-test/t/delayed.test	2007-06-06 10:57:14 -07:00
+++ 1.20/mysql-test/t/delayed.test	2007-06-06 10:57:14 -07:00
@@ -184,7 +184,7 @@
 INSERT INTO t1 VALUES(NULL, 81), (NULL, 82), (NULL, 83);
 # Create a duplicate value.
 SET insert_id= 114;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t1 VALUES(NULL, 91);
 INSERT INTO t1 VALUES           (NULL, 92), (NULL, 93);
 # Check what we have now

--- 1.37/mysql-test/t/heap.test	2007-06-06 10:57:14 -07:00
+++ 1.38/mysql-test/t/heap.test	2007-06-06 10:57:14 -07:00
@@ -128,7 +128,7 @@
 explain SELECT * FROM t1 WHERE b IS NULL;
 SELECT * FROM t1 WHERE b<=>NULL;
 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t1 VALUES (1,3);
 DROP TABLE t1;
 
@@ -270,7 +270,7 @@
 explain select count(*) from t1 where v between 'a' and 'a ';
 explain select count(*) from t1 where v between 'a' and 'a ' and v between 'a  ' and 'b\n';
 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 alter table t1 add unique(v);
 select concat('*',v,'*',c,'*',t,'*') as qq from t1 where v='a' order by length(concat('*',v,'*',c,'*',t,'*'));
 explain select * from t1 where v='a';
@@ -296,17 +296,17 @@
 
 create table t1 (a char(10), unique (a));
 insert into t1 values ('a');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a ');
 
 alter table t1 modify a varchar(10);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a '),('a  '),('a   '),('a         ');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a     ');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a          ');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a ');
 update t1 set a='a      ' where a like 'a ';
 update t1 set a='a  ' where a like 'a      ';
@@ -357,7 +357,7 @@
 --replace_column 9 #
 explain select count(*) from t1 where v between 'a' and 'a ' and v between 'a  ' and 'b\n';
 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 alter table t1 add unique(v);
 select concat('*',v,'*',c,'*',t,'*') as qq from t1 where v='a' order by length(concat('*',v,'*',c,'*',t,'*'));
 # Number of rows is not constant for b-trees keys
@@ -372,17 +372,17 @@
 
 create table t1 (a char(10), unique using btree (a)) engine=heap;
 insert into t1 values ('a');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a ');
 
 alter table t1 modify a varchar(10);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a '),('a  '),('a   '),('a         ');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a     ');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a          ');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a ');
 update t1 set a='a      ' where a like 'a ';
 update t1 set a='a  ' where a like 'a      ';
@@ -432,7 +432,7 @@
 #
 create table t1 (c char(255), primary key(c(90)));
 insert into t1 values ("abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz");
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ("abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz");
 drop table t1;
 

--- 1.162/mysql-test/t/innodb.test	2007-06-06 10:57:14 -07:00
+++ 1.163/mysql-test/t/innodb.test	2007-06-06 10:57:14 -07:00
@@ -53,7 +53,7 @@
 update t1 set parent_id=parent_id+100;
 select * from t1 where parent_id=102;
 update t1 set id=id+1000;
--- error ER_DUP_ENTRY_WITH_KEY_NAME,1022
+-- error ER_DUP_ENTRY,1022
 update t1 set id=1024 where id=1009; 
 select * from t1;
 update ignore t1 set id=id+1; # This will change all rows
@@ -134,13 +134,13 @@
 select n, "after commit" from t1;
 commit;
 insert into t1 values (5);
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 values (4);
 commit;
 select n, "after commit" from t1;
 set autocommit=1;
 insert into t1 values (6);
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 values (4);
 select n from t1;
 set autocommit=0;
@@ -214,7 +214,7 @@
 
 CREATE TABLE t1 (id char(8) not null primary key, val int not null) engine=innodb;
 insert into t1 values ('pippo', 12);
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 values ('pippo', 12); # Gives error
 delete from t1;
 delete from t1 where id = 'pippo';
@@ -342,9 +342,9 @@
 
 insert into t1 (ggid,passwd) values ('test1','xxx');
 insert into t1 (ggid,passwd) values ('test2','yyy');
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 (ggid,passwd) values ('test2','this will fail');
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 (ggid,id) values ('this will fail',1);
 
 select * from t1 where ggid='test1';
@@ -353,7 +353,7 @@
 
 replace into t1 (ggid,id) values ('this will work',1);
 replace into t1 (ggid,passwd) values ('test2','this will work');
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 update t1 set id=100,ggid='test2' where id=1;
 select * from t1;
 select * from t1 where id=1;
@@ -524,7 +524,7 @@
 create table t1 (id int NOT NULL,id2 int NOT NULL,id3 int NOT NULL,dummy1 char(30),primary key (id,id2),index index_id3 (id3)) engine=innodb;
 insert into t1 values (0,0,0,'ABCDEFGHIJ'),(2,2,2,'BCDEFGHIJK'),(1,1,1,'CDEFGHIJKL');
 LOCK TABLES t1 WRITE;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values (99,1,2,'D'),(1,1,2,'D');
 select id from t1;
 select id from t1;
@@ -535,7 +535,7 @@
 insert into t1 values (0,0,0,'ABCDEFGHIJ'),(2,2,2,'BCDEFGHIJK'),(1,1,1,'CDEFGHIJKL');
 LOCK TABLES t1 WRITE;
 begin;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values (99,1,2,'D'),(1,1,2,'D');
 select id from t1;
 insert ignore into t1 values (100,1,2,'D'),(1,1,99,'D');
@@ -1408,7 +1408,7 @@
 key (rowid), unique(val)) engine=innodb;
 replace into t1 (val) values ('1'),('2');
 replace into t1 (val) values ('1'),('2');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 (val) values ('1'),('2');
 select * from t1;
 drop table t1;
@@ -1421,7 +1421,7 @@
 insert into t1 (val) values (1);
 update t1 set a=2 where a=1;
 # We should get the following error because InnoDB does not update the counter
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 (val) values (1);
 select * from t1;
 drop table t1;
@@ -1744,13 +1744,13 @@
 create table t4 (s1 char(2) binary,primary key (s1)) engine=innodb;
 
 insert into t1 values (0x41),(0x4120),(0x4100);
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t2 values (0x41),(0x4120),(0x4100);
 insert into t2 values (0x41),(0x4120);
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t3 values (0x41),(0x4120),(0x4100);
 insert into t3 values (0x41),(0x4100);
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t4 values (0x41),(0x4120),(0x4100);
 insert into t4 values (0x41),(0x4100);
 select hex(s1) from t1;

--- 1.40/mysql-test/t/insert_select.test	2007-06-06 10:57:14 -07:00
+++ 1.41/mysql-test/t/insert_select.test	2007-06-06 10:57:14 -07:00
@@ -10,7 +10,7 @@
 insert into t1 (bandID,payoutID) VALUES (1,6),(2,6),(3,4),(4,9),(5,10),(6,1),(7,12),(8,12);
 create table t2 (payoutID SMALLINT UNSIGNED NOT NULL PRIMARY KEY);
 insert into t2 (payoutID) SELECT DISTINCT payoutID FROM t1;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t2 (payoutID) SELECT payoutID+10 FROM t1;
 insert ignore into t2 (payoutID) SELECT payoutID+10 FROM t1;
 select * from t2;
@@ -101,7 +101,7 @@
 create table t2 (a int not null, b char(10));
 insert into t1 values (1,"t1:1"),(3,"t1:3");
 insert into t2 values (2,"t2:2"), (3,"t2:3");
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 select * from t2;
 select * from t1;
 # REPLACE .. SELECT is not yet supported by PS

--- 1.43/mysql-test/t/join_outer.test	2007-06-06 10:57:14 -07:00
+++ 1.44/mysql-test/t/join_outer.test	2007-06-06 10:57:14 -07:00
@@ -97,7 +97,7 @@
 ORDER BY t2.c_amount;
 
 INSERT INTO t2 VALUES (2,3,3000,6000,0,0,746584,837484,'yes');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t2 VALUES (2,3,3000,6000,0,0,746584,837484,'yes');
 INSERT INTO t2 VALUES (7,3,1000,2000,0,0,746294,937484,'yes');
 

--- 1.36/mysql-test/t/key.test	2007-06-06 10:57:14 -07:00
+++ 1.37/mysql-test/t/key.test	2007-06-06 10:57:14 -07:00
@@ -150,7 +150,7 @@
 );
 INSERT INTO t1 VALUES (1, 1, 1, 1, 'a'); 
 INSERT INTO t1 VALUES (1, 1, 1, 1, 'b'); 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 INSERT INTO t1 VALUES (1, 1, 1, 1, 'a');
 drop table t1;
 
@@ -243,13 +243,13 @@
 insert t1 values ('cccc', 'tttt'),
   (0xD0B1212223D0B1D0B1D0B1D0B1D0B1, 0xD0B1D0B1212223D0B1D0B1D0B1D0B1),
   (0xD0B1222123D0B1D0B1D0B1D0B1D0B1, 0xD0B1D0B1222123D0B1D0B1D0B1D0B1);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert t1 (c) values ('cc22');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert t1 (t) values ('ttt22');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert t1 (c) values (0xD0B1212322D0B1D0B1D0B1D0B1D0B1);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert t1 (t) values (0xD0B1D0B1212322D0B1D0B1D0B1D0B1);
 select c from t1 where c='cccc';
 select t from t1 where t='tttt';
@@ -438,7 +438,7 @@
 # Drop some indexes for new adds.
 alter table t1 drop index i3, drop index i2, drop index i1;
 # Add indexes, one is unique on non-unique values.
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 alter table t1 add index i3 (c3), add index i2 (c2), add unique index i1 (c1);
 drop table t1;
 

--- 1.53/mysql-test/t/merge.test	2007-06-06 10:57:14 -07:00
+++ 1.54/mysql-test/t/merge.test	2007-06-06 10:57:14 -07:00
@@ -195,9 +195,9 @@
 insert into t1 values (99,NULL);
 select * from t4 where a+0 > 90;
 # bug#4008 - cannot determine a unique key that caused "dupl. key error"
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert t5 values (1,1);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert t6 values (2,1);
 insert t5 values (1,1) on duplicate key update b=b+10;
 insert t6 values (2,1) on duplicate key update b=b+20;

--- 1.76/mysql-test/t/show_check.test	2007-06-06 10:57:14 -07:00
+++ 1.77/mysql-test/t/show_check.test	2007-06-06 10:57:14 -07:00
@@ -30,7 +30,7 @@
 check table t1 medium;
 check table t1 extended;
 show index from t1;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values (5,5,5);
 optimize table t1;
 optimize table t1;

--- 1.18/mysql-test/t/temp_table.test	2007-06-06 10:57:14 -07:00
+++ 1.19/mysql-test/t/temp_table.test	2007-06-06 10:57:14 -07:00
@@ -73,7 +73,7 @@
 #
 create temporary table t1 (a int not null);
 insert into t1 values (1),(1);
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 alter table t1 add primary key (a);
 drop table t1;
 

--- 1.35/mysql-test/t/type_blob.test	2007-06-06 10:57:14 -07:00
+++ 1.36/mysql-test/t/type_blob.test	2007-06-06 10:57:14 -07:00
@@ -333,9 +333,9 @@
 #
 
 create table t1 (id integer primary key auto_increment, txt text not null, unique index txt_index (txt (20)));
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 (txt) values ('Chevy'), ('Chevy ');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 (txt) values ('Chevy'), ('CHEVY');
 alter table t1 drop index txt_index, add index txt_index (txt(20));
 insert into t1 (txt) values ('Chevy ');

--- 1.85/mysql-test/t/myisam.test	2007-06-06 10:57:14 -07:00
+++ 1.86/mysql-test/t/myisam.test	2007-06-06 10:57:14 -07:00
@@ -453,9 +453,9 @@
 insert into t1 (b) values ('a'),('b'),('c');
 select concat(b,'.') from t1;
 update t1 set b='b ' where a=2;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 update t1 set b='b  ' where a > 1;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 (b) values ('b');
 select * from t1;
 delete from t1 where b='b';

--- 1.17/mysql-test/include/query_cache.inc	2007-06-06 10:57:14 -07:00
+++ 1.18/mysql-test/include/query_cache.inc	2007-06-06 10:57:14 -07:00
@@ -90,7 +90,7 @@
 select t1.* from t1, t2, t3 where t3.state & 1 = 0 and t3.t1_id = t1.id and t3.t2_id = t2.id and t1.id = 1 order by t1.a asc;
 begin;
 insert into t3 VALUES ( NULL, 1, 1, 2 );
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t3 VALUES ( NULL, 1, 1, 2 );
 commit;
 select t1.* from t1, t2, t3 where t3.state & 1 = 0 and t3.t1_id = t1.id and t3.t2_id = t2.id and t1.id = 1 order by t1.a asc;

--- 1.9/mysql-test/include/varchar.inc	2007-06-06 10:57:14 -07:00
+++ 1.10/mysql-test/include/varchar.inc	2007-06-06 10:57:14 -07:00
@@ -81,7 +81,7 @@
 --replace_column 9 #
 explain select count(*) from t1 where v between 'a' and 'a ' and v between 'a  ' and 'b\n';
 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 alter table t1 add unique(v);
 alter table t1 add key(v);
 select concat('*',v,'*',c,'*',t,'*') as qq from t1 where v='a';
@@ -179,17 +179,17 @@
 
 create table t1 (a char(10), unique (a));
 insert into t1 values ('a   ');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a ');
 
 alter table t1 modify a varchar(10);
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a '),('a  '),('a   '),('a         ');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a     ');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a          ');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values ('a ');
 update t1 set a='a  ' where a like 'a%';
 select concat(a,'.') from t1;

--- 1.15/mysql-test/t/type_varchar.test	2007-06-06 10:57:15 -07:00
+++ 1.16/mysql-test/t/type_varchar.test	2007-06-06 10:57:15 -07:00
@@ -25,7 +25,7 @@
 select binary v='a' from t1;
 select binary v='a ' from t1;
 insert into t1 values('a');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 alter table t1 add primary key (v);
 drop table t1;
 create table t1 (v varbinary(20));

--- 1.10/mysql-test/t/ndb_update.test	2007-06-06 10:57:15 -07:00
+++ 1.11/mysql-test/t/ndb_update.test	2007-06-06 10:57:15 -07:00
@@ -23,11 +23,11 @@
 select * from t1 order by pk1;
 UPDATE t1 set pk1 = 4 where pk1 = 1;
 select * from t1 order by pk1;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 UPDATE t1 set pk1 = 4 where pk1 = 2;
 UPDATE IGNORE t1 set pk1 = 4 where pk1 = 2;
 select * from t1 order by pk1;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 UPDATE t1 set pk1 = 1, c = 2 where pk1 = 4;
 UPDATE IGNORE t1 set pk1 = 1, c = 2 where pk1 = 4;
 select * from t1 order by pk1;

--- 1.13/mysql-test/t/ndb_charset.test	2007-06-06 10:57:15 -07:00
+++ 1.14/mysql-test/t/ndb_charset.test	2007-06-06 10:57:15 -07:00
@@ -38,9 +38,9 @@
 # ok
 insert into t1 values('aAa');
 # fail
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values('aaa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values('AAA');
 # 1
 select * from t1 order by a;
@@ -61,9 +61,9 @@
 ) engine=ndb;
 #
 insert into t1 values ('A'),('b '),('C  '),('d      '),('E'),('f');
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 values('b');
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 values('a         ');
 #
 select a,length(a) from t1 order by a;
@@ -106,9 +106,9 @@
 # ok
 insert into t1 values(1, 'aAa');
 # fail
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values(2, 'aaa');
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values(3, 'AAA');
 # 1
 select * from t1 order by p;
@@ -131,9 +131,9 @@
 ) engine=ndb;
 #
 insert into t1 values (1,'A'),(2,'b '),(3,'C  '),(4,'d      '),(5,'E'),(6,'f');
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 values(99,'b');
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 insert into t1 values(99,'a         ');
 #
 select a,length(a) from t1 order by a;
@@ -231,7 +231,7 @@
 #  ('a','A '),('B   ','b'),('c','C    '),('D','d'),('e  ','E'),('F','f  '),
 #  ('A','b '),('b   ','C'),('C','d  '),('d','E'),('E  ','f'),
 #  ('a','C '),('B   ','d'),('c','E  '),('D','f');
-#-- error ER_DUP_ENTRY_WITH_KEY_NAME
+#-- error ER_DUP_ENTRY
 #insert into t1 values('d','f');
 #
 #select a,b,length(a),length(b) from t1 order by a,b limit 3;

--- 1.275/mysql-test/r/sp.result	2007-06-06 10:57:15 -07:00
+++ 1.276/mysql-test/r/sp.result	2007-06-06 10:57:15 -07:00
@@ -1497,10 +1497,10 @@
 create procedure h_ee()
 deterministic
 begin
-declare continue handler for 1582 -- ER_DUP_ENTRY_WITH_KEY_NAME
+declare continue handler for 1062 -- ER_DUP_ENTRY
 select 'Outer (bad)' as 'h_ee';
 begin
-declare continue handler for 1582 -- ER_DUP_ENTRY_WITH_KEY_NAME
+declare continue handler for 1062 -- ER_DUP_ENTRY
 select 'Inner (good)' as 'h_ee';
 insert into t3 values (1);
 end;
@@ -1508,7 +1508,7 @@
 create procedure h_es()
 deterministic
 begin
-declare continue handler for 1582 -- ER_DUP_ENTRY_WITH_KEY_NAME
+declare continue handler for 1062 -- ER_DUP_ENTRY
 select 'Outer (good)' as 'h_es';
 begin
 -- integrity constraint violation
@@ -1545,7 +1545,7 @@
 create procedure h_ex()
 deterministic
 begin
-declare continue handler for 1582 -- ER_DUP_ENTRY_WITH_KEY_NAME
+declare continue handler for 1062 -- ER_DUP_ENTRY
 select 'Outer (good)' as 'h_ex';
 begin
 declare continue handler for sqlexception
@@ -1560,7 +1560,7 @@
 declare continue handler for sqlstate '23000' 
 select 'Outer (bad)' as 'h_se';
 begin
-declare continue handler for 1582 -- ER_DUP_ENTRY_WITH_KEY_NAME
+declare continue handler for 1062 -- ER_DUP_ENTRY
 select 'Inner (good)' as 'h_se';
 insert into t3 values (1);
 end;
@@ -1700,7 +1700,7 @@
 declare continue handler for sqlexception
 select 'Outer (bad)' as 'h_xe';
 begin
-declare continue handler for 1582 -- ER_DUP_ENTRY_WITH_KEY_NAME
+declare continue handler for 1062 -- ER_DUP_ENTRY
 select 'Inner (good)' as 'h_xe';
 insert into t3 values (1);
 end;
@@ -4705,10 +4705,10 @@
 create procedure bug15011()
 deterministic
 begin
-declare continue handler for 1582
+declare continue handler for 1062
 select 'Outer' as 'Handler';
 begin
-declare continue handler for 1582
+declare continue handler for 1062
 select 'Inner' as 'Handler';
 insert into t3 values (1);
 end;

--- 1.121/mysql-test/t/sp-error.test	2007-06-06 10:57:15 -07:00
+++ 1.122/mysql-test/t/sp-error.test	2007-06-06 10:57:15 -07:00
@@ -586,7 +586,7 @@
 end|
 
 set @x = 0|
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 call bug3279(@x)|
 select @x|
 drop procedure bug3279|

--- 1.241/mysql-test/t/sp.test	2007-06-06 10:57:15 -07:00
+++ 1.242/mysql-test/t/sp.test	2007-06-06 10:57:15 -07:00
@@ -1767,11 +1767,11 @@
 create procedure h_ee()
     deterministic
 begin
-  declare continue handler for 1582 -- ER_DUP_ENTRY_WITH_KEY_NAME
+  declare continue handler for 1062 -- ER_DUP_ENTRY
     select 'Outer (bad)' as 'h_ee';
 
   begin
-    declare continue handler for 1582 -- ER_DUP_ENTRY_WITH_KEY_NAME
+    declare continue handler for 1062 -- ER_DUP_ENTRY
         select 'Inner (good)' as 'h_ee';
 
     insert into t3 values (1);
@@ -1781,7 +1781,7 @@
 create procedure h_es()
     deterministic
 begin
-  declare continue handler for 1582 -- ER_DUP_ENTRY_WITH_KEY_NAME
+  declare continue handler for 1062 -- ER_DUP_ENTRY
     select 'Outer (good)' as 'h_es';
 
   begin
@@ -1827,7 +1827,7 @@
 create procedure h_ex()
     deterministic
 begin
-  declare continue handler for 1582 -- ER_DUP_ENTRY_WITH_KEY_NAME
+  declare continue handler for 1062 -- ER_DUP_ENTRY
     select 'Outer (good)' as 'h_ex';
 
   begin
@@ -1846,7 +1846,7 @@
     select 'Outer (bad)' as 'h_se';
 
   begin
-    declare continue handler for 1582 -- ER_DUP_ENTRY_WITH_KEY_NAME
+    declare continue handler for 1062 -- ER_DUP_ENTRY
       select 'Inner (good)' as 'h_se';
 
     insert into t3 values (1);
@@ -2019,7 +2019,7 @@
     select 'Outer (bad)' as 'h_xe';
 
   begin
-    declare continue handler for 1582 -- ER_DUP_ENTRY_WITH_KEY_NAME
+    declare continue handler for 1062 -- ER_DUP_ENTRY
       select 'Inner (good)' as 'h_xe';
 
     insert into t3 values (1);
@@ -4511,7 +4511,7 @@
    select bug12379();
 end|
 
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 select bug12379()|
 select 1|
 # statement-based binlogging will show warning which row-based won't;
@@ -4522,7 +4522,7 @@
 call bug12379_2()|
 --enable_warnings
 select 3|
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 call bug12379_3()|
 select 4|
 
@@ -4604,7 +4604,7 @@
 
 call bug6127()|
 select * from t3|
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 call bug6127()|
 select * from t3|
 set sql_mode=@sm|
@@ -5532,11 +5532,11 @@
 create procedure bug15011()
   deterministic
 begin
-  declare continue handler for 1582
+  declare continue handler for 1062
     select 'Outer' as 'Handler';
 
   begin
-    declare continue handler for 1582
+    declare continue handler for 1062
       select 'Inner' as 'Handler';
 
     insert into t3 values (1);

--- 1.20/mysql-test/t/type_bit.test	2007-06-06 10:57:15 -07:00
+++ 1.21/mysql-test/t/type_bit.test	2007-06-06 10:57:15 -07:00
@@ -39,7 +39,7 @@
 create table t1 (a bit);
 insert into t1 values (b'0'), (b'1'), (b'000'), (b'100'), (b'001');
 select hex(a) from t1;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 alter table t1 add unique (a);
 drop table t1;
 

--- 1.6/mysql-test/t/type_bit_innodb.test	2007-06-06 10:57:15 -07:00
+++ 1.7/mysql-test/t/type_bit_innodb.test	2007-06-06 10:57:15 -07:00
@@ -40,7 +40,7 @@
 create table t1 (a bit) engine=innodb;
 insert into t1 values (b'0'), (b'1'), (b'000'), (b'100'), (b'001');
 select hex(a) from t1;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 alter table t1 add unique (a);
 drop table t1;
 

--- 1.16/mysql-test/t/sp_trans.test	2007-06-06 10:57:15 -07:00
+++ 1.17/mysql-test/t/sp_trans.test	2007-06-06 10:57:15 -07:00
@@ -89,7 +89,7 @@
     end if;
     return i;
   end|
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values (bug10015_5(4)), (bug10015_5(5))|
 select * from t1|
 drop function bug10015_5|

--- 1.27/mysql-test/t/insert_update.test	2007-06-06 10:57:15 -07:00
+++ 1.28/mysql-test/t/insert_update.test	2007-06-06 10:57:15 -07:00
@@ -12,7 +12,7 @@
 SELECT * FROM t1;
 INSERT t1 VALUES (1,4,60) ON DUPLICATE KEY UPDATE c=c+10000;
 SELECT * FROM t1;
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 INSERT t1 VALUES (1,9,70) ON DUPLICATE KEY UPDATE c=c+100000, b=4;
 SELECT * FROM t1;
 TRUNCATE TABLE t1;
@@ -63,7 +63,7 @@
 SELECT * FROM t1;
 INSERT t1 SELECT 1,4,60 FROM DUAL ON DUPLICATE KEY UPDATE c=c+10000;
 SELECT * FROM t1;
--- error ER_DUP_ENTRY_WITH_KEY_NAME
+-- error ER_DUP_ENTRY
 INSERT t1 SELECT 1,9,70 FROM DUAL ON DUPLICATE KEY UPDATE c=c+100000, b=4;
 SELECT * FROM t1;
 TRUNCATE TABLE t1;

--- 1.14/mysql-test/t/replace.test	2007-06-06 10:57:15 -07:00
+++ 1.15/mysql-test/t/replace.test	2007-06-06 10:57:15 -07:00
@@ -25,9 +25,9 @@
 
 create table t1 (a tinyint not null auto_increment primary key, b char(20) default "default_value");
 insert into t1 values (126,"first"),(63, "middle"),(0,"last");
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 insert into t1 values (0,"error");
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
 replace into t1 values (0,"error");
 replace into t1 values (126,"first updated");
 replace into t1 values (63,default);
Thread
bk commit into 5.1 tree (jimw:1.2545) BUG#28842Jim Winstead6 Jun