1
--source include/have_falcon.inc
2
--source include/have_partition.inc
5
# BUG#33404 - Falcon ignores partition-level TABLESPACE option
7
CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE=Falcon;
8
CREATE TABLESPACE ts2 ADD DATAFILE 'ts2.fts' ENGINE=Falcon;
9
CREATE TABLESPACE ts3 ADD DATAFILE 'ts3.fts' ENGINE=Falcon;
11
CREATE TABLE t1 (a INT) ENGINE=Falcon TABLESPACE ts1
12
PARTITION BY RANGE(a) SUBPARTITION BY HASH(a) (
13
PARTITION p1 VALUES LESS THAN (100) TABLESPACE ts2 (
14
SUBPARTITION p1s1 TABLESPACE ts3,
17
PARTITION p2 VALUES LESS THAN MAXVALUE (
22
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE
23
TABLE_NAME = 't1' AND SCHEMA_NAME='test';
26
ALTER TABLE t1 REMOVE PARTITIONING;
27
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE
28
TABLE_NAME = 't1' AND SCHEMA_NAME='test';
30
ALTER TABLE t1 TABLESPACE ts1
31
PARTITION BY RANGE(a) SUBPARTITION BY HASH(a) (
32
PARTITION p1 VALUES LESS THAN (100) TABLESPACE ts2 (
33
SUBPARTITION p1s1 TABLESPACE ts3,
36
PARTITION p2 VALUES LESS THAN (200) (
41
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE
42
TABLE_NAME = 't1' AND SCHEMA_NAME='test';
44
ALTER TABLE t1 ADD PARTITION (PARTITION p3 VALUES LESS THAN MAXVALUE);
45
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE
46
TABLE_NAME = 't1' AND SCHEMA_NAME='test';
48
ALTER TABLE t1 REORGANIZE PARTITION p3 INTO (PARTITION p3 VALUES LESS THAN
49
MAXVALUE TABLESPACE ts1);
50
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE
51
TABLE_NAME = 't1' AND SCHEMA_NAME='test';
53
ALTER TABLE t1 REORGANIZE PARTITION p3 INTO (PARTITION p3 VALUES LESS THAN
54
MAXVALUE TABLESPACE ts2);
55
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE
56
TABLE_NAME = 't1' AND SCHEMA_NAME='test';
58
ALTER TABLE t1 REORGANIZE PARTITION p1 INTO (PARTITION p1 VALUES LESS THAN
59
(100) TABLESPACE ts2);
60
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE
61
TABLE_NAME = 't1' AND SCHEMA_NAME='test';
64
DROP TABLESPACE ts1 ENGINE=Falcon;
65
DROP TABLESPACE ts2 ENGINE=Falcon;
66
DROP TABLESPACE ts3 ENGINE=Falcon;