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


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

--source include/have_debug_sync.inc
--source include/have_innodb.inc
--source include/have_partition.inc

CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB
       PARTITION BY RANGE (a) (
                 PARTITION p0 VALUES LESS THAN (3),
                 PARTITION p1 VALUES LESS THAN (10));

INSERT INTO t1 VALUES (1), (2), (3), (4);

--let $percona_nonflushing_analyze_table= t1
--source include/percona_nonflushing_analyze_debug.inc

DROP TABLE t1;

CREATE TABLE t2 (a INT PRIMARY KEY) ENGINE=InnoDB
       PARTITION BY RANGE (a)
       SUBPARTITION BY HASH (A)
       SUBPARTITIONS 2 (
                 PARTITION p0 VALUES LESS THAN (3),
                 PARTITION p1 VALUES LESS THAN (10));

INSERT INTO t2 VALUES (1), (2), (3), (4);

--let $percona_nonflushing_analyze_table= t2
--source include/percona_nonflushing_analyze_debug.inc

DROP TABLE t2;