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/key.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/key.result')
-rw-r--r-- | mysql-test/r/key.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/r/key.result b/mysql-test/r/key.result index 75676507760..5d62f8d61d6 100644 --- a/mysql-test/r/key.result +++ b/mysql-test/r/key.result @@ -127,7 +127,7 @@ primary key (SEQNO, MOTYPEID, MOINSTANCEID, ATTRID, VALUE ) INSERT INTO t1 VALUES (1, 1, 1, 1, 'a'); INSERT INTO t1 VALUES (1, 1, 1, 1, 'b'); INSERT INTO t1 VALUES (1, 1, 1, 1, 'a'); -ERROR 23000: Duplicate entry '1-1-1-1-a' for key 1 +ERROR 23000: Duplicate entry '1-1-1-1-a' for key 'PRIMARY' drop table t1; CREATE TABLE t1 ( a tinytext NOT NULL, @@ -251,13 +251,13 @@ insert t1 values ('cccc', 'tttt'), (0xD0B1212223D0B1D0B1D0B1D0B1D0B1, 0xD0B1D0B1212223D0B1D0B1D0B1D0B1), (0xD0B1222123D0B1D0B1D0B1D0B1D0B1, 0xD0B1D0B1222123D0B1D0B1D0B1D0B1); insert t1 (c) values ('cc22'); -ERROR 23000: Duplicate entry 'cc22' for key 1 +ERROR 23000: Duplicate entry 'cc22' for key 'c' insert t1 (t) values ('ttt22'); -ERROR 23000: Duplicate entry 'ttt22' for key 2 +ERROR 23000: Duplicate entry 'ttt22' for key 't' insert t1 (c) values (0xD0B1212322D0B1D0B1D0B1D0B1D0B1); -ERROR 23000: Duplicate entry 'б!#"Ð' for key 1 +ERROR 23000: Duplicate entry 'б!#"Ð' for key 'c' insert t1 (t) values (0xD0B1D0B1212322D0B1D0B1D0B1D0B1); -ERROR 23000: Duplicate entry 'бб!#"б' for key 2 +ERROR 23000: Duplicate entry 'бб!#"б' for key 't' select c from t1 where c='cccc'; c cccc @@ -462,5 +462,5 @@ insert into t1 values(1, 'a', 'a', NULL); insert into t1 values(1, 'b', 'b', NULL); alter table t1 drop index i3, drop index i2, drop index i1; alter table t1 add index i3 (c3), add index i2 (c2), add unique index i1 (c1); -ERROR 23000: Duplicate entry '1' for key 1 +ERROR 23000: Duplicate entry '1' for key 'i1' drop table t1; |