Debian Codegraph @

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

raw
1 --source include/have_debug_sync.inc
2 --source include/have_innodb.inc
3 --source include/have_partition.inc
4
5 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB
6 PARTITION BY RANGE (a) (
7 PARTITION p0 VALUES LESS THAN (3),
8 PARTITION p1 VALUES LESS THAN (10));
9
10 INSERT INTO t1 VALUES (1), (2), (3), (4);
11
12 --let $percona_nonflushing_analyze_table= t1
13 --source include/percona_nonflushing_analyze_debug.inc
14
15 DROP TABLE t1;
16
17 CREATE TABLE t2 (a INT PRIMARY KEY) ENGINE=InnoDB
18 PARTITION BY RANGE (a)
19 SUBPARTITION BY HASH (A)
20 SUBPARTITIONS 2 (
21 PARTITION p0 VALUES LESS THAN (3),
22 PARTITION p1 VALUES LESS THAN (10));
23
24 INSERT INTO t2 VALUES (1), (2), (3), (4);
25
26 --let $percona_nonflushing_analyze_table= t2
27 --source include/percona_nonflushing_analyze_debug.inc
28
29 DROP TABLE t2;