summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authorunknown <mskold/marty@mysql.com/linux.site>2006-12-07 15:51:16 +0100
committerunknown <mskold/marty@mysql.com/linux.site>2006-12-07 15:51:16 +0100
commitd8ff6cdfc8185e167db1ec6eac4f9bd486439ca4 (patch)
tree2eaf3a9cdbd39d389ad73150b6a272ca19c61605 /mysql-test/r
parentece3c40b31349fee7231059209cbbeecbf9d57ae (diff)
parent6e47c11c7abac4cd66806b48e07c9b179e2662e4 (diff)
downloadmariadb-git-d8ff6cdfc8185e167db1ec6eac4f9bd486439ca4.tar.gz
Merge mysql.com:/windows/Linux_space/MySQL/mysql-4.1
into mysql.com:/windows/Linux_space/MySQL/mysql-5.0 mysql-test/r/ndb_index_unique.result: Auto merged mysql-test/t/ndb_index_unique.test: Auto merged
Diffstat (limited to 'mysql-test/r')
-rw-r--r--mysql-test/r/ndb_index_unique.result15
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_index_unique.result b/mysql-test/r/ndb_index_unique.result
index 12ffc8437db..670fbe5b4e0 100644
--- a/mysql-test/r/ndb_index_unique.result
+++ b/mysql-test/r/ndb_index_unique.result
@@ -133,6 +133,21 @@ a b c
6 7 2
7 8 3
8 2 3
+create unique index bi using hash on t2(b);
+insert into t2 values(9, 3, 1);
+ERROR 23000: Duplicate entry '' for key 0
+alter table t2 drop index bi;
+insert into t2 values(9, 3, 1);
+select * from t2 order by a;
+a b c
+2 3 5
+3 4 6
+4 5 8
+5 6 2
+6 7 2
+7 8 3
+8 2 3
+9 3 1
drop table t2;
CREATE TABLE t2 (
a int unsigned NOT NULL PRIMARY KEY,