Debian Codegraph @

mysql-test/suite/engines/funcs/t/tc_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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
11 --replace_result $ENGINE ENGINE
12 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
13 CREATE TABLE t1 ( c1 MEDIUMINT, c2 INT) PARTITION BY LIST (c1) (
14 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
15 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
16 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
17 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
18 SHOW TABLES;
19 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
20 --replace_result $ENGINE ENGINE
21 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
22 CREATE TABLE t1 ( c1 INT, c2 INT) PARTITION BY LIST (c1) (
23 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
24 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
25 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
26 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
27 SHOW TABLES;
28 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
29 --replace_result $ENGINE ENGINE
30 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
31 CREATE TABLE t1 ( c1 INTEGER, c2 INT) PARTITION BY LIST (c1) (
32 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
33 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
34 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
35 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
36 SHOW TABLES;
37 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
38 --replace_result $ENGINE ENGINE
39 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
40 CREATE TABLE t1 ( c1 BIGINT, c2 INT) PARTITION BY LIST (c1) (
41 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
42 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
43 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
44 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
45 SHOW TABLES;
46 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
47 --replace_result $ENGINE ENGINE
48 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
49