summaryrefslogtreecommitdiff
path: root/mysql-test/t/alter_table.test
diff options
context:
space:
mode:
authorsvoj@april.(none) <>2006-12-13 17:32:40 +0400
committersvoj@april.(none) <>2006-12-13 17:32:40 +0400
commit35e7dea87186e65e2bac0b934f7ec08f95b4da12 (patch)
treee8eecc4a0ef60a1596baf9d7300490ae1cecfea2 /mysql-test/t/alter_table.test
parent5c062b2b84412d3385acd3e9e23c505edc08e4fb (diff)
parentdb88cf3df7bc004c35fdda2e683b4e170ca20889 (diff)
downloadmariadb-git-35e7dea87186e65e2bac0b934f7ec08f95b4da12.tar.gz
Merge mysql.com:/home/svoj/devel/mysql/BUG23404/mysql-5.0-engines
into mysql.com:/home/svoj/devel/mysql/BUG23404/mysql-5.1-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 6269ff38857..990f0f4adf5 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