summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorMagne Mahre <magne.mahre@sun.com>2010-06-28 11:23:50 +0200
committerMagne Mahre <magne.mahre@sun.com>2010-06-28 11:23:50 +0200
commite564e35d0699c3305b32757941344b542acd1656 (patch)
tree5c4dc7cc3f54b8d63a2c7f2adf1a9e2335e28948 /mysql-test
parent5d38fa7749b3b67fa45c9dbe2b58d629194ab128 (diff)
downloadmariadb-git-e564e35d0699c3305b32757941344b542acd1656.tar.gz
Bug#54846 main.lowercase_table2 on Mac OSX
This bug is a consequence of WL#5349, as the default storage engine was changed. The fix was to explicitly add an ENGINE clause to a CREATE TABLE statement, to ensure that we test case preservement on MyISAM.
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/lowercase_table2.result2
-rw-r--r--mysql-test/t/lowercase_table2.test2
2 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/lowercase_table2.result b/mysql-test/r/lowercase_table2.result
index b621a466a29..26a151b55aa 100644
--- a/mysql-test/r/lowercase_table2.result
+++ b/mysql-test/r/lowercase_table2.result
@@ -2,7 +2,7 @@ DROP TABLE IF EXISTS t1,t2,t3,t2aA,t1Aa;
DROP DATABASE IF EXISTS `TEST_$1`;
DROP DATABASE IF EXISTS `test_$1`;
DROP DATABASE IF EXISTS mysqltest_LC2;
-CREATE TABLE T1 (a int);
+CREATE TABLE T1 (a int) ENGINE=MyISAM;
INSERT INTO T1 VALUES (1);
SHOW TABLES LIKE "T1";
Tables_in_test (T1)
diff --git a/mysql-test/t/lowercase_table2.test b/mysql-test/t/lowercase_table2.test
index b8c7f532cde..d8aa4e97fb3 100644
--- a/mysql-test/t/lowercase_table2.test
+++ b/mysql-test/t/lowercase_table2.test
@@ -16,7 +16,7 @@ DROP DATABASE IF EXISTS `test_$1`;
DROP DATABASE IF EXISTS mysqltest_LC2;
--enable_warnings
-CREATE TABLE T1 (a int);
+CREATE TABLE T1 (a int) ENGINE=MyISAM;
INSERT INTO T1 VALUES (1);
SHOW TABLES LIKE "T1";
SHOW TABLES LIKE "t1";