summaryrefslogtreecommitdiff
path: root/mysql-test/r/ndb_index_unique.result
diff options
context:
space:
mode:
authorunknown <ingo@mysql.com>2006-01-23 12:17:05 +0100
committerunknown <ingo@mysql.com>2006-01-23 12:17:05 +0100
commit0369042a0903ac4c0c07ec44f723b34e4f0821e1 (patch)
treeb8e563f22089b8c74c2ba8e68fb041431a9a4829 /mysql-test/r/ndb_index_unique.result
parent098af0ae1aae693829f0c9daef551f2c3571c476 (diff)
downloadmariadb-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/ndb_index_unique.result')
-rw-r--r--mysql-test/r/ndb_index_unique.result10
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/ndb_index_unique.result b/mysql-test/r/ndb_index_unique.result
index 1401ae26ddb..e0e0364a1c4 100644
--- a/mysql-test/r/ndb_index_unique.result
+++ b/mysql-test/r/ndb_index_unique.result
@@ -22,7 +22,7 @@ select * from t1 where b = 4 order by a;
a b c
3 4 6
insert into t1 values(8, 2, 3);
-ERROR 23000: Duplicate entry '8' for key 1
+ERROR 23000: Duplicate entry '8' for key 'PRIMARY'
select * from t1 order by a;
a b c
1 2 3
@@ -89,7 +89,7 @@ a b c
1 1 1
4 4 NULL
insert into t1 values(5,1,1);
-ERROR 23000: Duplicate entry '5' for key 1
+ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
drop table t1;
CREATE TABLE t2 (
a int unsigned NOT NULL PRIMARY KEY,
@@ -112,7 +112,7 @@ select * from t2 where b = 4 order by a;
a b c
3 4 6
insert into t2 values(8, 2, 3);
-ERROR 23000: Duplicate entry '8' for key 1
+ERROR 23000: Duplicate entry '8' for key 'PRIMARY'
select * from t2 order by a;
a b c
1 2 3
@@ -177,7 +177,7 @@ pk a
3 NULL
4 4
insert into t1 values (5,0);
-ERROR 23000: Duplicate entry '5' for key 1
+ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
select * from t1 order by pk;
pk a
-1 NULL
@@ -210,7 +210,7 @@ pk a b c
0 NULL 18 NULL
1 3 19 abc
insert into t2 values(2,3,19,'abc');
-ERROR 23000: Duplicate entry '2' for key 1
+ERROR 23000: Duplicate entry '2' for key 'PRIMARY'
select * from t2 order by pk;
pk a b c
-1 1 17 NULL