Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 BIT NOT NULL);
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) NOT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 ALTER TABLE t1 ADD PRIMARY KEY (c1);
12 SHOW TABLES;
13 Tables_in_test
14 t1
15 SHOW CREATE TABLE t1;
16 Table Create Table
17 t1 CREATE TABLE `t1` (
18 `c1` bit(1) NOT NULL,
19 PRIMARY KEY (`c1`)
20 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
21 DROP TABLE t1;
22 SHOW TABLES;
23 Tables_in_test
24 CREATE TABLE t1(c1 TINYINT NOT NULL);
25 SHOW TABLES;
26 Tables_in_test
27 t1
28 SHOW CREATE TABLE t1;
29 Table Create Table
30 t1 CREATE TABLE `t1` (
31 `c1` tinyint NOT NULL
32 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
33 ALTER TABLE t1 ADD PRIMARY KEY (c1);
34 SHOW TABLES;
35 Tables_in_test
36 t1
37 SHOW CREATE TABLE t1;
38 Table Create Table
39 t1 CREATE TABLE `t1` (
40 `c1` tinyint NOT NULL,
41 PRIMARY KEY (`c1`)
42 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 DROP TABLE t1;
44 SHOW TABLES;
45 Tables_in_test
46 CREATE TABLE t1(c1 SMALLINT NOT NULL);
47 SHOW TABLES;
48 Tables_in_test
49 t1
50 SHOW CREATE TABLE t1;
51 Table Create Table
52 t1 CREATE TABLE `t1` (
53 `c1` smallint NOT NULL
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 ALTER TABLE t1 ADD PRIMARY KEY (c1);
56 SHOW TABLES;
57 Tables_in_test
58 t1
59 SHOW CREATE TABLE t1;
60 Table Create Table
61 t1 CREATE TABLE `t1` (
62 `c1` smallint NOT NULL,
63 PRIMARY KEY (`c1`)
64 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
65 DROP TABLE t1;
66 SHOW TABLES;
67 Tables_in_test
68 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
69 SHOW TABLES;
70 Tables_in_test
71 t1
72 SHOW CREATE TABLE t1;
73 Table Create Table
74 t1 CREATE TABLE `t1` (
75 `c1` mediumint NOT NULL
76 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
77 ALTER TABLE t1 ADD PRIMARY KEY (c1);
78 SHOW TABLES;
79 Tables_in_test
80 t1
81 SHOW CREATE TABLE t1;
82 Table Create Table
83 t1 CREATE TABLE `t1` (
84 `c1` mediumint NOT NULL,
85 PRIMARY KEY (`c1`)
86 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
87 DROP TABLE t1;
88 SHOW TABLES;
89 Tables_in_test
90 CREATE TABLE t1(c1 INT NOT NULL);
91 SHOW TABLES;
92 Tables_in_test
93 t1
94 SHOW CREATE TABLE t1;
95 Table Create Table
96 t1 CREATE TABLE `t1` (
97 `c1` int NOT NULL
98 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
99 ALTER TABLE t1 ADD PRIMARY KEY (c1);
100 SHOW TABLES;
101 Tables_in_test
102 t1
103 SHOW CREATE TABLE t1;
104 Table Create Table
105 t1 CREATE TABLE `t1` (
106 `c1` int NOT NULL,
107 PRIMARY KEY (`c1`)
108 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
109 DROP TABLE t1;
110 SHOW TABLES;
111 Tables_in_test
112 CREATE TABLE t1(c1 INTEGER NOT NULL);
113 SHOW TABLES;
114 Tables_in_test
115 t1
116 SHOW CREATE TABLE t1;
117 Table Create Table
118 t1 CREATE TABLE `t1` (
119 `c1` int NOT NULL
120 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
121 ALTER TABLE t1 ADD PRIMARY KEY (c1);
122 SHOW TABLES;
123 Tables_in_test
124 t1
125 SHOW CREATE TABLE t1;
126 Table Create Table
127 t1 CREATE TABLE `t1` (
128 `c1` int NOT NULL,
129 PRIMARY KEY (`c1`)
130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
131 DROP TABLE t1;
132 SHOW TABLES;
133 Tables_in_test
134 CREATE TABLE t1(c1 BIGINT NOT NULL);
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` bigint NOT NULL
142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
143 ALTER TABLE t1 ADD PRIMARY KEY (c1);
144 SHOW TABLES;
145 Tables_in_test
146 t1
147 SHOW CREATE TABLE t1;
148 Table Create Table
149 t1 CREATE TABLE `t1` (
150 `c1` bigint NOT NULL,
151 PRIMARY KEY (`c1`)
152 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
153 DROP TABLE t1;
154 SHOW TABLES;
155 Tables_in_test
156 CREATE TABLE t1(c1 REAL NOT NULL);
157 SHOW TABLES;
158 Tables_in_test
159 t1
160 SHOW CREATE TABLE t1;
161 Table Create Table
162 t1 CREATE TABLE `t1` (
163 `c1` double NOT NULL
164 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
165 ALTER TABLE t1 ADD PRIMARY KEY (c1);
166 SHOW TABLES;
167 Tables_in_test
168 t1
169 SHOW CREATE TABLE t1;
170 Table Create Table
171 t1 CREATE TABLE `t1` (
172 `c1` double NOT NULL,
173 PRIMARY KEY (`c1`)
174 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
175 DROP TABLE t1;
176 SHOW TABLES;
177 Tables_in_test
178 CREATE TABLE t1(c1 DOUBLE NOT NULL);
179 SHOW TABLES;
180 Tables_in_test
181 t1
182 SHOW CREATE TABLE t1;
183 Table Create Table
184 t1 CREATE TABLE `t1` (
185 `c1` double NOT NULL
186 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
187 ALTER TABLE t1 ADD PRIMARY KEY (c1);
188 SHOW TABLES;
189 Tables_in_test
190 t1
191 SHOW CREATE TABLE t1;
192 Table Create Table
193 t1 CREATE TABLE `t1` (
194 `c1` double NOT NULL,
195 PRIMARY KEY (`c1`)
196 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
197 DROP TABLE t1;
198 SHOW TABLES;
199 Tables_in_test
200 CREATE TABLE t1(c1 FLOAT NOT NULL);
201 SHOW TABLES;
202 Tables_in_test
203 t1
204 SHOW CREATE TABLE t1;
205 Table Create Table
206 t1 CREATE TABLE `t1` (
207 `c1` float NOT NULL
208 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
209 ALTER TABLE t1 ADD PRIMARY KEY (c1);
210 SHOW TABLES;
211 Tables_in_test
212 t1
213 SHOW CREATE TABLE t1;
214 Table Create Table
215 t1 CREATE TABLE `t1` (
216 `c1` float NOT NULL,
217 PRIMARY KEY (`c1`)
218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
219 DROP TABLE t1;
220 SHOW TABLES;
221 Tables_in_test
222 CREATE TABLE t1(c1 DECIMAL NOT NULL);
223 SHOW TABLES;
224 Tables_in_test
225 t1
226 SHOW CREATE TABLE t1;
227 Table Create Table
228 t1 CREATE TABLE `t1` (
229 `c1` decimal(10,0) NOT NULL
230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
231 ALTER TABLE t1 ADD PRIMARY KEY (c1);
232 SHOW TABLES;
233 Tables_in_test
234 t1
235 SHOW CREATE TABLE t1;
236 Table Create Table
237 t1 CREATE TABLE `t1` (
238 `c1` decimal(10,0) NOT NULL,
239 PRIMARY KEY (`c1`)
240 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
241 DROP TABLE t1;
242 SHOW TABLES;
243 Tables_in_test
244 CREATE TABLE t1(c1 NUMERIC NOT NULL);
245 SHOW TABLES;
246 Tables_in_test
247 t1
248 SHOW CREATE TABLE t1;
249 Table Create Table
250 t1 CREATE TABLE `t1` (
251 `c1` decimal(10,0) NOT NULL
252 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
253 ALTER TABLE t1 ADD PRIMARY KEY (c1);
254 SHOW TABLES;
255 Tables_in_test
256 t1
257 SHOW CREATE TABLE t1;
258 Table Create Table
259 t1 CREATE TABLE `t1` (
260 `c1` decimal(10,0) NOT NULL,
261 PRIMARY KEY (`c1`)
262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
263 DROP TABLE t1;
264 SHOW TABLES;
265 Tables_in_test
266 CREATE TABLE t1(c1 DATE NOT NULL);
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` date NOT NULL
274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
275 ALTER TABLE t1 ADD PRIMARY KEY (c1);
276 SHOW TABLES;
277 Tables_in_test
278 t1
279 SHOW CREATE TABLE t1;
280 Table Create Table
281 t1 CREATE TABLE `t1` (
282 `c1` date NOT NULL,
283 PRIMARY KEY (`c1`)
284 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
285 DROP TABLE t1;
286 SHOW TABLES;
287 Tables_in_test
288 CREATE TABLE t1(c1 TIME NOT NULL);
289 SHOW TABLES;
290 Tables_in_test
291 t1
292 SHOW CREATE TABLE t1;
293 Table Create Table
294 t1 CREATE TABLE `t1` (
295 `c1` time NOT NULL
296 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
297 ALTER TABLE t1 ADD PRIMARY KEY (c1);
298 SHOW TABLES;
299 Tables_in_test
300 t1
301 SHOW CREATE TABLE t1;
302 Table Create Table
303 t1 CREATE TABLE `t1` (
304 `c1` time NOT NULL,
305 PRIMARY KEY (`c1`)
306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
307 DROP TABLE t1;
308 SHOW TABLES;
309 Tables_in_test
310 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
311 SHOW TABLES;
312 Tables_in_test
313 t1
314 SHOW CREATE TABLE t1;
315 Table Create Table
316 t1 CREATE TABLE `t1` (
317 `c1` timestamp NOT NULL
318 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
319 ALTER TABLE t1 ADD PRIMARY KEY (c1);
320 SHOW TABLES;
321 Tables_in_test
322 t1
323 SHOW CREATE TABLE t1;
324 Table Create Table
325 t1 CREATE TABLE `t1` (
326 `c1` timestamp NOT NULL,
327 PRIMARY KEY (`c1`)
328 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
329 DROP TABLE t1;
330 SHOW TABLES;
331 Tables_in_test
332 CREATE TABLE t1(c1 YEAR NOT NULL);
333 SHOW TABLES;
334 Tables_in_test
335 t1
336 SHOW CREATE TABLE t1;
337 Table Create Table
338 t1 CREATE TABLE `t1` (
339 `c1` year NOT NULL
340 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
341 ALTER TABLE t1 ADD PRIMARY KEY (c1);
342 SHOW TABLES;
343 Tables_in_test
344 t1
345 SHOW CREATE TABLE t1;
346 Table Create Table
347 t1 CREATE TABLE `t1` (
348 `c1` year NOT NULL,
349 PRIMARY KEY (`c1`)
350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
351 DROP TABLE t1;
352 SHOW TABLES;
353 Tables_in_test