Debian Codegraph @

mysql-test/suite/innodb/r/innodb_i_s_columns.result

raw
1 #
2 # BUG#30837086 : SELECT FROM I_S.INNODB_COLUMNS IS SLOW IN 8.0
3 #
4 # Table without partition and virual columns
5 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b INT, d INT, c INT AS(a+b));
6 NAME POS MTYPE PRTYPE
7 a 0 6 1283
8 b 1 6 1027
9 d 2 6 1027
10 c 65539 6 9219
11 DROP TABLE t1;
12 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b INT, c INT AS(a+b), d INT);
13 NAME POS MTYPE PRTYPE
14 a 0 6 1283
15 b 1 6 1027
16 c 65538 6 9219
17 d 2 6 1027
18 DROP TABLE t1;
19 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, c INT AS(a+b), b INT, d INT);
20 NAME POS MTYPE PRTYPE
21 a 0 6 1283
22 c 65537 6 9219
23 b 1 6 1027
24 d 2 6 1027
25 DROP TABLE t1;
26 CREATE TABLE t1 (c INT AS(a+b), a INT NOT NULL PRIMARY KEY, b INT, d INT);
27 NAME POS MTYPE PRTYPE
28 c 65536 6 9219
29 a 0 6 1283
30 b 1 6 1027
31 d 2 6 1027
32 DROP TABLE t1;
33 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b INT, c INT AS(a+b), d INT, e INT AS(b+d) STORED,f INT AS(a+b+d));
34 NAME POS MTYPE PRTYPE
35 a 0 6 1283
36 b 1 6 1027
37 c 65538 6 9219
38 d 2 6 1027
39 e 3 6 1027
40 f 131077 6 9219
41 DROP TABLE t1;
42 # Table with partition and virtual column
43 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b INT, d INT, c INT AS(a+b))
44 PARTITION BY HASH (a) PARTITIONS 3;
45 NAME POS MTYPE PRTYPE
46 a 0 6 1283
47 b 1 6 1027
48 d 2 6 1027
49 c 65539 6 9219
50 NAME POS MTYPE PRTYPE
51 a 0 6 1283
52 b 1 6 1027
53 d 2 6 1027
54 c 65539 6 9219
55 NAME POS MTYPE PRTYPE
56 a 0 6 1283
57 b 1 6 1027
58 d 2 6 1027
59 c 65539 6 9219
60 DROP TABLE t1;
61 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b INT, c INT AS(a+b), d INT, e INT AS(b+d) STORED,f INT AS(a+b+d))
62 PARTITION BY HASH (a) PARTITIONS 3;
63 NAME POS MTYPE PRTYPE
64 a 0 6 1283
65 b 1 6 1027
66 c 65538 6 9219
67 d 2 6 1027
68 e 3 6 1027
69 f 131077 6 9219
70 NAME POS MTYPE PRTYPE
71 a 0 6 1283
72 b 1 6 1027
73 c 65538 6 9219
74 d 2 6 1027
75 e 3 6 1027
76 f 131077 6 9219
77 NAME POS MTYPE PRTYPE
78 a 0 6 1283
79 b 1 6 1027
80 c 65538 6 9219
81 d 2 6 1027
82 e 3 6 1027
83 f 131077 6 9219
84 DROP TABLE t1;
85 # Table with FTS Index
86 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b INT, d VARCHAR(100), c INT AS(a+b), FULLTEXT idx (d))
87 PARTITION BY HASH (a) PARTITIONS 3;
88 ERROR HY000: The used table type doesn't support FULLTEXT indexes
89 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b INT, d VARCHAR(100), c INT AS(a+b), FULLTEXT idx (d));
90 NAME POS MTYPE PRTYPE
91 a 0 6 1283
92 b 1 6 1027
93 d 2 12 16715791
94 c 65539 6 9219
95 DROP TABLE t1;
96 # Table with functional index
97 CREATE TABLE t1 (int_col INTEGER, string_col VARCHAR(255));
98 CREATE INDEX int_func_index ON t1 ((ABS(int_col)));
99 NAME POS MTYPE PRTYPE
100 int_col 0 6 1027
101 string_col 1 12 16715791
102 CREATE INDEX string_func_index ON t1 ((SUBSTRING(string_col, 1, 2)));
103 NAME POS MTYPE PRTYPE
104 int_col 0 6 1027
105 string_col 1 12 16715791
106 DROP TABLE t1;