summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <holyfoot/hf@mysql.com/hfmain.(none)>2007-04-05 20:26:18 +0500
committerunknown <holyfoot/hf@mysql.com/hfmain.(none)>2007-04-05 20:26:18 +0500
commitea3afa8d1e1325e621246a17fce30ddd24e74da2 (patch)
tree41070ba6ea7018fc51307ddbda20f99d5b8f62b0 /mysql-test
parent8653417e4ede7949f62f22e6554e3380bd622f53 (diff)
downloadmariadb-git-ea3afa8d1e1325e621246a17fce30ddd24e74da2.tar.gz
bug #26074 Mysql crash creating partition
As we have unified paths inside partition engine, we should look for '/' as a path separator mysql-test/r/windows.result: result fixed mysql-test/t/windows.test: testcase sql/ha_partition.cc: check for '/' instead of FN_LIBCHAR
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/windows.result15
-rw-r--r--mysql-test/t/windows.test21
2 files changed, 36 insertions, 0 deletions
diff --git a/mysql-test/r/windows.result b/mysql-test/r/windows.result
index 7472b724f47..423123692e5 100644
--- a/mysql-test/r/windows.result
+++ b/mysql-test/r/windows.result
@@ -26,3 +26,18 @@ ERROR HY000: No paths allowed for shared library
execute abc;
ERROR HY000: No paths allowed for shared library
deallocate prepare abc;
+CREATE TABLE t1 (
+`pkid` int(11) NOT NULL AUTO_INCREMENT,
+`SALES_DATE` date NOT NULL DEFAULT '0000-00-00',
+KEY `pkid` (`pkid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1
+PARTITION BY RANGE (MONTH(SALES_DATE))
+(
+PARTITION p0 VALUES LESS THAN (2) ENGINE=INNODB
+data DIRECTORY='c:/tmp/'
+ index DIRECTORY = 'c:/tmp/',
+PARTITION p1 VALUES LESS THAN (3) ENGINE=INNODB
+data DIRECTORY='c:/tmp/'
+ index DIRECTORY = 'c:/tmp/'
+);
+drop table t1;
diff --git a/mysql-test/t/windows.test b/mysql-test/t/windows.test
index a10d54b5452..efdf0963b80 100644
--- a/mysql-test/t/windows.test
+++ b/mysql-test/t/windows.test
@@ -1,5 +1,6 @@
# Windows-specific tests
--source include/windows.inc
+-- source include/have_innodb.inc
#
# Bug 9148: Denial of service
@@ -49,3 +50,23 @@ execute abc;
execute abc;
deallocate prepare abc;
+#
+# Bug #26074 Mysql crash when creating partitions
+#
+
+CREATE TABLE t1 (
+ `pkid` int(11) NOT NULL AUTO_INCREMENT,
+ `SALES_DATE` date NOT NULL DEFAULT '0000-00-00',
+ KEY `pkid` (`pkid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1
+PARTITION BY RANGE (MONTH(SALES_DATE))
+(
+ PARTITION p0 VALUES LESS THAN (2) ENGINE=INNODB
+ data DIRECTORY='c:/tmp/'
+ index DIRECTORY = 'c:/tmp/',
+ PARTITION p1 VALUES LESS THAN (3) ENGINE=INNODB
+ data DIRECTORY='c:/tmp/'
+ index DIRECTORY = 'c:/tmp/'
+);
+
+DROP TABLE t1;