Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1 ( c1 SMALLINT, c2 INT) PARTITION BY LIST (c1) (
5 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
6 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
7 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
8 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
9 SHOW TABLES;
10 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
11 CREATE TABLE t1 ( c1 MEDIUMINT, c2 INT) PARTITION BY LIST (c1) (
12 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
13 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
14 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
15 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
16 SHOW TABLES;
17 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
18 CREATE TABLE t1 ( c1 INT, c2 INT) PARTITION BY LIST (c1) (
19 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
20 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
21 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
22 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
23 SHOW TABLES;
24 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
25 CREATE TABLE t1 ( c1 INTEGER, c2 INT) PARTITION BY LIST (c1) (
26 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
27 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
28 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
29 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
30 SHOW TABLES;
31 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
32 CREATE TABLE t1 ( c1 BIGINT, c2 INT) PARTITION BY LIST (c1) (
33 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
34 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
35 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
36 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
37 SHOW TABLES;
38 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;