Debian Codegraph @

mysql-test/suite/innodb/t/innodb_stats_long_names.test

raw
1 #
2 # Test mysql.innodb_(table|index)_stats with long table names.
3 #
4
5
6 CREATE TABLE t_cdefgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd
7 (a INT, b INT) ENGINE=INNODB
8 PARTITION BY RANGE (a)
9 SUBPARTITION BY HASH(b)
10 (
11 PARTITION p1_defgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd
12 VALUES LESS THAN (100)
13 (
14 SUBPARTITION
15 p1s1_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd,
16 SUBPARTITION
17 p1s2_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd
18 ),
19 PARTITION p2_defgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd
20 VALUES LESS THAN (200)
21 (
22 SUBPARTITION
23 p2s1_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd,
24 SUBPARTITION
25 p2s2_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd
26 )
27 );
28
29 # On Windows MySQL uses lowercase p and sp.
30 -- replace_result #p# #P# #sp# #SP#
31 SELECT DISTINCT table_name
32 FROM mysql.innodb_table_stats
33 WHERE table_name LIKE 't_cde%' OR table_name LIKE 'ᵗ%'
34 ORDER BY 1;
35
36 # On Windows MySQL uses lowercase p and sp.
37 -- replace_result #p# #P# #sp# #SP#
38 SELECT DISTINCT table_name
39 FROM mysql.innodb_index_stats
40 WHERE table_name LIKE 't_cde%' OR table_name LIKE 'ᵗ%'
41 ORDER BY 1;
42
43 DROP TABLE t_cdefgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd;