summaryrefslogtreecommitdiff
path: root/mysql-test/t/partition_not_windows.test
diff options
context:
space:
mode:
authorunknown <gluh@mysql.com/mgluh.(none)>2008-03-03 20:29:58 +0400
committerunknown <gluh@mysql.com/mgluh.(none)>2008-03-03 20:29:58 +0400
commit28dc3ac696bd69a08ba4e5591668c3b270710b58 (patch)
tree57b350d637d2f239cabdedc2af8be71a5b437fb8 /mysql-test/t/partition_not_windows.test
parent8a176c559bbcded042f79da89878d9824b8286c5 (diff)
downloadmariadb-git-28dc3ac696bd69a08ba4e5591668c3b270710b58.tar.gz
fixed test case problem on win
mysql-test/r/partition.result: the test is moved to 'partition_not_windows' test case mysql-test/r/partition_not_windows.result: the test is moved from 'partition' test case mysql-test/t/partition.test: the test is moved to 'partition_not_windows' test case mysql-test/t/partition_not_windows.test: the test is moved from 'partition' test case
Diffstat (limited to 'mysql-test/t/partition_not_windows.test')
-rw-r--r--mysql-test/t/partition_not_windows.test38
1 files changed, 38 insertions, 0 deletions
diff --git a/mysql-test/t/partition_not_windows.test b/mysql-test/t/partition_not_windows.test
index 836d5ab10e6..103fb05029e 100644
--- a/mysql-test/t/partition_not_windows.test
+++ b/mysql-test/t/partition_not_windows.test
@@ -94,6 +94,44 @@ show create table t2;
DROP TABLE t1, t2;
set @@sql_mode=@org_mode;
+#
+# Bug#32167: another privilege bypass with DATA/INDEX DIRECTORY
+#
+--replace_result $MYSQLTEST_VARDIR TEST_DIR
+--error 1210
+eval CREATE TABLE t1(a INT)
+PARTITION BY KEY (a)
+(PARTITION p0 DATA DIRECTORY '$MYSQLTEST_VARDIR/master-data/test');
+--replace_result $MYSQLTEST_VARDIR TEST_DIR
+--error 1210
+eval CREATE TABLE t1(a INT)
+PARTITION BY KEY (a)
+(PARTITION p0 INDEX DIRECTORY '$MYSQLTEST_VARDIR/master-data/test');
+
+--replace_result $MYSQLTEST_VARDIR TEST_DIR
+--error 1210
+eval CREATE TABLE ts (id INT, purchased DATE)
+PARTITION BY RANGE(YEAR(purchased))
+SUBPARTITION BY HASH(TO_DAYS(purchased)) (
+PARTITION p0 VALUES LESS THAN (1990) (
+SUBPARTITION s0a
+ DATA DIRECTORY = '$MYSQLTEST_VARDIR/master-data/test',
+SUBPARTITION s0b
+ DATA DIRECTORY = '$MYSQLTEST_VARDIR/master-data/test'
+));
+
+--replace_result $MYSQLTEST_VARDIR TEST_DIR
+--error 1210
+eval CREATE TABLE ts (id INT, purchased DATE)
+PARTITION BY RANGE(YEAR(purchased))
+SUBPARTITION BY HASH(TO_DAYS(purchased)) (
+PARTITION p0 VALUES LESS THAN (1990) (
+SUBPARTITION s0a
+ INDEX DIRECTORY = '$MYSQLTEST_VARDIR/master-data/test',
+SUBPARTITION s0b
+ INDEX DIRECTORY = '$MYSQLTEST_VARDIR/master-data/test'
+));
+
# End Windows specific test failures.
# These tests contain non-Windows specific directory/file format.