diff options
| author | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-03-11 01:17:41 +0400 |
|---|---|---|
| committer | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-03-11 01:17:41 +0400 |
| commit | 32a19db3804789a76c1981ec111af58908f1f1ec (patch) | |
| tree | a6b8e2f842f6df6f0a6e508b59680e645a1ee61d /mysql-test/r/partition.result | |
| parent | 84ceb01eb63f7e344bbf0ae5d37542b74234d960 (diff) | |
| download | mariadb-git-32a19db3804789a76c1981ec111af58908f1f1ec.tar.gz | |
Bug #24633 SQL MODE "NO_DIR_IN_CREATE" does not work with
partitioned tables"
We have to ignore 'data directory' and 'index directory' parameters
if NO_DIR_IN_CREATE set.
mysql-test/r/partition.result:
result fixed
mysql-test/t/partition.test:
testcase
sql/partition_info.cc:
clear data_field_name and index_field_name if NO_DIR_IN_CREATE set
Diffstat (limited to 'mysql-test/r/partition.result')
| -rw-r--r-- | mysql-test/r/partition.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/partition.result b/mysql-test/r/partition.result index f7eda649dd2..35b760cfc9d 100644 --- a/mysql-test/r/partition.result +++ b/mysql-test/r/partition.result @@ -1219,4 +1219,17 @@ SELECT t2.id FROM t2 WHERE t2.id IN (SELECT id FROM t1 WHERE status = 'Verified' id 22589 drop table t1, t2; +set @org_mode=@@sql_mode; +set @@sql_mode='NO_DIR_IN_CREATE'; +select @@sql_mode; +@@sql_mode +NO_DIR_IN_CREATE +create table t1 (i int ) +partition by range (i) +( +partition p01 values less than (1000) +data directory='/not/existing' + index directory='/not/existing' +); +DROP TABLE t1; End of 5.1 tests |