summaryrefslogtreecommitdiff
path: root/mysql-test/t/alter_table.test
diff options
context:
space:
mode:
authorsvoj@mysql.com/april.(none) <>2006-12-13 16:29:33 +0400
committersvoj@mysql.com/april.(none) <>2006-12-13 16:29:33 +0400
commitdb88cf3df7bc004c35fdda2e683b4e170ca20889 (patch)
tree23861c714cc954c1cac1495dcc4d9f808049cef2 /mysql-test/t/alter_table.test
parentc583a7ba7664f2b821531dd3d53fb9919d76e8bd (diff)
parentf92ae8d6c1f9cc0648a4d8bf9a64c59008609107 (diff)
downloadmariadb-git-db88cf3df7bc004c35fdda2e683b4e170ca20889.tar.gz
Merge mysql.com:/home/svoj/devel/mysql/BUG23404/mysql-4.1-engines
into mysql.com:/home/svoj/devel/mysql/BUG23404/mysql-5.0-engines
Diffstat (limited to 'mysql-test/t/alter_table.test')
-rw-r--r--mysql-test/t/alter_table.test11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test
index 233726ce923..d2c9926c422 100644
--- a/mysql-test/t/alter_table.test
+++ b/mysql-test/t/alter_table.test
@@ -500,6 +500,17 @@ use test;
drop table t1;
#
+# BUG#23404 - ROW_FORMAT=FIXED option is lost is an index is added to the
+# table
+#
+CREATE TABLE t1(a INT) ROW_FORMAT=FIXED;
+CREATE INDEX i1 ON t1(a);
+SHOW CREATE TABLE t1;
+DROP INDEX i1 ON t1;
+SHOW CREATE TABLE t1;
+DROP TABLE t1;
+
+#
# Bug#24219 - ALTER TABLE ... RENAME TO ... , DISABLE KEYS leads to crash
#
--disable_warnings