summaryrefslogtreecommitdiff
path: root/mysql-test/t/key.test
diff options
context:
space:
mode:
authorunknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru>2007-10-29 20:31:03 +0400
committerunknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru>2007-10-29 20:31:03 +0400
commitfe68d102fb0143351e278aefdb6d0c9e797d031f (patch)
tree19270622324115e37b12d734f16d734bf86bb1d8 /mysql-test/t/key.test
parentbe04193c09201326109cae19f0fc5321956b6026 (diff)
downloadmariadb-git-fe68d102fb0143351e278aefdb6d0c9e797d031f.tar.gz
after-merge fix-up.
Diffstat (limited to 'mysql-test/t/key.test')
-rw-r--r--mysql-test/t/key.test20
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/key.test b/mysql-test/t/key.test
index f1eb8e68b49..f4d99024206 100644
--- a/mysql-test/t/key.test
+++ b/mysql-test/t/key.test
@@ -501,3 +501,23 @@ ORDER BY c.b, c.d
;
DROP TABLE t1, t2;
+
+#
+# Bug #31137: Assertion failed: primary_key_no == -1 || primary_key_no == 0
+#
+create table t1(a int not null, key aa(a),
+ b char(10) not null, unique key bb(b(1)),
+ c char(4) not null, unique key cc(c));
+desc t1;
+show create table t1;
+drop table t1;
+create table t1(a int not null, key aa(a),
+ b char(10) not null, unique key bb(b(1)),
+ c char(4) not null);
+desc t1;
+alter table t1 add unique key cc(c);
+desc t1;
+show create table t1;
+drop table t1;
+
+--echo End of 5.0 tests