diff options
| author | unknown <ingo@mysql.com> | 2006-01-23 12:17:05 +0100 |
|---|---|---|
| committer | unknown <ingo@mysql.com> | 2006-01-23 12:17:05 +0100 |
| commit | 0369042a0903ac4c0c07ec44f723b34e4f0821e1 (patch) | |
| tree | b8e563f22089b8c74c2ba8e68fb041431a9a4829 /mysql-test/r/create_select_tmp.result | |
| parent | 098af0ae1aae693829f0c9daef551f2c3571c476 (diff) | |
| download | mariadb-git-0369042a0903ac4c0c07ec44f723b34e4f0821e1.tar.gz | |
WL#1563 - Modify MySQL to support fast CREATE/DROP INDEX
Change "duplicate key" message to print key name
instead of key number.
Diffstat (limited to 'mysql-test/r/create_select_tmp.result')
| -rw-r--r-- | mysql-test/r/create_select_tmp.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/create_select_tmp.result b/mysql-test/r/create_select_tmp.result index b99bf3e3591..75b2ce760ff 100644 --- a/mysql-test/r/create_select_tmp.result +++ b/mysql-test/r/create_select_tmp.result @@ -2,18 +2,18 @@ drop table if exists t1, t2; CREATE TABLE t1 ( a int ); INSERT INTO t1 VALUES (1),(2),(1); CREATE TABLE t2 ( PRIMARY KEY (a) ) ENGINE=INNODB SELECT a FROM t1; -ERROR 23000: Duplicate entry '1' for key 1 +ERROR 23000: Duplicate entry '1' for key 'PRIMARY' select * from t2; ERROR 42S02: Table 'test.t2' doesn't exist CREATE TEMPORARY TABLE t2 ( PRIMARY KEY (a) ) ENGINE=INNODB SELECT a FROM t1; -ERROR 23000: Duplicate entry '1' for key 1 +ERROR 23000: Duplicate entry '1' for key 'PRIMARY' select * from t2; ERROR 42S02: Table 'test.t2' doesn't exist CREATE TABLE t2 ( PRIMARY KEY (a) ) ENGINE=MYISAM SELECT a FROM t1; -ERROR 23000: Duplicate entry '1' for key 1 +ERROR 23000: Duplicate entry '1' for key 'PRIMARY' select * from t2; ERROR 42S02: Table 'test.t2' doesn't exist CREATE TEMPORARY TABLE t2 ( PRIMARY KEY (a) ) ENGINE=MYISAM SELECT a FROM t1; -ERROR 23000: Duplicate entry '1' for key 1 +ERROR 23000: Duplicate entry '1' for key 'PRIMARY' select * from t2; ERROR 42S02: Table 'test.t2' doesn't exist |