diff options
| author | unknown <mskold/marty@mysql.com/linux.site> | 2006-12-07 15:49:59 +0100 |
|---|---|---|
| committer | unknown <mskold/marty@mysql.com/linux.site> | 2006-12-07 15:49:59 +0100 |
| commit | 6e47c11c7abac4cd66806b48e07c9b179e2662e4 (patch) | |
| tree | 4f0932bf00ab334a895251ff428b14f1261511f4 /mysql-test | |
| parent | 08ce5b3dbd9687145f2525ba308eaa854ab9e651 (diff) | |
| download | mariadb-git-6e47c11c7abac4cd66806b48e07c9b179e2662e4.tar.gz | |
Bug#24818 CREATE UNIQUE INDEX (...) USING HASH on a NDB table crashes mysqld: Added test case
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/ndb_index_unique.result | 15 | ||||
| -rw-r--r-- | mysql-test/t/ndb_index_unique.test | 8 |
2 files changed, 23 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, diff --git a/mysql-test/t/ndb_index_unique.test b/mysql-test/t/ndb_index_unique.test index 458f6a165f8..2bf4a763313 100644 --- a/mysql-test/t/ndb_index_unique.test +++ b/mysql-test/t/ndb_index_unique.test @@ -83,6 +83,14 @@ delete from t2 where a = 1; insert into t2 values(8, 2, 3); select * from t2 order by a; +# Bug #24818 CREATE UNIQUE INDEX (...) USING HASH on a NDB table crashes mysqld +create unique index bi using hash on t2(b); +-- error 1062 +insert into t2 values(9, 3, 1); +alter table t2 drop index bi; +insert into t2 values(9, 3, 1); +select * from t2 order by a; + drop table t2; -- error 1121 |