1
DROP TABLE IF EXISTS t1_selects, t1_modes, t1_values;
2
DROP VIEW IF EXISTS v1;
5
id BIGINT AUTO_INCREMENT,
8
) ENGINE = <engine_to_be_tested>;
9
ALTER TABLE t1_values ADD my_char_30 CHAR(30);
11
Warning 1478 Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
12
ALTER TABLE t1_values ADD my_varchar_1000 VARCHAR(1000);
14
Warning 1478 Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
15
ALTER TABLE t1_values ADD my_binary_30 BINARY(30);
17
Warning 1478 Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
18
ALTER TABLE t1_values ADD my_varbinary_1000 VARBINARY(1000);
20
Warning 1478 Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
21
ALTER TABLE t1_values ADD my_datetime DATETIME;
23
Warning 1478 Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
24
ALTER TABLE t1_values ADD my_date DATE;
26
Warning 1478 Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
27
ALTER TABLE t1_values ADD ts_dummy TIMESTAMP;
28
ALTER TABLE t1_values ADD my_timestamp TIMESTAMP;
29
ALTER TABLE t1_values ADD my_time TIME;
31
Warning 1478 Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
32
ALTER TABLE t1_values ADD my_year YEAR;
34
Warning 1478 Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
35
ALTER TABLE t1_values ADD my_bigint BIGINT;
37
Warning 1478 Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
38
ALTER TABLE t1_values ADD my_double DOUBLE;
40
Warning 1478 Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
41
ALTER TABLE t1_values ADD my_decimal DECIMAL(64,30);
43
Warning 1478 Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
44
SET sql_mode = 'traditional';
45
INSERT INTO t1_values SET id = 0;
46
INSERT INTO t1_values SET
50
my_varbinary_1000 = '',
51
my_datetime = '0001-01-01 00:00:00',
52
my_date = '0001-01-01',
53
my_timestamp = '1970-01-01 03:00:01',
54
my_time = '-838:59:59',
56
my_bigint = -9223372036854775808,
57
my_decimal = -9999999999999999999999999999999999.999999999999999999999999999999 ,
58
my_double = -1.7976931348623E+308;
59
INSERT INTO t1_values SET
60
my_char_30 = '<--------30 characters------->',
61
my_varchar_1000 = CONCAT('<---------1000 characters',
62
RPAD('',965,'-'),'--------->'),
63
my_binary_30 = '<--------30 characters------->',
64
my_varbinary_1000 = CONCAT('<---------1000 characters',
65
RPAD('',965,'-'),'--------->'),
66
my_datetime = '9999-12-31 23:59:59',
67
my_date = '9999-12-31',
68
my_timestamp = '2038-01-01 02:59:59',
69
my_time = '838:59:59',
71
my_bigint = 9223372036854775807,
72
my_decimal = +9999999999999999999999999999999999.999999999999999999999999999999 ,
73
my_double = 1.7976931348623E+308;
74
INSERT INTO t1_values SET
75
my_char_30 = ' ---äÖüß@µ*$-- ',
76
my_varchar_1000 = ' ---äÖüß@µ*$-- ',
77
my_binary_30 = ' ---äÖüß@µ*$-- ',
78
my_varbinary_1000 = ' ---äÖüß@µ*$-- ',
79
my_datetime = '2004-02-29 23:59:59',
80
my_date = '2004-02-29',
81
my_timestamp = '2004-02-29 23:59:59',
87
INSERT INTO t1_values SET
89
my_varchar_1000 = '-1',
91
my_varbinary_1000 = '-1',
92
my_datetime = '2005-06-28 10:00:00',
93
my_date = '2005-06-28',
94
my_timestamp = '2005-06-28 10:00:00',
98
my_decimal = -1.000000000000000000000000000000,
100
PREPARE ins_sel_with_result FROM "INSERT INTO t1_selects SET my_select = @my_select,
101
disable_result = 'No'" ;
102
PREPARE ins_sel_no_result FROM "INSERT INTO t1_selects SET my_select = @my_select,
103
disable_result = 'Yes'" ;
104
SET sql_mode = 'traditional';
105
SET @my_select = 'SELECT sqrt(my_bigint), my_bigint, id FROM t1_values';
106
INSERT INTO t1_values SET select_id = @select_id,
108
INSERT INTO t1_values SET select_id = @select_id,
110
##### 1.1.1. CAST --> BINARY
111
##### 1.1.2. CAST --> CHAR
112
##### 1.1.3. CAST --> DATE
113
INSERT INTO t1_values SET select_id = @select_id,
114
my_char_30 = '2005-06-27';
115
INSERT INTO t1_values SET select_id = @select_id,
116
my_varchar_1000 = '2005-06-27';
117
INSERT INTO t1_values SET select_id = @select_id,
118
my_binary_30 = '2005-06-27';
119
INSERT INTO t1_values SET select_id = @select_id,
120
my_varbinary_1000 = '2005-06-27';
121
INSERT INTO t1_values SET select_id = @select_id,
122
my_bigint = 20050627;
123
INSERT INTO t1_values SET select_id = @select_id,
124
my_double = +20.050627E+6;
125
##### 1.1.4. CAST --> DATETIME
126
INSERT INTO t1_values SET select_id = @select_id,
127
my_char_30 = '2005-06-27 17:58';
128
INSERT INTO t1_values SET select_id = @select_id,
129
my_varchar_1000 = '2005-06-27 17:58';
130
INSERT INTO t1_values SET select_id = @select_id,
131
my_binary_30 = '2005-06-27 17:58';
132
INSERT INTO t1_values SET select_id = @select_id,
133
my_varbinary_1000 = '2005-06-27 17:58';
134
INSERT INTO t1_values SET select_id = @select_id,
135
my_bigint = 200506271758;
136
INSERT INTO t1_values SET select_id = @select_id,
137
my_double = +0.0200506271758E+13;
138
##### 1.1.5. CAST --> TIME
139
INSERT INTO t1_values SET select_id = @select_id,
140
my_char_30 = '1 17:58';
141
INSERT INTO t1_values SET select_id = @select_id,
142
my_varchar_1000 = '1 17:58';
143
INSERT INTO t1_values SET select_id = @select_id,
144
my_binary_30 = '1 17:58';
145
INSERT INTO t1_values SET select_id = @select_id,
146
my_varbinary_1000 = '1 17:58';
147
INSERT INTO t1_values SET select_id = @select_id,
149
INSERT INTO t1_values SET select_id = @select_id,
150
my_double = +1.758E+3;
151
##### 1.1.6. CAST --> DECIMAL
152
INSERT INTO t1_values SET select_id = @select_id,
153
my_char_30 = '-3333.3333';
154
INSERT INTO t1_values SET select_id = @select_id,
155
my_varchar_1000 = '-3333.3333';
156
INSERT INTO t1_values SET select_id = @select_id,
157
my_binary_30 = '-3333.3333';
158
INSERT INTO t1_values SET select_id = @select_id,
159
my_varbinary_1000 = '-3333.3333';
160
INSERT INTO t1_values SET select_id = @select_id,
161
my_double = -0.33333333E+4;
162
##### 1.1.7. CAST --> SIGNED INTEGER
164
"Attention: CAST --> SIGNED INTEGER
165
Bug#5913 Traditional mode: BIGINT range not correctly delimited
166
Status: To be fixed later"
167
--------------------------------------------------------------------------------
168
##### 1.1.8. CAST --> UNSIGNED INTEGER
170
"Attention: CAST --> UNSIGNED INTEGER
171
The file with expected results suffers from Bug 5913"
172
--------------------------------------------------------------------------------
174
some statements disabled because of
175
Bug#5913 Traditional mode: BIGINT range not correctly delimited
176
--------------------------------------------------------------------------------
177
SET @my_select = 'SELECT CONVERT(my_char_30 USING utf8),
178
my_char_30, id FROM t1_values';
179
SET @my_select = 'SELECT CONVERT(my_varchar_1000 USING utf8),
180
my_varchar_1000, id FROM t1_values';
181
SET @my_select = 'SELECT CONVERT(my_binary_30 USING utf8),
182
my_binary_30, id FROM t1_values';
183
SET @my_select = 'SELECT CONVERT(my_varbinary_1000 USING utf8),
184
my_varbinary_1000, id FROM t1_values';
185
SET @my_select = 'SELECT CONVERT(my_char_30 USING koi8r),
186
my_char_30, id FROM t1_values';
187
SET @my_select = 'SELECT CONVERT(my_varchar_1000 USING koi8r),
188
my_varchar_1000, id FROM t1_values';
189
SET @my_select = 'SELECT CONVERT(my_binary_30 USING koi8r),
190
my_binary_30, id FROM t1_values';
191
SET @my_select = 'SELECT CONVERT(my_varbinary_1000 USING koi8r),
192
my_varbinary_1000, id FROM t1_values';
193
SET @my_select = 'SELECT BIT_LENGTH(my_char_30),
194
my_char_30, id FROM t1_values';
195
SET @my_select = 'SELECT BIT_LENGTH(my_varchar_1000),
196
my_varchar_1000, id FROM t1_values';
197
SET @my_select = 'SELECT BIT_LENGTH(my_binary_30),
198
my_binary_30, id FROM t1_values';
199
SET @my_select = 'SELECT BIT_LENGTH(my_varbinary_1000),
200
my_varbinary_1000, id FROM t1_values';
201
SET @my_select = 'SELECT INSTR(my_char_30, ''char''),
202
my_char_30, id FROM t1_values';
203
SET @my_select = 'SELECT LCASE(my_varchar_1000),
204
my_varchar_1000, id FROM t1_values';
206
'SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values';
208
'SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values';
210
'SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values';
212
'SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values';
214
'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_bigint), my_bigint, id FROM t1_values';
216
'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_decimal), my_decimal, id FROM t1_values';
218
'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_double), my_double, id FROM t1_values';
219
SET @my_select = 'SELECT LENGTH(my_char_30),
220
my_char_30, id FROM t1_values';
221
SET @my_select = 'SELECT LENGTH(my_varchar_1000),
222
my_varchar_1000, id FROM t1_values';
223
SET @my_select = 'SELECT LENGTH(my_binary_30),
224
my_binary_30, id FROM t1_values';
225
SET @my_select = 'SELECT LENGTH(my_varbinary_1000),
226
my_varbinary_1000, id FROM t1_values';
227
SELECT 'äÄ@' INTO OUTFILE '../tmp/func_view.dat';
229
'SELECT LOAD_FILE(''../tmp/func_view.dat''), id FROM t1_values';
230
SET @my_select = 'SELECT LOCATE(''char'', my_char_30),
231
my_char_30, id FROM t1_values';
232
SET @my_select = 'SELECT LOCATE(''char'', my_varchar_1000),
233
my_varchar_1000, id FROM t1_values';
234
SET @my_select = 'SELECT LOCATE(''char'', my_binary_30),
235
my_binary_30, id FROM t1_values';
236
SET @my_select = 'SELECT LOCATE(''char'', my_varbinary_1000),
237
my_varbinary_1000, id FROM t1_values';
238
SET @my_select = 'SELECT LOCATE(my_char_30, my_char_30 ),
239
my_char_30, id FROM t1_values';
240
SET @my_select = 'SELECT LOCATE(my_char_30, my_varchar_1000 ),
241
my_char_30, my_varchar_1000 id FROM t1_values';
242
SET @my_select = 'SELECT LOCATE(my_char_30, my_binary_30 ),
243
my_char_30, my_binary_30 id FROM t1_values';
244
SET @my_select = 'SELECT LOCATE(my_char_30, my_varbinary_1000 ),
245
my_char_30, my_varbinary_1000 id FROM t1_values';
246
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
247
my_varchar_1000, id FROM t1_values';
248
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_char_30 ),
249
my_varchar_1000, my_char_30 id FROM t1_values';
250
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_binary_30 ),
251
my_varchar_1000, my_binary_30 id FROM t1_values';
252
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
253
my_varchar_1000, my_varbinary_1000 id FROM t1_values';
254
SET @my_select = 'SELECT LOCATE(my_binary_30, my_binary_30 ),
255
my_binary_30, id FROM t1_values';
256
SET @my_select = 'SELECT LOCATE(my_binary_30, my_char_30 ),
257
my_binary_30, my_char_30 id FROM t1_values';
258
SET @my_select = 'SELECT LOCATE(my_binary_30, my_varchar_1000 ),
259
my_binary_30, my_varchar_1000 id FROM t1_values';
260
SET @my_select = 'SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
261
my_binary_30, my_varbinary_1000 id FROM t1_values';
262
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
263
my_varbinary_1000, id FROM t1_values';
264
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_char_30 ),
265
my_varbinary_1000, my_char_30 id FROM t1_values';
266
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
267
my_varbinary_1000, my_varchar_1000 id FROM t1_values';
268
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
269
my_varbinary_1000, my_binary_30 id FROM t1_values';
270
SET @my_select = 'SELECT LOCATE(''-'', my_char_30, 3),
271
my_char_30, id FROM t1_values';
272
SET @my_select = 'SELECT LOCATE(''-'', my_varchar_1000, 3),
273
my_varchar_1000, id FROM t1_values';
274
SET @my_select = 'SELECT LOCATE(''-'', my_binary_30, 3),
275
my_binary_30, id FROM t1_values';
276
SET @my_select = 'SELECT LOCATE(''-'', my_varbinary_1000, 3),
277
my_varbinary_1000, id FROM t1_values';
278
SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_bigint),
279
my_bigint, id FROM t1_values';
280
SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_double),
281
my_double, id FROM t1_values';
282
SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_decimal),
283
my_decimal, id FROM t1_values';
284
SET @my_select = 'SELECT LOWER(my_char_30),
285
my_char_30, id FROM t1_values';
286
SET @my_select = 'SELECT LOWER(my_varchar_1000),
287
my_varchar_1000, id FROM t1_values';
288
SET @my_select = 'SELECT LOWER(my_binary_30),
289
my_binary_30, id FROM t1_values';
290
SET @my_select = 'SELECT LOWER(my_varbinary_1000),
291
my_varbinary_1000, id FROM t1_values';
292
SET @my_select = 'SELECT LTRIM(my_char_30),
293
my_char_30, id FROM t1_values';
294
SET @my_select = 'SELECT LTRIM(my_varchar_1000),
295
my_varchar_1000, id FROM t1_values';
296
SET @my_select = 'SELECT LTRIM(my_binary_30),
297
my_binary_30, id FROM t1_values';
298
SET @my_select = 'SELECT LTRIM(my_varbinary_1000),
299
my_varbinary_1000, id FROM t1_values';
301
'SELECT CONCAT(''A'',my_char_30), my_char_30, id FROM t1_values';
302
SET @my_select = 'SELECT my_char_30, id FROM t1_values';
303
INSERT INTO t1_values SET select_id = @select_id,
304
my_char_30 = 'Viana do Castelo';
307
"# The basic preparations end and the main test starts here"
308
--------------------------------------------------------------------------------
309
CREATE VIEW v1 AS SELECT my_char_30, id FROM t1_values;
310
SELECT my_char_30, id FROM t1_values
311
WHERE select_id = 193 OR select_id IS NULL order by id;
313
View Create View character_set_client collation_connection
314
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
316
WHERE v1.id IN (SELECT id FROM t1_values
317
WHERE select_id = 193 OR select_id IS NULL) order by id;
321
CREATE VIEW v1 AS SELECT CONCAT('A',my_char_30), my_char_30, id FROM t1_values;
322
SELECT CONCAT('A',my_char_30), my_char_30, id FROM t1_values
323
WHERE select_id = 192 OR select_id IS NULL order by id;
324
CONCAT('A',my_char_30) my_char_30 id
327
A<--------30 characters-------> <--------30 characters-------> 3
328
A ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
331
View Create View character_set_client collation_connection
332
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select concat('A',`t1_values`.`my_char_30`) AS `CONCAT('A',my_char_30)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
334
WHERE v1.id IN (SELECT id FROM t1_values
335
WHERE select_id = 192 OR select_id IS NULL) order by id;
336
CONCAT('A',my_char_30) my_char_30 id
339
A<--------30 characters-------> <--------30 characters-------> 3
340
A ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
345
CREATE VIEW v1 AS SELECT LTRIM(my_varbinary_1000),
346
my_varbinary_1000, id FROM t1_values;
347
SELECT LTRIM(my_varbinary_1000),
348
my_varbinary_1000, id FROM t1_values
349
WHERE select_id = 191 OR select_id IS NULL order by id;
351
View Create View character_set_client collation_connection
352
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ltrim(`t1_values`.`my_varbinary_1000`) AS `LTRIM(my_varbinary_1000)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
354
WHERE v1.id IN (SELECT id FROM t1_values
355
WHERE select_id = 191 OR select_id IS NULL) order by id;
359
CREATE VIEW v1 AS SELECT LTRIM(my_binary_30),
360
my_binary_30, id FROM t1_values;
361
SELECT LTRIM(my_binary_30),
362
my_binary_30, id FROM t1_values
363
WHERE select_id = 190 OR select_id IS NULL order by id;
365
View Create View character_set_client collation_connection
366
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ltrim(`t1_values`.`my_binary_30`) AS `LTRIM(my_binary_30)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
368
WHERE v1.id IN (SELECT id FROM t1_values
369
WHERE select_id = 190 OR select_id IS NULL) order by id;
373
CREATE VIEW v1 AS SELECT LTRIM(my_varchar_1000),
374
my_varchar_1000, id FROM t1_values;
375
SELECT LTRIM(my_varchar_1000),
376
my_varchar_1000, id FROM t1_values
377
WHERE select_id = 189 OR select_id IS NULL order by id;
379
View Create View character_set_client collation_connection
380
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ltrim(`t1_values`.`my_varchar_1000`) AS `LTRIM(my_varchar_1000)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
382
WHERE v1.id IN (SELECT id FROM t1_values
383
WHERE select_id = 189 OR select_id IS NULL) order by id;
387
CREATE VIEW v1 AS SELECT LTRIM(my_char_30),
388
my_char_30, id FROM t1_values;
389
SELECT LTRIM(my_char_30),
390
my_char_30, id FROM t1_values
391
WHERE select_id = 188 OR select_id IS NULL order by id;
393
View Create View character_set_client collation_connection
394
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ltrim(`t1_values`.`my_char_30`) AS `LTRIM(my_char_30)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
396
WHERE v1.id IN (SELECT id FROM t1_values
397
WHERE select_id = 188 OR select_id IS NULL) order by id;
401
CREATE VIEW v1 AS SELECT LOWER(my_varbinary_1000),
402
my_varbinary_1000, id FROM t1_values;
403
SELECT LOWER(my_varbinary_1000),
404
my_varbinary_1000, id FROM t1_values
405
WHERE select_id = 187 OR select_id IS NULL order by id;
407
View Create View character_set_client collation_connection
408
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select lcase(`t1_values`.`my_varbinary_1000`) AS `LOWER(my_varbinary_1000)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
410
WHERE v1.id IN (SELECT id FROM t1_values
411
WHERE select_id = 187 OR select_id IS NULL) order by id;
415
CREATE VIEW v1 AS SELECT LOWER(my_binary_30),
416
my_binary_30, id FROM t1_values;
417
SELECT LOWER(my_binary_30),
418
my_binary_30, id FROM t1_values
419
WHERE select_id = 186 OR select_id IS NULL order by id;
421
View Create View character_set_client collation_connection
422
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select lcase(`t1_values`.`my_binary_30`) AS `LOWER(my_binary_30)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
424
WHERE v1.id IN (SELECT id FROM t1_values
425
WHERE select_id = 186 OR select_id IS NULL) order by id;
429
CREATE VIEW v1 AS SELECT LOWER(my_varchar_1000),
430
my_varchar_1000, id FROM t1_values;
431
SELECT LOWER(my_varchar_1000),
432
my_varchar_1000, id FROM t1_values
433
WHERE select_id = 185 OR select_id IS NULL order by id;
435
View Create View character_set_client collation_connection
436
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select lcase(`t1_values`.`my_varchar_1000`) AS `LOWER(my_varchar_1000)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
438
WHERE v1.id IN (SELECT id FROM t1_values
439
WHERE select_id = 185 OR select_id IS NULL) order by id;
443
CREATE VIEW v1 AS SELECT LOWER(my_char_30),
444
my_char_30, id FROM t1_values;
445
SELECT LOWER(my_char_30),
446
my_char_30, id FROM t1_values
447
WHERE select_id = 184 OR select_id IS NULL order by id;
449
View Create View character_set_client collation_connection
450
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select lcase(`t1_values`.`my_char_30`) AS `LOWER(my_char_30)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
452
WHERE v1.id IN (SELECT id FROM t1_values
453
WHERE select_id = 184 OR select_id IS NULL) order by id;
457
CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_decimal),
458
my_decimal, id FROM t1_values;
459
SELECT LOCATE('-', ' - -ABC', my_decimal),
460
my_decimal, id FROM t1_values
461
WHERE select_id = 183 OR select_id IS NULL order by id;
463
View Create View character_set_client collation_connection
464
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate('-',' - -ABC',`t1_values`.`my_decimal`) AS `LOCATE('-', ' - -ABC', my_decimal)`,`t1_values`.`my_decimal` AS `my_decimal`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
466
WHERE v1.id IN (SELECT id FROM t1_values
467
WHERE select_id = 183 OR select_id IS NULL) order by id;
471
CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_double),
472
my_double, id FROM t1_values;
473
SELECT LOCATE('-', ' - -ABC', my_double),
474
my_double, id FROM t1_values
475
WHERE select_id = 182 OR select_id IS NULL order by id;
477
View Create View character_set_client collation_connection
478
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate('-',' - -ABC',`t1_values`.`my_double`) AS `LOCATE('-', ' - -ABC', my_double)`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
480
WHERE v1.id IN (SELECT id FROM t1_values
481
WHERE select_id = 182 OR select_id IS NULL) order by id;
485
CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_bigint),
486
my_bigint, id FROM t1_values;
487
SELECT LOCATE('-', ' - -ABC', my_bigint),
488
my_bigint, id FROM t1_values
489
WHERE select_id = 181 OR select_id IS NULL order by id;
491
View Create View character_set_client collation_connection
492
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate('-',' - -ABC',`t1_values`.`my_bigint`) AS `LOCATE('-', ' - -ABC', my_bigint)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
494
WHERE v1.id IN (SELECT id FROM t1_values
495
WHERE select_id = 181 OR select_id IS NULL) order by id;
499
CREATE VIEW v1 AS SELECT LOCATE('-', my_varbinary_1000, 3),
500
my_varbinary_1000, id FROM t1_values;
501
SELECT LOCATE('-', my_varbinary_1000, 3),
502
my_varbinary_1000, id FROM t1_values
503
WHERE select_id = 180 OR select_id IS NULL order by id;
505
View Create View character_set_client collation_connection
506
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate('-',`t1_values`.`my_varbinary_1000`,3) AS `LOCATE('-', my_varbinary_1000, 3)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
508
WHERE v1.id IN (SELECT id FROM t1_values
509
WHERE select_id = 180 OR select_id IS NULL) order by id;
513
CREATE VIEW v1 AS SELECT LOCATE('-', my_binary_30, 3),
514
my_binary_30, id FROM t1_values;
515
SELECT LOCATE('-', my_binary_30, 3),
516
my_binary_30, id FROM t1_values
517
WHERE select_id = 179 OR select_id IS NULL order by id;
519
View Create View character_set_client collation_connection
520
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate('-',`t1_values`.`my_binary_30`,3) AS `LOCATE('-', my_binary_30, 3)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
522
WHERE v1.id IN (SELECT id FROM t1_values
523
WHERE select_id = 179 OR select_id IS NULL) order by id;
527
CREATE VIEW v1 AS SELECT LOCATE('-', my_varchar_1000, 3),
528
my_varchar_1000, id FROM t1_values;
529
SELECT LOCATE('-', my_varchar_1000, 3),
530
my_varchar_1000, id FROM t1_values
531
WHERE select_id = 178 OR select_id IS NULL order by id;
533
View Create View character_set_client collation_connection
534
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate('-',`t1_values`.`my_varchar_1000`,3) AS `LOCATE('-', my_varchar_1000, 3)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
536
WHERE v1.id IN (SELECT id FROM t1_values
537
WHERE select_id = 178 OR select_id IS NULL) order by id;
541
CREATE VIEW v1 AS SELECT LOCATE('-', my_char_30, 3),
542
my_char_30, id FROM t1_values;
543
SELECT LOCATE('-', my_char_30, 3),
544
my_char_30, id FROM t1_values
545
WHERE select_id = 177 OR select_id IS NULL order by id;
547
View Create View character_set_client collation_connection
548
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate('-',`t1_values`.`my_char_30`,3) AS `LOCATE('-', my_char_30, 3)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
550
WHERE v1.id IN (SELECT id FROM t1_values
551
WHERE select_id = 177 OR select_id IS NULL) order by id;
555
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
556
my_varbinary_1000, my_binary_30 id FROM t1_values;
557
SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
558
my_varbinary_1000, my_binary_30 id FROM t1_values
559
WHERE select_id = 176 OR select_id IS NULL order by id;
561
View Create View character_set_client collation_connection
562
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_varbinary_1000`,`t1_values`.`my_binary_30`) AS `LOCATE(my_varbinary_1000, my_binary_30 )`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`my_binary_30` AS `id` from `t1_values` latin1 latin1_swedish_ci
564
WHERE v1.id IN (SELECT id FROM t1_values
565
WHERE select_id = 176 OR select_id IS NULL) order by id;
569
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
570
my_varbinary_1000, my_varchar_1000 id FROM t1_values;
571
SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
572
my_varbinary_1000, my_varchar_1000 id FROM t1_values
573
WHERE select_id = 175 OR select_id IS NULL order by id;
575
View Create View character_set_client collation_connection
576
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_varbinary_1000`,`t1_values`.`my_varchar_1000`) AS `LOCATE(my_varbinary_1000, my_varchar_1000 )`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`my_varchar_1000` AS `id` from `t1_values` latin1 latin1_swedish_ci
578
WHERE v1.id IN (SELECT id FROM t1_values
579
WHERE select_id = 175 OR select_id IS NULL) order by id;
583
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_char_30 ),
584
my_varbinary_1000, my_char_30 id FROM t1_values;
585
SELECT LOCATE(my_varbinary_1000, my_char_30 ),
586
my_varbinary_1000, my_char_30 id FROM t1_values
587
WHERE select_id = 174 OR select_id IS NULL order by id;
589
View Create View character_set_client collation_connection
590
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_varbinary_1000`,`t1_values`.`my_char_30`) AS `LOCATE(my_varbinary_1000, my_char_30 )`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`my_char_30` AS `id` from `t1_values` latin1 latin1_swedish_ci
592
WHERE v1.id IN (SELECT id FROM t1_values
593
WHERE select_id = 174 OR select_id IS NULL) order by id;
597
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
598
my_varbinary_1000, id FROM t1_values;
599
SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
600
my_varbinary_1000, id FROM t1_values
601
WHERE select_id = 173 OR select_id IS NULL order by id;
603
View Create View character_set_client collation_connection
604
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_varbinary_1000`,`t1_values`.`my_varbinary_1000`) AS `LOCATE(my_varbinary_1000, my_varbinary_1000 )`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
606
WHERE v1.id IN (SELECT id FROM t1_values
607
WHERE select_id = 173 OR select_id IS NULL) order by id;
611
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
612
my_binary_30, my_varbinary_1000 id FROM t1_values;
613
SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
614
my_binary_30, my_varbinary_1000 id FROM t1_values
615
WHERE select_id = 172 OR select_id IS NULL order by id;
617
View Create View character_set_client collation_connection
618
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_binary_30`,`t1_values`.`my_varbinary_1000`) AS `LOCATE(my_binary_30, my_varbinary_1000 )`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`my_varbinary_1000` AS `id` from `t1_values` latin1 latin1_swedish_ci
620
WHERE v1.id IN (SELECT id FROM t1_values
621
WHERE select_id = 172 OR select_id IS NULL) order by id;
625
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_varchar_1000 ),
626
my_binary_30, my_varchar_1000 id FROM t1_values;
627
SELECT LOCATE(my_binary_30, my_varchar_1000 ),
628
my_binary_30, my_varchar_1000 id FROM t1_values
629
WHERE select_id = 171 OR select_id IS NULL order by id;
631
View Create View character_set_client collation_connection
632
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_binary_30`,`t1_values`.`my_varchar_1000`) AS `LOCATE(my_binary_30, my_varchar_1000 )`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`my_varchar_1000` AS `id` from `t1_values` latin1 latin1_swedish_ci
634
WHERE v1.id IN (SELECT id FROM t1_values
635
WHERE select_id = 171 OR select_id IS NULL) order by id;
639
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_char_30 ),
640
my_binary_30, my_char_30 id FROM t1_values;
641
SELECT LOCATE(my_binary_30, my_char_30 ),
642
my_binary_30, my_char_30 id FROM t1_values
643
WHERE select_id = 170 OR select_id IS NULL order by id;
645
View Create View character_set_client collation_connection
646
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_binary_30`,`t1_values`.`my_char_30`) AS `LOCATE(my_binary_30, my_char_30 )`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`my_char_30` AS `id` from `t1_values` latin1 latin1_swedish_ci
648
WHERE v1.id IN (SELECT id FROM t1_values
649
WHERE select_id = 170 OR select_id IS NULL) order by id;
653
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_binary_30 ),
654
my_binary_30, id FROM t1_values;
655
SELECT LOCATE(my_binary_30, my_binary_30 ),
656
my_binary_30, id FROM t1_values
657
WHERE select_id = 169 OR select_id IS NULL order by id;
659
View Create View character_set_client collation_connection
660
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_binary_30`,`t1_values`.`my_binary_30`) AS `LOCATE(my_binary_30, my_binary_30 )`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
662
WHERE v1.id IN (SELECT id FROM t1_values
663
WHERE select_id = 169 OR select_id IS NULL) order by id;
667
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
668
my_varchar_1000, my_varbinary_1000 id FROM t1_values;
669
SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
670
my_varchar_1000, my_varbinary_1000 id FROM t1_values
671
WHERE select_id = 168 OR select_id IS NULL order by id;
673
View Create View character_set_client collation_connection
674
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_varchar_1000`,`t1_values`.`my_varbinary_1000`) AS `LOCATE(my_varchar_1000, my_varbinary_1000 )`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`my_varbinary_1000` AS `id` from `t1_values` latin1 latin1_swedish_ci
676
WHERE v1.id IN (SELECT id FROM t1_values
677
WHERE select_id = 168 OR select_id IS NULL) order by id;
681
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_binary_30 ),
682
my_varchar_1000, my_binary_30 id FROM t1_values;
683
SELECT LOCATE(my_varchar_1000, my_binary_30 ),
684
my_varchar_1000, my_binary_30 id FROM t1_values
685
WHERE select_id = 167 OR select_id IS NULL order by id;
687
View Create View character_set_client collation_connection
688
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_varchar_1000`,`t1_values`.`my_binary_30`) AS `LOCATE(my_varchar_1000, my_binary_30 )`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`my_binary_30` AS `id` from `t1_values` latin1 latin1_swedish_ci
690
WHERE v1.id IN (SELECT id FROM t1_values
691
WHERE select_id = 167 OR select_id IS NULL) order by id;
695
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_char_30 ),
696
my_varchar_1000, my_char_30 id FROM t1_values;
697
SELECT LOCATE(my_varchar_1000, my_char_30 ),
698
my_varchar_1000, my_char_30 id FROM t1_values
699
WHERE select_id = 166 OR select_id IS NULL order by id;
701
View Create View character_set_client collation_connection
702
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_varchar_1000`,`t1_values`.`my_char_30`) AS `LOCATE(my_varchar_1000, my_char_30 )`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`my_char_30` AS `id` from `t1_values` latin1 latin1_swedish_ci
704
WHERE v1.id IN (SELECT id FROM t1_values
705
WHERE select_id = 166 OR select_id IS NULL) order by id;
709
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
710
my_varchar_1000, id FROM t1_values;
711
SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
712
my_varchar_1000, id FROM t1_values
713
WHERE select_id = 165 OR select_id IS NULL order by id;
715
View Create View character_set_client collation_connection
716
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_varchar_1000`,`t1_values`.`my_varchar_1000`) AS `LOCATE(my_varchar_1000, my_varchar_1000 )`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
718
WHERE v1.id IN (SELECT id FROM t1_values
719
WHERE select_id = 165 OR select_id IS NULL) order by id;
723
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_varbinary_1000 ),
724
my_char_30, my_varbinary_1000 id FROM t1_values;
725
SELECT LOCATE(my_char_30, my_varbinary_1000 ),
726
my_char_30, my_varbinary_1000 id FROM t1_values
727
WHERE select_id = 164 OR select_id IS NULL order by id;
729
View Create View character_set_client collation_connection
730
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_char_30`,`t1_values`.`my_varbinary_1000`) AS `LOCATE(my_char_30, my_varbinary_1000 )`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`my_varbinary_1000` AS `id` from `t1_values` latin1 latin1_swedish_ci
732
WHERE v1.id IN (SELECT id FROM t1_values
733
WHERE select_id = 164 OR select_id IS NULL) order by id;
737
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_binary_30 ),
738
my_char_30, my_binary_30 id FROM t1_values;
739
SELECT LOCATE(my_char_30, my_binary_30 ),
740
my_char_30, my_binary_30 id FROM t1_values
741
WHERE select_id = 163 OR select_id IS NULL order by id;
743
View Create View character_set_client collation_connection
744
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_char_30`,`t1_values`.`my_binary_30`) AS `LOCATE(my_char_30, my_binary_30 )`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`my_binary_30` AS `id` from `t1_values` latin1 latin1_swedish_ci
746
WHERE v1.id IN (SELECT id FROM t1_values
747
WHERE select_id = 163 OR select_id IS NULL) order by id;
751
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_varchar_1000 ),
752
my_char_30, my_varchar_1000 id FROM t1_values;
753
SELECT LOCATE(my_char_30, my_varchar_1000 ),
754
my_char_30, my_varchar_1000 id FROM t1_values
755
WHERE select_id = 162 OR select_id IS NULL order by id;
757
View Create View character_set_client collation_connection
758
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_char_30`,`t1_values`.`my_varchar_1000`) AS `LOCATE(my_char_30, my_varchar_1000 )`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`my_varchar_1000` AS `id` from `t1_values` latin1 latin1_swedish_ci
760
WHERE v1.id IN (SELECT id FROM t1_values
761
WHERE select_id = 162 OR select_id IS NULL) order by id;
765
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_char_30 ),
766
my_char_30, id FROM t1_values;
767
SELECT LOCATE(my_char_30, my_char_30 ),
768
my_char_30, id FROM t1_values
769
WHERE select_id = 161 OR select_id IS NULL order by id;
771
View Create View character_set_client collation_connection
772
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate(`t1_values`.`my_char_30`,`t1_values`.`my_char_30`) AS `LOCATE(my_char_30, my_char_30 )`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
774
WHERE v1.id IN (SELECT id FROM t1_values
775
WHERE select_id = 161 OR select_id IS NULL) order by id;
779
CREATE VIEW v1 AS SELECT LOCATE('char', my_varbinary_1000),
780
my_varbinary_1000, id FROM t1_values;
781
SELECT LOCATE('char', my_varbinary_1000),
782
my_varbinary_1000, id FROM t1_values
783
WHERE select_id = 160 OR select_id IS NULL order by id;
785
View Create View character_set_client collation_connection
786
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate('char',`t1_values`.`my_varbinary_1000`) AS `LOCATE('char', my_varbinary_1000)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
788
WHERE v1.id IN (SELECT id FROM t1_values
789
WHERE select_id = 160 OR select_id IS NULL) order by id;
793
CREATE VIEW v1 AS SELECT LOCATE('char', my_binary_30),
794
my_binary_30, id FROM t1_values;
795
SELECT LOCATE('char', my_binary_30),
796
my_binary_30, id FROM t1_values
797
WHERE select_id = 159 OR select_id IS NULL order by id;
799
View Create View character_set_client collation_connection
800
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate('char',`t1_values`.`my_binary_30`) AS `LOCATE('char', my_binary_30)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
802
WHERE v1.id IN (SELECT id FROM t1_values
803
WHERE select_id = 159 OR select_id IS NULL) order by id;
807
CREATE VIEW v1 AS SELECT LOCATE('char', my_varchar_1000),
808
my_varchar_1000, id FROM t1_values;
809
SELECT LOCATE('char', my_varchar_1000),
810
my_varchar_1000, id FROM t1_values
811
WHERE select_id = 158 OR select_id IS NULL order by id;
813
View Create View character_set_client collation_connection
814
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate('char',`t1_values`.`my_varchar_1000`) AS `LOCATE('char', my_varchar_1000)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
816
WHERE v1.id IN (SELECT id FROM t1_values
817
WHERE select_id = 158 OR select_id IS NULL) order by id;
821
CREATE VIEW v1 AS SELECT LOCATE('char', my_char_30),
822
my_char_30, id FROM t1_values;
823
SELECT LOCATE('char', my_char_30),
824
my_char_30, id FROM t1_values
825
WHERE select_id = 157 OR select_id IS NULL order by id;
827
View Create View character_set_client collation_connection
828
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate('char',`t1_values`.`my_char_30`) AS `LOCATE('char', my_char_30)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
830
WHERE v1.id IN (SELECT id FROM t1_values
831
WHERE select_id = 157 OR select_id IS NULL) order by id;
835
CREATE VIEW v1 AS SELECT LOAD_FILE('../tmp/func_view.dat'), id FROM t1_values;
836
SELECT LOAD_FILE('../tmp/func_view.dat'), id FROM t1_values
837
WHERE select_id = 156 OR select_id IS NULL order by id;
838
LOAD_FILE('../tmp/func_view.dat') id
850
View Create View character_set_client collation_connection
851
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select load_file('../tmp/func_view.dat') AS `LOAD_FILE('../tmp/func_view.dat')`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
853
WHERE v1.id IN (SELECT id FROM t1_values
854
WHERE select_id = 156 OR select_id IS NULL) order by id;
855
LOAD_FILE('../tmp/func_view.dat') id
869
CREATE VIEW v1 AS SELECT LENGTH(my_varbinary_1000),
870
my_varbinary_1000, id FROM t1_values;
871
SELECT LENGTH(my_varbinary_1000),
872
my_varbinary_1000, id FROM t1_values
873
WHERE select_id = 155 OR select_id IS NULL order by id;
875
View Create View character_set_client collation_connection
876
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select length(`t1_values`.`my_varbinary_1000`) AS `LENGTH(my_varbinary_1000)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
878
WHERE v1.id IN (SELECT id FROM t1_values
879
WHERE select_id = 155 OR select_id IS NULL) order by id;
883
CREATE VIEW v1 AS SELECT LENGTH(my_binary_30),
884
my_binary_30, id FROM t1_values;
885
SELECT LENGTH(my_binary_30),
886
my_binary_30, id FROM t1_values
887
WHERE select_id = 154 OR select_id IS NULL order by id;
889
View Create View character_set_client collation_connection
890
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select length(`t1_values`.`my_binary_30`) AS `LENGTH(my_binary_30)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
892
WHERE v1.id IN (SELECT id FROM t1_values
893
WHERE select_id = 154 OR select_id IS NULL) order by id;
897
CREATE VIEW v1 AS SELECT LENGTH(my_varchar_1000),
898
my_varchar_1000, id FROM t1_values;
899
SELECT LENGTH(my_varchar_1000),
900
my_varchar_1000, id FROM t1_values
901
WHERE select_id = 153 OR select_id IS NULL order by id;
903
View Create View character_set_client collation_connection
904
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select length(`t1_values`.`my_varchar_1000`) AS `LENGTH(my_varchar_1000)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
906
WHERE v1.id IN (SELECT id FROM t1_values
907
WHERE select_id = 153 OR select_id IS NULL) order by id;
911
CREATE VIEW v1 AS SELECT LENGTH(my_char_30),
912
my_char_30, id FROM t1_values;
913
SELECT LENGTH(my_char_30),
914
my_char_30, id FROM t1_values
915
WHERE select_id = 152 OR select_id IS NULL order by id;
917
View Create View character_set_client collation_connection
918
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select length(`t1_values`.`my_char_30`) AS `LENGTH(my_char_30)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
920
WHERE v1.id IN (SELECT id FROM t1_values
921
WHERE select_id = 152 OR select_id IS NULL) order by id;
925
CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double), my_double, id FROM t1_values;
926
SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double), my_double, id FROM t1_values
927
WHERE select_id = 151 OR select_id IS NULL order by id;
928
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double) my_double id
930
-1.7976931348623e308 2
931
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 1.7976931348623e308 3
935
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
936
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
938
View Create View character_set_client collation_connection
939
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select left('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö',`t1_values`.`my_double`) AS `LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double)`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
941
WHERE v1.id IN (SELECT id FROM t1_values
942
WHERE select_id = 151 OR select_id IS NULL) order by id;
943
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double) my_double id
945
-1.7976931348623e308 2
946
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 1.7976931348623e308 3
950
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
951
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
955
CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal), my_decimal, id FROM t1_values;
956
SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal), my_decimal, id FROM t1_values
957
WHERE select_id = 150 OR select_id IS NULL order by id;
958
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal) my_decimal id
960
-9999999999999999999999999999999999.999999999999999999999999999999 2
961
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9999999999999999999999999999999999.999999999999999999999999999999 3
962
0.000000000000000000000000000000 4
963
-1.000000000000000000000000000000 5
965
Error 1292 Truncated incorrect DECIMAL value: ''
966
Error 1292 Truncated incorrect DECIMAL value: ''
968
View Create View character_set_client collation_connection
969
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select left('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö',`t1_values`.`my_decimal`) AS `LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal)`,`t1_values`.`my_decimal` AS `my_decimal`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
971
WHERE v1.id IN (SELECT id FROM t1_values
972
WHERE select_id = 150 OR select_id IS NULL) order by id;
973
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal) my_decimal id
975
-9999999999999999999999999999999999.999999999999999999999999999999 2
976
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9999999999999999999999999999999999.999999999999999999999999999999 3
977
0.000000000000000000000000000000 4
978
-1.000000000000000000000000000000 5
980
Error 1292 Truncated incorrect DECIMAL value: ''
981
Error 1292 Truncated incorrect DECIMAL value: ''
985
CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint), my_bigint, id FROM t1_values;
986
SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint), my_bigint, id FROM t1_values
987
WHERE select_id = 149 OR select_id IS NULL order by id;
988
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint) my_bigint id
990
-9223372036854775808 2
991
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9223372036854775807 3
995
View Create View character_set_client collation_connection
996
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select left('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö',`t1_values`.`my_bigint`) AS `LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
998
WHERE v1.id IN (SELECT id FROM t1_values
999
WHERE select_id = 149 OR select_id IS NULL) order by id;
1000
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint) my_bigint id
1002
-9223372036854775808 2
1003
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9223372036854775807 3
1009
CREATE VIEW v1 AS SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values;
1010
SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values
1011
WHERE select_id = 148 OR select_id IS NULL order by id;
1012
LEFT(my_varbinary_1000, 2) my_varbinary_1000 id
1015
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1018
SHOW CREATE VIEW v1;
1019
View Create View character_set_client collation_connection
1020
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select left(`t1_values`.`my_varbinary_1000`,2) AS `LEFT(my_varbinary_1000, 2)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1022
WHERE v1.id IN (SELECT id FROM t1_values
1023
WHERE select_id = 148 OR select_id IS NULL) order by id;
1024
LEFT(my_varbinary_1000, 2) my_varbinary_1000 id
1027
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1033
CREATE VIEW v1 AS SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values;
1034
SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values
1035
WHERE select_id = 147 OR select_id IS NULL order by id;
1036
LEFT(my_binary_30, 2) my_binary_30 id
1039
<- <--------30 characters-------> 3
1042
SHOW CREATE VIEW v1;
1043
View Create View character_set_client collation_connection
1044
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select left(`t1_values`.`my_binary_30`,2) AS `LEFT(my_binary_30, 2)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1046
WHERE v1.id IN (SELECT id FROM t1_values
1047
WHERE select_id = 147 OR select_id IS NULL) order by id;
1048
LEFT(my_binary_30, 2) my_binary_30 id
1051
<- <--------30 characters-------> 3
1057
CREATE VIEW v1 AS SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values;
1058
SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values
1059
WHERE select_id = 146 OR select_id IS NULL order by id;
1060
LEFT(my_varchar_1000, 2) my_varchar_1000 id
1063
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1066
SHOW CREATE VIEW v1;
1067
View Create View character_set_client collation_connection
1068
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select left(`t1_values`.`my_varchar_1000`,2) AS `LEFT(my_varchar_1000, 2)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1070
WHERE v1.id IN (SELECT id FROM t1_values
1071
WHERE select_id = 146 OR select_id IS NULL) order by id;
1072
LEFT(my_varchar_1000, 2) my_varchar_1000 id
1075
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1081
CREATE VIEW v1 AS SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values;
1082
SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values
1083
WHERE select_id = 145 OR select_id IS NULL order by id;
1084
LEFT(my_char_30, 2) my_char_30 id
1087
<- <--------30 characters-------> 3
1090
SHOW CREATE VIEW v1;
1091
View Create View character_set_client collation_connection
1092
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select left(`t1_values`.`my_char_30`,2) AS `LEFT(my_char_30, 2)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1094
WHERE v1.id IN (SELECT id FROM t1_values
1095
WHERE select_id = 145 OR select_id IS NULL) order by id;
1096
LEFT(my_char_30, 2) my_char_30 id
1099
<- <--------30 characters-------> 3
1105
CREATE VIEW v1 AS SELECT LCASE(my_varchar_1000),
1106
my_varchar_1000, id FROM t1_values;
1107
SELECT LCASE(my_varchar_1000),
1108
my_varchar_1000, id FROM t1_values
1109
WHERE select_id = 144 OR select_id IS NULL order by id;
1110
SHOW CREATE VIEW v1;
1111
View Create View character_set_client collation_connection
1112
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select lcase(`t1_values`.`my_varchar_1000`) AS `LCASE(my_varchar_1000)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1114
WHERE v1.id IN (SELECT id FROM t1_values
1115
WHERE select_id = 144 OR select_id IS NULL) order by id;
1119
CREATE VIEW v1 AS SELECT INSTR(my_char_30, 'char'),
1120
my_char_30, id FROM t1_values;
1121
SELECT INSTR(my_char_30, 'char'),
1122
my_char_30, id FROM t1_values
1123
WHERE select_id = 143 OR select_id IS NULL order by id;
1124
SHOW CREATE VIEW v1;
1125
View Create View character_set_client collation_connection
1126
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select locate('char',`t1_values`.`my_char_30`) AS `INSTR(my_char_30, 'char')`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1128
WHERE v1.id IN (SELECT id FROM t1_values
1129
WHERE select_id = 143 OR select_id IS NULL) order by id;
1133
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_varbinary_1000),
1134
my_varbinary_1000, id FROM t1_values;
1135
SELECT BIT_LENGTH(my_varbinary_1000),
1136
my_varbinary_1000, id FROM t1_values
1137
WHERE select_id = 142 OR select_id IS NULL order by id;
1138
BIT_LENGTH(my_varbinary_1000) my_varbinary_1000 id
1141
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1144
SHOW CREATE VIEW v1;
1145
View Create View character_set_client collation_connection
1146
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select bit_length(`t1_values`.`my_varbinary_1000`) AS `BIT_LENGTH(my_varbinary_1000)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1148
WHERE v1.id IN (SELECT id FROM t1_values
1149
WHERE select_id = 142 OR select_id IS NULL) order by id;
1150
BIT_LENGTH(my_varbinary_1000) my_varbinary_1000 id
1153
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1159
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_binary_30),
1160
my_binary_30, id FROM t1_values;
1161
SELECT BIT_LENGTH(my_binary_30),
1162
my_binary_30, id FROM t1_values
1163
WHERE select_id = 141 OR select_id IS NULL order by id;
1164
BIT_LENGTH(my_binary_30) my_binary_30 id
1167
240 <--------30 characters-------> 3
1170
SHOW CREATE VIEW v1;
1171
View Create View character_set_client collation_connection
1172
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select bit_length(`t1_values`.`my_binary_30`) AS `BIT_LENGTH(my_binary_30)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1174
WHERE v1.id IN (SELECT id FROM t1_values
1175
WHERE select_id = 141 OR select_id IS NULL) order by id;
1176
BIT_LENGTH(my_binary_30) my_binary_30 id
1179
240 <--------30 characters-------> 3
1185
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_varchar_1000),
1186
my_varchar_1000, id FROM t1_values;
1187
SELECT BIT_LENGTH(my_varchar_1000),
1188
my_varchar_1000, id FROM t1_values
1189
WHERE select_id = 140 OR select_id IS NULL order by id;
1190
BIT_LENGTH(my_varchar_1000) my_varchar_1000 id
1193
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1196
SHOW CREATE VIEW v1;
1197
View Create View character_set_client collation_connection
1198
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select bit_length(`t1_values`.`my_varchar_1000`) AS `BIT_LENGTH(my_varchar_1000)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1200
WHERE v1.id IN (SELECT id FROM t1_values
1201
WHERE select_id = 140 OR select_id IS NULL) order by id;
1202
BIT_LENGTH(my_varchar_1000) my_varchar_1000 id
1205
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1211
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_char_30),
1212
my_char_30, id FROM t1_values;
1213
SELECT BIT_LENGTH(my_char_30),
1214
my_char_30, id FROM t1_values
1215
WHERE select_id = 139 OR select_id IS NULL order by id;
1216
BIT_LENGTH(my_char_30) my_char_30 id
1219
240 <--------30 characters-------> 3
1222
SHOW CREATE VIEW v1;
1223
View Create View character_set_client collation_connection
1224
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select bit_length(`t1_values`.`my_char_30`) AS `BIT_LENGTH(my_char_30)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1226
WHERE v1.id IN (SELECT id FROM t1_values
1227
WHERE select_id = 139 OR select_id IS NULL) order by id;
1228
BIT_LENGTH(my_char_30) my_char_30 id
1231
240 <--------30 characters-------> 3
1237
CREATE VIEW v1 AS SELECT IFNULL(my_year,'IS_NULL'),
1238
my_year, id FROM t1_values;
1239
SELECT IFNULL(my_year,'IS_NULL'),
1240
my_year, id FROM t1_values
1241
WHERE select_id = 138 OR select_id IS NULL order by id;
1242
IFNULL(my_year,'IS_NULL') my_year id
1248
SHOW CREATE VIEW v1;
1249
View Create View character_set_client collation_connection
1250
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ifnull(`t1_values`.`my_year`,'IS_NULL') AS `IFNULL(my_year,'IS_NULL')`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1252
WHERE v1.id IN (SELECT id FROM t1_values
1253
WHERE select_id = 138 OR select_id IS NULL) order by id;
1254
IFNULL(my_year,'IS_NULL') my_year id
1263
CREATE VIEW v1 AS SELECT IFNULL(my_time,'IS_NULL'),
1264
my_time, id FROM t1_values;
1265
SELECT IFNULL(my_time,'IS_NULL'),
1266
my_time, id FROM t1_values
1267
WHERE select_id = 137 OR select_id IS NULL order by id;
1268
IFNULL(my_time,'IS_NULL') my_time id
1270
-838:59:59 -838:59:59 2
1271
838:59:59 838:59:59 3
1274
SHOW CREATE VIEW v1;
1275
View Create View character_set_client collation_connection
1276
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ifnull(`t1_values`.`my_time`,'IS_NULL') AS `IFNULL(my_time,'IS_NULL')`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1278
WHERE v1.id IN (SELECT id FROM t1_values
1279
WHERE select_id = 137 OR select_id IS NULL) order by id;
1280
IFNULL(my_time,'IS_NULL') my_time id
1282
-838:59:59 -838:59:59 2
1283
838:59:59 838:59:59 3
1289
CREATE VIEW v1 AS SELECT IFNULL(my_timestamp,'IS_NULL'),
1290
my_timestamp, id FROM t1_values;
1291
SELECT IFNULL(my_timestamp,'IS_NULL'),
1292
my_timestamp, id FROM t1_values
1293
WHERE select_id = 136 OR select_id IS NULL order by id;
1294
IFNULL(my_timestamp,'IS_NULL') my_timestamp id
1295
0000-00-00 00:00:00 0000-00-00 00:00:00 1
1296
1970-01-01 03:00:01 1970-01-01 03:00:01 2
1297
2038-01-01 02:59:59 2038-01-01 02:59:59 3
1298
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1299
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1300
SHOW CREATE VIEW v1;
1301
View Create View character_set_client collation_connection
1302
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ifnull(`t1_values`.`my_timestamp`,'IS_NULL') AS `IFNULL(my_timestamp,'IS_NULL')`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1304
WHERE v1.id IN (SELECT id FROM t1_values
1305
WHERE select_id = 136 OR select_id IS NULL) order by id;
1306
IFNULL(my_timestamp,'IS_NULL') my_timestamp id
1307
0000-00-00 00:00:00 0000-00-00 00:00:00 1
1308
1970-01-01 03:00:01 1970-01-01 03:00:01 2
1309
2038-01-01 02:59:59 2038-01-01 02:59:59 3
1310
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1311
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1315
CREATE VIEW v1 AS SELECT IFNULL(my_date,'IS_NULL'),
1316
my_date, id FROM t1_values;
1317
SELECT IFNULL(my_date,'IS_NULL'),
1318
my_date, id FROM t1_values
1319
WHERE select_id = 135 OR select_id IS NULL order by id;
1320
IFNULL(my_date,'IS_NULL') my_date id
1322
0001-01-01 0001-01-01 2
1323
9999-12-31 9999-12-31 3
1324
2004-02-29 2004-02-29 4
1325
2005-06-28 2005-06-28 5
1326
SHOW CREATE VIEW v1;
1327
View Create View character_set_client collation_connection
1328
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ifnull(`t1_values`.`my_date`,'IS_NULL') AS `IFNULL(my_date,'IS_NULL')`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1330
WHERE v1.id IN (SELECT id FROM t1_values
1331
WHERE select_id = 135 OR select_id IS NULL) order by id;
1332
IFNULL(my_date,'IS_NULL') my_date id
1334
0001-01-01 0001-01-01 2
1335
9999-12-31 9999-12-31 3
1336
2004-02-29 2004-02-29 4
1337
2005-06-28 2005-06-28 5
1341
CREATE VIEW v1 AS SELECT IFNULL(my_datetime,'IS_NULL'),
1342
my_datetime, id FROM t1_values;
1343
SELECT IFNULL(my_datetime,'IS_NULL'),
1344
my_datetime, id FROM t1_values
1345
WHERE select_id = 134 OR select_id IS NULL order by id;
1346
IFNULL(my_datetime,'IS_NULL') my_datetime id
1348
0001-01-01 00:00:00 0001-01-01 00:00:00 2
1349
9999-12-31 23:59:59 9999-12-31 23:59:59 3
1350
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1351
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1352
SHOW CREATE VIEW v1;
1353
View Create View character_set_client collation_connection
1354
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ifnull(`t1_values`.`my_datetime`,'IS_NULL') AS `IFNULL(my_datetime,'IS_NULL')`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1356
WHERE v1.id IN (SELECT id FROM t1_values
1357
WHERE select_id = 134 OR select_id IS NULL) order by id;
1358
IFNULL(my_datetime,'IS_NULL') my_datetime id
1360
0001-01-01 00:00:00 0001-01-01 00:00:00 2
1361
9999-12-31 23:59:59 9999-12-31 23:59:59 3
1362
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1363
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1367
CREATE VIEW v1 AS SELECT IFNULL(my_double,'IS_NULL'),
1368
my_double, id FROM t1_values;
1369
SELECT IFNULL(my_double,'IS_NULL'),
1370
my_double, id FROM t1_values
1371
WHERE select_id = 133 OR select_id IS NULL order by id;
1372
IFNULL(my_double,'IS_NULL') my_double id
1374
-1.7976931348623e308 -1.7976931348623e308 2
1375
1.7976931348623e308 1.7976931348623e308 3
1378
SHOW CREATE VIEW v1;
1379
View Create View character_set_client collation_connection
1380
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ifnull(`t1_values`.`my_double`,'IS_NULL') AS `IFNULL(my_double,'IS_NULL')`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1382
WHERE v1.id IN (SELECT id FROM t1_values
1383
WHERE select_id = 133 OR select_id IS NULL) order by id;
1384
IFNULL(my_double,'IS_NULL') my_double id
1386
-1.7976931348623e308 -1.7976931348623e308 2
1387
1.7976931348623e308 1.7976931348623e308 3
1393
CREATE VIEW v1 AS SELECT IFNULL(my_decimal,'IS_NULL'),
1394
my_decimal, id FROM t1_values;
1395
SELECT IFNULL(my_decimal,'IS_NULL'),
1396
my_decimal, id FROM t1_values
1397
WHERE select_id = 132 OR select_id IS NULL order by id;
1398
IFNULL(my_decimal,'IS_NULL') my_decimal id
1400
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
1401
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
1402
0.000000000000000000000000000000 0.000000000000000000000000000000 4
1403
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
1404
SHOW CREATE VIEW v1;
1405
View Create View character_set_client collation_connection
1406
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ifnull(`t1_values`.`my_decimal`,'IS_NULL') AS `IFNULL(my_decimal,'IS_NULL')`,`t1_values`.`my_decimal` AS `my_decimal`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1408
WHERE v1.id IN (SELECT id FROM t1_values
1409
WHERE select_id = 132 OR select_id IS NULL) order by id;
1410
IFNULL(my_decimal,'IS_NULL') my_decimal id
1412
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
1413
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
1414
0.000000000000000000000000000000 0.000000000000000000000000000000 4
1415
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
1419
CREATE VIEW v1 AS SELECT IFNULL(my_bigint,'IS_NULL'),
1420
my_bigint, id FROM t1_values;
1421
SELECT IFNULL(my_bigint,'IS_NULL'),
1422
my_bigint, id FROM t1_values
1423
WHERE select_id = 131 OR select_id IS NULL order by id;
1424
IFNULL(my_bigint,'IS_NULL') my_bigint id
1426
-9223372036854775808 -9223372036854775808 2
1427
9223372036854775807 9223372036854775807 3
1430
SHOW CREATE VIEW v1;
1431
View Create View character_set_client collation_connection
1432
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ifnull(`t1_values`.`my_bigint`,'IS_NULL') AS `IFNULL(my_bigint,'IS_NULL')`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1434
WHERE v1.id IN (SELECT id FROM t1_values
1435
WHERE select_id = 131 OR select_id IS NULL) order by id;
1436
IFNULL(my_bigint,'IS_NULL') my_bigint id
1438
-9223372036854775808 -9223372036854775808 2
1439
9223372036854775807 9223372036854775807 3
1445
CREATE VIEW v1 AS SELECT IFNULL(my_varbinary_1000,'IS_NULL'),
1446
my_varbinary_1000, id FROM t1_values;
1447
SELECT IFNULL(my_varbinary_1000,'IS_NULL'),
1448
my_varbinary_1000, id FROM t1_values
1449
WHERE select_id = 130 OR select_id IS NULL order by id;
1450
IFNULL(my_varbinary_1000,'IS_NULL') my_varbinary_1000 id
1453
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1454
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1456
SHOW CREATE VIEW v1;
1457
View Create View character_set_client collation_connection
1458
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ifnull(`t1_values`.`my_varbinary_1000`,'IS_NULL') AS `IFNULL(my_varbinary_1000,'IS_NULL')`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1460
WHERE v1.id IN (SELECT id FROM t1_values
1461
WHERE select_id = 130 OR select_id IS NULL) order by id;
1462
IFNULL(my_varbinary_1000,'IS_NULL') my_varbinary_1000 id
1465
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1466
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1471
CREATE VIEW v1 AS SELECT IFNULL(my_binary_30,'IS_NULL'),
1472
my_binary_30, id FROM t1_values;
1473
SELECT IFNULL(my_binary_30,'IS_NULL'),
1474
my_binary_30, id FROM t1_values
1475
WHERE select_id = 129 OR select_id IS NULL order by id;
1476
IFNULL(my_binary_30,'IS_NULL') my_binary_30 id
1479
<--------30 characters-------> <--------30 characters-------> 3
1480
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1482
SHOW CREATE VIEW v1;
1483
View Create View character_set_client collation_connection
1484
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ifnull(`t1_values`.`my_binary_30`,'IS_NULL') AS `IFNULL(my_binary_30,'IS_NULL')`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1486
WHERE v1.id IN (SELECT id FROM t1_values
1487
WHERE select_id = 129 OR select_id IS NULL) order by id;
1488
IFNULL(my_binary_30,'IS_NULL') my_binary_30 id
1491
<--------30 characters-------> <--------30 characters-------> 3
1492
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1497
CREATE VIEW v1 AS SELECT IFNULL(my_varchar_1000,'IS_NULL'),
1498
my_varchar_1000, id FROM t1_values;
1499
SELECT IFNULL(my_varchar_1000,'IS_NULL'),
1500
my_varchar_1000, id FROM t1_values
1501
WHERE select_id = 128 OR select_id IS NULL order by id;
1502
IFNULL(my_varchar_1000,'IS_NULL') my_varchar_1000 id
1505
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1506
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1508
SHOW CREATE VIEW v1;
1509
View Create View character_set_client collation_connection
1510
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ifnull(`t1_values`.`my_varchar_1000`,'IS_NULL') AS `IFNULL(my_varchar_1000,'IS_NULL')`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1512
WHERE v1.id IN (SELECT id FROM t1_values
1513
WHERE select_id = 128 OR select_id IS NULL) order by id;
1514
IFNULL(my_varchar_1000,'IS_NULL') my_varchar_1000 id
1517
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1518
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1523
CREATE VIEW v1 AS SELECT IFNULL(my_char_30,'IS_NULL'),
1524
my_char_30, id FROM t1_values;
1525
SELECT IFNULL(my_char_30,'IS_NULL'),
1526
my_char_30, id FROM t1_values
1527
WHERE select_id = 127 OR select_id IS NULL order by id;
1528
IFNULL(my_char_30,'IS_NULL') my_char_30 id
1531
<--------30 characters-------> <--------30 characters-------> 3
1532
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1534
SHOW CREATE VIEW v1;
1535
View Create View character_set_client collation_connection
1536
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select ifnull(`t1_values`.`my_char_30`,'IS_NULL') AS `IFNULL(my_char_30,'IS_NULL')`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1538
WHERE v1.id IN (SELECT id FROM t1_values
1539
WHERE select_id = 127 OR select_id IS NULL) order by id;
1540
IFNULL(my_char_30,'IS_NULL') my_char_30 id
1543
<--------30 characters-------> <--------30 characters-------> 3
1544
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1549
CREATE VIEW v1 AS SELECT IF(my_year IS NULL, 'IS NULL',
1550
'IS NOT NULL'), my_year, id FROM t1_values;
1551
SELECT IF(my_year IS NULL, 'IS NULL',
1552
'IS NOT NULL'), my_year, id FROM t1_values
1553
WHERE select_id = 126 OR select_id IS NULL order by id;
1554
IF(my_year IS NULL, 'IS NULL',
1555
'IS NOT NULL') my_year id
1561
SHOW CREATE VIEW v1;
1562
View Create View character_set_client collation_connection
1563
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(isnull(`t1_values`.`my_year`),'IS NULL','IS NOT NULL') AS `IF(my_year IS NULL, 'IS NULL',
1564
'IS NOT NULL')`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1566
WHERE v1.id IN (SELECT id FROM t1_values
1567
WHERE select_id = 126 OR select_id IS NULL) order by id;
1568
IF(my_year IS NULL, 'IS NULL',
1569
'IS NOT NULL') my_year id
1578
CREATE VIEW v1 AS SELECT IF(my_time IS NULL, 'IS NULL',
1579
'IS NOT NULL'), my_time, id FROM t1_values;
1580
SELECT IF(my_time IS NULL, 'IS NULL',
1581
'IS NOT NULL'), my_time, id FROM t1_values
1582
WHERE select_id = 125 OR select_id IS NULL order by id;
1583
IF(my_time IS NULL, 'IS NULL',
1584
'IS NOT NULL') my_time id
1586
IS NOT NULL -838:59:59 2
1587
IS NOT NULL 838:59:59 3
1588
IS NOT NULL 13:00:00 4
1589
IS NOT NULL 10:00:00 5
1590
SHOW CREATE VIEW v1;
1591
View Create View character_set_client collation_connection
1592
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(isnull(`t1_values`.`my_time`),'IS NULL','IS NOT NULL') AS `IF(my_time IS NULL, 'IS NULL',
1593
'IS NOT NULL')`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1595
WHERE v1.id IN (SELECT id FROM t1_values
1596
WHERE select_id = 125 OR select_id IS NULL) order by id;
1597
IF(my_time IS NULL, 'IS NULL',
1598
'IS NOT NULL') my_time id
1600
IS NOT NULL -838:59:59 2
1601
IS NOT NULL 838:59:59 3
1602
IS NOT NULL 13:00:00 4
1603
IS NOT NULL 10:00:00 5
1607
CREATE VIEW v1 AS SELECT IF(my_timestamp IS NULL, 'IS NULL',
1608
'IS NOT NULL'), my_timestamp, id FROM t1_values;
1609
SELECT IF(my_timestamp IS NULL, 'IS NULL',
1610
'IS NOT NULL'), my_timestamp, id FROM t1_values
1611
WHERE select_id = 124 OR select_id IS NULL order by id;
1612
IF(my_timestamp IS NULL, 'IS NULL',
1613
'IS NOT NULL') my_timestamp id
1614
IS NOT NULL 0000-00-00 00:00:00 1
1615
IS NOT NULL 1970-01-01 03:00:01 2
1616
IS NOT NULL 2038-01-01 02:59:59 3
1617
IS NOT NULL 2004-02-29 23:59:59 4
1618
IS NOT NULL 2005-06-28 10:00:00 5
1619
SHOW CREATE VIEW v1;
1620
View Create View character_set_client collation_connection
1621
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(isnull(`t1_values`.`my_timestamp`),'IS NULL','IS NOT NULL') AS `IF(my_timestamp IS NULL, 'IS NULL',
1622
'IS NOT NULL')`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1624
WHERE v1.id IN (SELECT id FROM t1_values
1625
WHERE select_id = 124 OR select_id IS NULL) order by id;
1626
IF(my_timestamp IS NULL, 'IS NULL',
1627
'IS NOT NULL') my_timestamp id
1628
IS NOT NULL 0000-00-00 00:00:00 1
1629
IS NOT NULL 1970-01-01 03:00:01 2
1630
IS NOT NULL 2038-01-01 02:59:59 3
1631
IS NOT NULL 2004-02-29 23:59:59 4
1632
IS NOT NULL 2005-06-28 10:00:00 5
1636
CREATE VIEW v1 AS SELECT IF(my_date IS NULL, 'IS NULL',
1637
'IS NOT NULL'), my_date, id FROM t1_values;
1638
SELECT IF(my_date IS NULL, 'IS NULL',
1639
'IS NOT NULL'), my_date, id FROM t1_values
1640
WHERE select_id = 123 OR select_id IS NULL order by id;
1641
IF(my_date IS NULL, 'IS NULL',
1642
'IS NOT NULL') my_date id
1644
IS NOT NULL 0001-01-01 2
1645
IS NOT NULL 9999-12-31 3
1646
IS NOT NULL 2004-02-29 4
1647
IS NOT NULL 2005-06-28 5
1648
SHOW CREATE VIEW v1;
1649
View Create View character_set_client collation_connection
1650
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(isnull(`t1_values`.`my_date`),'IS NULL','IS NOT NULL') AS `IF(my_date IS NULL, 'IS NULL',
1651
'IS NOT NULL')`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1653
WHERE v1.id IN (SELECT id FROM t1_values
1654
WHERE select_id = 123 OR select_id IS NULL) order by id;
1655
IF(my_date IS NULL, 'IS NULL',
1656
'IS NOT NULL') my_date id
1658
IS NOT NULL 0001-01-01 2
1659
IS NOT NULL 9999-12-31 3
1660
IS NOT NULL 2004-02-29 4
1661
IS NOT NULL 2005-06-28 5
1665
CREATE VIEW v1 AS SELECT IF(my_datetime IS NULL, 'IS NULL',
1666
'IS NOT NULL'), my_datetime, id FROM t1_values;
1667
SELECT IF(my_datetime IS NULL, 'IS NULL',
1668
'IS NOT NULL'), my_datetime, id FROM t1_values
1669
WHERE select_id = 122 OR select_id IS NULL order by id;
1670
IF(my_datetime IS NULL, 'IS NULL',
1671
'IS NOT NULL') my_datetime id
1673
IS NOT NULL 0001-01-01 00:00:00 2
1674
IS NOT NULL 9999-12-31 23:59:59 3
1675
IS NOT NULL 2004-02-29 23:59:59 4
1676
IS NOT NULL 2005-06-28 10:00:00 5
1677
SHOW CREATE VIEW v1;
1678
View Create View character_set_client collation_connection
1679
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(isnull(`t1_values`.`my_datetime`),'IS NULL','IS NOT NULL') AS `IF(my_datetime IS NULL, 'IS NULL',
1680
'IS NOT NULL')`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1682
WHERE v1.id IN (SELECT id FROM t1_values
1683
WHERE select_id = 122 OR select_id IS NULL) order by id;
1684
IF(my_datetime IS NULL, 'IS NULL',
1685
'IS NOT NULL') my_datetime id
1687
IS NOT NULL 0001-01-01 00:00:00 2
1688
IS NOT NULL 9999-12-31 23:59:59 3
1689
IS NOT NULL 2004-02-29 23:59:59 4
1690
IS NOT NULL 2005-06-28 10:00:00 5
1694
CREATE VIEW v1 AS SELECT IF(my_double IS NULL, 'IS NULL',
1695
'IS NOT NULL'), my_double, id FROM t1_values;
1696
SELECT IF(my_double IS NULL, 'IS NULL',
1697
'IS NOT NULL'), my_double, id FROM t1_values
1698
WHERE select_id = 121 OR select_id IS NULL order by id;
1699
IF(my_double IS NULL, 'IS NULL',
1700
'IS NOT NULL') my_double id
1702
IS NOT NULL -1.7976931348623e308 2
1703
IS NOT NULL 1.7976931348623e308 3
1706
SHOW CREATE VIEW v1;
1707
View Create View character_set_client collation_connection
1708
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(isnull(`t1_values`.`my_double`),'IS NULL','IS NOT NULL') AS `IF(my_double IS NULL, 'IS NULL',
1709
'IS NOT NULL')`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1711
WHERE v1.id IN (SELECT id FROM t1_values
1712
WHERE select_id = 121 OR select_id IS NULL) order by id;
1713
IF(my_double IS NULL, 'IS NULL',
1714
'IS NOT NULL') my_double id
1716
IS NOT NULL -1.7976931348623e308 2
1717
IS NOT NULL 1.7976931348623e308 3
1723
CREATE VIEW v1 AS SELECT IF(my_decimal IS NULL, 'IS NULL',
1724
'IS NOT NULL'), my_decimal, id FROM t1_values;
1725
SELECT IF(my_decimal IS NULL, 'IS NULL',
1726
'IS NOT NULL'), my_decimal, id FROM t1_values
1727
WHERE select_id = 120 OR select_id IS NULL order by id;
1728
IF(my_decimal IS NULL, 'IS NULL',
1729
'IS NOT NULL') my_decimal id
1731
IS NOT NULL -9999999999999999999999999999999999.999999999999999999999999999999 2
1732
IS NOT NULL 9999999999999999999999999999999999.999999999999999999999999999999 3
1733
IS NOT NULL 0.000000000000000000000000000000 4
1734
IS NOT NULL -1.000000000000000000000000000000 5
1735
SHOW CREATE VIEW v1;
1736
View Create View character_set_client collation_connection
1737
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(isnull(`t1_values`.`my_decimal`),'IS NULL','IS NOT NULL') AS `IF(my_decimal IS NULL, 'IS NULL',
1738
'IS NOT NULL')`,`t1_values`.`my_decimal` AS `my_decimal`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1740
WHERE v1.id IN (SELECT id FROM t1_values
1741
WHERE select_id = 120 OR select_id IS NULL) order by id;
1742
IF(my_decimal IS NULL, 'IS NULL',
1743
'IS NOT NULL') my_decimal id
1745
IS NOT NULL -9999999999999999999999999999999999.999999999999999999999999999999 2
1746
IS NOT NULL 9999999999999999999999999999999999.999999999999999999999999999999 3
1747
IS NOT NULL 0.000000000000000000000000000000 4
1748
IS NOT NULL -1.000000000000000000000000000000 5
1752
CREATE VIEW v1 AS SELECT IF(my_bigint IS NULL, 'IS NULL',
1753
'IS NOT NULL'), my_bigint, id FROM t1_values;
1754
SELECT IF(my_bigint IS NULL, 'IS NULL',
1755
'IS NOT NULL'), my_bigint, id FROM t1_values
1756
WHERE select_id = 119 OR select_id IS NULL order by id;
1757
IF(my_bigint IS NULL, 'IS NULL',
1758
'IS NOT NULL') my_bigint id
1760
IS NOT NULL -9223372036854775808 2
1761
IS NOT NULL 9223372036854775807 3
1764
SHOW CREATE VIEW v1;
1765
View Create View character_set_client collation_connection
1766
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(isnull(`t1_values`.`my_bigint`),'IS NULL','IS NOT NULL') AS `IF(my_bigint IS NULL, 'IS NULL',
1767
'IS NOT NULL')`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1769
WHERE v1.id IN (SELECT id FROM t1_values
1770
WHERE select_id = 119 OR select_id IS NULL) order by id;
1771
IF(my_bigint IS NULL, 'IS NULL',
1772
'IS NOT NULL') my_bigint id
1774
IS NOT NULL -9223372036854775808 2
1775
IS NOT NULL 9223372036854775807 3
1781
CREATE VIEW v1 AS SELECT IF(my_varbinary_1000 IS NULL, 'IS NULL',
1782
'IS NOT NULL'), my_varbinary_1000, id FROM t1_values;
1783
SELECT IF(my_varbinary_1000 IS NULL, 'IS NULL',
1784
'IS NOT NULL'), my_varbinary_1000, id FROM t1_values
1785
WHERE select_id = 118 OR select_id IS NULL order by id;
1786
IF(my_varbinary_1000 IS NULL, 'IS NULL',
1787
'IS NOT NULL') my_varbinary_1000 id
1790
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1791
IS NOT NULL ---äÖüß@µ*$-- 4
1793
SHOW CREATE VIEW v1;
1794
View Create View character_set_client collation_connection
1795
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(isnull(`t1_values`.`my_varbinary_1000`),'IS NULL','IS NOT NULL') AS `IF(my_varbinary_1000 IS NULL, 'IS NULL',
1796
'IS NOT NULL')`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1798
WHERE v1.id IN (SELECT id FROM t1_values
1799
WHERE select_id = 118 OR select_id IS NULL) order by id;
1800
IF(my_varbinary_1000 IS NULL, 'IS NULL',
1801
'IS NOT NULL') my_varbinary_1000 id
1804
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1805
IS NOT NULL ---äÖüß@µ*$-- 4
1810
CREATE VIEW v1 AS SELECT IF(my_binary_30 IS NULL, 'IS NULL',
1811
'IS NOT NULL'), my_binary_30, id FROM t1_values;
1812
SELECT IF(my_binary_30 IS NULL, 'IS NULL',
1813
'IS NOT NULL'), my_binary_30, id FROM t1_values
1814
WHERE select_id = 117 OR select_id IS NULL order by id;
1815
IF(my_binary_30 IS NULL, 'IS NULL',
1816
'IS NOT NULL') my_binary_30 id
1819
IS NOT NULL <--------30 characters-------> 3
1820
IS NOT NULL ---äÖüß@µ*$-- 4
1822
SHOW CREATE VIEW v1;
1823
View Create View character_set_client collation_connection
1824
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(isnull(`t1_values`.`my_binary_30`),'IS NULL','IS NOT NULL') AS `IF(my_binary_30 IS NULL, 'IS NULL',
1825
'IS NOT NULL')`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1827
WHERE v1.id IN (SELECT id FROM t1_values
1828
WHERE select_id = 117 OR select_id IS NULL) order by id;
1829
IF(my_binary_30 IS NULL, 'IS NULL',
1830
'IS NOT NULL') my_binary_30 id
1833
IS NOT NULL <--------30 characters-------> 3
1834
IS NOT NULL ---äÖüß@µ*$-- 4
1839
CREATE VIEW v1 AS SELECT IF(my_varchar_1000 IS NULL, 'IS NULL',
1840
'IS NOT NULL'), my_varchar_1000, id FROM t1_values;
1841
SELECT IF(my_varchar_1000 IS NULL, 'IS NULL',
1842
'IS NOT NULL'), my_varchar_1000, id FROM t1_values
1843
WHERE select_id = 116 OR select_id IS NULL order by id;
1844
IF(my_varchar_1000 IS NULL, 'IS NULL',
1845
'IS NOT NULL') my_varchar_1000 id
1848
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1849
IS NOT NULL ---äÖüß@µ*$-- 4
1851
SHOW CREATE VIEW v1;
1852
View Create View character_set_client collation_connection
1853
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(isnull(`t1_values`.`my_varchar_1000`),'IS NULL','IS NOT NULL') AS `IF(my_varchar_1000 IS NULL, 'IS NULL',
1854
'IS NOT NULL')`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1856
WHERE v1.id IN (SELECT id FROM t1_values
1857
WHERE select_id = 116 OR select_id IS NULL) order by id;
1858
IF(my_varchar_1000 IS NULL, 'IS NULL',
1859
'IS NOT NULL') my_varchar_1000 id
1862
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1863
IS NOT NULL ---äÖüß@µ*$-- 4
1868
CREATE VIEW v1 AS SELECT IF(my_char_30 IS NULL, 'IS NULL',
1869
'IS NOT NULL'), my_char_30, id FROM t1_values;
1870
SELECT IF(my_char_30 IS NULL, 'IS NULL',
1871
'IS NOT NULL'), my_char_30, id FROM t1_values
1872
WHERE select_id = 115 OR select_id IS NULL order by id;
1873
IF(my_char_30 IS NULL, 'IS NULL',
1874
'IS NOT NULL') my_char_30 id
1877
IS NOT NULL <--------30 characters-------> 3
1878
IS NOT NULL ---äÖüß@µ*$-- 4
1880
SHOW CREATE VIEW v1;
1881
View Create View character_set_client collation_connection
1882
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(isnull(`t1_values`.`my_char_30`),'IS NULL','IS NOT NULL') AS `IF(my_char_30 IS NULL, 'IS NULL',
1883
'IS NOT NULL')`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1885
WHERE v1.id IN (SELECT id FROM t1_values
1886
WHERE select_id = 115 OR select_id IS NULL) order by id;
1887
IF(my_char_30 IS NULL, 'IS NULL',
1888
'IS NOT NULL') my_char_30 id
1891
IS NOT NULL <--------30 characters-------> 3
1892
IS NOT NULL ---äÖüß@µ*$-- 4
1897
CREATE VIEW v1 AS SELECT IF(my_year, 'IS TRUE', 'IS NOT TRUE'),
1898
my_year, id FROM t1_values;
1899
SELECT IF(my_year, 'IS TRUE', 'IS NOT TRUE'),
1900
my_year, id FROM t1_values
1901
WHERE select_id = 114 OR select_id IS NULL order by id;
1902
IF(my_year, 'IS TRUE', 'IS NOT TRUE') my_year id
1908
SHOW CREATE VIEW v1;
1909
View Create View character_set_client collation_connection
1910
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(`t1_values`.`my_year`,'IS TRUE','IS NOT TRUE') AS `IF(my_year, 'IS TRUE', 'IS NOT TRUE')`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1912
WHERE v1.id IN (SELECT id FROM t1_values
1913
WHERE select_id = 114 OR select_id IS NULL) order by id;
1914
IF(my_year, 'IS TRUE', 'IS NOT TRUE') my_year id
1923
CREATE VIEW v1 AS SELECT IF(my_time, 'IS TRUE', 'IS NOT TRUE'),
1924
my_time, id FROM t1_values;
1925
SELECT IF(my_time, 'IS TRUE', 'IS NOT TRUE'),
1926
my_time, id FROM t1_values
1927
WHERE select_id = 113 OR select_id IS NULL order by id;
1928
IF(my_time, 'IS TRUE', 'IS NOT TRUE') my_time id
1930
IS TRUE -838:59:59 2
1934
SHOW CREATE VIEW v1;
1935
View Create View character_set_client collation_connection
1936
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(`t1_values`.`my_time`,'IS TRUE','IS NOT TRUE') AS `IF(my_time, 'IS TRUE', 'IS NOT TRUE')`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1938
WHERE v1.id IN (SELECT id FROM t1_values
1939
WHERE select_id = 113 OR select_id IS NULL) order by id;
1940
IF(my_time, 'IS TRUE', 'IS NOT TRUE') my_time id
1942
IS TRUE -838:59:59 2
1949
CREATE VIEW v1 AS SELECT IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE'),
1950
my_timestamp, id FROM t1_values;
1951
SELECT IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE'),
1952
my_timestamp, id FROM t1_values
1953
WHERE select_id = 112 OR select_id IS NULL order by id;
1954
IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE') my_timestamp id
1955
IS NOT TRUE 0000-00-00 00:00:00 1
1956
IS TRUE 1970-01-01 03:00:01 2
1957
IS TRUE 2038-01-01 02:59:59 3
1958
IS TRUE 2004-02-29 23:59:59 4
1959
IS TRUE 2005-06-28 10:00:00 5
1960
SHOW CREATE VIEW v1;
1961
View Create View character_set_client collation_connection
1962
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(`t1_values`.`my_timestamp`,'IS TRUE','IS NOT TRUE') AS `IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE')`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1964
WHERE v1.id IN (SELECT id FROM t1_values
1965
WHERE select_id = 112 OR select_id IS NULL) order by id;
1966
IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE') my_timestamp id
1967
IS NOT TRUE 0000-00-00 00:00:00 1
1968
IS TRUE 1970-01-01 03:00:01 2
1969
IS TRUE 2038-01-01 02:59:59 3
1970
IS TRUE 2004-02-29 23:59:59 4
1971
IS TRUE 2005-06-28 10:00:00 5
1975
CREATE VIEW v1 AS SELECT IF(my_date, 'IS TRUE', 'IS NOT TRUE'),
1976
my_date, id FROM t1_values;
1977
SELECT IF(my_date, 'IS TRUE', 'IS NOT TRUE'),
1978
my_date, id FROM t1_values
1979
WHERE select_id = 111 OR select_id IS NULL order by id;
1980
IF(my_date, 'IS TRUE', 'IS NOT TRUE') my_date id
1982
IS TRUE 0001-01-01 2
1983
IS TRUE 9999-12-31 3
1984
IS TRUE 2004-02-29 4
1985
IS TRUE 2005-06-28 5
1986
SHOW CREATE VIEW v1;
1987
View Create View character_set_client collation_connection
1988
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(`t1_values`.`my_date`,'IS TRUE','IS NOT TRUE') AS `IF(my_date, 'IS TRUE', 'IS NOT TRUE')`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1990
WHERE v1.id IN (SELECT id FROM t1_values
1991
WHERE select_id = 111 OR select_id IS NULL) order by id;
1992
IF(my_date, 'IS TRUE', 'IS NOT TRUE') my_date id
1994
IS TRUE 0001-01-01 2
1995
IS TRUE 9999-12-31 3
1996
IS TRUE 2004-02-29 4
1997
IS TRUE 2005-06-28 5
2001
CREATE VIEW v1 AS SELECT IF(my_datetime, 'IS TRUE', 'IS NOT TRUE'),
2002
my_datetime, id FROM t1_values;
2003
SELECT IF(my_datetime, 'IS TRUE', 'IS NOT TRUE'),
2004
my_datetime, id FROM t1_values
2005
WHERE select_id = 110 OR select_id IS NULL order by id;
2006
IF(my_datetime, 'IS TRUE', 'IS NOT TRUE') my_datetime id
2008
IS TRUE 0001-01-01 00:00:00 2
2009
IS TRUE 9999-12-31 23:59:59 3
2010
IS TRUE 2004-02-29 23:59:59 4
2011
IS TRUE 2005-06-28 10:00:00 5
2012
SHOW CREATE VIEW v1;
2013
View Create View character_set_client collation_connection
2014
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(`t1_values`.`my_datetime`,'IS TRUE','IS NOT TRUE') AS `IF(my_datetime, 'IS TRUE', 'IS NOT TRUE')`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2016
WHERE v1.id IN (SELECT id FROM t1_values
2017
WHERE select_id = 110 OR select_id IS NULL) order by id;
2018
IF(my_datetime, 'IS TRUE', 'IS NOT TRUE') my_datetime id
2020
IS TRUE 0001-01-01 00:00:00 2
2021
IS TRUE 9999-12-31 23:59:59 3
2022
IS TRUE 2004-02-29 23:59:59 4
2023
IS TRUE 2005-06-28 10:00:00 5
2027
CREATE VIEW v1 AS SELECT IF(my_double, 'IS TRUE', 'IS NOT TRUE'),
2028
my_double, id FROM t1_values;
2029
SELECT IF(my_double, 'IS TRUE', 'IS NOT TRUE'),
2030
my_double, id FROM t1_values
2031
WHERE select_id = 109 OR select_id IS NULL order by id;
2032
IF(my_double, 'IS TRUE', 'IS NOT TRUE') my_double id
2034
IS TRUE -1.7976931348623e308 2
2035
IS TRUE 1.7976931348623e308 3
2038
SHOW CREATE VIEW v1;
2039
View Create View character_set_client collation_connection
2040
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(`t1_values`.`my_double`,'IS TRUE','IS NOT TRUE') AS `IF(my_double, 'IS TRUE', 'IS NOT TRUE')`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2042
WHERE v1.id IN (SELECT id FROM t1_values
2043
WHERE select_id = 109 OR select_id IS NULL) order by id;
2044
IF(my_double, 'IS TRUE', 'IS NOT TRUE') my_double id
2046
IS TRUE -1.7976931348623e308 2
2047
IS TRUE 1.7976931348623e308 3
2053
CREATE VIEW v1 AS SELECT IF(my_decimal, 'IS TRUE', 'IS NOT TRUE'),
2054
my_decimal, id FROM t1_values;
2055
SELECT IF(my_decimal, 'IS TRUE', 'IS NOT TRUE'),
2056
my_decimal, id FROM t1_values
2057
WHERE select_id = 108 OR select_id IS NULL order by id;
2058
IF(my_decimal, 'IS TRUE', 'IS NOT TRUE') my_decimal id
2060
IS TRUE -9999999999999999999999999999999999.999999999999999999999999999999 2
2061
IS TRUE 9999999999999999999999999999999999.999999999999999999999999999999 3
2062
IS NOT TRUE 0.000000000000000000000000000000 4
2063
IS TRUE -1.000000000000000000000000000000 5
2064
SHOW CREATE VIEW v1;
2065
View Create View character_set_client collation_connection
2066
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(`t1_values`.`my_decimal`,'IS TRUE','IS NOT TRUE') AS `IF(my_decimal, 'IS TRUE', 'IS NOT TRUE')`,`t1_values`.`my_decimal` AS `my_decimal`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2068
WHERE v1.id IN (SELECT id FROM t1_values
2069
WHERE select_id = 108 OR select_id IS NULL) order by id;
2070
IF(my_decimal, 'IS TRUE', 'IS NOT TRUE') my_decimal id
2072
IS TRUE -9999999999999999999999999999999999.999999999999999999999999999999 2
2073
IS TRUE 9999999999999999999999999999999999.999999999999999999999999999999 3
2074
IS NOT TRUE 0.000000000000000000000000000000 4
2075
IS TRUE -1.000000000000000000000000000000 5
2079
CREATE VIEW v1 AS SELECT IF(my_bigint, 'IS TRUE', 'IS NOT TRUE'),
2080
my_bigint, id FROM t1_values;
2081
SELECT IF(my_bigint, 'IS TRUE', 'IS NOT TRUE'),
2082
my_bigint, id FROM t1_values
2083
WHERE select_id = 107 OR select_id IS NULL order by id;
2084
IF(my_bigint, 'IS TRUE', 'IS NOT TRUE') my_bigint id
2086
IS TRUE -9223372036854775808 2
2087
IS TRUE 9223372036854775807 3
2090
SHOW CREATE VIEW v1;
2091
View Create View character_set_client collation_connection
2092
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(`t1_values`.`my_bigint`,'IS TRUE','IS NOT TRUE') AS `IF(my_bigint, 'IS TRUE', 'IS NOT TRUE')`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2094
WHERE v1.id IN (SELECT id FROM t1_values
2095
WHERE select_id = 107 OR select_id IS NULL) order by id;
2096
IF(my_bigint, 'IS TRUE', 'IS NOT TRUE') my_bigint id
2098
IS TRUE -9223372036854775808 2
2099
IS TRUE 9223372036854775807 3
2105
CREATE VIEW v1 AS SELECT IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE'),
2106
my_varbinary_1000, id FROM t1_values;
2107
SELECT IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE'),
2108
my_varbinary_1000, id FROM t1_values
2109
WHERE select_id = 106 OR select_id IS NULL order by id;
2110
IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE') my_varbinary_1000 id
2113
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2114
IS NOT TRUE ---äÖüß@µ*$-- 4
2116
SHOW CREATE VIEW v1;
2117
View Create View character_set_client collation_connection
2118
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(`t1_values`.`my_varbinary_1000`,'IS TRUE','IS NOT TRUE') AS `IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE')`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2120
WHERE v1.id IN (SELECT id FROM t1_values
2121
WHERE select_id = 106 OR select_id IS NULL) order by id;
2122
IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE') my_varbinary_1000 id
2125
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2126
IS NOT TRUE ---äÖüß@µ*$-- 4
2131
CREATE VIEW v1 AS SELECT IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE'),
2132
my_binary_30, id FROM t1_values;
2133
SELECT IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE'),
2134
my_binary_30, id FROM t1_values
2135
WHERE select_id = 105 OR select_id IS NULL order by id;
2136
IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE') my_binary_30 id
2139
IS NOT TRUE <--------30 characters-------> 3
2140
IS NOT TRUE ---äÖüß@µ*$-- 4
2143
Warning 1292 Truncated incorrect DOUBLE value: ''
2144
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2145
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2146
Warning 1292 Truncated incorrect DOUBLE value: '-1'
2147
SHOW CREATE VIEW v1;
2148
View Create View character_set_client collation_connection
2149
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(`t1_values`.`my_binary_30`,'IS TRUE','IS NOT TRUE') AS `IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE')`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2151
WHERE v1.id IN (SELECT id FROM t1_values
2152
WHERE select_id = 105 OR select_id IS NULL) order by id;
2153
IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE') my_binary_30 id
2156
IS NOT TRUE <--------30 characters-------> 3
2157
IS NOT TRUE ---äÖüß@µ*$-- 4
2160
Warning 1292 Truncated incorrect DOUBLE value: ''
2161
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2162
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2163
Warning 1292 Truncated incorrect DOUBLE value: '-1'
2167
CREATE VIEW v1 AS SELECT IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE'),
2168
my_varchar_1000, id FROM t1_values;
2169
SELECT IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE'),
2170
my_varchar_1000, id FROM t1_values
2171
WHERE select_id = 104 OR select_id IS NULL order by id;
2172
IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE') my_varchar_1000 id
2175
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2176
IS NOT TRUE ---äÖüß@µ*$-- 4
2178
SHOW CREATE VIEW v1;
2179
View Create View character_set_client collation_connection
2180
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(`t1_values`.`my_varchar_1000`,'IS TRUE','IS NOT TRUE') AS `IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE')`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2182
WHERE v1.id IN (SELECT id FROM t1_values
2183
WHERE select_id = 104 OR select_id IS NULL) order by id;
2184
IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE') my_varchar_1000 id
2187
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2188
IS NOT TRUE ---äÖüß@µ*$-- 4
2193
CREATE VIEW v1 AS SELECT IF(my_char_30, 'IS TRUE', 'IS NOT TRUE'),
2194
my_char_30, id FROM t1_values;
2195
SELECT IF(my_char_30, 'IS TRUE', 'IS NOT TRUE'),
2196
my_char_30, id FROM t1_values
2197
WHERE select_id = 103 OR select_id IS NULL order by id;
2198
IF(my_char_30, 'IS TRUE', 'IS NOT TRUE') my_char_30 id
2201
IS NOT TRUE <--------30 characters-------> 3
2202
IS NOT TRUE ---äÖüß@µ*$-- 4
2205
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2206
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2207
SHOW CREATE VIEW v1;
2208
View Create View character_set_client collation_connection
2209
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select if(`t1_values`.`my_char_30`,'IS TRUE','IS NOT TRUE') AS `IF(my_char_30, 'IS TRUE', 'IS NOT TRUE')`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2211
WHERE v1.id IN (SELECT id FROM t1_values
2212
WHERE select_id = 103 OR select_id IS NULL) order by id;
2213
IF(my_char_30, 'IS TRUE', 'IS NOT TRUE') my_char_30 id
2216
IS NOT TRUE <--------30 characters-------> 3
2217
IS NOT TRUE ---äÖüß@µ*$-- 4
2220
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2221
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2225
CREATE VIEW v1 AS SELECT CONVERT(my_varbinary_1000 USING koi8r),
2226
my_varbinary_1000, id FROM t1_values;
2227
SELECT CONVERT(my_varbinary_1000 USING koi8r),
2228
my_varbinary_1000, id FROM t1_values
2229
WHERE select_id = 102 OR select_id IS NULL order by id;
2230
CONVERT(my_varbinary_1000 USING koi8r) my_varbinary_1000 id
2233
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2234
---???????�@??*$-- ---äÖüß@µ*$-- 4
2236
SHOW CREATE VIEW v1;
2237
View Create View character_set_client collation_connection
2238
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select convert(`t1_values`.`my_varbinary_1000` using koi8r) AS `CONVERT(my_varbinary_1000 USING koi8r)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2240
WHERE v1.id IN (SELECT id FROM t1_values
2241
WHERE select_id = 102 OR select_id IS NULL) order by id;
2242
CONVERT(my_varbinary_1000 USING koi8r) my_varbinary_1000 id
2245
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2246
---???????�@??*$-- ---äÖüß@µ*$-- 4
2251
CREATE VIEW v1 AS SELECT CONVERT(my_binary_30 USING koi8r),
2252
my_binary_30, id FROM t1_values;
2253
SELECT CONVERT(my_binary_30 USING koi8r),
2254
my_binary_30, id FROM t1_values
2255
WHERE select_id = 101 OR select_id IS NULL order by id;
2256
CONVERT(my_binary_30 USING koi8r) my_binary_30 id
2259
<--------30 characters-------> <--------30 characters-------> 3
2260
---???????�@??*$-- ---äÖüß@µ*$-- 4
2262
SHOW CREATE VIEW v1;
2263
View Create View character_set_client collation_connection
2264
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select convert(`t1_values`.`my_binary_30` using koi8r) AS `CONVERT(my_binary_30 USING koi8r)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2266
WHERE v1.id IN (SELECT id FROM t1_values
2267
WHERE select_id = 101 OR select_id IS NULL) order by id;
2268
CONVERT(my_binary_30 USING koi8r) my_binary_30 id
2271
<--------30 characters-------> <--------30 characters-------> 3
2272
---???????�@??*$-- ---äÖüß@µ*$-- 4
2277
CREATE VIEW v1 AS SELECT CONVERT(my_varchar_1000 USING koi8r),
2278
my_varchar_1000, id FROM t1_values;
2279
SELECT CONVERT(my_varchar_1000 USING koi8r),
2280
my_varchar_1000, id FROM t1_values
2281
WHERE select_id = 100 OR select_id IS NULL order by id;
2282
CONVERT(my_varchar_1000 USING koi8r) my_varchar_1000 id
2285
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2286
---????????@??*$-- ---äÖüß@µ*$-- 4
2288
SHOW CREATE VIEW v1;
2289
View Create View character_set_client collation_connection
2290
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select convert(`t1_values`.`my_varchar_1000` using koi8r) AS `CONVERT(my_varchar_1000 USING koi8r)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2292
WHERE v1.id IN (SELECT id FROM t1_values
2293
WHERE select_id = 100 OR select_id IS NULL) order by id;
2294
CONVERT(my_varchar_1000 USING koi8r) my_varchar_1000 id
2297
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2298
---????????@??*$-- ---äÖüß@µ*$-- 4
2303
CREATE VIEW v1 AS SELECT CONVERT(my_char_30 USING koi8r),
2304
my_char_30, id FROM t1_values;
2305
SELECT CONVERT(my_char_30 USING koi8r),
2306
my_char_30, id FROM t1_values
2307
WHERE select_id = 99 OR select_id IS NULL order by id;
2308
CONVERT(my_char_30 USING koi8r) my_char_30 id
2311
<--------30 characters-------> <--------30 characters-------> 3
2312
---????????@??*$-- ---äÖüß@µ*$-- 4
2314
SHOW CREATE VIEW v1;
2315
View Create View character_set_client collation_connection
2316
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select convert(`t1_values`.`my_char_30` using koi8r) AS `CONVERT(my_char_30 USING koi8r)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2318
WHERE v1.id IN (SELECT id FROM t1_values
2319
WHERE select_id = 99 OR select_id IS NULL) order by id;
2320
CONVERT(my_char_30 USING koi8r) my_char_30 id
2323
<--------30 characters-------> <--------30 characters-------> 3
2324
---????????@??*$-- ---äÖüß@µ*$-- 4
2329
CREATE VIEW v1 AS SELECT CONVERT(my_varbinary_1000 USING utf8),
2330
my_varbinary_1000, id FROM t1_values;
2331
SELECT CONVERT(my_varbinary_1000 USING utf8),
2332
my_varbinary_1000, id FROM t1_values
2333
WHERE select_id = 98 OR select_id IS NULL order by id;
2334
CONVERT(my_varbinary_1000 USING utf8) my_varbinary_1000 id
2337
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2338
---����@�*$-- ---äÖüß@µ*$-- 4
2340
SHOW CREATE VIEW v1;
2341
View Create View character_set_client collation_connection
2342
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select convert(`t1_values`.`my_varbinary_1000` using utf8) AS `CONVERT(my_varbinary_1000 USING utf8)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2344
WHERE v1.id IN (SELECT id FROM t1_values
2345
WHERE select_id = 98 OR select_id IS NULL) order by id;
2346
CONVERT(my_varbinary_1000 USING utf8) my_varbinary_1000 id
2349
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2350
---����@�*$-- ---äÖüß@µ*$-- 4
2355
CREATE VIEW v1 AS SELECT CONVERT(my_binary_30 USING utf8),
2356
my_binary_30, id FROM t1_values;
2357
SELECT CONVERT(my_binary_30 USING utf8),
2358
my_binary_30, id FROM t1_values
2359
WHERE select_id = 97 OR select_id IS NULL order by id;
2360
CONVERT(my_binary_30 USING utf8) my_binary_30 id
2363
<--------30 characters-------> <--------30 characters-------> 3
2364
---����@�*$-- ---äÖüß@µ*$-- 4
2366
SHOW CREATE VIEW v1;
2367
View Create View character_set_client collation_connection
2368
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select convert(`t1_values`.`my_binary_30` using utf8) AS `CONVERT(my_binary_30 USING utf8)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2370
WHERE v1.id IN (SELECT id FROM t1_values
2371
WHERE select_id = 97 OR select_id IS NULL) order by id;
2372
CONVERT(my_binary_30 USING utf8) my_binary_30 id
2375
<--------30 characters-------> <--------30 characters-------> 3
2376
---����@�*$-- ---äÖüß@µ*$-- 4
2381
CREATE VIEW v1 AS SELECT CONVERT(my_varchar_1000 USING utf8),
2382
my_varchar_1000, id FROM t1_values;
2383
SELECT CONVERT(my_varchar_1000 USING utf8),
2384
my_varchar_1000, id FROM t1_values
2385
WHERE select_id = 96 OR select_id IS NULL order by id;
2386
CONVERT(my_varchar_1000 USING utf8) my_varchar_1000 id
2389
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2390
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2392
SHOW CREATE VIEW v1;
2393
View Create View character_set_client collation_connection
2394
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select convert(`t1_values`.`my_varchar_1000` using utf8) AS `CONVERT(my_varchar_1000 USING utf8)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2396
WHERE v1.id IN (SELECT id FROM t1_values
2397
WHERE select_id = 96 OR select_id IS NULL) order by id;
2398
CONVERT(my_varchar_1000 USING utf8) my_varchar_1000 id
2401
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2402
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2407
CREATE VIEW v1 AS SELECT CONVERT(my_char_30 USING utf8),
2408
my_char_30, id FROM t1_values;
2409
SELECT CONVERT(my_char_30 USING utf8),
2410
my_char_30, id FROM t1_values
2411
WHERE select_id = 95 OR select_id IS NULL order by id;
2412
CONVERT(my_char_30 USING utf8) my_char_30 id
2415
<--------30 characters-------> <--------30 characters-------> 3
2416
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2418
SHOW CREATE VIEW v1;
2419
View Create View character_set_client collation_connection
2420
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select convert(`t1_values`.`my_char_30` using utf8) AS `CONVERT(my_char_30 USING utf8)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2422
WHERE v1.id IN (SELECT id FROM t1_values
2423
WHERE select_id = 95 OR select_id IS NULL) order by id;
2424
CONVERT(my_char_30 USING utf8) my_char_30 id
2427
<--------30 characters-------> <--------30 characters-------> 3
2428
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2433
CREATE VIEW v1 AS SELECT CAST(my_year AS UNSIGNED INTEGER),
2434
my_year, id FROM t1_values;
2435
SELECT CAST(my_year AS UNSIGNED INTEGER),
2436
my_year, id FROM t1_values
2437
WHERE select_id = 94 OR select_id IS NULL order by id;
2438
CAST(my_year AS UNSIGNED INTEGER) my_year id
2444
SHOW CREATE VIEW v1;
2445
View Create View character_set_client collation_connection
2446
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_year` as unsigned) AS `CAST(my_year AS UNSIGNED INTEGER)`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2448
WHERE v1.id IN (SELECT id FROM t1_values
2449
WHERE select_id = 94 OR select_id IS NULL) order by id;
2450
CAST(my_year AS UNSIGNED INTEGER) my_year id
2459
CREATE VIEW v1 AS SELECT CAST(my_time AS UNSIGNED INTEGER),
2460
my_time, id FROM t1_values;
2461
SELECT CAST(my_time AS UNSIGNED INTEGER),
2462
my_time, id FROM t1_values
2463
WHERE select_id = 93 OR select_id IS NULL order by id;
2464
CAST(my_time AS UNSIGNED INTEGER) my_time id
2466
18446744073701165657 -838:59:59 2
2470
SHOW CREATE VIEW v1;
2471
View Create View character_set_client collation_connection
2472
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_time` as unsigned) AS `CAST(my_time AS UNSIGNED INTEGER)`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2474
WHERE v1.id IN (SELECT id FROM t1_values
2475
WHERE select_id = 93 OR select_id IS NULL) order by id;
2476
CAST(my_time AS UNSIGNED INTEGER) my_time id
2478
18446744073701165657 -838:59:59 2
2485
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS UNSIGNED INTEGER),
2486
my_timestamp, id FROM t1_values;
2487
SELECT CAST(my_timestamp AS UNSIGNED INTEGER),
2488
my_timestamp, id FROM t1_values
2489
WHERE select_id = 92 OR select_id IS NULL order by id;
2490
CAST(my_timestamp AS UNSIGNED INTEGER) my_timestamp id
2491
0 0000-00-00 00:00:00 1
2492
19700101030001 1970-01-01 03:00:01 2
2493
20380101025959 2038-01-01 02:59:59 3
2494
20040229235959 2004-02-29 23:59:59 4
2495
20050628100000 2005-06-28 10:00:00 5
2496
SHOW CREATE VIEW v1;
2497
View Create View character_set_client collation_connection
2498
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_timestamp` as unsigned) AS `CAST(my_timestamp AS UNSIGNED INTEGER)`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2500
WHERE v1.id IN (SELECT id FROM t1_values
2501
WHERE select_id = 92 OR select_id IS NULL) order by id;
2502
CAST(my_timestamp AS UNSIGNED INTEGER) my_timestamp id
2503
0 0000-00-00 00:00:00 1
2504
19700101030001 1970-01-01 03:00:01 2
2505
20380101025959 2038-01-01 02:59:59 3
2506
20040229235959 2004-02-29 23:59:59 4
2507
20050628100000 2005-06-28 10:00:00 5
2511
CREATE VIEW v1 AS SELECT CAST(my_date AS UNSIGNED INTEGER),
2512
my_date, id FROM t1_values;
2513
SELECT CAST(my_date AS UNSIGNED INTEGER),
2514
my_date, id FROM t1_values
2515
WHERE select_id = 91 OR select_id IS NULL order by id;
2516
CAST(my_date AS UNSIGNED INTEGER) my_date id
2519
99991231 9999-12-31 3
2520
20040229 2004-02-29 4
2521
20050628 2005-06-28 5
2522
SHOW CREATE VIEW v1;
2523
View Create View character_set_client collation_connection
2524
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_date` as unsigned) AS `CAST(my_date AS UNSIGNED INTEGER)`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2526
WHERE v1.id IN (SELECT id FROM t1_values
2527
WHERE select_id = 91 OR select_id IS NULL) order by id;
2528
CAST(my_date AS UNSIGNED INTEGER) my_date id
2531
99991231 9999-12-31 3
2532
20040229 2004-02-29 4
2533
20050628 2005-06-28 5
2537
CREATE VIEW v1 AS SELECT CAST(my_datetime AS UNSIGNED INTEGER),
2538
my_datetime, id FROM t1_values;
2539
SELECT CAST(my_datetime AS UNSIGNED INTEGER),
2540
my_datetime, id FROM t1_values
2541
WHERE select_id = 90 OR select_id IS NULL order by id;
2542
CAST(my_datetime AS UNSIGNED INTEGER) my_datetime id
2544
10101000000 0001-01-01 00:00:00 2
2545
99991231235959 9999-12-31 23:59:59 3
2546
20040229235959 2004-02-29 23:59:59 4
2547
20050628100000 2005-06-28 10:00:00 5
2548
SHOW CREATE VIEW v1;
2549
View Create View character_set_client collation_connection
2550
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_datetime` as unsigned) AS `CAST(my_datetime AS UNSIGNED INTEGER)`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2552
WHERE v1.id IN (SELECT id FROM t1_values
2553
WHERE select_id = 90 OR select_id IS NULL) order by id;
2554
CAST(my_datetime AS UNSIGNED INTEGER) my_datetime id
2556
10101000000 0001-01-01 00:00:00 2
2557
99991231235959 9999-12-31 23:59:59 3
2558
20040229235959 2004-02-29 23:59:59 4
2559
20050628100000 2005-06-28 10:00:00 5
2563
CREATE VIEW v1 AS SELECT CAST(my_double AS UNSIGNED INTEGER),
2564
my_double, id FROM t1_values;
2565
SELECT CAST(my_double AS UNSIGNED INTEGER),
2566
my_double, id FROM t1_values
2567
WHERE select_id = 89 OR select_id IS NULL order by id;
2568
CAST(my_double AS UNSIGNED INTEGER) my_double id
2570
9223372036854775808 -1.7976931348623e308 2
2571
9223372036854775807 1.7976931348623e308 3
2573
18446744073709551615 -1 5
2575
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2576
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2577
SHOW CREATE VIEW v1;
2578
View Create View character_set_client collation_connection
2579
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_double` as unsigned) AS `CAST(my_double AS UNSIGNED INTEGER)`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2581
WHERE v1.id IN (SELECT id FROM t1_values
2582
WHERE select_id = 89 OR select_id IS NULL) order by id;
2583
CAST(my_double AS UNSIGNED INTEGER) my_double id
2585
9223372036854775808 -1.7976931348623e308 2
2586
9223372036854775807 1.7976931348623e308 3
2588
18446744073709551615 -1 5
2590
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2591
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2595
CREATE VIEW v1 AS SELECT CAST(my_decimal AS UNSIGNED INTEGER),
2596
my_decimal, id FROM t1_values;
2597
SELECT CAST(my_decimal AS UNSIGNED INTEGER),
2598
my_decimal, id FROM t1_values
2599
WHERE select_id = 88 OR select_id IS NULL order by id;
2600
CAST(my_decimal AS UNSIGNED INTEGER) my_decimal id
2602
0 -9999999999999999999999999999999999.999999999999999999999999999999 2
2603
18446744073709551615 9999999999999999999999999999999999.999999999999999999999999999999 3
2604
0 0.000000000000000000000000000000 4
2605
0 -1.000000000000000000000000000000 5
2607
Error 1292 Truncated incorrect DECIMAL value: ''
2608
Error 1292 Truncated incorrect DECIMAL value: ''
2609
Error 1292 Truncated incorrect DECIMAL value: ''
2610
SHOW CREATE VIEW v1;
2611
View Create View character_set_client collation_connection
2612
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_decimal` as unsigned) AS `CAST(my_decimal AS UNSIGNED INTEGER)`,`t1_values`.`my_decimal` AS `my_decimal`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2614
WHERE v1.id IN (SELECT id FROM t1_values
2615
WHERE select_id = 88 OR select_id IS NULL) order by id;
2616
CAST(my_decimal AS UNSIGNED INTEGER) my_decimal id
2618
0 -9999999999999999999999999999999999.999999999999999999999999999999 2
2619
18446744073709551615 9999999999999999999999999999999999.999999999999999999999999999999 3
2620
0 0.000000000000000000000000000000 4
2621
0 -1.000000000000000000000000000000 5
2623
Error 1292 Truncated incorrect DECIMAL value: ''
2624
Error 1292 Truncated incorrect DECIMAL value: ''
2625
Error 1292 Truncated incorrect DECIMAL value: ''
2629
CREATE VIEW v1 AS SELECT CAST(my_bigint AS UNSIGNED INTEGER),
2630
my_bigint, id FROM t1_values;
2631
SELECT CAST(my_bigint AS UNSIGNED INTEGER),
2632
my_bigint, id FROM t1_values
2633
WHERE select_id = 87 OR select_id IS NULL order by id;
2634
CAST(my_bigint AS UNSIGNED INTEGER) my_bigint id
2636
9223372036854775808 -9223372036854775808 2
2637
9223372036854775807 9223372036854775807 3
2639
18446744073709551615 -1 5
2640
SHOW CREATE VIEW v1;
2641
View Create View character_set_client collation_connection
2642
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as unsigned) AS `CAST(my_bigint AS UNSIGNED INTEGER)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2644
WHERE v1.id IN (SELECT id FROM t1_values
2645
WHERE select_id = 87 OR select_id IS NULL) order by id;
2646
CAST(my_bigint AS UNSIGNED INTEGER) my_bigint id
2648
9223372036854775808 -9223372036854775808 2
2649
9223372036854775807 9223372036854775807 3
2651
18446744073709551615 -1 5
2655
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS UNSIGNED INTEGER),
2656
my_varbinary_1000, id FROM t1_values;
2657
SELECT CAST(my_varbinary_1000 AS UNSIGNED INTEGER),
2658
my_varbinary_1000, id FROM t1_values
2659
WHERE select_id = 86 OR select_id IS NULL order by id;
2660
CAST(my_varbinary_1000 AS UNSIGNED INTEGER) my_varbinary_1000 id
2663
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2665
18446744073709551615 -1 5
2667
Warning 1292 Truncated incorrect INTEGER value: ''
2668
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2669
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2670
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2671
SHOW CREATE VIEW v1;
2672
View Create View character_set_client collation_connection
2673
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varbinary_1000` as unsigned) AS `CAST(my_varbinary_1000 AS UNSIGNED INTEGER)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2675
WHERE v1.id IN (SELECT id FROM t1_values
2676
WHERE select_id = 86 OR select_id IS NULL) order by id;
2677
CAST(my_varbinary_1000 AS UNSIGNED INTEGER) my_varbinary_1000 id
2680
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2682
18446744073709551615 -1 5
2684
Warning 1292 Truncated incorrect INTEGER value: ''
2685
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2686
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2687
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2691
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS UNSIGNED INTEGER),
2692
my_binary_30, id FROM t1_values;
2693
SELECT CAST(my_binary_30 AS UNSIGNED INTEGER),
2694
my_binary_30, id FROM t1_values
2695
WHERE select_id = 85 OR select_id IS NULL order by id;
2696
CAST(my_binary_30 AS UNSIGNED INTEGER) my_binary_30 id
2699
0 <--------30 characters-------> 3
2701
18446744073709551615 -1 5
2703
Warning 1292 Truncated incorrect INTEGER value: ''
2704
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2705
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2706
Warning 1292 Truncated incorrect INTEGER value: '-1'
2707
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2708
SHOW CREATE VIEW v1;
2709
View Create View character_set_client collation_connection
2710
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_binary_30` as unsigned) AS `CAST(my_binary_30 AS UNSIGNED INTEGER)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2712
WHERE v1.id IN (SELECT id FROM t1_values
2713
WHERE select_id = 85 OR select_id IS NULL) order by id;
2714
CAST(my_binary_30 AS UNSIGNED INTEGER) my_binary_30 id
2717
0 <--------30 characters-------> 3
2719
18446744073709551615 -1 5
2721
Warning 1292 Truncated incorrect INTEGER value: ''
2722
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2723
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2724
Warning 1292 Truncated incorrect INTEGER value: '-1'
2725
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2729
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS UNSIGNED INTEGER),
2730
my_varchar_1000, id FROM t1_values;
2731
SELECT CAST(my_varchar_1000 AS UNSIGNED INTEGER),
2732
my_varchar_1000, id FROM t1_values
2733
WHERE select_id = 84 OR select_id IS NULL order by id;
2734
CAST(my_varchar_1000 AS UNSIGNED INTEGER) my_varchar_1000 id
2737
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2739
18446744073709551615 -1 5
2741
Warning 1292 Truncated incorrect INTEGER value: ''
2742
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2743
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2744
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2745
SHOW CREATE VIEW v1;
2746
View Create View character_set_client collation_connection
2747
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varchar_1000` as unsigned) AS `CAST(my_varchar_1000 AS UNSIGNED INTEGER)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2749
WHERE v1.id IN (SELECT id FROM t1_values
2750
WHERE select_id = 84 OR select_id IS NULL) order by id;
2751
CAST(my_varchar_1000 AS UNSIGNED INTEGER) my_varchar_1000 id
2754
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2756
18446744073709551615 -1 5
2758
Warning 1292 Truncated incorrect INTEGER value: ''
2759
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2760
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2761
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2765
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS UNSIGNED INTEGER),
2766
my_char_30, id FROM t1_values;
2767
SELECT CAST(my_char_30 AS UNSIGNED INTEGER),
2768
my_char_30, id FROM t1_values
2769
WHERE select_id = 83 OR select_id IS NULL order by id;
2770
CAST(my_char_30 AS UNSIGNED INTEGER) my_char_30 id
2773
0 <--------30 characters-------> 3
2775
18446744073709551615 -1 5
2777
Warning 1292 Truncated incorrect INTEGER value: ''
2778
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2779
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$--'
2780
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2781
SHOW CREATE VIEW v1;
2782
View Create View character_set_client collation_connection
2783
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_char_30` as unsigned) AS `CAST(my_char_30 AS UNSIGNED INTEGER)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2785
WHERE v1.id IN (SELECT id FROM t1_values
2786
WHERE select_id = 83 OR select_id IS NULL) order by id;
2787
CAST(my_char_30 AS UNSIGNED INTEGER) my_char_30 id
2790
0 <--------30 characters-------> 3
2792
18446744073709551615 -1 5
2794
Warning 1292 Truncated incorrect INTEGER value: ''
2795
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2796
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$--'
2797
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2801
CREATE VIEW v1 AS SELECT CAST(my_year AS SIGNED INTEGER),
2802
my_year, id FROM t1_values;
2803
SELECT CAST(my_year AS SIGNED INTEGER),
2804
my_year, id FROM t1_values
2805
WHERE select_id = 82 OR select_id IS NULL order by id;
2806
CAST(my_year AS SIGNED INTEGER) my_year id
2812
SHOW CREATE VIEW v1;
2813
View Create View character_set_client collation_connection
2814
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_year` as signed) AS `CAST(my_year AS SIGNED INTEGER)`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2816
WHERE v1.id IN (SELECT id FROM t1_values
2817
WHERE select_id = 82 OR select_id IS NULL) order by id;
2818
CAST(my_year AS SIGNED INTEGER) my_year id
2827
CREATE VIEW v1 AS SELECT CAST(my_time AS SIGNED INTEGER),
2828
my_time, id FROM t1_values;
2829
SELECT CAST(my_time AS SIGNED INTEGER),
2830
my_time, id FROM t1_values
2831
WHERE select_id = 81 OR select_id IS NULL order by id;
2832
CAST(my_time AS SIGNED INTEGER) my_time id
2834
-8385959 -838:59:59 2
2838
SHOW CREATE VIEW v1;
2839
View Create View character_set_client collation_connection
2840
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_time` as signed) AS `CAST(my_time AS SIGNED INTEGER)`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2842
WHERE v1.id IN (SELECT id FROM t1_values
2843
WHERE select_id = 81 OR select_id IS NULL) order by id;
2844
CAST(my_time AS SIGNED INTEGER) my_time id
2846
-8385959 -838:59:59 2
2853
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS SIGNED INTEGER),
2854
my_timestamp, id FROM t1_values;
2855
SELECT CAST(my_timestamp AS SIGNED INTEGER),
2856
my_timestamp, id FROM t1_values
2857
WHERE select_id = 80 OR select_id IS NULL order by id;
2858
CAST(my_timestamp AS SIGNED INTEGER) my_timestamp id
2859
0 0000-00-00 00:00:00 1
2860
19700101030001 1970-01-01 03:00:01 2
2861
20380101025959 2038-01-01 02:59:59 3
2862
20040229235959 2004-02-29 23:59:59 4
2863
20050628100000 2005-06-28 10:00:00 5
2864
SHOW CREATE VIEW v1;
2865
View Create View character_set_client collation_connection
2866
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_timestamp` as signed) AS `CAST(my_timestamp AS SIGNED INTEGER)`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2868
WHERE v1.id IN (SELECT id FROM t1_values
2869
WHERE select_id = 80 OR select_id IS NULL) order by id;
2870
CAST(my_timestamp AS SIGNED INTEGER) my_timestamp id
2871
0 0000-00-00 00:00:00 1
2872
19700101030001 1970-01-01 03:00:01 2
2873
20380101025959 2038-01-01 02:59:59 3
2874
20040229235959 2004-02-29 23:59:59 4
2875
20050628100000 2005-06-28 10:00:00 5
2879
CREATE VIEW v1 AS SELECT CAST(my_date AS SIGNED INTEGER),
2880
my_date, id FROM t1_values;
2881
SELECT CAST(my_date AS SIGNED INTEGER),
2882
my_date, id FROM t1_values
2883
WHERE select_id = 79 OR select_id IS NULL order by id;
2884
CAST(my_date AS SIGNED INTEGER) my_date id
2887
99991231 9999-12-31 3
2888
20040229 2004-02-29 4
2889
20050628 2005-06-28 5
2890
SHOW CREATE VIEW v1;
2891
View Create View character_set_client collation_connection
2892
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_date` as signed) AS `CAST(my_date AS SIGNED INTEGER)`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2894
WHERE v1.id IN (SELECT id FROM t1_values
2895
WHERE select_id = 79 OR select_id IS NULL) order by id;
2896
CAST(my_date AS SIGNED INTEGER) my_date id
2899
99991231 9999-12-31 3
2900
20040229 2004-02-29 4
2901
20050628 2005-06-28 5
2905
CREATE VIEW v1 AS SELECT CAST(my_datetime AS SIGNED INTEGER),
2906
my_datetime, id FROM t1_values;
2907
SELECT CAST(my_datetime AS SIGNED INTEGER),
2908
my_datetime, id FROM t1_values
2909
WHERE select_id = 78 OR select_id IS NULL order by id;
2910
CAST(my_datetime AS SIGNED INTEGER) my_datetime id
2912
10101000000 0001-01-01 00:00:00 2
2913
99991231235959 9999-12-31 23:59:59 3
2914
20040229235959 2004-02-29 23:59:59 4
2915
20050628100000 2005-06-28 10:00:00 5
2916
SHOW CREATE VIEW v1;
2917
View Create View character_set_client collation_connection
2918
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_datetime` as signed) AS `CAST(my_datetime AS SIGNED INTEGER)`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2920
WHERE v1.id IN (SELECT id FROM t1_values
2921
WHERE select_id = 78 OR select_id IS NULL) order by id;
2922
CAST(my_datetime AS SIGNED INTEGER) my_datetime id
2924
10101000000 0001-01-01 00:00:00 2
2925
99991231235959 9999-12-31 23:59:59 3
2926
20040229235959 2004-02-29 23:59:59 4
2927
20050628100000 2005-06-28 10:00:00 5
2931
CREATE VIEW v1 AS SELECT CAST(my_double AS SIGNED INTEGER),
2932
my_double, id FROM t1_values;
2933
SELECT CAST(my_double AS SIGNED INTEGER),
2934
my_double, id FROM t1_values
2935
WHERE select_id = 77 OR select_id IS NULL order by id;
2936
CAST(my_double AS SIGNED INTEGER) my_double id
2938
-9223372036854775808 -1.7976931348623e308 2
2939
9223372036854775807 1.7976931348623e308 3
2943
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2944
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2945
SHOW CREATE VIEW v1;
2946
View Create View character_set_client collation_connection
2947
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_double` as signed) AS `CAST(my_double AS SIGNED INTEGER)`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2949
WHERE v1.id IN (SELECT id FROM t1_values
2950
WHERE select_id = 77 OR select_id IS NULL) order by id;
2951
CAST(my_double AS SIGNED INTEGER) my_double id
2953
-9223372036854775808 -1.7976931348623e308 2
2954
9223372036854775807 1.7976931348623e308 3
2958
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2959
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2963
CREATE VIEW v1 AS SELECT CAST(my_decimal AS SIGNED INTEGER),
2964
my_decimal, id FROM t1_values;
2965
SELECT CAST(my_decimal AS SIGNED INTEGER),
2966
my_decimal, id FROM t1_values
2967
WHERE select_id = 76 OR select_id IS NULL order by id;
2968
CAST(my_decimal AS SIGNED INTEGER) my_decimal id
2970
-9223372036854775808 -9999999999999999999999999999999999.999999999999999999999999999999 2
2971
9223372036854775807 9999999999999999999999999999999999.999999999999999999999999999999 3
2972
0 0.000000000000000000000000000000 4
2973
-1 -1.000000000000000000000000000000 5
2975
Error 1292 Truncated incorrect DECIMAL value: ''
2976
Error 1292 Truncated incorrect DECIMAL value: ''
2977
SHOW CREATE VIEW v1;
2978
View Create View character_set_client collation_connection
2979
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_decimal` as signed) AS `CAST(my_decimal AS SIGNED INTEGER)`,`t1_values`.`my_decimal` AS `my_decimal`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
2981
WHERE v1.id IN (SELECT id FROM t1_values
2982
WHERE select_id = 76 OR select_id IS NULL) order by id;
2983
CAST(my_decimal AS SIGNED INTEGER) my_decimal id
2985
-9223372036854775808 -9999999999999999999999999999999999.999999999999999999999999999999 2
2986
9223372036854775807 9999999999999999999999999999999999.999999999999999999999999999999 3
2987
0 0.000000000000000000000000000000 4
2988
-1 -1.000000000000000000000000000000 5
2990
Error 1292 Truncated incorrect DECIMAL value: ''
2991
Error 1292 Truncated incorrect DECIMAL value: ''
2995
CREATE VIEW v1 AS SELECT CAST(my_bigint AS SIGNED INTEGER),
2996
my_bigint, id FROM t1_values;
2997
SELECT CAST(my_bigint AS SIGNED INTEGER),
2998
my_bigint, id FROM t1_values
2999
WHERE select_id = 75 OR select_id IS NULL order by id;
3000
CAST(my_bigint AS SIGNED INTEGER) my_bigint id
3002
-9223372036854775808 -9223372036854775808 2
3003
9223372036854775807 9223372036854775807 3
3006
SHOW CREATE VIEW v1;
3007
View Create View character_set_client collation_connection
3008
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as signed) AS `CAST(my_bigint AS SIGNED INTEGER)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3010
WHERE v1.id IN (SELECT id FROM t1_values
3011
WHERE select_id = 75 OR select_id IS NULL) order by id;
3012
CAST(my_bigint AS SIGNED INTEGER) my_bigint id
3014
-9223372036854775808 -9223372036854775808 2
3015
9223372036854775807 9223372036854775807 3
3021
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS SIGNED INTEGER),
3022
my_varbinary_1000, id FROM t1_values;
3023
SELECT CAST(my_varbinary_1000 AS SIGNED INTEGER),
3024
my_varbinary_1000, id FROM t1_values
3025
WHERE select_id = 74 OR select_id IS NULL order by id;
3026
CAST(my_varbinary_1000 AS SIGNED INTEGER) my_varbinary_1000 id
3029
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3033
Warning 1292 Truncated incorrect INTEGER value: ''
3034
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3035
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3036
SHOW CREATE VIEW v1;
3037
View Create View character_set_client collation_connection
3038
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varbinary_1000` as signed) AS `CAST(my_varbinary_1000 AS SIGNED INTEGER)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3040
WHERE v1.id IN (SELECT id FROM t1_values
3041
WHERE select_id = 74 OR select_id IS NULL) order by id;
3042
CAST(my_varbinary_1000 AS SIGNED INTEGER) my_varbinary_1000 id
3045
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3049
Warning 1292 Truncated incorrect INTEGER value: ''
3050
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3051
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3055
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS SIGNED INTEGER),
3056
my_binary_30, id FROM t1_values;
3057
SELECT CAST(my_binary_30 AS SIGNED INTEGER),
3058
my_binary_30, id FROM t1_values
3059
WHERE select_id = 73 OR select_id IS NULL order by id;
3060
CAST(my_binary_30 AS SIGNED INTEGER) my_binary_30 id
3063
0 <--------30 characters-------> 3
3067
Warning 1292 Truncated incorrect INTEGER value: ''
3068
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3069
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3070
Warning 1292 Truncated incorrect INTEGER value: '-1'
3071
SHOW CREATE VIEW v1;
3072
View Create View character_set_client collation_connection
3073
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_binary_30` as signed) AS `CAST(my_binary_30 AS SIGNED INTEGER)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3075
WHERE v1.id IN (SELECT id FROM t1_values
3076
WHERE select_id = 73 OR select_id IS NULL) order by id;
3077
CAST(my_binary_30 AS SIGNED INTEGER) my_binary_30 id
3080
0 <--------30 characters-------> 3
3084
Warning 1292 Truncated incorrect INTEGER value: ''
3085
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3086
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3087
Warning 1292 Truncated incorrect INTEGER value: '-1'
3091
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS SIGNED INTEGER),
3092
my_varchar_1000, id FROM t1_values;
3093
SELECT CAST(my_varchar_1000 AS SIGNED INTEGER),
3094
my_varchar_1000, id FROM t1_values
3095
WHERE select_id = 72 OR select_id IS NULL order by id;
3096
CAST(my_varchar_1000 AS SIGNED INTEGER) my_varchar_1000 id
3099
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3103
Warning 1292 Truncated incorrect INTEGER value: ''
3104
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3105
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3106
SHOW CREATE VIEW v1;
3107
View Create View character_set_client collation_connection
3108
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varchar_1000` as signed) AS `CAST(my_varchar_1000 AS SIGNED INTEGER)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3110
WHERE v1.id IN (SELECT id FROM t1_values
3111
WHERE select_id = 72 OR select_id IS NULL) order by id;
3112
CAST(my_varchar_1000 AS SIGNED INTEGER) my_varchar_1000 id
3115
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3119
Warning 1292 Truncated incorrect INTEGER value: ''
3120
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3121
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3125
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS SIGNED INTEGER),
3126
my_char_30, id FROM t1_values;
3127
SELECT CAST(my_char_30 AS SIGNED INTEGER),
3128
my_char_30, id FROM t1_values
3129
WHERE select_id = 71 OR select_id IS NULL order by id;
3130
CAST(my_char_30 AS SIGNED INTEGER) my_char_30 id
3133
0 <--------30 characters-------> 3
3137
Warning 1292 Truncated incorrect INTEGER value: ''
3138
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3139
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$--'
3140
SHOW CREATE VIEW v1;
3141
View Create View character_set_client collation_connection
3142
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_char_30` as signed) AS `CAST(my_char_30 AS SIGNED INTEGER)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3144
WHERE v1.id IN (SELECT id FROM t1_values
3145
WHERE select_id = 71 OR select_id IS NULL) order by id;
3146
CAST(my_char_30 AS SIGNED INTEGER) my_char_30 id
3149
0 <--------30 characters-------> 3
3153
Warning 1292 Truncated incorrect INTEGER value: ''
3154
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3155
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$--'
3159
CREATE VIEW v1 AS SELECT CAST(my_year AS DECIMAL(37,2)),
3160
my_year, id FROM t1_values;
3161
SELECT CAST(my_year AS DECIMAL(37,2)),
3162
my_year, id FROM t1_values
3163
WHERE select_id = 70 OR select_id IS NULL order by id;
3164
CAST(my_year AS DECIMAL(37,2)) my_year id
3170
SHOW CREATE VIEW v1;
3171
View Create View character_set_client collation_connection
3172
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_year` as decimal(37,2)) AS `CAST(my_year AS DECIMAL(37,2))`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3174
WHERE v1.id IN (SELECT id FROM t1_values
3175
WHERE select_id = 70 OR select_id IS NULL) order by id;
3176
CAST(my_year AS DECIMAL(37,2)) my_year id
3185
CREATE VIEW v1 AS SELECT CAST(my_time AS DECIMAL(37,2)),
3186
my_time, id FROM t1_values;
3187
SELECT CAST(my_time AS DECIMAL(37,2)),
3188
my_time, id FROM t1_values
3189
WHERE select_id = 69 OR select_id IS NULL order by id;
3190
CAST(my_time AS DECIMAL(37,2)) my_time id
3192
-8385959.00 -838:59:59 2
3193
8385959.00 838:59:59 3
3194
130000.00 13:00:00 4
3195
100000.00 10:00:00 5
3196
SHOW CREATE VIEW v1;
3197
View Create View character_set_client collation_connection
3198
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_time` as decimal(37,2)) AS `CAST(my_time AS DECIMAL(37,2))`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3200
WHERE v1.id IN (SELECT id FROM t1_values
3201
WHERE select_id = 69 OR select_id IS NULL) order by id;
3202
CAST(my_time AS DECIMAL(37,2)) my_time id
3204
-8385959.00 -838:59:59 2
3205
8385959.00 838:59:59 3
3206
130000.00 13:00:00 4
3207
100000.00 10:00:00 5
3211
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DECIMAL(37,2)),
3212
my_timestamp, id FROM t1_values;
3213
SELECT CAST(my_timestamp AS DECIMAL(37,2)),
3214
my_timestamp, id FROM t1_values
3215
WHERE select_id = 68 OR select_id IS NULL order by id;
3216
CAST(my_timestamp AS DECIMAL(37,2)) my_timestamp id
3217
0.00 0000-00-00 00:00:00 1
3218
19700101030001.00 1970-01-01 03:00:01 2
3219
20380101025959.00 2038-01-01 02:59:59 3
3220
20040229235959.00 2004-02-29 23:59:59 4
3221
20050628100000.00 2005-06-28 10:00:00 5
3222
SHOW CREATE VIEW v1;
3223
View Create View character_set_client collation_connection
3224
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_timestamp` as decimal(37,2)) AS `CAST(my_timestamp AS DECIMAL(37,2))`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3226
WHERE v1.id IN (SELECT id FROM t1_values
3227
WHERE select_id = 68 OR select_id IS NULL) order by id;
3228
CAST(my_timestamp AS DECIMAL(37,2)) my_timestamp id
3229
0.00 0000-00-00 00:00:00 1
3230
19700101030001.00 1970-01-01 03:00:01 2
3231
20380101025959.00 2038-01-01 02:59:59 3
3232
20040229235959.00 2004-02-29 23:59:59 4
3233
20050628100000.00 2005-06-28 10:00:00 5
3237
CREATE VIEW v1 AS SELECT CAST(my_date AS DECIMAL(37,2)),
3238
my_date, id FROM t1_values;
3239
SELECT CAST(my_date AS DECIMAL(37,2)),
3240
my_date, id FROM t1_values
3241
WHERE select_id = 67 OR select_id IS NULL order by id;
3242
CAST(my_date AS DECIMAL(37,2)) my_date id
3244
10101.00 0001-01-01 2
3245
99991231.00 9999-12-31 3
3246
20040229.00 2004-02-29 4
3247
20050628.00 2005-06-28 5
3248
SHOW CREATE VIEW v1;
3249
View Create View character_set_client collation_connection
3250
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_date` as decimal(37,2)) AS `CAST(my_date AS DECIMAL(37,2))`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3252
WHERE v1.id IN (SELECT id FROM t1_values
3253
WHERE select_id = 67 OR select_id IS NULL) order by id;
3254
CAST(my_date AS DECIMAL(37,2)) my_date id
3256
10101.00 0001-01-01 2
3257
99991231.00 9999-12-31 3
3258
20040229.00 2004-02-29 4
3259
20050628.00 2005-06-28 5
3263
CREATE VIEW v1 AS SELECT CAST(my_datetime AS DECIMAL(37,2)),
3264
my_datetime, id FROM t1_values;
3265
SELECT CAST(my_datetime AS DECIMAL(37,2)),
3266
my_datetime, id FROM t1_values
3267
WHERE select_id = 66 OR select_id IS NULL order by id;
3268
CAST(my_datetime AS DECIMAL(37,2)) my_datetime id
3270
10101000000.00 0001-01-01 00:00:00 2
3271
99991231235959.00 9999-12-31 23:59:59 3
3272
20040229235959.00 2004-02-29 23:59:59 4
3273
20050628100000.00 2005-06-28 10:00:00 5
3274
SHOW CREATE VIEW v1;
3275
View Create View character_set_client collation_connection
3276
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_datetime` as decimal(37,2)) AS `CAST(my_datetime AS DECIMAL(37,2))`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3278
WHERE v1.id IN (SELECT id FROM t1_values
3279
WHERE select_id = 66 OR select_id IS NULL) order by id;
3280
CAST(my_datetime AS DECIMAL(37,2)) my_datetime id
3282
10101000000.00 0001-01-01 00:00:00 2
3283
99991231235959.00 9999-12-31 23:59:59 3
3284
20040229235959.00 2004-02-29 23:59:59 4
3285
20050628100000.00 2005-06-28 10:00:00 5
3289
CREATE VIEW v1 AS SELECT CAST(my_double AS DECIMAL(37,2)),
3290
my_double, id FROM t1_values;
3291
SELECT CAST(my_double AS DECIMAL(37,2)),
3292
my_double, id FROM t1_values
3293
WHERE select_id = 65 OR select_id IS NULL order by id;
3294
CAST(my_double AS DECIMAL(37,2)) my_double id
3296
-99999999999999999999999999999999999.99 -1.7976931348623e308 2
3297
99999999999999999999999999999999999.99 1.7976931348623e308 3
3300
-3333.33 -3333.3333 30
3302
Error 1292 Truncated incorrect DECIMAL value: ''
3303
Error 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3304
Error 1292 Truncated incorrect DECIMAL value: ''
3305
Error 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3306
SHOW CREATE VIEW v1;
3307
View Create View character_set_client collation_connection
3308
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_double` as decimal(37,2)) AS `CAST(my_double AS DECIMAL(37,2))`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3310
WHERE v1.id IN (SELECT id FROM t1_values
3311
WHERE select_id = 65 OR select_id IS NULL) order by id;
3312
CAST(my_double AS DECIMAL(37,2)) my_double id
3314
-99999999999999999999999999999999999.99 -1.7976931348623e308 2
3315
99999999999999999999999999999999999.99 1.7976931348623e308 3
3318
-3333.33 -3333.3333 30
3320
Error 1292 Truncated incorrect DECIMAL value: ''
3321
Error 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3322
Error 1292 Truncated incorrect DECIMAL value: ''
3323
Error 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3327
CREATE VIEW v1 AS SELECT CAST(my_decimal AS DECIMAL(37,2)),
3328
my_decimal, id FROM t1_values;
3329
SELECT CAST(my_decimal AS DECIMAL(37,2)),
3330
my_decimal, id FROM t1_values
3331
WHERE select_id = 64 OR select_id IS NULL order by id;
3332
CAST(my_decimal AS DECIMAL(37,2)) my_decimal id
3334
-10000000000000000000000000000000000.00 -9999999999999999999999999999999999.999999999999999999999999999999 2
3335
10000000000000000000000000000000000.00 9999999999999999999999999999999999.999999999999999999999999999999 3
3336
0.00 0.000000000000000000000000000000 4
3337
-1.00 -1.000000000000000000000000000000 5
3338
SHOW CREATE VIEW v1;
3339
View Create View character_set_client collation_connection
3340
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_decimal` as decimal(37,2)) AS `CAST(my_decimal AS DECIMAL(37,2))`,`t1_values`.`my_decimal` AS `my_decimal`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3342
WHERE v1.id IN (SELECT id FROM t1_values
3343
WHERE select_id = 64 OR select_id IS NULL) order by id;
3344
CAST(my_decimal AS DECIMAL(37,2)) my_decimal id
3346
-10000000000000000000000000000000000.00 -9999999999999999999999999999999999.999999999999999999999999999999 2
3347
10000000000000000000000000000000000.00 9999999999999999999999999999999999.999999999999999999999999999999 3
3348
0.00 0.000000000000000000000000000000 4
3349
-1.00 -1.000000000000000000000000000000 5
3353
CREATE VIEW v1 AS SELECT CAST(my_bigint AS DECIMAL(37,2)),
3354
my_bigint, id FROM t1_values;
3355
SELECT CAST(my_bigint AS DECIMAL(37,2)),
3356
my_bigint, id FROM t1_values
3357
WHERE select_id = 63 OR select_id IS NULL order by id;
3358
CAST(my_bigint AS DECIMAL(37,2)) my_bigint id
3360
-9223372036854775808.00 -9223372036854775808 2
3361
9223372036854775807.00 9223372036854775807 3
3364
SHOW CREATE VIEW v1;
3365
View Create View character_set_client collation_connection
3366
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as decimal(37,2)) AS `CAST(my_bigint AS DECIMAL(37,2))`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3368
WHERE v1.id IN (SELECT id FROM t1_values
3369
WHERE select_id = 63 OR select_id IS NULL) order by id;
3370
CAST(my_bigint AS DECIMAL(37,2)) my_bigint id
3372
-9223372036854775808.00 -9223372036854775808 2
3373
9223372036854775807.00 9223372036854775807 3
3379
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DECIMAL(37,2)),
3380
my_varbinary_1000, id FROM t1_values;
3381
SELECT CAST(my_varbinary_1000 AS DECIMAL(37,2)),
3382
my_varbinary_1000, id FROM t1_values
3383
WHERE select_id = 62 OR select_id IS NULL order by id;
3384
CAST(my_varbinary_1000 AS DECIMAL(37,2)) my_varbinary_1000 id
3387
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3388
0.00 ---äÖüß@µ*$-- 4
3390
-3333.33 -3333.3333 29
3392
Error 1366 Incorrect decimal value: '' for column '' at row -1
3393
Error 1366 Incorrect decimal value: '' for column '' at row -1
3394
Error 1366 Incorrect decimal value: '' for column '' at row -1
3395
SHOW CREATE VIEW v1;
3396
View Create View character_set_client collation_connection
3397
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varbinary_1000` as decimal(37,2)) AS `CAST(my_varbinary_1000 AS DECIMAL(37,2))`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3399
WHERE v1.id IN (SELECT id FROM t1_values
3400
WHERE select_id = 62 OR select_id IS NULL) order by id;
3401
CAST(my_varbinary_1000 AS DECIMAL(37,2)) my_varbinary_1000 id
3404
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3405
0.00 ---äÖüß@µ*$-- 4
3407
-3333.33 -3333.3333 29
3409
Error 1366 Incorrect decimal value: '' for column '' at row -1
3410
Error 1366 Incorrect decimal value: '' for column '' at row -1
3411
Error 1366 Incorrect decimal value: '' for column '' at row -1
3415
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DECIMAL(37,2)),
3416
my_binary_30, id FROM t1_values;
3417
SELECT CAST(my_binary_30 AS DECIMAL(37,2)),
3418
my_binary_30, id FROM t1_values
3419
WHERE select_id = 61 OR select_id IS NULL order by id;
3420
CAST(my_binary_30 AS DECIMAL(37,2)) my_binary_30 id
3423
0.00 <--------30 characters-------> 3
3424
0.00 ---äÖüß@µ*$-- 4
3426
-3333.33 -3333.3333 28
3428
Error 1366 Incorrect decimal value: '' for column '' at row -1
3429
Warning 1292 Truncated incorrect DECIMAL value: ''
3430
Error 1366 Incorrect decimal value: '' for column '' at row -1
3431
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3432
Error 1366 Incorrect decimal value: '' for column '' at row -1
3433
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3434
Warning 1292 Truncated incorrect DECIMAL value: '-1'
3435
Warning 1292 Truncated incorrect DECIMAL value: '-3333.3333'
3436
SHOW CREATE VIEW v1;
3437
View Create View character_set_client collation_connection
3438
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_binary_30` as decimal(37,2)) AS `CAST(my_binary_30 AS DECIMAL(37,2))`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3440
WHERE v1.id IN (SELECT id FROM t1_values
3441
WHERE select_id = 61 OR select_id IS NULL) order by id;
3442
CAST(my_binary_30 AS DECIMAL(37,2)) my_binary_30 id
3445
0.00 <--------30 characters-------> 3
3446
0.00 ---äÖüß@µ*$-- 4
3448
-3333.33 -3333.3333 28
3450
Error 1366 Incorrect decimal value: '' for column '' at row -1
3451
Warning 1292 Truncated incorrect DECIMAL value: ''
3452
Error 1366 Incorrect decimal value: '' for column '' at row -1
3453
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3454
Error 1366 Incorrect decimal value: '' for column '' at row -1
3455
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3456
Warning 1292 Truncated incorrect DECIMAL value: '-1'
3457
Warning 1292 Truncated incorrect DECIMAL value: '-3333.3333'
3461
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DECIMAL(37,2)),
3462
my_varchar_1000, id FROM t1_values;
3463
SELECT CAST(my_varchar_1000 AS DECIMAL(37,2)),
3464
my_varchar_1000, id FROM t1_values
3465
WHERE select_id = 60 OR select_id IS NULL order by id;
3466
CAST(my_varchar_1000 AS DECIMAL(37,2)) my_varchar_1000 id
3469
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3470
0.00 ---äÖüß@µ*$-- 4
3472
-3333.33 -3333.3333 27
3474
Error 1366 Incorrect decimal value: '' for column '' at row -1
3475
Error 1366 Incorrect decimal value: '' for column '' at row -1
3476
Error 1366 Incorrect decimal value: '' for column '' at row -1
3477
SHOW CREATE VIEW v1;
3478
View Create View character_set_client collation_connection
3479
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varchar_1000` as decimal(37,2)) AS `CAST(my_varchar_1000 AS DECIMAL(37,2))`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3481
WHERE v1.id IN (SELECT id FROM t1_values
3482
WHERE select_id = 60 OR select_id IS NULL) order by id;
3483
CAST(my_varchar_1000 AS DECIMAL(37,2)) my_varchar_1000 id
3486
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3487
0.00 ---äÖüß@µ*$-- 4
3489
-3333.33 -3333.3333 27
3491
Error 1366 Incorrect decimal value: '' for column '' at row -1
3492
Error 1366 Incorrect decimal value: '' for column '' at row -1
3493
Error 1366 Incorrect decimal value: '' for column '' at row -1
3497
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DECIMAL(37,2)),
3498
my_char_30, id FROM t1_values;
3499
SELECT CAST(my_char_30 AS DECIMAL(37,2)),
3500
my_char_30, id FROM t1_values
3501
WHERE select_id = 59 OR select_id IS NULL order by id;
3502
CAST(my_char_30 AS DECIMAL(37,2)) my_char_30 id
3505
0.00 <--------30 characters-------> 3
3506
0.00 ---äÖüß@µ*$-- 4
3508
-3333.33 -3333.3333 26
3510
Error 1366 Incorrect decimal value: '' for column '' at row -1
3511
Warning 1292 Truncated incorrect DECIMAL value: ' '
3512
Error 1366 Incorrect decimal value: '' for column '' at row -1
3513
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3514
Error 1366 Incorrect decimal value: '' for column '' at row -1
3515
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3516
SHOW CREATE VIEW v1;
3517
View Create View character_set_client collation_connection
3518
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_char_30` as decimal(37,2)) AS `CAST(my_char_30 AS DECIMAL(37,2))`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3520
WHERE v1.id IN (SELECT id FROM t1_values
3521
WHERE select_id = 59 OR select_id IS NULL) order by id;
3522
CAST(my_char_30 AS DECIMAL(37,2)) my_char_30 id
3525
0.00 <--------30 characters-------> 3
3526
0.00 ---äÖüß@µ*$-- 4
3528
-3333.33 -3333.3333 26
3530
Error 1366 Incorrect decimal value: '' for column '' at row -1
3531
Warning 1292 Truncated incorrect DECIMAL value: ' '
3532
Error 1366 Incorrect decimal value: '' for column '' at row -1
3533
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3534
Error 1366 Incorrect decimal value: '' for column '' at row -1
3535
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3539
CREATE VIEW v1 AS SELECT CAST(my_year AS TIME),
3540
my_year, id FROM t1_values;
3541
SELECT CAST(my_year AS TIME),
3542
my_year, id FROM t1_values
3543
WHERE select_id = 58 OR select_id IS NULL order by id;
3544
CAST(my_year AS TIME) my_year id
3550
SHOW CREATE VIEW v1;
3551
View Create View character_set_client collation_connection
3552
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_year` as time) AS `CAST(my_year AS TIME)`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3554
WHERE v1.id IN (SELECT id FROM t1_values
3555
WHERE select_id = 58 OR select_id IS NULL) order by id;
3556
CAST(my_year AS TIME) my_year id
3565
CREATE VIEW v1 AS SELECT CAST(my_time AS TIME),
3566
my_time, id FROM t1_values;
3567
SELECT CAST(my_time AS TIME),
3568
my_time, id FROM t1_values
3569
WHERE select_id = 57 OR select_id IS NULL order by id;
3570
CAST(my_time AS TIME) my_time id
3572
-838:59:59 -838:59:59 2
3573
838:59:59 838:59:59 3
3576
SHOW CREATE VIEW v1;
3577
View Create View character_set_client collation_connection
3578
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_time` as time) AS `CAST(my_time AS TIME)`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3580
WHERE v1.id IN (SELECT id FROM t1_values
3581
WHERE select_id = 57 OR select_id IS NULL) order by id;
3582
CAST(my_time AS TIME) my_time id
3584
-838:59:59 -838:59:59 2
3585
838:59:59 838:59:59 3
3591
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS TIME),
3592
my_timestamp, id FROM t1_values;
3593
SELECT CAST(my_timestamp AS TIME),
3594
my_timestamp, id FROM t1_values
3595
WHERE select_id = 56 OR select_id IS NULL order by id;
3596
CAST(my_timestamp AS TIME) my_timestamp id
3597
00:00:00 0000-00-00 00:00:00 1
3598
03:00:01 1970-01-01 03:00:01 2
3599
02:59:59 2038-01-01 02:59:59 3
3600
23:59:59 2004-02-29 23:59:59 4
3601
10:00:00 2005-06-28 10:00:00 5
3602
SHOW CREATE VIEW v1;
3603
View Create View character_set_client collation_connection
3604
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_timestamp` as time) AS `CAST(my_timestamp AS TIME)`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3606
WHERE v1.id IN (SELECT id FROM t1_values
3607
WHERE select_id = 56 OR select_id IS NULL) order by id;
3608
CAST(my_timestamp AS TIME) my_timestamp id
3609
00:00:00 0000-00-00 00:00:00 1
3610
03:00:01 1970-01-01 03:00:01 2
3611
02:59:59 2038-01-01 02:59:59 3
3612
23:59:59 2004-02-29 23:59:59 4
3613
10:00:00 2005-06-28 10:00:00 5
3617
CREATE VIEW v1 AS SELECT CAST(my_date AS TIME),
3618
my_date, id FROM t1_values;
3619
SELECT CAST(my_date AS TIME),
3620
my_date, id FROM t1_values
3621
WHERE select_id = 55 OR select_id IS NULL order by id;
3622
CAST(my_date AS TIME) my_date id
3624
00:00:00 0001-01-01 2
3625
00:00:00 9999-12-31 3
3626
00:00:00 2004-02-29 4
3627
00:00:00 2005-06-28 5
3628
SHOW CREATE VIEW v1;
3629
View Create View character_set_client collation_connection
3630
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_date` as time) AS `CAST(my_date AS TIME)`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3632
WHERE v1.id IN (SELECT id FROM t1_values
3633
WHERE select_id = 55 OR select_id IS NULL) order by id;
3634
CAST(my_date AS TIME) my_date id
3636
00:00:00 0001-01-01 2
3637
00:00:00 9999-12-31 3
3638
00:00:00 2004-02-29 4
3639
00:00:00 2005-06-28 5
3643
CREATE VIEW v1 AS SELECT CAST(my_datetime AS TIME),
3644
my_datetime, id FROM t1_values;
3645
SELECT CAST(my_datetime AS TIME),
3646
my_datetime, id FROM t1_values
3647
WHERE select_id = 54 OR select_id IS NULL order by id;
3648
CAST(my_datetime AS TIME) my_datetime id
3650
00:00:00 0001-01-01 00:00:00 2
3651
23:59:59 9999-12-31 23:59:59 3
3652
23:59:59 2004-02-29 23:59:59 4
3653
10:00:00 2005-06-28 10:00:00 5
3654
SHOW CREATE VIEW v1;
3655
View Create View character_set_client collation_connection
3656
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_datetime` as time) AS `CAST(my_datetime AS TIME)`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3658
WHERE v1.id IN (SELECT id FROM t1_values
3659
WHERE select_id = 54 OR select_id IS NULL) order by id;
3660
CAST(my_datetime AS TIME) my_datetime id
3662
00:00:00 0001-01-01 00:00:00 2
3663
23:59:59 9999-12-31 23:59:59 3
3664
23:59:59 2004-02-29 23:59:59 4
3665
10:00:00 2005-06-28 10:00:00 5
3669
CREATE VIEW v1 AS SELECT CAST(my_double AS TIME),
3670
my_double, id FROM t1_values;
3671
SELECT CAST(my_double AS TIME),
3672
my_double, id FROM t1_values
3673
WHERE select_id = 53 OR select_id IS NULL order by id;
3674
CAST(my_double AS TIME) my_double id
3676
NULL -1.7976931348623e308 2
3677
NULL 1.7976931348623e308 3
3682
Warning 1292 Truncated incorrect time value: '-1.7976931348623e308'
3683
Warning 1292 Truncated incorrect time value: '1.7976931348623e308'
3684
SHOW CREATE VIEW v1;
3685
View Create View character_set_client collation_connection
3686
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_double` as time) AS `CAST(my_double AS TIME)`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3688
WHERE v1.id IN (SELECT id FROM t1_values
3689
WHERE select_id = 53 OR select_id IS NULL) order by id;
3690
CAST(my_double AS TIME) my_double id
3692
NULL -1.7976931348623e308 2
3693
NULL 1.7976931348623e308 3
3698
Warning 1292 Truncated incorrect time value: '-1.7976931348623e308'
3699
Warning 1292 Truncated incorrect time value: '1.7976931348623e308'
3703
CREATE VIEW v1 AS SELECT CAST(my_bigint AS TIME),
3704
my_bigint, id FROM t1_values;
3705
SELECT CAST(my_bigint AS TIME),
3706
my_bigint, id FROM t1_values
3707
WHERE select_id = 52 OR select_id IS NULL order by id;
3708
CAST(my_bigint AS TIME) my_bigint id
3710
NULL -9223372036854775808 2
3711
NULL 9223372036854775807 3
3716
Warning 1292 Truncated incorrect time value: '-9223372036854775808'
3717
Warning 1292 Truncated incorrect time value: '9223372036854775807'
3718
SHOW CREATE VIEW v1;
3719
View Create View character_set_client collation_connection
3720
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as time) AS `CAST(my_bigint AS TIME)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3722
WHERE v1.id IN (SELECT id FROM t1_values
3723
WHERE select_id = 52 OR select_id IS NULL) order by id;
3724
CAST(my_bigint AS TIME) my_bigint id
3726
NULL -9223372036854775808 2
3727
NULL 9223372036854775807 3
3732
Warning 1292 Truncated incorrect time value: '-9223372036854775808'
3733
Warning 1292 Truncated incorrect time value: '9223372036854775807'
3737
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS TIME),
3738
my_varbinary_1000, id FROM t1_values;
3739
SELECT CAST(my_varbinary_1000 AS TIME),
3740
my_varbinary_1000, id FROM t1_values
3741
WHERE select_id = 51 OR select_id IS NULL order by id;
3742
CAST(my_varbinary_1000 AS TIME) my_varbinary_1000 id
3745
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3746
-00:00:00 ---äÖüß@µ*$-- 4
3750
Warning 1292 Truncated incorrect time value: ''
3751
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3752
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3753
SHOW CREATE VIEW v1;
3754
View Create View character_set_client collation_connection
3755
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varbinary_1000` as time) AS `CAST(my_varbinary_1000 AS TIME)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3757
WHERE v1.id IN (SELECT id FROM t1_values
3758
WHERE select_id = 51 OR select_id IS NULL) order by id;
3759
CAST(my_varbinary_1000 AS TIME) my_varbinary_1000 id
3762
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3763
-00:00:00 ---äÖüß@µ*$-- 4
3767
Warning 1292 Truncated incorrect time value: ''
3768
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3769
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3773
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS TIME),
3774
my_binary_30, id FROM t1_values;
3775
SELECT CAST(my_binary_30 AS TIME),
3776
my_binary_30, id FROM t1_values
3777
WHERE select_id = 50 OR select_id IS NULL order by id;
3778
CAST(my_binary_30 AS TIME) my_binary_30 id
3781
00:00:00 <--------30 characters-------> 3
3782
-00:00:00 ---äÖüß@µ*$-- 4
3786
Warning 1292 Truncated incorrect time value: ''
3787
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3788
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3789
Warning 1292 Truncated incorrect time value: '-1'
3790
Warning 1292 Truncated incorrect time value: '1 17:58'
3791
SHOW CREATE VIEW v1;
3792
View Create View character_set_client collation_connection
3793
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_binary_30` as time) AS `CAST(my_binary_30 AS TIME)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3795
WHERE v1.id IN (SELECT id FROM t1_values
3796
WHERE select_id = 50 OR select_id IS NULL) order by id;
3797
CAST(my_binary_30 AS TIME) my_binary_30 id
3800
00:00:00 <--------30 characters-------> 3
3801
-00:00:00 ---äÖüß@µ*$-- 4
3805
Warning 1292 Truncated incorrect time value: ''
3806
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3807
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3808
Warning 1292 Truncated incorrect time value: '-1'
3809
Warning 1292 Truncated incorrect time value: '1 17:58'
3813
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS TIME),
3814
my_varchar_1000, id FROM t1_values;
3815
SELECT CAST(my_varchar_1000 AS TIME),
3816
my_varchar_1000, id FROM t1_values
3817
WHERE select_id = 49 OR select_id IS NULL order by id;
3818
CAST(my_varchar_1000 AS TIME) my_varchar_1000 id
3821
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3822
-00:00:00 ---äÖüß@µ*$-- 4
3826
Warning 1292 Truncated incorrect time value: ''
3827
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3828
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3829
SHOW CREATE VIEW v1;
3830
View Create View character_set_client collation_connection
3831
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varchar_1000` as time) AS `CAST(my_varchar_1000 AS TIME)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3833
WHERE v1.id IN (SELECT id FROM t1_values
3834
WHERE select_id = 49 OR select_id IS NULL) order by id;
3835
CAST(my_varchar_1000 AS TIME) my_varchar_1000 id
3838
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3839
-00:00:00 ---äÖüß@µ*$-- 4
3843
Warning 1292 Truncated incorrect time value: ''
3844
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3845
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3849
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS TIME),
3850
my_char_30, id FROM t1_values;
3851
SELECT CAST(my_char_30 AS TIME),
3852
my_char_30, id FROM t1_values
3853
WHERE select_id = 48 OR select_id IS NULL order by id;
3854
CAST(my_char_30 AS TIME) my_char_30 id
3857
00:00:00 <--------30 characters-------> 3
3858
-00:00:00 ---äÖüß@µ*$-- 4
3862
Warning 1292 Truncated incorrect time value: ''
3863
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3864
Warning 1292 Truncated incorrect time value: ' ---����@�*$--'
3865
SHOW CREATE VIEW v1;
3866
View Create View character_set_client collation_connection
3867
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_char_30` as time) AS `CAST(my_char_30 AS TIME)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3869
WHERE v1.id IN (SELECT id FROM t1_values
3870
WHERE select_id = 48 OR select_id IS NULL) order by id;
3871
CAST(my_char_30 AS TIME) my_char_30 id
3874
00:00:00 <--------30 characters-------> 3
3875
-00:00:00 ---äÖüß@µ*$-- 4
3879
Warning 1292 Truncated incorrect time value: ''
3880
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3881
Warning 1292 Truncated incorrect time value: ' ---����@�*$--'
3885
CREATE VIEW v1 AS SELECT CAST(my_year AS DATETIME),
3886
my_year, id FROM t1_values;
3887
SELECT CAST(my_year AS DATETIME),
3888
my_year, id FROM t1_values
3889
WHERE select_id = 47 OR select_id IS NULL order by id;
3890
CAST(my_year AS DATETIME) my_year id
3897
Warning 1292 Incorrect datetime value: '1901'
3898
Warning 1292 Incorrect datetime value: '2155'
3899
Warning 1292 Incorrect datetime value: '2000'
3900
Warning 1292 Incorrect datetime value: '2005'
3901
SHOW CREATE VIEW v1;
3902
View Create View character_set_client collation_connection
3903
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_year` as datetime) AS `CAST(my_year AS DATETIME)`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3905
WHERE v1.id IN (SELECT id FROM t1_values
3906
WHERE select_id = 47 OR select_id IS NULL) order by id;
3907
CAST(my_year AS DATETIME) my_year id
3914
Warning 1292 Incorrect datetime value: '1901'
3915
Warning 1292 Incorrect datetime value: '2155'
3916
Warning 1292 Incorrect datetime value: '2000'
3917
Warning 1292 Incorrect datetime value: '2005'
3921
CREATE VIEW v1 AS SELECT CAST(my_time AS DATETIME),
3922
my_time, id FROM t1_values;
3923
SELECT CAST(my_time AS DATETIME),
3924
my_time, id FROM t1_values
3925
WHERE select_id = 46 OR select_id IS NULL order by id;
3926
CAST(my_time AS DATETIME) my_time id
3928
0000-00-00 00:00:00 -838:59:59 2
3929
0000-00-00 00:00:00 838:59:59 3
3930
0000-00-00 13:00:00 13:00:00 4
3931
0000-00-00 10:00:00 10:00:00 5
3933
Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3934
Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3935
SHOW CREATE VIEW v1;
3936
View Create View character_set_client collation_connection
3937
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_time` as datetime) AS `CAST(my_time AS DATETIME)`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3939
WHERE v1.id IN (SELECT id FROM t1_values
3940
WHERE select_id = 46 OR select_id IS NULL) order by id;
3941
CAST(my_time AS DATETIME) my_time id
3943
0000-00-00 00:00:00 -838:59:59 2
3944
0000-00-00 00:00:00 838:59:59 3
3945
0000-00-00 13:00:00 13:00:00 4
3946
0000-00-00 10:00:00 10:00:00 5
3948
Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3949
Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3953
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DATETIME),
3954
my_timestamp, id FROM t1_values;
3955
SELECT CAST(my_timestamp AS DATETIME),
3956
my_timestamp, id FROM t1_values
3957
WHERE select_id = 45 OR select_id IS NULL order by id;
3958
CAST(my_timestamp AS DATETIME) my_timestamp id
3959
0000-00-00 00:00:00 0000-00-00 00:00:00 1
3960
1970-01-01 03:00:01 1970-01-01 03:00:01 2
3961
2038-01-01 02:59:59 2038-01-01 02:59:59 3
3962
2004-02-29 23:59:59 2004-02-29 23:59:59 4
3963
2005-06-28 10:00:00 2005-06-28 10:00:00 5
3964
SHOW CREATE VIEW v1;
3965
View Create View character_set_client collation_connection
3966
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_timestamp` as datetime) AS `CAST(my_timestamp AS DATETIME)`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3968
WHERE v1.id IN (SELECT id FROM t1_values
3969
WHERE select_id = 45 OR select_id IS NULL) order by id;
3970
CAST(my_timestamp AS DATETIME) my_timestamp id
3971
0000-00-00 00:00:00 0000-00-00 00:00:00 1
3972
1970-01-01 03:00:01 1970-01-01 03:00:01 2
3973
2038-01-01 02:59:59 2038-01-01 02:59:59 3
3974
2004-02-29 23:59:59 2004-02-29 23:59:59 4
3975
2005-06-28 10:00:00 2005-06-28 10:00:00 5
3979
CREATE VIEW v1 AS SELECT CAST(my_date AS DATETIME),
3980
my_date, id FROM t1_values;
3981
SELECT CAST(my_date AS DATETIME),
3982
my_date, id FROM t1_values
3983
WHERE select_id = 44 OR select_id IS NULL order by id;
3984
CAST(my_date AS DATETIME) my_date id
3986
0001-01-01 00:00:00 0001-01-01 2
3987
9999-12-31 00:00:00 9999-12-31 3
3988
2004-02-29 00:00:00 2004-02-29 4
3989
2005-06-28 00:00:00 2005-06-28 5
3990
SHOW CREATE VIEW v1;
3991
View Create View character_set_client collation_connection
3992
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_date` as datetime) AS `CAST(my_date AS DATETIME)`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3994
WHERE v1.id IN (SELECT id FROM t1_values
3995
WHERE select_id = 44 OR select_id IS NULL) order by id;
3996
CAST(my_date AS DATETIME) my_date id
3998
0001-01-01 00:00:00 0001-01-01 2
3999
9999-12-31 00:00:00 9999-12-31 3
4000
2004-02-29 00:00:00 2004-02-29 4
4001
2005-06-28 00:00:00 2005-06-28 5
4005
CREATE VIEW v1 AS SELECT CAST(my_datetime AS DATETIME),
4006
my_datetime, id FROM t1_values;
4007
SELECT CAST(my_datetime AS DATETIME),
4008
my_datetime, id FROM t1_values
4009
WHERE select_id = 43 OR select_id IS NULL order by id;
4010
CAST(my_datetime AS DATETIME) my_datetime id
4012
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4013
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4014
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4015
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4016
SHOW CREATE VIEW v1;
4017
View Create View character_set_client collation_connection
4018
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_datetime` as datetime) AS `CAST(my_datetime AS DATETIME)`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4020
WHERE v1.id IN (SELECT id FROM t1_values
4021
WHERE select_id = 43 OR select_id IS NULL) order by id;
4022
CAST(my_datetime AS DATETIME) my_datetime id
4024
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4025
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4026
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4027
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4031
CREATE VIEW v1 AS SELECT CAST(my_double AS DATETIME),
4032
my_double, id FROM t1_values;
4033
SELECT CAST(my_double AS DATETIME),
4034
my_double, id FROM t1_values
4035
WHERE select_id = 42 OR select_id IS NULL order by id;
4036
CAST(my_double AS DATETIME) my_double id
4038
NULL -1.7976931348623e308 2
4039
NULL 1.7976931348623e308 3
4042
NULL 200506271758 19
4044
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4045
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4046
Warning 1292 Incorrect datetime value: '0'
4047
Warning 1292 Incorrect datetime value: '-1'
4048
Warning 1292 Incorrect datetime value: '200506271758'
4049
SHOW CREATE VIEW v1;
4050
View Create View character_set_client collation_connection
4051
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_double` as datetime) AS `CAST(my_double AS DATETIME)`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4053
WHERE v1.id IN (SELECT id FROM t1_values
4054
WHERE select_id = 42 OR select_id IS NULL) order by id;
4055
CAST(my_double AS DATETIME) my_double id
4057
NULL -1.7976931348623e308 2
4058
NULL 1.7976931348623e308 3
4061
NULL 200506271758 19
4063
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4064
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4065
Warning 1292 Incorrect datetime value: '0'
4066
Warning 1292 Incorrect datetime value: '-1'
4067
Warning 1292 Incorrect datetime value: '200506271758'
4071
CREATE VIEW v1 AS SELECT CAST(my_bigint AS DATETIME),
4072
my_bigint, id FROM t1_values;
4073
SELECT CAST(my_bigint AS DATETIME),
4074
my_bigint, id FROM t1_values
4075
WHERE select_id = 41 OR select_id IS NULL order by id;
4076
CAST(my_bigint AS DATETIME) my_bigint id
4078
NULL -9223372036854775808 2
4079
NULL 9223372036854775807 3
4082
NULL 200506271758 18
4084
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4085
Warning 1292 Incorrect datetime value: '9223372036854775807'
4086
Warning 1292 Incorrect datetime value: '0'
4087
Warning 1292 Incorrect datetime value: '-1'
4088
Warning 1292 Incorrect datetime value: '200506271758'
4089
SHOW CREATE VIEW v1;
4090
View Create View character_set_client collation_connection
4091
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as datetime) AS `CAST(my_bigint AS DATETIME)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4093
WHERE v1.id IN (SELECT id FROM t1_values
4094
WHERE select_id = 41 OR select_id IS NULL) order by id;
4095
CAST(my_bigint AS DATETIME) my_bigint id
4097
NULL -9223372036854775808 2
4098
NULL 9223372036854775807 3
4101
NULL 200506271758 18
4103
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4104
Warning 1292 Incorrect datetime value: '9223372036854775807'
4105
Warning 1292 Incorrect datetime value: '0'
4106
Warning 1292 Incorrect datetime value: '-1'
4107
Warning 1292 Incorrect datetime value: '200506271758'
4111
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DATETIME),
4112
my_varbinary_1000, id FROM t1_values;
4113
SELECT CAST(my_varbinary_1000 AS DATETIME),
4114
my_varbinary_1000, id FROM t1_values
4115
WHERE select_id = 40 OR select_id IS NULL order by id;
4116
CAST(my_varbinary_1000 AS DATETIME) my_varbinary_1000 id
4119
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4120
NULL ---äÖüß@µ*$-- 4
4122
2005-06-27 17:58:00 2005-06-27 17:58 17
4124
Warning 1292 Incorrect datetime value: ''
4125
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4126
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4127
Warning 1292 Incorrect datetime value: '-1'
4128
SHOW CREATE VIEW v1;
4129
View Create View character_set_client collation_connection
4130
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varbinary_1000` as datetime) AS `CAST(my_varbinary_1000 AS DATETIME)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4132
WHERE v1.id IN (SELECT id FROM t1_values
4133
WHERE select_id = 40 OR select_id IS NULL) order by id;
4134
CAST(my_varbinary_1000 AS DATETIME) my_varbinary_1000 id
4137
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4138
NULL ---äÖüß@µ*$-- 4
4140
2005-06-27 17:58:00 2005-06-27 17:58 17
4142
Warning 1292 Incorrect datetime value: ''
4143
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4144
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4145
Warning 1292 Incorrect datetime value: '-1'
4149
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DATETIME),
4150
my_binary_30, id FROM t1_values;
4151
SELECT CAST(my_binary_30 AS DATETIME),
4152
my_binary_30, id FROM t1_values
4153
WHERE select_id = 39 OR select_id IS NULL order by id;
4154
CAST(my_binary_30 AS DATETIME) my_binary_30 id
4157
NULL <--------30 characters-------> 3
4158
NULL ---äÖüß@µ*$-- 4
4160
2005-06-27 17:58:00 2005-06-27 17:58 16
4162
Warning 1292 Incorrect datetime value: ''
4163
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4164
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4165
Warning 1292 Incorrect datetime value: '-1'
4166
Warning 1292 Truncated incorrect datetime value: '2005-06-27 17:58'
4167
SHOW CREATE VIEW v1;
4168
View Create View character_set_client collation_connection
4169
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_binary_30` as datetime) AS `CAST(my_binary_30 AS DATETIME)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4171
WHERE v1.id IN (SELECT id FROM t1_values
4172
WHERE select_id = 39 OR select_id IS NULL) order by id;
4173
CAST(my_binary_30 AS DATETIME) my_binary_30 id
4176
NULL <--------30 characters-------> 3
4177
NULL ---äÖüß@µ*$-- 4
4179
2005-06-27 17:58:00 2005-06-27 17:58 16
4181
Warning 1292 Incorrect datetime value: ''
4182
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4183
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4184
Warning 1292 Incorrect datetime value: '-1'
4185
Warning 1292 Truncated incorrect datetime value: '2005-06-27 17:58'
4189
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DATETIME),
4190
my_varchar_1000, id FROM t1_values;
4191
SELECT CAST(my_varchar_1000 AS DATETIME),
4192
my_varchar_1000, id FROM t1_values
4193
WHERE select_id = 38 OR select_id IS NULL order by id;
4194
CAST(my_varchar_1000 AS DATETIME) my_varchar_1000 id
4197
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4198
NULL ---äÖüß@µ*$-- 4
4200
2005-06-27 17:58:00 2005-06-27 17:58 15
4202
Warning 1292 Incorrect datetime value: ''
4203
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4204
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4205
Warning 1292 Incorrect datetime value: '-1'
4206
SHOW CREATE VIEW v1;
4207
View Create View character_set_client collation_connection
4208
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varchar_1000` as datetime) AS `CAST(my_varchar_1000 AS DATETIME)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4210
WHERE v1.id IN (SELECT id FROM t1_values
4211
WHERE select_id = 38 OR select_id IS NULL) order by id;
4212
CAST(my_varchar_1000 AS DATETIME) my_varchar_1000 id
4215
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4216
NULL ---äÖüß@µ*$-- 4
4218
2005-06-27 17:58:00 2005-06-27 17:58 15
4220
Warning 1292 Incorrect datetime value: ''
4221
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4222
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4223
Warning 1292 Incorrect datetime value: '-1'
4227
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DATETIME),
4228
my_char_30, id FROM t1_values;
4229
SELECT CAST(my_char_30 AS DATETIME),
4230
my_char_30, id FROM t1_values
4231
WHERE select_id = 37 OR select_id IS NULL order by id;
4232
CAST(my_char_30 AS DATETIME) my_char_30 id
4235
NULL <--------30 characters-------> 3
4236
NULL ---äÖüß@µ*$-- 4
4238
2005-06-27 17:58:00 2005-06-27 17:58 14
4240
Warning 1292 Incorrect datetime value: ''
4241
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4242
Warning 1292 Incorrect datetime value: ' ---����@�*$--'
4243
Warning 1292 Incorrect datetime value: '-1'
4244
SHOW CREATE VIEW v1;
4245
View Create View character_set_client collation_connection
4246
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_char_30` as datetime) AS `CAST(my_char_30 AS DATETIME)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4248
WHERE v1.id IN (SELECT id FROM t1_values
4249
WHERE select_id = 37 OR select_id IS NULL) order by id;
4250
CAST(my_char_30 AS DATETIME) my_char_30 id
4253
NULL <--------30 characters-------> 3
4254
NULL ---äÖüß@µ*$-- 4
4256
2005-06-27 17:58:00 2005-06-27 17:58 14
4258
Warning 1292 Incorrect datetime value: ''
4259
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4260
Warning 1292 Incorrect datetime value: ' ---����@�*$--'
4261
Warning 1292 Incorrect datetime value: '-1'
4265
CREATE VIEW v1 AS SELECT CAST(my_year AS DATE),
4266
my_year, id FROM t1_values;
4267
SELECT CAST(my_year AS DATE),
4268
my_year, id FROM t1_values
4269
WHERE select_id = 36 OR select_id IS NULL order by id;
4270
CAST(my_year AS DATE) my_year id
4277
Warning 1292 Incorrect datetime value: '1901'
4278
Warning 1292 Incorrect datetime value: '2155'
4279
Warning 1292 Incorrect datetime value: '2000'
4280
Warning 1292 Incorrect datetime value: '2005'
4281
SHOW CREATE VIEW v1;
4282
View Create View character_set_client collation_connection
4283
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_year` as date) AS `CAST(my_year AS DATE)`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4285
WHERE v1.id IN (SELECT id FROM t1_values
4286
WHERE select_id = 36 OR select_id IS NULL) order by id;
4287
CAST(my_year AS DATE) my_year id
4294
Warning 1292 Incorrect datetime value: '1901'
4295
Warning 1292 Incorrect datetime value: '2155'
4296
Warning 1292 Incorrect datetime value: '2000'
4297
Warning 1292 Incorrect datetime value: '2005'
4301
CREATE VIEW v1 AS SELECT CAST(my_time AS DATE),
4302
my_time, id FROM t1_values;
4303
SELECT CAST(my_time AS DATE),
4304
my_time, id FROM t1_values
4305
WHERE select_id = 35 OR select_id IS NULL order by id;
4306
CAST(my_time AS DATE) my_time id
4308
0000-00-00 -838:59:59 2
4309
0000-00-00 838:59:59 3
4310
0000-00-00 13:00:00 4
4311
0000-00-00 10:00:00 5
4312
SHOW CREATE VIEW v1;
4313
View Create View character_set_client collation_connection
4314
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_time` as date) AS `CAST(my_time AS DATE)`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4316
WHERE v1.id IN (SELECT id FROM t1_values
4317
WHERE select_id = 35 OR select_id IS NULL) order by id;
4318
CAST(my_time AS DATE) my_time id
4320
0000-00-00 -838:59:59 2
4321
0000-00-00 838:59:59 3
4322
0000-00-00 13:00:00 4
4323
0000-00-00 10:00:00 5
4327
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DATE),
4328
my_timestamp, id FROM t1_values;
4329
SELECT CAST(my_timestamp AS DATE),
4330
my_timestamp, id FROM t1_values
4331
WHERE select_id = 34 OR select_id IS NULL order by id;
4332
CAST(my_timestamp AS DATE) my_timestamp id
4333
0000-00-00 0000-00-00 00:00:00 1
4334
1970-01-01 1970-01-01 03:00:01 2
4335
2038-01-01 2038-01-01 02:59:59 3
4336
2004-02-29 2004-02-29 23:59:59 4
4337
2005-06-28 2005-06-28 10:00:00 5
4338
SHOW CREATE VIEW v1;
4339
View Create View character_set_client collation_connection
4340
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_timestamp` as date) AS `CAST(my_timestamp AS DATE)`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4342
WHERE v1.id IN (SELECT id FROM t1_values
4343
WHERE select_id = 34 OR select_id IS NULL) order by id;
4344
CAST(my_timestamp AS DATE) my_timestamp id
4345
0000-00-00 0000-00-00 00:00:00 1
4346
1970-01-01 1970-01-01 03:00:01 2
4347
2038-01-01 2038-01-01 02:59:59 3
4348
2004-02-29 2004-02-29 23:59:59 4
4349
2005-06-28 2005-06-28 10:00:00 5
4353
CREATE VIEW v1 AS SELECT CAST(my_date AS DATE),
4354
my_date, id FROM t1_values;
4355
SELECT CAST(my_date AS DATE),
4356
my_date, id FROM t1_values
4357
WHERE select_id = 33 OR select_id IS NULL order by id;
4358
CAST(my_date AS DATE) my_date id
4360
0001-01-01 0001-01-01 2
4361
9999-12-31 9999-12-31 3
4362
2004-02-29 2004-02-29 4
4363
2005-06-28 2005-06-28 5
4364
SHOW CREATE VIEW v1;
4365
View Create View character_set_client collation_connection
4366
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_date` as date) AS `CAST(my_date AS DATE)`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4368
WHERE v1.id IN (SELECT id FROM t1_values
4369
WHERE select_id = 33 OR select_id IS NULL) order by id;
4370
CAST(my_date AS DATE) my_date id
4372
0001-01-01 0001-01-01 2
4373
9999-12-31 9999-12-31 3
4374
2004-02-29 2004-02-29 4
4375
2005-06-28 2005-06-28 5
4379
CREATE VIEW v1 AS SELECT CAST(my_datetime AS DATE),
4380
my_datetime, id FROM t1_values;
4381
SELECT CAST(my_datetime AS DATE),
4382
my_datetime, id FROM t1_values
4383
WHERE select_id = 32 OR select_id IS NULL order by id;
4384
CAST(my_datetime AS DATE) my_datetime id
4386
0001-01-01 0001-01-01 00:00:00 2
4387
9999-12-31 9999-12-31 23:59:59 3
4388
2004-02-29 2004-02-29 23:59:59 4
4389
2005-06-28 2005-06-28 10:00:00 5
4390
SHOW CREATE VIEW v1;
4391
View Create View character_set_client collation_connection
4392
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_datetime` as date) AS `CAST(my_datetime AS DATE)`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4394
WHERE v1.id IN (SELECT id FROM t1_values
4395
WHERE select_id = 32 OR select_id IS NULL) order by id;
4396
CAST(my_datetime AS DATE) my_datetime id
4398
0001-01-01 0001-01-01 00:00:00 2
4399
9999-12-31 9999-12-31 23:59:59 3
4400
2004-02-29 2004-02-29 23:59:59 4
4401
2005-06-28 2005-06-28 10:00:00 5
4405
CREATE VIEW v1 AS SELECT CAST(my_double AS DATE),
4406
my_double, id FROM t1_values;
4407
SELECT CAST(my_double AS DATE),
4408
my_double, id FROM t1_values
4409
WHERE select_id = 31 OR select_id IS NULL order by id;
4410
CAST(my_double AS DATE) my_double id
4412
NULL -1.7976931348623e308 2
4413
NULL 1.7976931348623e308 3
4416
2005-06-27 20050627 13
4418
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4419
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4420
Warning 1292 Incorrect datetime value: '0'
4421
Warning 1292 Incorrect datetime value: '-1'
4422
SHOW CREATE VIEW v1;
4423
View Create View character_set_client collation_connection
4424
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_double` as date) AS `CAST(my_double AS DATE)`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4426
WHERE v1.id IN (SELECT id FROM t1_values
4427
WHERE select_id = 31 OR select_id IS NULL) order by id;
4428
CAST(my_double AS DATE) my_double id
4430
NULL -1.7976931348623e308 2
4431
NULL 1.7976931348623e308 3
4434
2005-06-27 20050627 13
4436
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4437
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4438
Warning 1292 Incorrect datetime value: '0'
4439
Warning 1292 Incorrect datetime value: '-1'
4443
CREATE VIEW v1 AS SELECT CAST(my_bigint AS DATE),
4444
my_bigint, id FROM t1_values;
4445
SELECT CAST(my_bigint AS DATE),
4446
my_bigint, id FROM t1_values
4447
WHERE select_id = 30 OR select_id IS NULL order by id;
4448
CAST(my_bigint AS DATE) my_bigint id
4450
NULL -9223372036854775808 2
4451
NULL 9223372036854775807 3
4454
2005-06-27 20050627 12
4456
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4457
Warning 1292 Incorrect datetime value: '9223372036854775807'
4458
Warning 1292 Incorrect datetime value: '0'
4459
Warning 1292 Incorrect datetime value: '-1'
4460
SHOW CREATE VIEW v1;
4461
View Create View character_set_client collation_connection
4462
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as date) AS `CAST(my_bigint AS DATE)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4464
WHERE v1.id IN (SELECT id FROM t1_values
4465
WHERE select_id = 30 OR select_id IS NULL) order by id;
4466
CAST(my_bigint AS DATE) my_bigint id
4468
NULL -9223372036854775808 2
4469
NULL 9223372036854775807 3
4472
2005-06-27 20050627 12
4474
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4475
Warning 1292 Incorrect datetime value: '9223372036854775807'
4476
Warning 1292 Incorrect datetime value: '0'
4477
Warning 1292 Incorrect datetime value: '-1'
4481
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DATE),
4482
my_varbinary_1000, id FROM t1_values;
4483
SELECT CAST(my_varbinary_1000 AS DATE),
4484
my_varbinary_1000, id FROM t1_values
4485
WHERE select_id = 29 OR select_id IS NULL order by id;
4486
CAST(my_varbinary_1000 AS DATE) my_varbinary_1000 id
4489
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4490
NULL ---äÖüß@µ*$-- 4
4492
2005-06-27 2005-06-27 11
4494
Warning 1292 Incorrect datetime value: ''
4495
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4496
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4497
Warning 1292 Incorrect datetime value: '-1'
4498
SHOW CREATE VIEW v1;
4499
View Create View character_set_client collation_connection
4500
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varbinary_1000` as date) AS `CAST(my_varbinary_1000 AS DATE)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4502
WHERE v1.id IN (SELECT id FROM t1_values
4503
WHERE select_id = 29 OR select_id IS NULL) order by id;
4504
CAST(my_varbinary_1000 AS DATE) my_varbinary_1000 id
4507
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4508
NULL ---äÖüß@µ*$-- 4
4510
2005-06-27 2005-06-27 11
4512
Warning 1292 Incorrect datetime value: ''
4513
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4514
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4515
Warning 1292 Incorrect datetime value: '-1'
4519
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DATE),
4520
my_binary_30, id FROM t1_values;
4521
SELECT CAST(my_binary_30 AS DATE),
4522
my_binary_30, id FROM t1_values
4523
WHERE select_id = 28 OR select_id IS NULL order by id;
4524
CAST(my_binary_30 AS DATE) my_binary_30 id
4527
NULL <--------30 characters-------> 3
4528
NULL ---äÖüß@µ*$-- 4
4530
2005-06-27 2005-06-27 10
4532
Warning 1292 Incorrect datetime value: ''
4533
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4534
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4535
Warning 1292 Incorrect datetime value: '-1'
4536
Warning 1292 Truncated incorrect date value: '2005-06-27'
4537
SHOW CREATE VIEW v1;
4538
View Create View character_set_client collation_connection
4539
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_binary_30` as date) AS `CAST(my_binary_30 AS DATE)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4541
WHERE v1.id IN (SELECT id FROM t1_values
4542
WHERE select_id = 28 OR select_id IS NULL) order by id;
4543
CAST(my_binary_30 AS DATE) my_binary_30 id
4546
NULL <--------30 characters-------> 3
4547
NULL ---äÖüß@µ*$-- 4
4549
2005-06-27 2005-06-27 10
4551
Warning 1292 Incorrect datetime value: ''
4552
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4553
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4554
Warning 1292 Incorrect datetime value: '-1'
4555
Warning 1292 Truncated incorrect date value: '2005-06-27'
4559
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DATE),
4560
my_varchar_1000, id FROM t1_values;
4561
SELECT CAST(my_varchar_1000 AS DATE),
4562
my_varchar_1000, id FROM t1_values
4563
WHERE select_id = 27 OR select_id IS NULL order by id;
4564
CAST(my_varchar_1000 AS DATE) my_varchar_1000 id
4567
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4568
NULL ---äÖüß@µ*$-- 4
4570
2005-06-27 2005-06-27 9
4572
Warning 1292 Incorrect datetime value: ''
4573
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4574
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4575
Warning 1292 Incorrect datetime value: '-1'
4576
SHOW CREATE VIEW v1;
4577
View Create View character_set_client collation_connection
4578
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varchar_1000` as date) AS `CAST(my_varchar_1000 AS DATE)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4580
WHERE v1.id IN (SELECT id FROM t1_values
4581
WHERE select_id = 27 OR select_id IS NULL) order by id;
4582
CAST(my_varchar_1000 AS DATE) my_varchar_1000 id
4585
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4586
NULL ---äÖüß@µ*$-- 4
4588
2005-06-27 2005-06-27 9
4590
Warning 1292 Incorrect datetime value: ''
4591
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4592
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4593
Warning 1292 Incorrect datetime value: '-1'
4597
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DATE),
4598
my_char_30, id FROM t1_values;
4599
SELECT CAST(my_char_30 AS DATE),
4600
my_char_30, id FROM t1_values
4601
WHERE select_id = 26 OR select_id IS NULL order by id;
4602
CAST(my_char_30 AS DATE) my_char_30 id
4605
NULL <--------30 characters-------> 3
4606
NULL ---äÖüß@µ*$-- 4
4608
2005-06-27 2005-06-27 8
4610
Warning 1292 Incorrect datetime value: ''
4611
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4612
Warning 1292 Incorrect datetime value: ' ---����@�*$--'
4613
Warning 1292 Incorrect datetime value: '-1'
4614
SHOW CREATE VIEW v1;
4615
View Create View character_set_client collation_connection
4616
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_char_30` as date) AS `CAST(my_char_30 AS DATE)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4618
WHERE v1.id IN (SELECT id FROM t1_values
4619
WHERE select_id = 26 OR select_id IS NULL) order by id;
4620
CAST(my_char_30 AS DATE) my_char_30 id
4623
NULL <--------30 characters-------> 3
4624
NULL ---äÖüß@µ*$-- 4
4626
2005-06-27 2005-06-27 8
4628
Warning 1292 Incorrect datetime value: ''
4629
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4630
Warning 1292 Incorrect datetime value: ' ---����@�*$--'
4631
Warning 1292 Incorrect datetime value: '-1'
4635
CREATE VIEW v1 AS SELECT CAST(my_year AS CHAR),
4636
my_year, id FROM t1_values;
4637
SELECT CAST(my_year AS CHAR),
4638
my_year, id FROM t1_values
4639
WHERE select_id = 25 OR select_id IS NULL order by id;
4640
CAST(my_year AS CHAR) my_year id
4646
SHOW CREATE VIEW v1;
4647
View Create View character_set_client collation_connection
4648
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_year` as char charset latin1) AS `CAST(my_year AS CHAR)`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4650
WHERE v1.id IN (SELECT id FROM t1_values
4651
WHERE select_id = 25 OR select_id IS NULL) order by id;
4652
CAST(my_year AS CHAR) my_year id
4661
CREATE VIEW v1 AS SELECT CAST(my_time AS CHAR),
4662
my_time, id FROM t1_values;
4663
SELECT CAST(my_time AS CHAR),
4664
my_time, id FROM t1_values
4665
WHERE select_id = 24 OR select_id IS NULL order by id;
4666
CAST(my_time AS CHAR) my_time id
4668
-838:59:59 -838:59:59 2
4669
838:59:59 838:59:59 3
4672
SHOW CREATE VIEW v1;
4673
View Create View character_set_client collation_connection
4674
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_time` as char charset latin1) AS `CAST(my_time AS CHAR)`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4676
WHERE v1.id IN (SELECT id FROM t1_values
4677
WHERE select_id = 24 OR select_id IS NULL) order by id;
4678
CAST(my_time AS CHAR) my_time id
4680
-838:59:59 -838:59:59 2
4681
838:59:59 838:59:59 3
4687
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS CHAR),
4688
my_timestamp, id FROM t1_values;
4689
SELECT CAST(my_timestamp AS CHAR),
4690
my_timestamp, id FROM t1_values
4691
WHERE select_id = 23 OR select_id IS NULL order by id;
4692
CAST(my_timestamp AS CHAR) my_timestamp id
4693
0000-00-00 00:00:00 0000-00-00 00:00:00 1
4694
1970-01-01 03:00:01 1970-01-01 03:00:01 2
4695
2038-01-01 02:59:59 2038-01-01 02:59:59 3
4696
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4697
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4698
SHOW CREATE VIEW v1;
4699
View Create View character_set_client collation_connection
4700
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_timestamp` as char charset latin1) AS `CAST(my_timestamp AS CHAR)`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4702
WHERE v1.id IN (SELECT id FROM t1_values
4703
WHERE select_id = 23 OR select_id IS NULL) order by id;
4704
CAST(my_timestamp AS CHAR) my_timestamp id
4705
0000-00-00 00:00:00 0000-00-00 00:00:00 1
4706
1970-01-01 03:00:01 1970-01-01 03:00:01 2
4707
2038-01-01 02:59:59 2038-01-01 02:59:59 3
4708
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4709
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4713
CREATE VIEW v1 AS SELECT CAST(my_date AS CHAR),
4714
my_date, id FROM t1_values;
4715
SELECT CAST(my_date AS CHAR),
4716
my_date, id FROM t1_values
4717
WHERE select_id = 22 OR select_id IS NULL order by id;
4718
CAST(my_date AS CHAR) my_date id
4720
0001-01-01 0001-01-01 2
4721
9999-12-31 9999-12-31 3
4722
2004-02-29 2004-02-29 4
4723
2005-06-28 2005-06-28 5
4724
SHOW CREATE VIEW v1;
4725
View Create View character_set_client collation_connection
4726
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_date` as char charset latin1) AS `CAST(my_date AS CHAR)`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4728
WHERE v1.id IN (SELECT id FROM t1_values
4729
WHERE select_id = 22 OR select_id IS NULL) order by id;
4730
CAST(my_date AS CHAR) my_date id
4732
0001-01-01 0001-01-01 2
4733
9999-12-31 9999-12-31 3
4734
2004-02-29 2004-02-29 4
4735
2005-06-28 2005-06-28 5
4739
CREATE VIEW v1 AS SELECT CAST(my_datetime AS CHAR),
4740
my_datetime, id FROM t1_values;
4741
SELECT CAST(my_datetime AS CHAR),
4742
my_datetime, id FROM t1_values
4743
WHERE select_id = 21 OR select_id IS NULL order by id;
4744
CAST(my_datetime AS CHAR) my_datetime id
4746
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4747
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4748
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4749
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4750
SHOW CREATE VIEW v1;
4751
View Create View character_set_client collation_connection
4752
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_datetime` as char charset latin1) AS `CAST(my_datetime AS CHAR)`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4754
WHERE v1.id IN (SELECT id FROM t1_values
4755
WHERE select_id = 21 OR select_id IS NULL) order by id;
4756
CAST(my_datetime AS CHAR) my_datetime id
4758
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4759
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4760
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4761
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4765
CREATE VIEW v1 AS SELECT CAST(my_double AS CHAR),
4766
my_double, id FROM t1_values;
4767
SELECT CAST(my_double AS CHAR),
4768
my_double, id FROM t1_values
4769
WHERE select_id = 20 OR select_id IS NULL order by id;
4770
CAST(my_double AS CHAR) my_double id
4772
-1.7976931348623e308 -1.7976931348623e308 2
4773
1.7976931348623e308 1.7976931348623e308 3
4776
SHOW CREATE VIEW v1;
4777
View Create View character_set_client collation_connection
4778
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_double` as char charset latin1) AS `CAST(my_double AS CHAR)`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4780
WHERE v1.id IN (SELECT id FROM t1_values
4781
WHERE select_id = 20 OR select_id IS NULL) order by id;
4782
CAST(my_double AS CHAR) my_double id
4784
-1.7976931348623e308 -1.7976931348623e308 2
4785
1.7976931348623e308 1.7976931348623e308 3
4791
CREATE VIEW v1 AS SELECT CAST(my_decimal AS CHAR),
4792
my_decimal, id FROM t1_values;
4793
SELECT CAST(my_decimal AS CHAR),
4794
my_decimal, id FROM t1_values
4795
WHERE select_id = 19 OR select_id IS NULL order by id;
4796
CAST(my_decimal AS CHAR) my_decimal id
4798
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
4799
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
4800
0.000000000000000000000000000000 0.000000000000000000000000000000 4
4801
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
4802
SHOW CREATE VIEW v1;
4803
View Create View character_set_client collation_connection
4804
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_decimal` as char charset latin1) AS `CAST(my_decimal AS CHAR)`,`t1_values`.`my_decimal` AS `my_decimal`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4806
WHERE v1.id IN (SELECT id FROM t1_values
4807
WHERE select_id = 19 OR select_id IS NULL) order by id;
4808
CAST(my_decimal AS CHAR) my_decimal id
4810
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
4811
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
4812
0.000000000000000000000000000000 0.000000000000000000000000000000 4
4813
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
4817
CREATE VIEW v1 AS SELECT CAST(my_bigint AS CHAR),
4818
my_bigint, id FROM t1_values;
4819
SELECT CAST(my_bigint AS CHAR),
4820
my_bigint, id FROM t1_values
4821
WHERE select_id = 18 OR select_id IS NULL order by id;
4822
CAST(my_bigint AS CHAR) my_bigint id
4824
-9223372036854775808 -9223372036854775808 2
4825
9223372036854775807 9223372036854775807 3
4828
SHOW CREATE VIEW v1;
4829
View Create View character_set_client collation_connection
4830
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as char charset latin1) AS `CAST(my_bigint AS CHAR)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4832
WHERE v1.id IN (SELECT id FROM t1_values
4833
WHERE select_id = 18 OR select_id IS NULL) order by id;
4834
CAST(my_bigint AS CHAR) my_bigint id
4836
-9223372036854775808 -9223372036854775808 2
4837
9223372036854775807 9223372036854775807 3
4843
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS CHAR),
4844
my_varbinary_1000, id FROM t1_values;
4845
SELECT CAST(my_varbinary_1000 AS CHAR),
4846
my_varbinary_1000, id FROM t1_values
4847
WHERE select_id = 17 OR select_id IS NULL order by id;
4848
CAST(my_varbinary_1000 AS CHAR) my_varbinary_1000 id
4851
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4852
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4854
SHOW CREATE VIEW v1;
4855
View Create View character_set_client collation_connection
4856
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varbinary_1000` as char charset latin1) AS `CAST(my_varbinary_1000 AS CHAR)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4858
WHERE v1.id IN (SELECT id FROM t1_values
4859
WHERE select_id = 17 OR select_id IS NULL) order by id;
4860
CAST(my_varbinary_1000 AS CHAR) my_varbinary_1000 id
4863
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4864
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4869
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS CHAR),
4870
my_binary_30, id FROM t1_values;
4871
SELECT CAST(my_binary_30 AS CHAR),
4872
my_binary_30, id FROM t1_values
4873
WHERE select_id = 16 OR select_id IS NULL order by id;
4874
CAST(my_binary_30 AS CHAR) my_binary_30 id
4877
<--------30 characters-------> <--------30 characters-------> 3
4878
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4880
SHOW CREATE VIEW v1;
4881
View Create View character_set_client collation_connection
4882
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_binary_30` as char charset latin1) AS `CAST(my_binary_30 AS CHAR)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4884
WHERE v1.id IN (SELECT id FROM t1_values
4885
WHERE select_id = 16 OR select_id IS NULL) order by id;
4886
CAST(my_binary_30 AS CHAR) my_binary_30 id
4889
<--------30 characters-------> <--------30 characters-------> 3
4890
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4895
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS CHAR),
4896
my_varchar_1000, id FROM t1_values;
4897
SELECT CAST(my_varchar_1000 AS CHAR),
4898
my_varchar_1000, id FROM t1_values
4899
WHERE select_id = 15 OR select_id IS NULL order by id;
4900
CAST(my_varchar_1000 AS CHAR) my_varchar_1000 id
4903
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4904
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4906
SHOW CREATE VIEW v1;
4907
View Create View character_set_client collation_connection
4908
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varchar_1000` as char charset latin1) AS `CAST(my_varchar_1000 AS CHAR)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4910
WHERE v1.id IN (SELECT id FROM t1_values
4911
WHERE select_id = 15 OR select_id IS NULL) order by id;
4912
CAST(my_varchar_1000 AS CHAR) my_varchar_1000 id
4915
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4916
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4921
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS CHAR),
4922
my_char_30, id FROM t1_values;
4923
SELECT CAST(my_char_30 AS CHAR),
4924
my_char_30, id FROM t1_values
4925
WHERE select_id = 14 OR select_id IS NULL order by id;
4926
CAST(my_char_30 AS CHAR) my_char_30 id
4929
<--------30 characters-------> <--------30 characters-------> 3
4930
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4932
SHOW CREATE VIEW v1;
4933
View Create View character_set_client collation_connection
4934
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_char_30` as char charset latin1) AS `CAST(my_char_30 AS CHAR)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4936
WHERE v1.id IN (SELECT id FROM t1_values
4937
WHERE select_id = 14 OR select_id IS NULL) order by id;
4938
CAST(my_char_30 AS CHAR) my_char_30 id
4941
<--------30 characters-------> <--------30 characters-------> 3
4942
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4947
CREATE VIEW v1 AS SELECT CAST(my_year AS BINARY),
4948
my_year, id FROM t1_values;
4949
SELECT CAST(my_year AS BINARY),
4950
my_year, id FROM t1_values
4951
WHERE select_id = 13 OR select_id IS NULL order by id;
4952
CAST(my_year AS BINARY) my_year id
4958
SHOW CREATE VIEW v1;
4959
View Create View character_set_client collation_connection
4960
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_year` as char charset binary) AS `CAST(my_year AS BINARY)`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4962
WHERE v1.id IN (SELECT id FROM t1_values
4963
WHERE select_id = 13 OR select_id IS NULL) order by id;
4964
CAST(my_year AS BINARY) my_year id
4973
CREATE VIEW v1 AS SELECT CAST(my_time AS BINARY),
4974
my_time, id FROM t1_values;
4975
SELECT CAST(my_time AS BINARY),
4976
my_time, id FROM t1_values
4977
WHERE select_id = 12 OR select_id IS NULL order by id;
4978
CAST(my_time AS BINARY) my_time id
4980
-838:59:59 -838:59:59 2
4981
838:59:59 838:59:59 3
4984
SHOW CREATE VIEW v1;
4985
View Create View character_set_client collation_connection
4986
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_time` as char charset binary) AS `CAST(my_time AS BINARY)`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4988
WHERE v1.id IN (SELECT id FROM t1_values
4989
WHERE select_id = 12 OR select_id IS NULL) order by id;
4990
CAST(my_time AS BINARY) my_time id
4992
-838:59:59 -838:59:59 2
4993
838:59:59 838:59:59 3
4999
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS BINARY),
5000
my_timestamp, id FROM t1_values;
5001
SELECT CAST(my_timestamp AS BINARY),
5002
my_timestamp, id FROM t1_values
5003
WHERE select_id = 11 OR select_id IS NULL order by id;
5004
CAST(my_timestamp AS BINARY) my_timestamp id
5005
0000-00-00 00:00:00 0000-00-00 00:00:00 1
5006
1970-01-01 03:00:01 1970-01-01 03:00:01 2
5007
2038-01-01 02:59:59 2038-01-01 02:59:59 3
5008
2004-02-29 23:59:59 2004-02-29 23:59:59 4
5009
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5010
SHOW CREATE VIEW v1;
5011
View Create View character_set_client collation_connection
5012
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_timestamp` as char charset binary) AS `CAST(my_timestamp AS BINARY)`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
5014
WHERE v1.id IN (SELECT id FROM t1_values
5015
WHERE select_id = 11 OR select_id IS NULL) order by id;
5016
CAST(my_timestamp AS BINARY) my_timestamp id
5017
0000-00-00 00:00:00 0000-00-00 00:00:00 1
5018
1970-01-01 03:00:01 1970-01-01 03:00:01 2
5019
2038-01-01 02:59:59 2038-01-01 02:59:59 3
5020
2004-02-29 23:59:59 2004-02-29 23:59:59 4
5021
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5025
CREATE VIEW v1 AS SELECT CAST(my_date AS BINARY),
5026
my_date, id FROM t1_values;
5027
SELECT CAST(my_date AS BINARY),
5028
my_date, id FROM t1_values
5029
WHERE select_id = 10 OR select_id IS NULL order by id;
5030
CAST(my_date AS BINARY) my_date id
5032
0001-01-01 0001-01-01 2
5033
9999-12-31 9999-12-31 3
5034
2004-02-29 2004-02-29 4
5035
2005-06-28 2005-06-28 5
5036
SHOW CREATE VIEW v1;
5037
View Create View character_set_client collation_connection
5038
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_date` as char charset binary) AS `CAST(my_date AS BINARY)`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
5040
WHERE v1.id IN (SELECT id FROM t1_values
5041
WHERE select_id = 10 OR select_id IS NULL) order by id;
5042
CAST(my_date AS BINARY) my_date id
5044
0001-01-01 0001-01-01 2
5045
9999-12-31 9999-12-31 3
5046
2004-02-29 2004-02-29 4
5047
2005-06-28 2005-06-28 5
5051
CREATE VIEW v1 AS SELECT CAST(my_datetime AS BINARY),
5052
my_datetime, id FROM t1_values;
5053
SELECT CAST(my_datetime AS BINARY),
5054
my_datetime, id FROM t1_values
5055
WHERE select_id = 9 OR select_id IS NULL order by id;
5056
CAST(my_datetime AS BINARY) my_datetime id
5058
0001-01-01 00:00:00 0001-01-01 00:00:00 2
5059
9999-12-31 23:59:59 9999-12-31 23:59:59 3
5060
2004-02-29 23:59:59 2004-02-29 23:59:59 4
5061
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5062
SHOW CREATE VIEW v1;
5063
View Create View character_set_client collation_connection
5064
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_datetime` as char charset binary) AS `CAST(my_datetime AS BINARY)`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
5066
WHERE v1.id IN (SELECT id FROM t1_values
5067
WHERE select_id = 9 OR select_id IS NULL) order by id;
5068
CAST(my_datetime AS BINARY) my_datetime id
5070
0001-01-01 00:00:00 0001-01-01 00:00:00 2
5071
9999-12-31 23:59:59 9999-12-31 23:59:59 3
5072
2004-02-29 23:59:59 2004-02-29 23:59:59 4
5073
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5077
CREATE VIEW v1 AS SELECT CAST(my_double AS BINARY),
5078
my_double, id FROM t1_values;
5079
SELECT CAST(my_double AS BINARY),
5080
my_double, id FROM t1_values
5081
WHERE select_id = 8 OR select_id IS NULL order by id;
5082
CAST(my_double AS BINARY) my_double id
5084
-1.7976931348623e308 -1.7976931348623e308 2
5085
1.7976931348623e308 1.7976931348623e308 3
5088
SHOW CREATE VIEW v1;
5089
View Create View character_set_client collation_connection
5090
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_double` as char charset binary) AS `CAST(my_double AS BINARY)`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
5092
WHERE v1.id IN (SELECT id FROM t1_values
5093
WHERE select_id = 8 OR select_id IS NULL) order by id;
5094
CAST(my_double AS BINARY) my_double id
5096
-1.7976931348623e308 -1.7976931348623e308 2
5097
1.7976931348623e308 1.7976931348623e308 3
5103
CREATE VIEW v1 AS SELECT CAST(my_decimal AS BINARY),
5104
my_decimal, id FROM t1_values;
5105
SELECT CAST(my_decimal AS BINARY),
5106
my_decimal, id FROM t1_values
5107
WHERE select_id = 7 OR select_id IS NULL order by id;
5108
CAST(my_decimal AS BINARY) my_decimal id
5110
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
5111
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
5112
0.000000000000000000000000000000 0.000000000000000000000000000000 4
5113
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
5114
SHOW CREATE VIEW v1;
5115
View Create View character_set_client collation_connection
5116
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_decimal` as char charset binary) AS `CAST(my_decimal AS BINARY)`,`t1_values`.`my_decimal` AS `my_decimal`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
5118
WHERE v1.id IN (SELECT id FROM t1_values
5119
WHERE select_id = 7 OR select_id IS NULL) order by id;
5120
CAST(my_decimal AS BINARY) my_decimal id
5122
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
5123
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
5124
0.000000000000000000000000000000 0.000000000000000000000000000000 4
5125
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
5129
CREATE VIEW v1 AS SELECT CAST(my_bigint AS BINARY),
5130
my_bigint, id FROM t1_values;
5131
SELECT CAST(my_bigint AS BINARY),
5132
my_bigint, id FROM t1_values
5133
WHERE select_id = 6 OR select_id IS NULL order by id;
5134
CAST(my_bigint AS BINARY) my_bigint id
5136
-9223372036854775808 -9223372036854775808 2
5137
9223372036854775807 9223372036854775807 3
5140
SHOW CREATE VIEW v1;
5141
View Create View character_set_client collation_connection
5142
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as char charset binary) AS `CAST(my_bigint AS BINARY)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
5144
WHERE v1.id IN (SELECT id FROM t1_values
5145
WHERE select_id = 6 OR select_id IS NULL) order by id;
5146
CAST(my_bigint AS BINARY) my_bigint id
5148
-9223372036854775808 -9223372036854775808 2
5149
9223372036854775807 9223372036854775807 3
5155
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS BINARY),
5156
my_varbinary_1000, id FROM t1_values;
5157
SELECT CAST(my_varbinary_1000 AS BINARY),
5158
my_varbinary_1000, id FROM t1_values
5159
WHERE select_id = 5 OR select_id IS NULL order by id;
5160
CAST(my_varbinary_1000 AS BINARY) my_varbinary_1000 id
5163
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5164
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5166
SHOW CREATE VIEW v1;
5167
View Create View character_set_client collation_connection
5168
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varbinary_1000` as char charset binary) AS `CAST(my_varbinary_1000 AS BINARY)`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
5170
WHERE v1.id IN (SELECT id FROM t1_values
5171
WHERE select_id = 5 OR select_id IS NULL) order by id;
5172
CAST(my_varbinary_1000 AS BINARY) my_varbinary_1000 id
5175
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5176
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5181
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS BINARY),
5182
my_binary_30, id FROM t1_values;
5183
SELECT CAST(my_binary_30 AS BINARY),
5184
my_binary_30, id FROM t1_values
5185
WHERE select_id = 4 OR select_id IS NULL order by id;
5186
CAST(my_binary_30 AS BINARY) my_binary_30 id
5189
<--------30 characters-------> <--------30 characters-------> 3
5190
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5192
SHOW CREATE VIEW v1;
5193
View Create View character_set_client collation_connection
5194
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_binary_30` as char charset binary) AS `CAST(my_binary_30 AS BINARY)`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
5196
WHERE v1.id IN (SELECT id FROM t1_values
5197
WHERE select_id = 4 OR select_id IS NULL) order by id;
5198
CAST(my_binary_30 AS BINARY) my_binary_30 id
5201
<--------30 characters-------> <--------30 characters-------> 3
5202
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5207
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS BINARY),
5208
my_varchar_1000, id FROM t1_values;
5209
SELECT CAST(my_varchar_1000 AS BINARY),
5210
my_varchar_1000, id FROM t1_values
5211
WHERE select_id = 3 OR select_id IS NULL order by id;
5212
CAST(my_varchar_1000 AS BINARY) my_varchar_1000 id
5215
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5216
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5218
SHOW CREATE VIEW v1;
5219
View Create View character_set_client collation_connection
5220
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varchar_1000` as char charset binary) AS `CAST(my_varchar_1000 AS BINARY)`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
5222
WHERE v1.id IN (SELECT id FROM t1_values
5223
WHERE select_id = 3 OR select_id IS NULL) order by id;
5224
CAST(my_varchar_1000 AS BINARY) my_varchar_1000 id
5227
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5228
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5233
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS BINARY),
5234
my_char_30, id FROM t1_values;
5235
SELECT CAST(my_char_30 AS BINARY),
5236
my_char_30, id FROM t1_values
5237
WHERE select_id = 2 OR select_id IS NULL order by id;
5238
CAST(my_char_30 AS BINARY) my_char_30 id
5241
<--------30 characters-------> <--------30 characters-------> 3
5242
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5244
SHOW CREATE VIEW v1;
5245
View Create View character_set_client collation_connection
5246
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_char_30` as char charset binary) AS `CAST(my_char_30 AS BINARY)`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
5248
WHERE v1.id IN (SELECT id FROM t1_values
5249
WHERE select_id = 2 OR select_id IS NULL) order by id;
5250
CAST(my_char_30 AS BINARY) my_char_30 id
5253
<--------30 characters-------> <--------30 characters-------> 3
5254
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5259
CREATE VIEW v1 AS SELECT sqrt(my_bigint), my_bigint, id FROM t1_values;
5260
SELECT sqrt(my_bigint), my_bigint, id FROM t1_values
5261
WHERE select_id = 1 OR select_id IS NULL order by id;
5262
sqrt(my_bigint) my_bigint id
5264
NULL -9223372036854775808 2
5265
3037000499.97605 9223372036854775807 3
5270
SHOW CREATE VIEW v1;
5271
View Create View character_set_client collation_connection
5272
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select sqrt(`t1_values`.`my_bigint`) AS `sqrt(my_bigint)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
5274
WHERE v1.id IN (SELECT id FROM t1_values
5275
WHERE select_id = 1 OR select_id IS NULL) order by id;
5276
sqrt(my_bigint) my_bigint id
5278
NULL -9223372036854775808 2
5279
3037000499.97605 9223372036854775807 3
5287
DROP TABLE t1_selects, t1_modes, t1_values;
added
removed
mysql-test/suite/funcs_1/r/ndb_func_view.result
