partition_symlink.result 3.26 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
DROP TABLE IF EXISTS t1;
DROP DATABASE IF EXISTS mysqltest2;
# Creating two non colliding tables mysqltest2.t1 and test.t1
# test.t1 have partitions in mysqltest2-directory!
# user root:
CREATE USER mysqltest_1@localhost;
CREATE DATABASE mysqltest2;
USE mysqltest2;
CREATE TABLE t1 (a INT);
INSERT INTO t1 VALUES (0);
# user mysqltest_1:
USE test;
CREATE TABLE t1 (a INT)
PARTITION BY LIST (a) (
PARTITION p0 VALUES IN (0)
16 17
DATA DIRECTORY 'MYSQLTEST_VARDIR/tmp'
     INDEX DIRECTORY 'MYSQLTEST_VARDIR/tmp',
18
PARTITION p1 VALUES IN (1)
19 20
DATA DIRECTORY 'MYSQLTEST_VARDIR/tmp'
     INDEX DIRECTORY 'MYSQLTEST_VARDIR/tmp',
21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
PARTITION p2 VALUES IN (2)
);
# without the patch for bug#32091 this would create
# files mysqltest2/t1.MYD + .MYI and possible overwrite
# the mysqltest2.t1 table (depending on bug#32111)
ALTER TABLE t1 REMOVE PARTITIONING;
INSERT INTO t1 VALUES (1);
SELECT * FROM t1;
a
1
# user root:
USE mysqltest2;
FLUSH TABLES;
# if the patch works, this should be different
# and before the patch they were the same!
SELECT * FROM t1;
a
0
USE test;
SELECT * FROM t1;
a
1
DROP TABLE t1;
DROP DATABASE mysqltest2;
# test that symlinks can not overwrite files when CREATE TABLE
# user root:
CREATE DATABASE mysqltest2;
USE mysqltest2;
CREATE TABLE t1 (a INT)
PARTITION BY LIST (a) (
PARTITION p0 VALUES IN (0)
52 53
DATA DIRECTORY 'MYSQLTEST_VARDIR/tmp'
     INDEX DIRECTORY 'MYSQLTEST_VARDIR/tmp',
54
PARTITION p1 VALUES IN (1)
55 56
DATA DIRECTORY 'MYSQLTEST_VARDIR/tmp'
     INDEX DIRECTORY 'MYSQLTEST_VARDIR/tmp'
57 58 59 60 61 62
   );
# user mysqltest_1:
USE test;
CREATE TABLE t1 (a INT)
PARTITION BY LIST (a) (
PARTITION p0 VALUES IN (0)
63 64
DATA DIRECTORY 'MYSQLTEST_VARDIR/tmp'
     INDEX DIRECTORY 'MYSQLTEST_VARDIR/tmp',
65
PARTITION p1 VALUES IN (1)
66 67
DATA DIRECTORY 'MYSQLTEST_VARDIR/tmp'
     INDEX DIRECTORY 'MYSQLTEST_VARDIR/tmp'
68 69 70 71 72
   );
Got one of the listed errors
CREATE TABLE t1 (a INT)
PARTITION BY LIST (a) (
PARTITION p0 VALUES IN (0)
73 74
DATA DIRECTORY 'MYSQLTEST_VARDIR/tmp'
     INDEX DIRECTORY 'MYSQLTEST_VARDIR/tmp',
75
PARTITION p1 VALUES IN (1)
76 77
DATA DIRECTORY 'MYSQLTEST_VARDIR/tmp'
     INDEX DIRECTORY 'MYSQLTEST_VARDIR/tmp'
78 79 80 81 82 83
  );
Got one of the listed errors
# user root (cleanup):
DROP DATABASE mysqltest2;
USE test;
DROP USER mysqltest_1@localhost;
84 85 86 87 88 89 90
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"
);
91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115
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'
);
Warnings:
Warning	0	DATA DIRECTORY option ignored
Warning	0	INDEX DIRECTORY option ignored
show create table t2;
Table	Create Table
t2	CREATE TABLE `t2` (
  `i` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (i) (PARTITION p01 VALUES LESS THAN (1000) ENGINE = MyISAM) */
DROP TABLE t1, t2;
set @@sql_mode=@org_mode;
create table t1 (a int)
partition by key (a)
(partition p0 DATA DIRECTORY 'part-data' INDEX DIRECTORY 'part-data');
116
Got one of the listed errors
117 118 119 120
create table t1 (a int)
partition by key (a)
(partition p0,
partition p1 DATA DIRECTORY 'part-data' INDEX DIRECTORY 'part-data');
121
Got one of the listed errors