test case fix

mysql-test/r/partition.result:
  the test is moved to 'partition_not_windows' test
mysql-test/r/partition_not_windows.result:
  the test is moved from 'partition' test
mysql-test/t/partition.test:
  the test is moved to 'partition_not_windows' test
mysql-test/t/partition_not_windows.test:
  the test is moved from 'partition' test

1 files changed, 27 insertions, 0 deletions

diff --git a/mysql-test/t/partition_not_windows.test b/mysql-test/t/partition_not_windows.test
index c5f54286095..836d5ab10e6 100644
--- a/mysql-test/t/partition_not_windows.test
+++ b/mysql-test/t/partition_not_windows.test
@@ -67,6 +67,33 @@ eval ALTER TABLE t1 REORGANIZE PARTITION p0 INTO
 
 drop table t1;
 
+#
+# Bug #24633 SQL MODE "NO_DIR_IN_CREATE" does not work with partitioned tables
+#
+disable_query_log;
+eval create table t2 (i int )
+partition by range (i)
+(
+ partition p01 values less than (1000)
+ data directory="$MYSQLTEST_VARDIR/tmp/"
+ index directory="$MYSQLTEST_VARDIR/tmp/"
+);
+enable_query_log;
+          
+set @org_mode=@@sql_mode;
+set @@sql_mode='NO_DIR_IN_CREATE';
+select @@sql_mode;
+create table t1 (i int )
+partition by range (i)
+(
+  partition p01 values less than (1000)
+  data directory='/not/existing'
+  index directory='/not/existing'
+);
+show create table t2;
+DROP TABLE t1, t2;
+set @@sql_mode=@org_mode;
+
 # End Windows specific test failures.
 
 # These tests contain non-Windows specific directory/file format.