Debian Codegraph @

mysql-test/suite/parts/t/backup_log.test

raw
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;