Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 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)
5 ) COMMENT='ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcd';
6
7
8 --sorted_result
9 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
10
11
12 --sorted_result
13 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
14
15
16 --sorted_result
17 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
18 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
19 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
20 SHOW CREATE TABLE t1;
21
22
23 --sorted_result
24 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
25
26
27 --sorted_result
28 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
29
30
31 --sorted_result
32 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
33 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
34 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
35 SHOW CREATE TABLE t1;
36
37
38 --sorted_result
39 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
40
41
42 --sorted_result
43 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
44
45
46 --sorted_result
47 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
48 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
49 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
50 SHOW CREATE TABLE t1;
51
52 DROP INDEX i1 ON t1;
53 ALTER TABLE t1 DROP INDEX i2;
54
55
56 --sorted_result
57 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
58
59
60 --sorted_result
61 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
62
63
64 --sorted_result
65 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
66 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
67 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
81 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
82 SHOW CREATE TABLE t1;
83
84
85 --sorted_result
86 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
87
88
89 --sorted_result
90 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
91
92
93 --sorted_result
94 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
95 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
96 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
97 SHOW CREATE TABLE t1;
98
99
100 --sorted_result
101 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
102
103
104 --sorted_result
105 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
106
107
108 --sorted_result
109 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
110 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
111 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
112 SHOW CREATE TABLE t1;
113
114 --sorted_result
115 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
116
117
118 --sorted_result
119 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
120
121
122 --sorted_result
123 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
124 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
125 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
126 SHOW CREATE TABLE t1;
127
128
129
130
131 set sql_mode='TRADITIONAL';
132
133
134 --sorted_result
135 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
136
137
138 --sorted_result
139 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
140
141
142 --sorted_result
143 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
144 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
145 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
146 SHOW CREATE TABLE t1;
147
148
149 set sql_mode='TRADITIONAL';
150
151 --sorted_result
152 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
153
154
155 --sorted_result
156 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
157
158
159 --sorted_result
160 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
161 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
162 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
163 SHOW CREATE TABLE t1;
164 DROP TABLE t1;
165