diff options
Diffstat (limited to 'mysql-test/t/partition_error.test')
| -rw-r--r-- | mysql-test/t/partition_error.test | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/mysql-test/t/partition_error.test b/mysql-test/t/partition_error.test index 19bd922e78f..39dd6773ce8 100644 --- a/mysql-test/t/partition_error.test +++ b/mysql-test/t/partition_error.test @@ -755,6 +755,7 @@ DROP TABLE t1; --echo # --echo # Bug#42954: SQL MODE 'NO_DIR_IN_CREATE' does not work with --echo # subpartitions +let $curr_engine=`select @@default_storage_engine`; SET @org_mode=@@sql_mode; SET @@sql_mode='NO_DIR_IN_CREATE'; SELECT @@sql_mode; @@ -764,7 +765,7 @@ SUBPARTITION BY HASH(TO_DAYS(purchased)) (PARTITION p0 VALUES LESS THAN MAXVALUE DATA DIRECTORY = '/tmp/not-existing' INDEX DIRECTORY = '/tmp/not-existing'); ---replace_result MyISAM <curr_engine> InnoDB <curr_engine> +--replace_result $curr_engine <curr_engine> SHOW CREATE TABLE t1; DROP TABLE t1; CREATE TABLE t1 (id INT, purchased DATE) @@ -775,7 +776,7 @@ SUBPARTITION BY HASH(TO_DAYS(purchased)) SUBPARTITIONS 2 DATA DIRECTORY = '/tmp/not-existing' INDEX DIRECTORY = '/tmp/not-existing', SUBPARTITION sp1)); ---replace_result MyISAM <curr_engine> InnoDB <curr_engine> +--replace_result $curr_engine <curr_engine> SHOW CREATE TABLE t1; DROP TABLE t1; CREATE TABLE t1 (id INT, purchased DATE) @@ -783,7 +784,7 @@ PARTITION BY RANGE(YEAR(purchased)) (PARTITION p0 VALUES LESS THAN MAXVALUE DATA DIRECTORY = '/tmp/not-existing' INDEX DIRECTORY = '/tmp/not-existing'); ---replace_result MyISAM <curr_engine> InnoDB <curr_engine> +--replace_result $curr_engine <curr_engine> SHOW CREATE TABLE t1; DROP TABLE t1; SET @@sql_mode= @org_mode; |