summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authorunknown <mskold/marty@mysql.com/linux.site>2006-12-07 15:49:59 +0100
committerunknown <mskold/marty@mysql.com/linux.site>2006-12-07 15:49:59 +0100
commitfe68484a47e70a4a16368b24918c6a154e92ce66 (patch)
tree4f0932bf00ab334a895251ff428b14f1261511f4 /mysql-test/r
parentb0b842942272270f8af1a573e9f759354a8643b7 (diff)
downloadmariadb-git-fe68484a47e70a4a16368b24918c6a154e92ce66.tar.gz
Bug#24818 CREATE UNIQUE INDEX (...) USING HASH on a NDB table crashes mysqld: Added test case
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 f9fb6f89aa2..3bc41e8a197 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,