Debian Codegraph @

mysql-test/suite/x/r/fieldtypes_all.result

raw
1 RUN create schema xtest
2
3 1 rows affected
4 RUN use xtest
5
6 0 rows affected
7 RUN CREATE TABLE t_tinyint (c1 TINYINT, c2 TINYINT UNSIGNED)
8
9 0 rows affected
10 RUN INSERT INTO t_tinyint VALUES (-128, 0)
11
12 1 rows affected
13 RUN INSERT INTO t_tinyint VALUES (-1, 1)
14
15 1 rows affected
16 RUN INSERT INTO t_tinyint VALUES (0, 127)
17
18 1 rows affected
19 RUN INSERT INTO t_tinyint VALUES (1, 200)
20
21 1 rows affected
22 RUN INSERT INTO t_tinyint VALUES (127, 255)
23
24 1 rows affected
25 RUN CREATE TABLE t_smallint (c1 SMALLINT, c2 SMALLINT UNSIGNED)
26
27 0 rows affected
28 RUN INSERT INTO t_smallint VALUES (-32768, 0)
29
30 1 rows affected
31 RUN INSERT INTO t_smallint VALUES (-1, 1)
32
33 1 rows affected
34 RUN INSERT INTO t_smallint VALUES (0, 32767)
35
36 1 rows affected
37 RUN INSERT INTO t_smallint VALUES (1, 65534)
38
39 1 rows affected
40 RUN INSERT INTO t_smallint VALUES (32767, 65535)
41
42 1 rows affected
43 RUN CREATE TABLE t_mediumint (c1 MEDIUMINT, c2 MEDIUMINT UNSIGNED)
44
45 0 rows affected
46 RUN INSERT INTO t_mediumint VALUES (-8388608, 0)
47
48 1 rows affected
49 RUN INSERT INTO t_mediumint VALUES (-1, 1)
50
51 1 rows affected
52 RUN INSERT INTO t_mediumint VALUES (0, 8388607)
53
54 1 rows affected
55 RUN INSERT INTO t_mediumint VALUES (1, 16777214)
56
57 1 rows affected
58 RUN INSERT INTO t_mediumint VALUES (8388607, 16777215)
59
60 1 rows affected
61 RUN CREATE TABLE t_int (c1 INT, c2 INT UNSIGNED)
62
63 0 rows affected
64 RUN INSERT INTO t_int VALUES (-2147483648, 0)
65
66 1 rows affected
67 RUN INSERT INTO t_int VALUES (-1, 1)
68
69 1 rows affected
70 RUN INSERT INTO t_int VALUES (0, 2147483647)
71
72 1 rows affected
73 RUN INSERT INTO t_int VALUES (1, 4294967294)
74
75 1 rows affected
76 RUN INSERT INTO t_int VALUES (2147483647, 4294967295)
77
78 1 rows affected
79 RUN CREATE TABLE t_integer (c1 INTEGER, c2 INTEGER UNSIGNED)
80
81 0 rows affected
82 RUN INSERT INTO t_integer VALUES (-2147483648, 0)
83
84 1 rows affected
85 RUN INSERT INTO t_integer VALUES (-1, 1)
86
87 1 rows affected
88 RUN INSERT INTO t_integer VALUES (0, 2147483647)
89
90 1 rows affected
91 RUN INSERT INTO t_integer VALUES (1, 4294967294)
92
93 1 rows affected
94 RUN INSERT INTO t_integer VALUES (2147483647, 4294967295)
95
96 1 rows affected
97 RUN CREATE TABLE t_bigint (c1 BIGINT, c2 BIGINT UNSIGNED)
98
99 0 rows affected
100 RUN INSERT INTO t_bigint VALUES (-9223372036854775808, 0)
101
102 1 rows affected
103 RUN INSERT INTO t_bigint VALUES (-1, 1)
104
105 1 rows affected
106 RUN INSERT INTO t_bigint VALUES (0, 9223372036854775807)
107
108 1 rows affected
109 RUN INSERT INTO t_bigint VALUES (1, 18446744073709551614)
110
111 1 rows affected
112 RUN INSERT INTO t_bigint VALUES (9223372036854775807, 18446744073709551615)
113
114 1 rows affected
115 RUN SELECT * FROM t_tinyint
116 c1 c2
117 -128 0
118 -1 1
119 0 127
120 1 200
121 127 255
122 0 rows affected
123 RUN SELECT * FROM t_smallint
124 c1 c2
125 -32768 0
126 -1 1
127 0 32767
128 1 65534
129 32767 65535
130 0 rows affected
131 RUN SELECT * FROM t_mediumint
132 c1 c2
133 -8388608 0
134 -1 1
135 0 8388607
136 1 16777214
137 8388607 16777215
138 0 rows affected
139 RUN SELECT * FROM t_int
140 c1 c2
141 -2147483648 0
142 -1 1
143 0 2147483647
144 1 4294967294
145 2147483647 4294967295
146 0 rows affected
147 RUN SELECT * FROM t_bigint
148 c1 c2
149 -9223372036854775808 0
150 -1 1
151 0 9223372036854775807
152 1 18446744073709551614
153 9223372036854775807 18446744073709551615
154 0 rows affected
155 RUN CREATE TABLE t_decimal1 (c1 DECIMAL(2,1), c2 DECIMAL(2,1) UNSIGNED)
156
157 0 rows affected
158 RUN INSERT INTO t_decimal1 VALUES (-1.1, 0.0)
159
160 1 rows affected
161 RUN INSERT INTO t_decimal1 VALUES (-9.9, 9.8)
162
163 1 rows affected
164 RUN INSERT INTO t_decimal1 VALUES (9.9, 9.9)
165
166 1 rows affected
167 RUN CREATE TABLE t_decimal2 (c1 DECIMAL(64,30), c2 DECIMAL(64,30) UNSIGNED)
168
169 0 rows affected
170 RUN INSERT INTO t_decimal2 VALUES (-1234567890123456789012345678901234.567890123456789012345678901234, 1234567890123456789012345678901234.567890123456789012345678901234)
171
172 1 rows affected
173 RUN INSERT INTO t_decimal2 VALUES (9234567890123456789012345678901234.567890123456789012345678901234, 9234567890123456789012345678901234.567890123456789012345678901234)
174
175 1 rows affected
176 RUN INSERT INTO t_decimal2 VALUES (0, 0)
177
178 1 rows affected
179 RUN CREATE TABLE t_numeric1 (c1 NUMERIC(2,1), c2 NUMERIC(2,1) UNSIGNED)
180
181 0 rows affected
182 RUN INSERT INTO t_numeric1 VALUES (-1.1, 0.0)
183
184 1 rows affected
185 RUN INSERT INTO t_numeric1 VALUES (-9.9, 9.8)
186
187 1 rows affected
188 RUN INSERT INTO t_numeric1 VALUES (9.9, 9.9)
189
190 1 rows affected
191 RUN CREATE TABLE t_numeric2 (c1 NUMERIC(64,30), c2 NUMERIC(64,30) UNSIGNED)
192
193 0 rows affected
194 RUN INSERT INTO t_numeric2 VALUES (-1234567890123456789012345678901234.567890123456789012345678901234, 1234567890123456789012345678901234.567890123456789012345678901234)
195
196 1 rows affected
197 RUN INSERT INTO t_numeric2 VALUES (9234567890123456789012345678901234.567890123456789012345678901234, 9234567890123456789012345678901234.567890123456789012345678901234)
198
199 1 rows affected
200 RUN INSERT INTO t_numeric2 VALUES (0, 0)
201
202 1 rows affected
203 RUN SELECT * FROM t_decimal1
204 c1 c2
205 -1.1 0.0
206 -9.9 9.8
207 9.9 9.9
208 0 rows affected
209 RUN SELECT * FROM t_decimal2
210 c1 c2
211 -1234567890123456789012345678901234.567890123456789012345678901234 1234567890123456789012345678901234.567890123456789012345678901234
212 9234567890123456789012345678901234.567890123456789012345678901234 9234567890123456789012345678901234.567890123456789012345678901234
213 0.000000000000000000000000000000 0.000000000000000000000000000000
214 0 rows affected
215 RUN SELECT * FROM t_numeric1
216 c1 c2
217 -1.1 0.0
218 -9.9 9.8
219 9.9 9.9
220 0 rows affected
221 RUN SELECT * FROM t_numeric2
222 c1 c2
223 -1234567890123456789012345678901234.567890123456789012345678901234 1234567890123456789012345678901234.567890123456789012345678901234
224 9234567890123456789012345678901234.567890123456789012345678901234 9234567890123456789012345678901234.567890123456789012345678901234
225 0.000000000000000000000000000000 0.000000000000000000000000000000
226 0 rows affected
227 RUN CREATE TABLE t_real (c1 REAL, c2 REAL UNSIGNED)
228
229 0 rows affected
230 RUN INSERT INTO t_real VALUES (-1220.001, 0)
231
232 1 rows affected
233 RUN INSERT INTO t_real VALUES (-1.01, 1.201)
234
235 1 rows affected
236 RUN INSERT INTO t_real VALUES (1235.67, 11235.67)
237
238 1 rows affected
239 RUN CREATE TABLE t_float (c1 FLOAT, c2 FLOAT UNSIGNED)
240
241 0 rows affected
242 RUN INSERT INTO t_float VALUES (-1220223.00221, 0.0001)
243
244 1 rows affected
245 RUN INSERT INTO t_float VALUES (-1.02323, 1.2333)
246
247 1 rows affected
248 RUN INSERT INTO t_float VALUES (123522.67, 112352.67)
249
250 1 rows affected
251 RUN CREATE TABLE t_double (c1 DOUBLE, c2 DOUBLE UNSIGNED)
252
253 0 rows affected
254 RUN INSERT INTO t_double VALUES (-122022323.0230221, 2320.0012301)
255
256 1 rows affected
257 RUN INSERT INTO t_double VALUES (-1.232023231, 1231231231.23331231)
258
259 1 rows affected
260 RUN INSERT INTO t_double VALUES (1235212322.6123123, 11235212312322.671)
261
262 1 rows affected
263 RUN SELECT * FROM t_real
264 c1 c2
265 -1220.001 0
266 -1.01 1.201
267 1235.67 11235.67
268 0 rows affected
269 RUN SELECT * FROM t_float
270 c1 c2
271 -1220220 0.0001
272 -1.02323 1.2333
273 123523 112353
274 0 rows affected
275 RUN SELECT * FROM t_double
276 c1 c2
277 -122022323.0230221 2320.0012301
278 -1.232023231 1231231231.2333124
279 1235212322.6123123 11235212312322.672
280 0 rows affected
281 RUN CREATE TABLE t_date (c1 DATE, c2 TIME, c3 TIMESTAMP, c4 DATETIME, c5 DATETIME(6), c6 YEAR)
282
283 0 rows affected
284 RUN INSERT INTO t_date VALUES ('2015-07-23', '16:34:12', '2015-07-23 16:34:12', '2015-07-23 16:34:12', '2015-07-23 16:34:12.0001234', '2015')
285
286 1 rows affected
287 RUN INSERT INTO t_date VALUES ('0-1-1', '-1:0:0.12', '2000-1-1 0:0:2', '0-1-1', '0-1-1', '1999')
288
289 1 rows affected
290 RUN SELECT * FROM t_date
291 c1 c2 c3 c4 c5 c6
292 2015-07-23 16:34:12 2015-07-23 16:34:12 2015-07-23 16:34:12 2015-07-23 16:34:12.000123 2015
293 0000-01-01 -01:00:00 2000-01-01 00:00:02 0000-01-01 00:00:00 0000-01-01 00:00:00 1999
294 0 rows affected
295 RUN CREATE TABLE t_lob (c1 TINYBLOB,
296 c2 BLOB,
297 c3 MEDIUMBLOB,
298 c4 LONGBLOB,
299 c5 TINYTEXT,
300 c6 TEXT,
301 c7 MEDIUMTEXT,
302 c8 LONGTEXT,
303 c9 TINYTEXT BINARY,
304 c10 TEXT BINARY,
305 c11 MEDIUMTEXT BINARY,
306 c12 LONGTEXT BINARY)
307
308 0 rows affected
309 RUN INSERT INTO t_lob VALUES ('','','','','','','','','','','','')
310
311 1 rows affected
312 RUN INSERT INTO t_lob VALUES ('tinyblob-text readable','blob-text readable','mediumblob-text readable',
313 'longblob-text readable','tinytext','text','mediumtext','longtext',
314 'tinytext-binary\nnext line','text-binary\nnext line',
315 'mediumtext-binary\nnext line','longtext-binary \nnext line')
316
317 1 rows affected
318 RUN SELECT * FROM t_lob
319 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12
320
321 tinyblob-text readable blob-text readable mediumblob-text readable longblob-text readable tinytext text mediumtext longtext tinytext-binary
322 next line text-binary
323 next line mediumtext-binary
324 next line longtext-binary
325 next line
326 0 rows affected
327 RUN CREATE TABLE t_bit (c1 BIT(1), c2 BIT(64))
328
329 0 rows affected
330 RUN INSERT INTO t_bit VALUES (b'0', b'0')
331
332 1 rows affected
333 RUN INSERT INTO t_bit VALUES (b'1', b'1')
334
335 1 rows affected
336 RUN INSERT INTO t_bit VALUES (b'1', b'1111111111111111111111111111111111111111111111111111111111111111')
337
338 1 rows affected
339 RUN CREATE TABLE t_enum (c1 ENUM('v1','v2','v3'), c2 ENUM(''))
340
341 0 rows affected
342 RUN INSERT INTO t_enum VALUES ('v1', '')
343
344 1 rows affected
345 RUN INSERT INTO t_enum VALUES ('v2', '')
346
347 1 rows affected
348 RUN CREATE TABLE t_set (c1 SET('v1','v2','v3'), c2 SET(''))
349
350 0 rows affected
351 RUN INSERT INTO t_set VALUES ('v1,v1,v2', '')
352
353 1 rows affected
354 RUN INSERT INTO t_set VALUES ('', '')
355
356 1 rows affected
357 RUN SELECT * FROM t_bit
358 c1 c2
359 0 0
360 1 1
361 1 18446744073709551615
362 0 rows affected
363 RUN SELECT * FROM t_enum
364 c1 c2
365 v1
366 v2
367 0 rows affected
368 RUN SELECT * FROM t_set
369 c1 c2
370 v1,v2
371
372 0 rows affected
373 RUN drop schema if exists xtest
374
375 18 rows affected
376 Mysqlx.Ok {
377 msg: "bye!"
378 }
379 ok