Debian Codegraph @

mysql-test/suite/engines/funcs/r/tc_structure_comment.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 BIT NULL) COMMENT = 'This table has a BIT column';
3 SHOW TABLES;
4 Tables_in_test
5 t1
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `c1` bit(1) DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a BIT column'
11 DROP TABLE t1;
12 SHOW TABLES;
13 Tables_in_test
14 CREATE TABLE t1(c1 TINYINT NULL) COMMENT = 'This table has a TINYINT column';
15 SHOW TABLES;
16 Tables_in_test
17 t1
18 SHOW CREATE TABLE t1;
19 Table Create Table
20 t1 CREATE TABLE `t1` (
21 `c1` tinyint DEFAULT NULL
22 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a TINYINT column'
23 DROP TABLE t1;
24 SHOW TABLES;
25 Tables_in_test
26 CREATE TABLE t1(c1 SMALLINT NULL) COMMENT = 'This table has a SMALLINT column';
27 SHOW TABLES;
28 Tables_in_test
29 t1
30 SHOW CREATE TABLE t1;
31 Table Create Table
32 t1 CREATE TABLE `t1` (
33 `c1` smallint DEFAULT NULL
34 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a SMALLINT column'
35 DROP TABLE t1;
36 SHOW TABLES;
37 Tables_in_test
38 CREATE TABLE t1(c1 MEDIUMINT NULL) COMMENT = 'This table has a MEDIUMINT column';
39 SHOW TABLES;
40 Tables_in_test
41 t1
42 SHOW CREATE TABLE t1;
43 Table Create Table
44 t1 CREATE TABLE `t1` (
45 `c1` mediumint DEFAULT NULL
46 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a MEDIUMINT column'
47 DROP TABLE t1;
48 SHOW TABLES;
49 Tables_in_test
50 CREATE TABLE t1(c1 INT NULL) COMMENT = 'This table has a INT column';
51 SHOW TABLES;
52 Tables_in_test
53 t1
54 SHOW CREATE TABLE t1;
55 Table Create Table
56 t1 CREATE TABLE `t1` (
57 `c1` int DEFAULT NULL
58 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a INT column'
59 DROP TABLE t1;
60 SHOW TABLES;
61 Tables_in_test
62 CREATE TABLE t1(c1 INTEGER NULL) COMMENT = 'This table has a INTEGER column';
63 SHOW TABLES;
64 Tables_in_test
65 t1
66 SHOW CREATE TABLE t1;
67 Table Create Table
68 t1 CREATE TABLE `t1` (
69 `c1` int DEFAULT NULL
70 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a INTEGER column'
71 DROP TABLE t1;
72 SHOW TABLES;
73 Tables_in_test
74 CREATE TABLE t1(c1 BIGINT NULL) COMMENT = 'This table has a BIGINT column';
75 SHOW TABLES;
76 Tables_in_test
77 t1
78 SHOW CREATE TABLE t1;
79 Table Create Table
80 t1 CREATE TABLE `t1` (
81 `c1` bigint DEFAULT NULL
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a BIGINT column'
83 DROP TABLE t1;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t1(c1 REAL NULL) COMMENT = 'This table has a REAL column';
87 SHOW TABLES;
88 Tables_in_test
89 t1
90 SHOW CREATE TABLE t1;
91 Table Create Table
92 t1 CREATE TABLE `t1` (
93 `c1` double DEFAULT NULL
94 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a REAL column'
95 DROP TABLE t1;
96 SHOW TABLES;
97 Tables_in_test
98 CREATE TABLE t1(c1 DOUBLE NULL) COMMENT = 'This table has a DOUBLE column';
99 SHOW TABLES;
100 Tables_in_test
101 t1
102 SHOW CREATE TABLE t1;
103 Table Create Table
104 t1 CREATE TABLE `t1` (
105 `c1` double DEFAULT NULL
106 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a DOUBLE column'
107 DROP TABLE t1;
108 SHOW TABLES;
109 Tables_in_test
110 CREATE TABLE t1(c1 FLOAT NULL) COMMENT = 'This table has a FLOAT column';
111 SHOW TABLES;
112 Tables_in_test
113 t1
114 SHOW CREATE TABLE t1;
115 Table Create Table
116 t1 CREATE TABLE `t1` (
117 `c1` float DEFAULT NULL
118 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a FLOAT column'
119 DROP TABLE t1;
120 SHOW TABLES;
121 Tables_in_test
122 CREATE TABLE t1(c1 DECIMAL NULL) COMMENT = 'This table has a DECIMAL column';
123 SHOW TABLES;
124 Tables_in_test
125 t1
126 SHOW CREATE TABLE t1;
127 Table Create Table
128 t1 CREATE TABLE `t1` (
129 `c1` decimal(10,0) DEFAULT NULL
130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a DECIMAL column'
131 DROP TABLE t1;
132 SHOW TABLES;
133 Tables_in_test
134 CREATE TABLE t1(c1 NUMERIC NULL) COMMENT = 'This table has a NUMERIC column';
135 SHOW TABLES;
136 Tables_in_test
137 t1
138 SHOW CREATE TABLE t1;
139 Table Create Table
140 t1 CREATE TABLE `t1` (
141 `c1` decimal(10,0) DEFAULT NULL
142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a NUMERIC column'
143 DROP TABLE t1;
144 SHOW TABLES;
145 Tables_in_test
146 CREATE TABLE t1(c1 DATE NULL) COMMENT = 'This table has a DATE column';
147 SHOW TABLES;
148 Tables_in_test
149 t1
150 SHOW CREATE TABLE t1;
151 Table Create Table
152 t1 CREATE TABLE `t1` (
153 `c1` date DEFAULT NULL
154 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a DATE column'
155 DROP TABLE t1;
156 SHOW TABLES;
157 Tables_in_test
158 CREATE TABLE t1(c1 TIME NULL) COMMENT = 'This table has a TIME column';
159 SHOW TABLES;
160 Tables_in_test
161 t1
162 SHOW CREATE TABLE t1;
163 Table Create Table
164 t1 CREATE TABLE `t1` (
165 `c1` time DEFAULT NULL
166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a TIME column'
167 DROP TABLE t1;
168 SHOW TABLES;
169 Tables_in_test
170 CREATE TABLE t1(c1 DATETIME NULL) COMMENT = 'This table has a DATETIME column';
171 SHOW TABLES;
172 Tables_in_test
173 t1
174 SHOW CREATE TABLE t1;
175 Table Create Table
176 t1 CREATE TABLE `t1` (
177 `c1` datetime DEFAULT NULL
178 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a DATETIME column'
179 DROP TABLE t1;
180 SHOW TABLES;
181 Tables_in_test
182 CREATE TABLE t1(c1 TIMESTAMP NULL) COMMENT = 'This table has a TIMESTAMP column';
183 SHOW TABLES;
184 Tables_in_test
185 t1
186 SHOW CREATE TABLE t1;
187 Table Create Table
188 t1 CREATE TABLE `t1` (
189 `c1` timestamp NULL DEFAULT NULL
190 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a TIMESTAMP column'
191 DROP TABLE t1;
192 SHOW TABLES;
193 Tables_in_test
194 CREATE TABLE t1(c1 YEAR NULL) COMMENT = 'This table has a YEAR column';
195 SHOW TABLES;
196 Tables_in_test
197 t1
198 SHOW CREATE TABLE t1;
199 Table Create Table
200 t1 CREATE TABLE `t1` (
201 `c1` year DEFAULT NULL
202 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a YEAR column'
203 DROP TABLE t1;
204 SHOW TABLES;
205 Tables_in_test
206 CREATE TABLE t1(c1 TINYBLOB NULL) COMMENT = 'This table has a TINYBLOB column';
207 SHOW TABLES;
208 Tables_in_test
209 t1
210 SHOW CREATE TABLE t1;
211 Table Create Table
212 t1 CREATE TABLE `t1` (
213 `c1` tinyblob
214 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a TINYBLOB column'
215 DROP TABLE t1;
216 SHOW TABLES;
217 Tables_in_test
218 CREATE TABLE t1(c1 BLOB NULL) COMMENT = 'This table has a BLOB column';
219 SHOW TABLES;
220 Tables_in_test
221 t1
222 SHOW CREATE TABLE t1;
223 Table Create Table
224 t1 CREATE TABLE `t1` (
225 `c1` blob
226 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a BLOB column'
227 DROP TABLE t1;
228 SHOW TABLES;
229 Tables_in_test
230 CREATE TABLE t1(c1 MEDIUMBLOB NULL) COMMENT = 'This table has a MEDIUMBLOB column';
231 SHOW TABLES;
232 Tables_in_test
233 t1
234 SHOW CREATE TABLE t1;
235 Table Create Table
236 t1 CREATE TABLE `t1` (
237 `c1` mediumblob
238 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a MEDIUMBLOB column'
239 DROP TABLE t1;
240 SHOW TABLES;
241 Tables_in_test
242 CREATE TABLE t1(c1 LONGBLOB NULL) COMMENT = 'This table has a LONGBLOB column';
243 SHOW TABLES;
244 Tables_in_test
245 t1
246 SHOW CREATE TABLE t1;
247 Table Create Table
248 t1 CREATE TABLE `t1` (
249 `c1` longblob
250 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a LONGBLOB column'
251 DROP TABLE t1;
252 SHOW TABLES;
253 Tables_in_test
254 CREATE TABLE t1(c1 TINYTEXT NULL) COMMENT = 'This table has a TINYTEXT column';
255 SHOW TABLES;
256 Tables_in_test
257 t1
258 SHOW CREATE TABLE t1;
259 Table Create Table
260 t1 CREATE TABLE `t1` (
261 `c1` tinytext
262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a TINYTEXT column'
263 DROP TABLE t1;
264 SHOW TABLES;
265 Tables_in_test
266 CREATE TABLE t1(c1 TEXT NULL) COMMENT = 'This table has a TEXT column';
267 SHOW TABLES;
268 Tables_in_test
269 t1
270 SHOW CREATE TABLE t1;
271 Table Create Table
272 t1 CREATE TABLE `t1` (
273 `c1` text
274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a TEXT column'
275 DROP TABLE t1;
276 SHOW TABLES;
277 Tables_in_test
278 CREATE TABLE t1(c1 MEDIUMTEXT NULL) COMMENT = 'This table has a MEDIUMTEXT column';
279 SHOW TABLES;
280 Tables_in_test
281 t1
282 SHOW CREATE TABLE t1;
283 Table Create Table
284 t1 CREATE TABLE `t1` (
285 `c1` mediumtext
286 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a MEDIUMTEXT column'
287 DROP TABLE t1;
288 SHOW TABLES;
289 Tables_in_test
290 CREATE TABLE t1(c1 LONGTEXT NULL) COMMENT = 'This table has a LONGTEXT column';
291 SHOW TABLES;
292 Tables_in_test
293 t1
294 SHOW CREATE TABLE t1;
295 Table Create Table
296 t1 CREATE TABLE `t1` (
297 `c1` longtext
298 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table has a LONGTEXT column'
299 DROP TABLE t1;
300 SHOW TABLES;
301 Tables_in_test