Debian Codegraph @

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

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