| 1 |
--source include/have_partition.inc |
| 2 |
--source include/have_innodb.inc |
| 3 |
--source include/not_embedded.inc |
| 4 |
|
| 5 |
connect (con1,localhost,root,,); |
| 6 |
BACKUP STAGE START; |
| 7 |
connection default; |
| 8 |
|
| 9 |
--let $part_int=PARTITION BY HASH(a) PARTITIONS 2 |
| 10 |
--let $part_date=PARTITION BY HASH(YEAR(a)) PARTITIONS 2 |
| 11 |
--source main/backup_log.inc |
| 12 |
|
| 13 |
--echo # |
| 14 |
--echo # Testing backup ddl log for partitioned tables |
| 15 |
--echo # |
| 16 |
|
| 17 |
CREATE TABLE t200(a INT, b INT) ENGINE ARIA TRANSACTIONAL = 1 PAGE_CHECKSUM = 1; |
| 18 |
INSERT INTO t200 VALUES (5, 5), (15, 15), (25, 25); |
| 19 |
ALTER TABLE t200 PARTITION BY RANGE( a ) ( |
| 20 |
PARTITION p0 VALUES LESS THAN (10), |
| 21 |
PARTITION p1 VALUES LESS THAN (20), |
| 22 |
PARTITION p2 VALUES LESS THAN (30) |
| 23 |
); |
| 24 |
CREATE TABLE t210(a INT, b INT) ENGINE ARIA TRANSACTIONAL = 1 PAGE_CHECKSUM = 1; |
| 25 |
--echo #TODO: echange partitions have not logged yet |
| 26 |
ALTER TABLE t200 EXCHANGE PARTITION p2 WITH TABLE t210; |
| 27 |
ALTER TABLE t200 DROP PARTITION p0; |
| 28 |
ALTER TABLE t200 ADD PARTITION (PARTITION p3 VALUES LESS THAN (40)); |
| 29 |
ALTER TABLE t200 |
| 30 |
REORGANIZE PARTITION p3 INTO ( |
| 31 |
PARTITION n0 VALUES LESS THAN (35), |
| 32 |
PARTITION n1 VALUES LESS THAN (45) |
| 33 |
); |
| 34 |
ALTER TABLE t200 PARTITION BY KEY(a) PARTITIONS 2; |
| 35 |
ALTER TABLE t200 PARTITION BY HASH(a) PARTITIONS 8; |
| 36 |
ALTER TABLE t200 COALESCE PARTITION 4; |
| 37 |
ALTER TABLE t200 |
| 38 |
PARTITION BY RANGE (b) |
| 39 |
SUBPARTITION BY KEY (a) |
| 40 |
SUBPARTITIONS 2 ( |
| 41 |
PARTITION p0 VALUES LESS THAN (10), |
| 42 |
PARTITION p1 VALUES LESS THAN (20), |
| 43 |
PARTITION p2 VALUES LESS THAN (30), |
| 44 |
PARTITION p3 VALUES LESS THAN (MAXVALUE) |
| 45 |
); |
| 46 |
ALTER TABLE t200 REMOVE PARTITIONING; |
| 47 |
DROP TABLE t200, t210; |
| 48 |
|
| 49 |
--echo # Test for the case when TDC contains TABLE_SHARE object for the |
| 50 |
--echo # certain table, but the table is not opened |
| 51 |
CREATE TABLE t220(a INT) ENGINE ARIA PARTITION BY HASH(a) PARTITIONS 2; |
| 52 |
--disable_result_log |
| 53 |
SELECT VERSION FROM INFORMATION_SCHEMA.tables WHERE |
| 54 |
TABLE_SCHEMA = 'test' AND TABLE_NAME = 't220'; |
| 55 |
--enable_result_log |
| 56 |
DROP TABLE t220; |
| 57 |
|
| 58 |
--source include/print_ddl_log.inc |
| 59 |
|
| 60 |
--echo # |
| 61 |
--echo # Cleanup |
| 62 |
--echo # |
| 63 |
disconnect con1; |