Debian Codegraph @

mysql-test/suite/engines/funcs/t/ai_init_insert.test

raw
1 --disable_warnings
2 let $ENGINE=`select variable_value from performance_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`;
3 --enable_warnings
4
5 --disable_warnings
6 DROP TABLE IF EXISTS t1;
7 --enable_warnings
8 create table t1 (c1 VARCHAR(10) NOT NULL COMMENT 'Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcd', c2 INTEGER COMMENT 'aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcd',c3 INTEGER COMMENT '012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789', c4 INTEGER, c5 INTEGER, c6 INTEGER, c7 INTEGER, c8 VARCHAR(100), c9 CHAR(50), c10 DATETIME, c11 DATETIME, c12 DATETIME,c13 DATETIME, INDEX i1 (c1), INDEX i2(c2)
9 ) COMMENT='ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcd';
10
11
12 --sorted_result
13 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
14
15
16 --sorted_result
17 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
18
19
20 --sorted_result
21 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
22 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
23 SHOW CREATE TABLE t1;
24
25
26 --sorted_result
27 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
28
29
30 --sorted_result
31 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
32
33
34 --sorted_result
35 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
36 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
37 SHOW CREATE TABLE t1;
38
39
40 --sorted_result
41 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
42
43
44 --sorted_result
45 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
46
47
48 --sorted_result
49 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
50 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
51 SHOW CREATE TABLE t1;
52
53 DROP INDEX i1 ON t1;
54 ALTER TABLE t1 DROP INDEX i2;
55
56
57 --sorted_result
58 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
59
60
61 --sorted_result
62 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
63
64
65 --sorted_result
66 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
67 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
68 SHOW CREATE TABLE t1;
69
70 --sorted_result
71 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
72
73
74 --sorted_result
75 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
76
77
78 --sorted_result
79 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
80 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
81 SHOW CREATE TABLE t1;
82
83
84 --sorted_result
85 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
86
87
88 --sorted_result
89 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
90
91
92 --sorted_result
93 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
94 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
95 SHOW CREATE TABLE t1;
96
97
98 --sorted_result
99 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
100
101
102 --sorted_result
103 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
104
105
106 --sorted_result
107 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
108 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
109 SHOW CREATE TABLE t1;
110
111 --sorted_result
112 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
113
114
115 --sorted_result
116 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
117
118
119 --sorted_result
120 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
121 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
122 SHOW CREATE TABLE t1;
123
124
125
126
127 set sql_mode='TRADITIONAL';
128
129
130 --sorted_result
131 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
132
133
134 --sorted_result
135 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
136
137
138 --sorted_result
139 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
140 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
141 SHOW CREATE TABLE t1;
142
143
144 set sql_mode='TRADITIONAL';
145
146 --sorted_result
147 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
148
149
150 --sorted_result
151 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
152
153
154 --sorted_result
155 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
156 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
157 SHOW CREATE TABLE t1;
158 DROP TABLE t1;