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);
10
ALTER TABLE t1_values ADD my_varchar_1000 VARCHAR(1000);
11
ALTER TABLE t1_values ADD my_binary_30 BINARY(30);
12
ALTER TABLE t1_values ADD my_varbinary_1000 VARBINARY(1000);
13
ALTER TABLE t1_values ADD my_datetime DATETIME;
14
ALTER TABLE t1_values ADD my_date DATE;
15
ALTER TABLE t1_values ADD ts_dummy TIMESTAMP;
16
ALTER TABLE t1_values ADD my_timestamp TIMESTAMP;
17
ALTER TABLE t1_values ADD my_time TIME;
18
ALTER TABLE t1_values ADD my_year YEAR;
19
ALTER TABLE t1_values ADD my_bigint BIGINT;
20
ALTER TABLE t1_values ADD my_double DOUBLE;
21
ALTER TABLE t1_values ADD my_decimal DECIMAL(64,30);
22
SET sql_mode = 'traditional';
23
INSERT INTO t1_values SET id = 0;
24
INSERT INTO t1_values SET
28
my_varbinary_1000 = '',
29
my_datetime = '0001-01-01 00:00:00',
30
my_date = '0001-01-01',
31
my_timestamp = '1970-01-01 03:00:01',
32
my_time = '-838:59:59',
34
my_bigint = -9223372036854775808,
35
my_decimal = -9999999999999999999999999999999999.999999999999999999999999999999 ,
36
my_double = -1.7976931348623E+308;
37
INSERT INTO t1_values SET
38
my_char_30 = '<--------30 characters------->',
39
my_varchar_1000 = CONCAT('<---------1000 characters',
40
RPAD('',965,'-'),'--------->'),
41
my_binary_30 = '<--------30 characters------->',
42
my_varbinary_1000 = CONCAT('<---------1000 characters',
43
RPAD('',965,'-'),'--------->'),
44
my_datetime = '9999-12-31 23:59:59',
45
my_date = '9999-12-31',
46
my_timestamp = '2038-01-01 02:59:59',
47
my_time = '838:59:59',
49
my_bigint = 9223372036854775807,
50
my_decimal = +9999999999999999999999999999999999.999999999999999999999999999999 ,
51
my_double = 1.7976931348623E+308;
52
INSERT INTO t1_values SET
53
my_char_30 = ' ---äÖüß@µ*$-- ',
54
my_varchar_1000 = ' ---äÖüß@µ*$-- ',
55
my_binary_30 = ' ---äÖüß@µ*$-- ',
56
my_varbinary_1000 = ' ---äÖüß@µ*$-- ',
57
my_datetime = '2004-02-29 23:59:59',
58
my_date = '2004-02-29',
59
my_timestamp = '2004-02-29 23:59:59',
65
INSERT INTO t1_values SET
67
my_varchar_1000 = '-1',
69
my_varbinary_1000 = '-1',
70
my_datetime = '2005-06-28 10:00:00',
71
my_date = '2005-06-28',
72
my_timestamp = '2005-06-28 10:00:00',
76
my_decimal = -1.000000000000000000000000000000,
78
PREPARE ins_sel_with_result FROM "INSERT INTO t1_selects SET my_select = @my_select,
79
disable_result = 'No'" ;
80
PREPARE ins_sel_no_result FROM "INSERT INTO t1_selects SET my_select = @my_select,
81
disable_result = 'Yes'" ;
82
SET sql_mode = 'traditional';
83
SET @my_select = 'SELECT sqrt(my_bigint), my_bigint, id FROM t1_values';
84
INSERT INTO t1_values SET select_id = @select_id,
86
INSERT INTO t1_values SET select_id = @select_id,
88
##### 1.1.1. CAST --> BINARY
89
##### 1.1.2. CAST --> CHAR
90
##### 1.1.3. CAST --> DATE
91
INSERT INTO t1_values SET select_id = @select_id,
92
my_char_30 = '2005-06-27';
93
INSERT INTO t1_values SET select_id = @select_id,
94
my_varchar_1000 = '2005-06-27';
95
INSERT INTO t1_values SET select_id = @select_id,
96
my_binary_30 = '2005-06-27';
97
INSERT INTO t1_values SET select_id = @select_id,
98
my_varbinary_1000 = '2005-06-27';
99
INSERT INTO t1_values SET select_id = @select_id,
100
my_bigint = 20050627;
101
INSERT INTO t1_values SET select_id = @select_id,
102
my_double = +20.050627E+6;
103
##### 1.1.4. CAST --> DATETIME
104
INSERT INTO t1_values SET select_id = @select_id,
105
my_char_30 = '2005-06-27 17:58';
106
INSERT INTO t1_values SET select_id = @select_id,
107
my_varchar_1000 = '2005-06-27 17:58';
108
INSERT INTO t1_values SET select_id = @select_id,
109
my_binary_30 = '2005-06-27 17:58';
110
INSERT INTO t1_values SET select_id = @select_id,
111
my_varbinary_1000 = '2005-06-27 17:58';
112
INSERT INTO t1_values SET select_id = @select_id,
113
my_bigint = 200506271758;
114
INSERT INTO t1_values SET select_id = @select_id,
115
my_double = +0.0200506271758E+13;
116
##### 1.1.5. CAST --> TIME
117
INSERT INTO t1_values SET select_id = @select_id,
118
my_char_30 = '1 17:58';
119
INSERT INTO t1_values SET select_id = @select_id,
120
my_varchar_1000 = '1 17:58';
121
INSERT INTO t1_values SET select_id = @select_id,
122
my_binary_30 = '1 17:58';
123
INSERT INTO t1_values SET select_id = @select_id,
124
my_varbinary_1000 = '1 17:58';
125
INSERT INTO t1_values SET select_id = @select_id,
127
INSERT INTO t1_values SET select_id = @select_id,
128
my_double = +1.758E+3;
129
##### 1.1.6. CAST --> DECIMAL
130
INSERT INTO t1_values SET select_id = @select_id,
131
my_char_30 = '-3333.3333';
132
INSERT INTO t1_values SET select_id = @select_id,
133
my_varchar_1000 = '-3333.3333';
134
INSERT INTO t1_values SET select_id = @select_id,
135
my_binary_30 = '-3333.3333';
136
INSERT INTO t1_values SET select_id = @select_id,
137
my_varbinary_1000 = '-3333.3333';
138
INSERT INTO t1_values SET select_id = @select_id,
139
my_double = -0.33333333E+4;
140
##### 1.1.7. CAST --> SIGNED INTEGER
142
"Attention: CAST --> SIGNED INTEGER
143
Bug#5913 Traditional mode: BIGINT range not correctly delimited
144
Status: To be fixed later"
145
--------------------------------------------------------------------------------
146
##### 1.1.8. CAST --> UNSIGNED INTEGER
148
"Attention: CAST --> UNSIGNED INTEGER
149
The file with expected results suffers from Bug 5913"
150
--------------------------------------------------------------------------------
152
some statements disabled because of
153
Bug#5913 Traditional mode: BIGINT range not correctly delimited
154
--------------------------------------------------------------------------------
155
SET @my_select = 'SELECT CONVERT(my_char_30 USING utf8),
156
my_char_30, id FROM t1_values';
157
SET @my_select = 'SELECT CONVERT(my_varchar_1000 USING utf8),
158
my_varchar_1000, id FROM t1_values';
159
SET @my_select = 'SELECT CONVERT(my_binary_30 USING utf8),
160
my_binary_30, id FROM t1_values';
161
SET @my_select = 'SELECT CONVERT(my_varbinary_1000 USING utf8),
162
my_varbinary_1000, id FROM t1_values';
163
SET @my_select = 'SELECT CONVERT(my_char_30 USING koi8r),
164
my_char_30, id FROM t1_values';
165
SET @my_select = 'SELECT CONVERT(my_varchar_1000 USING koi8r),
166
my_varchar_1000, id FROM t1_values';
167
SET @my_select = 'SELECT CONVERT(my_binary_30 USING koi8r),
168
my_binary_30, id FROM t1_values';
169
SET @my_select = 'SELECT CONVERT(my_varbinary_1000 USING koi8r),
170
my_varbinary_1000, id FROM t1_values';
171
SET @my_select = 'SELECT BIT_LENGTH(my_char_30),
172
my_char_30, id FROM t1_values';
173
SET @my_select = 'SELECT BIT_LENGTH(my_varchar_1000),
174
my_varchar_1000, id FROM t1_values';
175
SET @my_select = 'SELECT BIT_LENGTH(my_binary_30),
176
my_binary_30, id FROM t1_values';
177
SET @my_select = 'SELECT BIT_LENGTH(my_varbinary_1000),
178
my_varbinary_1000, id FROM t1_values';
179
SET @my_select = 'SELECT INSTR(my_char_30, ''char''),
180
my_char_30, id FROM t1_values';
181
SET @my_select = 'SELECT LCASE(my_varchar_1000),
182
my_varchar_1000, id FROM t1_values';
184
'SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values';
186
'SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values';
188
'SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values';
190
'SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values';
192
'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_bigint), my_bigint, id FROM t1_values';
194
'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_decimal), my_decimal, id FROM t1_values';
196
'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_double), my_double, id FROM t1_values';
197
SET @my_select = 'SELECT LENGTH(my_char_30),
198
my_char_30, id FROM t1_values';
199
SET @my_select = 'SELECT LENGTH(my_varchar_1000),
200
my_varchar_1000, id FROM t1_values';
201
SET @my_select = 'SELECT LENGTH(my_binary_30),
202
my_binary_30, id FROM t1_values';
203
SET @my_select = 'SELECT LENGTH(my_varbinary_1000),
204
my_varbinary_1000, id FROM t1_values';
205
SELECT 'äÄ@' INTO OUTFILE '../tmp/func_view.dat';
207
'SELECT LOAD_FILE(''../tmp/func_view.dat''), id FROM t1_values';
208
SET @my_select = 'SELECT LOCATE(''char'', my_char_30),
209
my_char_30, id FROM t1_values';
210
SET @my_select = 'SELECT LOCATE(''char'', my_varchar_1000),
211
my_varchar_1000, id FROM t1_values';
212
SET @my_select = 'SELECT LOCATE(''char'', my_binary_30),
213
my_binary_30, id FROM t1_values';
214
SET @my_select = 'SELECT LOCATE(''char'', my_varbinary_1000),
215
my_varbinary_1000, id FROM t1_values';
216
SET @my_select = 'SELECT LOCATE(my_char_30, my_char_30 ),
217
my_char_30, id FROM t1_values';
218
SET @my_select = 'SELECT LOCATE(my_char_30, my_varchar_1000 ),
219
my_char_30, my_varchar_1000 id FROM t1_values';
220
SET @my_select = 'SELECT LOCATE(my_char_30, my_binary_30 ),
221
my_char_30, my_binary_30 id FROM t1_values';
222
SET @my_select = 'SELECT LOCATE(my_char_30, my_varbinary_1000 ),
223
my_char_30, my_varbinary_1000 id FROM t1_values';
224
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
225
my_varchar_1000, id FROM t1_values';
226
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_char_30 ),
227
my_varchar_1000, my_char_30 id FROM t1_values';
228
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_binary_30 ),
229
my_varchar_1000, my_binary_30 id FROM t1_values';
230
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
231
my_varchar_1000, my_varbinary_1000 id FROM t1_values';
232
SET @my_select = 'SELECT LOCATE(my_binary_30, my_binary_30 ),
233
my_binary_30, id FROM t1_values';
234
SET @my_select = 'SELECT LOCATE(my_binary_30, my_char_30 ),
235
my_binary_30, my_char_30 id FROM t1_values';
236
SET @my_select = 'SELECT LOCATE(my_binary_30, my_varchar_1000 ),
237
my_binary_30, my_varchar_1000 id FROM t1_values';
238
SET @my_select = 'SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
239
my_binary_30, my_varbinary_1000 id FROM t1_values';
240
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
241
my_varbinary_1000, id FROM t1_values';
242
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_char_30 ),
243
my_varbinary_1000, my_char_30 id FROM t1_values';
244
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
245
my_varbinary_1000, my_varchar_1000 id FROM t1_values';
246
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
247
my_varbinary_1000, my_binary_30 id FROM t1_values';
248
SET @my_select = 'SELECT LOCATE(''-'', my_char_30, 3),
249
my_char_30, id FROM t1_values';
250
SET @my_select = 'SELECT LOCATE(''-'', my_varchar_1000, 3),
251
my_varchar_1000, id FROM t1_values';
252
SET @my_select = 'SELECT LOCATE(''-'', my_binary_30, 3),
253
my_binary_30, id FROM t1_values';
254
SET @my_select = 'SELECT LOCATE(''-'', my_varbinary_1000, 3),
255
my_varbinary_1000, id FROM t1_values';
256
SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_bigint),
257
my_bigint, id FROM t1_values';
258
SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_double),
259
my_double, id FROM t1_values';
260
SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_decimal),
261
my_decimal, id FROM t1_values';
262
SET @my_select = 'SELECT LOWER(my_char_30),
263
my_char_30, id FROM t1_values';
264
SET @my_select = 'SELECT LOWER(my_varchar_1000),
265
my_varchar_1000, id FROM t1_values';
266
SET @my_select = 'SELECT LOWER(my_binary_30),
267
my_binary_30, id FROM t1_values';
268
SET @my_select = 'SELECT LOWER(my_varbinary_1000),
269
my_varbinary_1000, id FROM t1_values';
270
SET @my_select = 'SELECT LTRIM(my_char_30),
271
my_char_30, id FROM t1_values';
272
SET @my_select = 'SELECT LTRIM(my_varchar_1000),
273
my_varchar_1000, id FROM t1_values';
274
SET @my_select = 'SELECT LTRIM(my_binary_30),
275
my_binary_30, id FROM t1_values';
276
SET @my_select = 'SELECT LTRIM(my_varbinary_1000),
277
my_varbinary_1000, id FROM t1_values';
279
'SELECT CONCAT(''A'',my_char_30), my_char_30, id FROM t1_values';
280
SET @my_select = 'SELECT my_char_30, id FROM t1_values';
281
INSERT INTO t1_values SET select_id = @select_id,
282
my_char_30 = 'Viana do Castelo';
285
"# The basic preparations end and the main test starts here"
286
--------------------------------------------------------------------------------
287
CREATE VIEW v1 AS SELECT my_char_30, id FROM t1_values;
288
SELECT my_char_30, id FROM t1_values
289
WHERE select_id = 193 OR select_id IS NULL order by id;
291
View Create View character_set_client collation_connection
292
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
294
WHERE v1.id IN (SELECT id FROM t1_values
295
WHERE select_id = 193 OR select_id IS NULL) order by id;
299
CREATE VIEW v1 AS SELECT CONCAT('A',my_char_30), my_char_30, id FROM t1_values;
300
SELECT CONCAT('A',my_char_30), my_char_30, id FROM t1_values
301
WHERE select_id = 192 OR select_id IS NULL order by id;
302
CONCAT('A',my_char_30) my_char_30 id
305
A<--------30 characters-------> <--------30 characters-------> 3
306
A ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
309
View Create View character_set_client collation_connection
310
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
312
WHERE v1.id IN (SELECT id FROM t1_values
313
WHERE select_id = 192 OR select_id IS NULL) order by id;
314
CONCAT('A',my_char_30) my_char_30 id
317
A<--------30 characters-------> <--------30 characters-------> 3
318
A ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
323
CREATE VIEW v1 AS SELECT LTRIM(my_varbinary_1000),
324
my_varbinary_1000, id FROM t1_values;
325
SELECT LTRIM(my_varbinary_1000),
326
my_varbinary_1000, id FROM t1_values
327
WHERE select_id = 191 OR select_id IS NULL order by id;
329
View Create View character_set_client collation_connection
330
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
332
WHERE v1.id IN (SELECT id FROM t1_values
333
WHERE select_id = 191 OR select_id IS NULL) order by id;
337
CREATE VIEW v1 AS SELECT LTRIM(my_binary_30),
338
my_binary_30, id FROM t1_values;
339
SELECT LTRIM(my_binary_30),
340
my_binary_30, id FROM t1_values
341
WHERE select_id = 190 OR select_id IS NULL order by id;
343
View Create View character_set_client collation_connection
344
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
346
WHERE v1.id IN (SELECT id FROM t1_values
347
WHERE select_id = 190 OR select_id IS NULL) order by id;
351
CREATE VIEW v1 AS SELECT LTRIM(my_varchar_1000),
352
my_varchar_1000, id FROM t1_values;
353
SELECT LTRIM(my_varchar_1000),
354
my_varchar_1000, id FROM t1_values
355
WHERE select_id = 189 OR select_id IS NULL order by id;
357
View Create View character_set_client collation_connection
358
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
360
WHERE v1.id IN (SELECT id FROM t1_values
361
WHERE select_id = 189 OR select_id IS NULL) order by id;
365
CREATE VIEW v1 AS SELECT LTRIM(my_char_30),
366
my_char_30, id FROM t1_values;
367
SELECT LTRIM(my_char_30),
368
my_char_30, id FROM t1_values
369
WHERE select_id = 188 OR select_id IS NULL order by id;
371
View Create View character_set_client collation_connection
372
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
374
WHERE v1.id IN (SELECT id FROM t1_values
375
WHERE select_id = 188 OR select_id IS NULL) order by id;
379
CREATE VIEW v1 AS SELECT LOWER(my_varbinary_1000),
380
my_varbinary_1000, id FROM t1_values;
381
SELECT LOWER(my_varbinary_1000),
382
my_varbinary_1000, id FROM t1_values
383
WHERE select_id = 187 OR select_id IS NULL order by id;
385
View Create View character_set_client collation_connection
386
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
388
WHERE v1.id IN (SELECT id FROM t1_values
389
WHERE select_id = 187 OR select_id IS NULL) order by id;
393
CREATE VIEW v1 AS SELECT LOWER(my_binary_30),
394
my_binary_30, id FROM t1_values;
395
SELECT LOWER(my_binary_30),
396
my_binary_30, id FROM t1_values
397
WHERE select_id = 186 OR select_id IS NULL order by id;
399
View Create View character_set_client collation_connection
400
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
402
WHERE v1.id IN (SELECT id FROM t1_values
403
WHERE select_id = 186 OR select_id IS NULL) order by id;
407
CREATE VIEW v1 AS SELECT LOWER(my_varchar_1000),
408
my_varchar_1000, id FROM t1_values;
409
SELECT LOWER(my_varchar_1000),
410
my_varchar_1000, id FROM t1_values
411
WHERE select_id = 185 OR select_id IS NULL order by id;
413
View Create View character_set_client collation_connection
414
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
416
WHERE v1.id IN (SELECT id FROM t1_values
417
WHERE select_id = 185 OR select_id IS NULL) order by id;
421
CREATE VIEW v1 AS SELECT LOWER(my_char_30),
422
my_char_30, id FROM t1_values;
423
SELECT LOWER(my_char_30),
424
my_char_30, id FROM t1_values
425
WHERE select_id = 184 OR select_id IS NULL order by id;
427
View Create View character_set_client collation_connection
428
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
430
WHERE v1.id IN (SELECT id FROM t1_values
431
WHERE select_id = 184 OR select_id IS NULL) order by id;
435
CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_decimal),
436
my_decimal, id FROM t1_values;
437
SELECT LOCATE('-', ' - -ABC', my_decimal),
438
my_decimal, id FROM t1_values
439
WHERE select_id = 183 OR select_id IS NULL order by id;
441
View Create View character_set_client collation_connection
442
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
444
WHERE v1.id IN (SELECT id FROM t1_values
445
WHERE select_id = 183 OR select_id IS NULL) order by id;
449
CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_double),
450
my_double, id FROM t1_values;
451
SELECT LOCATE('-', ' - -ABC', my_double),
452
my_double, id FROM t1_values
453
WHERE select_id = 182 OR select_id IS NULL order by id;
455
View Create View character_set_client collation_connection
456
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
458
WHERE v1.id IN (SELECT id FROM t1_values
459
WHERE select_id = 182 OR select_id IS NULL) order by id;
463
CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_bigint),
464
my_bigint, id FROM t1_values;
465
SELECT LOCATE('-', ' - -ABC', my_bigint),
466
my_bigint, id FROM t1_values
467
WHERE select_id = 181 OR select_id IS NULL order by id;
469
View Create View character_set_client collation_connection
470
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
472
WHERE v1.id IN (SELECT id FROM t1_values
473
WHERE select_id = 181 OR select_id IS NULL) order by id;
477
CREATE VIEW v1 AS SELECT LOCATE('-', my_varbinary_1000, 3),
478
my_varbinary_1000, id FROM t1_values;
479
SELECT LOCATE('-', my_varbinary_1000, 3),
480
my_varbinary_1000, id FROM t1_values
481
WHERE select_id = 180 OR select_id IS NULL order by id;
483
View Create View character_set_client collation_connection
484
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
486
WHERE v1.id IN (SELECT id FROM t1_values
487
WHERE select_id = 180 OR select_id IS NULL) order by id;
491
CREATE VIEW v1 AS SELECT LOCATE('-', my_binary_30, 3),
492
my_binary_30, id FROM t1_values;
493
SELECT LOCATE('-', my_binary_30, 3),
494
my_binary_30, id FROM t1_values
495
WHERE select_id = 179 OR select_id IS NULL order by id;
497
View Create View character_set_client collation_connection
498
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
500
WHERE v1.id IN (SELECT id FROM t1_values
501
WHERE select_id = 179 OR select_id IS NULL) order by id;
505
CREATE VIEW v1 AS SELECT LOCATE('-', my_varchar_1000, 3),
506
my_varchar_1000, id FROM t1_values;
507
SELECT LOCATE('-', my_varchar_1000, 3),
508
my_varchar_1000, id FROM t1_values
509
WHERE select_id = 178 OR select_id IS NULL order by id;
511
View Create View character_set_client collation_connection
512
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
514
WHERE v1.id IN (SELECT id FROM t1_values
515
WHERE select_id = 178 OR select_id IS NULL) order by id;
519
CREATE VIEW v1 AS SELECT LOCATE('-', my_char_30, 3),
520
my_char_30, id FROM t1_values;
521
SELECT LOCATE('-', my_char_30, 3),
522
my_char_30, id FROM t1_values
523
WHERE select_id = 177 OR select_id IS NULL order by id;
525
View Create View character_set_client collation_connection
526
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
528
WHERE v1.id IN (SELECT id FROM t1_values
529
WHERE select_id = 177 OR select_id IS NULL) order by id;
533
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
534
my_varbinary_1000, my_binary_30 id FROM t1_values;
535
SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
536
my_varbinary_1000, my_binary_30 id FROM t1_values
537
WHERE select_id = 176 OR select_id IS NULL order by id;
539
View Create View character_set_client collation_connection
540
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
542
WHERE v1.id IN (SELECT id FROM t1_values
543
WHERE select_id = 176 OR select_id IS NULL) order by id;
547
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
548
my_varbinary_1000, my_varchar_1000 id FROM t1_values;
549
SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
550
my_varbinary_1000, my_varchar_1000 id FROM t1_values
551
WHERE select_id = 175 OR select_id IS NULL order by id;
553
View Create View character_set_client collation_connection
554
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
556
WHERE v1.id IN (SELECT id FROM t1_values
557
WHERE select_id = 175 OR select_id IS NULL) order by id;
561
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_char_30 ),
562
my_varbinary_1000, my_char_30 id FROM t1_values;
563
SELECT LOCATE(my_varbinary_1000, my_char_30 ),
564
my_varbinary_1000, my_char_30 id FROM t1_values
565
WHERE select_id = 174 OR select_id IS NULL order by id;
567
View Create View character_set_client collation_connection
568
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
570
WHERE v1.id IN (SELECT id FROM t1_values
571
WHERE select_id = 174 OR select_id IS NULL) order by id;
575
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
576
my_varbinary_1000, id FROM t1_values;
577
SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
578
my_varbinary_1000, id FROM t1_values
579
WHERE select_id = 173 OR select_id IS NULL order by id;
581
View Create View character_set_client collation_connection
582
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
584
WHERE v1.id IN (SELECT id FROM t1_values
585
WHERE select_id = 173 OR select_id IS NULL) order by id;
589
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
590
my_binary_30, my_varbinary_1000 id FROM t1_values;
591
SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
592
my_binary_30, my_varbinary_1000 id FROM t1_values
593
WHERE select_id = 172 OR select_id IS NULL order by id;
595
View Create View character_set_client collation_connection
596
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
598
WHERE v1.id IN (SELECT id FROM t1_values
599
WHERE select_id = 172 OR select_id IS NULL) order by id;
603
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_varchar_1000 ),
604
my_binary_30, my_varchar_1000 id FROM t1_values;
605
SELECT LOCATE(my_binary_30, my_varchar_1000 ),
606
my_binary_30, my_varchar_1000 id FROM t1_values
607
WHERE select_id = 171 OR select_id IS NULL order by id;
609
View Create View character_set_client collation_connection
610
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
612
WHERE v1.id IN (SELECT id FROM t1_values
613
WHERE select_id = 171 OR select_id IS NULL) order by id;
617
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_char_30 ),
618
my_binary_30, my_char_30 id FROM t1_values;
619
SELECT LOCATE(my_binary_30, my_char_30 ),
620
my_binary_30, my_char_30 id FROM t1_values
621
WHERE select_id = 170 OR select_id IS NULL order by id;
623
View Create View character_set_client collation_connection
624
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
626
WHERE v1.id IN (SELECT id FROM t1_values
627
WHERE select_id = 170 OR select_id IS NULL) order by id;
631
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_binary_30 ),
632
my_binary_30, id FROM t1_values;
633
SELECT LOCATE(my_binary_30, my_binary_30 ),
634
my_binary_30, id FROM t1_values
635
WHERE select_id = 169 OR select_id IS NULL order by id;
637
View Create View character_set_client collation_connection
638
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
640
WHERE v1.id IN (SELECT id FROM t1_values
641
WHERE select_id = 169 OR select_id IS NULL) order by id;
645
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
646
my_varchar_1000, my_varbinary_1000 id FROM t1_values;
647
SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
648
my_varchar_1000, my_varbinary_1000 id FROM t1_values
649
WHERE select_id = 168 OR select_id IS NULL order by id;
651
View Create View character_set_client collation_connection
652
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
654
WHERE v1.id IN (SELECT id FROM t1_values
655
WHERE select_id = 168 OR select_id IS NULL) order by id;
659
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_binary_30 ),
660
my_varchar_1000, my_binary_30 id FROM t1_values;
661
SELECT LOCATE(my_varchar_1000, my_binary_30 ),
662
my_varchar_1000, my_binary_30 id FROM t1_values
663
WHERE select_id = 167 OR select_id IS NULL order by id;
665
View Create View character_set_client collation_connection
666
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
668
WHERE v1.id IN (SELECT id FROM t1_values
669
WHERE select_id = 167 OR select_id IS NULL) order by id;
673
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_char_30 ),
674
my_varchar_1000, my_char_30 id FROM t1_values;
675
SELECT LOCATE(my_varchar_1000, my_char_30 ),
676
my_varchar_1000, my_char_30 id FROM t1_values
677
WHERE select_id = 166 OR select_id IS NULL order by id;
679
View Create View character_set_client collation_connection
680
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
682
WHERE v1.id IN (SELECT id FROM t1_values
683
WHERE select_id = 166 OR select_id IS NULL) order by id;
687
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
688
my_varchar_1000, id FROM t1_values;
689
SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
690
my_varchar_1000, id FROM t1_values
691
WHERE select_id = 165 OR select_id IS NULL order by id;
693
View Create View character_set_client collation_connection
694
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
696
WHERE v1.id IN (SELECT id FROM t1_values
697
WHERE select_id = 165 OR select_id IS NULL) order by id;
701
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_varbinary_1000 ),
702
my_char_30, my_varbinary_1000 id FROM t1_values;
703
SELECT LOCATE(my_char_30, my_varbinary_1000 ),
704
my_char_30, my_varbinary_1000 id FROM t1_values
705
WHERE select_id = 164 OR select_id IS NULL order by id;
707
View Create View character_set_client collation_connection
708
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
710
WHERE v1.id IN (SELECT id FROM t1_values
711
WHERE select_id = 164 OR select_id IS NULL) order by id;
715
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_binary_30 ),
716
my_char_30, my_binary_30 id FROM t1_values;
717
SELECT LOCATE(my_char_30, my_binary_30 ),
718
my_char_30, my_binary_30 id FROM t1_values
719
WHERE select_id = 163 OR select_id IS NULL order by id;
721
View Create View character_set_client collation_connection
722
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
724
WHERE v1.id IN (SELECT id FROM t1_values
725
WHERE select_id = 163 OR select_id IS NULL) order by id;
729
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_varchar_1000 ),
730
my_char_30, my_varchar_1000 id FROM t1_values;
731
SELECT LOCATE(my_char_30, my_varchar_1000 ),
732
my_char_30, my_varchar_1000 id FROM t1_values
733
WHERE select_id = 162 OR select_id IS NULL order by id;
735
View Create View character_set_client collation_connection
736
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
738
WHERE v1.id IN (SELECT id FROM t1_values
739
WHERE select_id = 162 OR select_id IS NULL) order by id;
743
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_char_30 ),
744
my_char_30, id FROM t1_values;
745
SELECT LOCATE(my_char_30, my_char_30 ),
746
my_char_30, id FROM t1_values
747
WHERE select_id = 161 OR select_id IS NULL order by id;
749
View Create View character_set_client collation_connection
750
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
752
WHERE v1.id IN (SELECT id FROM t1_values
753
WHERE select_id = 161 OR select_id IS NULL) order by id;
757
CREATE VIEW v1 AS SELECT LOCATE('char', my_varbinary_1000),
758
my_varbinary_1000, id FROM t1_values;
759
SELECT LOCATE('char', my_varbinary_1000),
760
my_varbinary_1000, id FROM t1_values
761
WHERE select_id = 160 OR select_id IS NULL order by id;
763
View Create View character_set_client collation_connection
764
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
766
WHERE v1.id IN (SELECT id FROM t1_values
767
WHERE select_id = 160 OR select_id IS NULL) order by id;
771
CREATE VIEW v1 AS SELECT LOCATE('char', my_binary_30),
772
my_binary_30, id FROM t1_values;
773
SELECT LOCATE('char', my_binary_30),
774
my_binary_30, id FROM t1_values
775
WHERE select_id = 159 OR select_id IS NULL order by id;
777
View Create View character_set_client collation_connection
778
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
780
WHERE v1.id IN (SELECT id FROM t1_values
781
WHERE select_id = 159 OR select_id IS NULL) order by id;
785
CREATE VIEW v1 AS SELECT LOCATE('char', my_varchar_1000),
786
my_varchar_1000, id FROM t1_values;
787
SELECT LOCATE('char', my_varchar_1000),
788
my_varchar_1000, id FROM t1_values
789
WHERE select_id = 158 OR select_id IS NULL order by id;
791
View Create View character_set_client collation_connection
792
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
794
WHERE v1.id IN (SELECT id FROM t1_values
795
WHERE select_id = 158 OR select_id IS NULL) order by id;
799
CREATE VIEW v1 AS SELECT LOCATE('char', my_char_30),
800
my_char_30, id FROM t1_values;
801
SELECT LOCATE('char', my_char_30),
802
my_char_30, id FROM t1_values
803
WHERE select_id = 157 OR select_id IS NULL order by id;
805
View Create View character_set_client collation_connection
806
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
808
WHERE v1.id IN (SELECT id FROM t1_values
809
WHERE select_id = 157 OR select_id IS NULL) order by id;
813
CREATE VIEW v1 AS SELECT LOAD_FILE('../tmp/func_view.dat'), id FROM t1_values;
814
SELECT LOAD_FILE('../tmp/func_view.dat'), id FROM t1_values
815
WHERE select_id = 156 OR select_id IS NULL order by id;
816
LOAD_FILE('../tmp/func_view.dat') id
828
View Create View character_set_client collation_connection
829
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
831
WHERE v1.id IN (SELECT id FROM t1_values
832
WHERE select_id = 156 OR select_id IS NULL) order by id;
833
LOAD_FILE('../tmp/func_view.dat') id
847
CREATE VIEW v1 AS SELECT LENGTH(my_varbinary_1000),
848
my_varbinary_1000, id FROM t1_values;
849
SELECT LENGTH(my_varbinary_1000),
850
my_varbinary_1000, id FROM t1_values
851
WHERE select_id = 155 OR select_id IS NULL order by id;
853
View Create View character_set_client collation_connection
854
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
856
WHERE v1.id IN (SELECT id FROM t1_values
857
WHERE select_id = 155 OR select_id IS NULL) order by id;
861
CREATE VIEW v1 AS SELECT LENGTH(my_binary_30),
862
my_binary_30, id FROM t1_values;
863
SELECT LENGTH(my_binary_30),
864
my_binary_30, id FROM t1_values
865
WHERE select_id = 154 OR select_id IS NULL order by id;
867
View Create View character_set_client collation_connection
868
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
870
WHERE v1.id IN (SELECT id FROM t1_values
871
WHERE select_id = 154 OR select_id IS NULL) order by id;
875
CREATE VIEW v1 AS SELECT LENGTH(my_varchar_1000),
876
my_varchar_1000, id FROM t1_values;
877
SELECT LENGTH(my_varchar_1000),
878
my_varchar_1000, id FROM t1_values
879
WHERE select_id = 153 OR select_id IS NULL order by id;
881
View Create View character_set_client collation_connection
882
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
884
WHERE v1.id IN (SELECT id FROM t1_values
885
WHERE select_id = 153 OR select_id IS NULL) order by id;
889
CREATE VIEW v1 AS SELECT LENGTH(my_char_30),
890
my_char_30, id FROM t1_values;
891
SELECT LENGTH(my_char_30),
892
my_char_30, id FROM t1_values
893
WHERE select_id = 152 OR select_id IS NULL order by id;
895
View Create View character_set_client collation_connection
896
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
898
WHERE v1.id IN (SELECT id FROM t1_values
899
WHERE select_id = 152 OR select_id IS NULL) order by id;
903
CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double), my_double, id FROM t1_values;
904
SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double), my_double, id FROM t1_values
905
WHERE select_id = 151 OR select_id IS NULL order by id;
906
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double) my_double id
908
-1.7976931348623e308 2
909
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 1.7976931348623e308 3
913
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
914
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
916
View Create View character_set_client collation_connection
917
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
919
WHERE v1.id IN (SELECT id FROM t1_values
920
WHERE select_id = 151 OR select_id IS NULL) order by id;
921
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double) my_double id
923
-1.7976931348623e308 2
924
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 1.7976931348623e308 3
928
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
929
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
933
CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal), my_decimal, id FROM t1_values;
934
SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal), my_decimal, id FROM t1_values
935
WHERE select_id = 150 OR select_id IS NULL order by id;
936
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal) my_decimal id
938
-9999999999999999999999999999999999.999999999999999999999999999999 2
939
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9999999999999999999999999999999999.999999999999999999999999999999 3
940
0.000000000000000000000000000000 4
941
-1.000000000000000000000000000000 5
943
Error 1292 Truncated incorrect DECIMAL value: ''
944
Error 1292 Truncated incorrect DECIMAL value: ''
946
View Create View character_set_client collation_connection
947
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
949
WHERE v1.id IN (SELECT id FROM t1_values
950
WHERE select_id = 150 OR select_id IS NULL) order by id;
951
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal) my_decimal id
953
-9999999999999999999999999999999999.999999999999999999999999999999 2
954
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9999999999999999999999999999999999.999999999999999999999999999999 3
955
0.000000000000000000000000000000 4
956
-1.000000000000000000000000000000 5
958
Error 1292 Truncated incorrect DECIMAL value: ''
959
Error 1292 Truncated incorrect DECIMAL value: ''
963
CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint), my_bigint, id FROM t1_values;
964
SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint), my_bigint, id FROM t1_values
965
WHERE select_id = 149 OR select_id IS NULL order by id;
966
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint) my_bigint id
968
-9223372036854775808 2
969
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9223372036854775807 3
973
View Create View character_set_client collation_connection
974
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
976
WHERE v1.id IN (SELECT id FROM t1_values
977
WHERE select_id = 149 OR select_id IS NULL) order by id;
978
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint) my_bigint id
980
-9223372036854775808 2
981
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9223372036854775807 3
987
CREATE VIEW v1 AS SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values;
988
SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values
989
WHERE select_id = 148 OR select_id IS NULL order by id;
990
LEFT(my_varbinary_1000, 2) my_varbinary_1000 id
993
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
997
View Create View character_set_client collation_connection
998
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
1000
WHERE v1.id IN (SELECT id FROM t1_values
1001
WHERE select_id = 148 OR select_id IS NULL) order by id;
1002
LEFT(my_varbinary_1000, 2) my_varbinary_1000 id
1005
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1011
CREATE VIEW v1 AS SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values;
1012
SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values
1013
WHERE select_id = 147 OR select_id IS NULL order by id;
1014
LEFT(my_binary_30, 2) my_binary_30 id
1017
<- <--------30 characters-------> 3
1020
SHOW CREATE VIEW v1;
1021
View Create View character_set_client collation_connection
1022
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
1024
WHERE v1.id IN (SELECT id FROM t1_values
1025
WHERE select_id = 147 OR select_id IS NULL) order by id;
1026
LEFT(my_binary_30, 2) my_binary_30 id
1029
<- <--------30 characters-------> 3
1035
CREATE VIEW v1 AS SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values;
1036
SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values
1037
WHERE select_id = 146 OR select_id IS NULL order by id;
1038
LEFT(my_varchar_1000, 2) my_varchar_1000 id
1041
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1044
SHOW CREATE VIEW v1;
1045
View Create View character_set_client collation_connection
1046
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
1048
WHERE v1.id IN (SELECT id FROM t1_values
1049
WHERE select_id = 146 OR select_id IS NULL) order by id;
1050
LEFT(my_varchar_1000, 2) my_varchar_1000 id
1053
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1059
CREATE VIEW v1 AS SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values;
1060
SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values
1061
WHERE select_id = 145 OR select_id IS NULL order by id;
1062
LEFT(my_char_30, 2) my_char_30 id
1065
<- <--------30 characters-------> 3
1068
SHOW CREATE VIEW v1;
1069
View Create View character_set_client collation_connection
1070
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
1072
WHERE v1.id IN (SELECT id FROM t1_values
1073
WHERE select_id = 145 OR select_id IS NULL) order by id;
1074
LEFT(my_char_30, 2) my_char_30 id
1077
<- <--------30 characters-------> 3
1083
CREATE VIEW v1 AS SELECT LCASE(my_varchar_1000),
1084
my_varchar_1000, id FROM t1_values;
1085
SELECT LCASE(my_varchar_1000),
1086
my_varchar_1000, id FROM t1_values
1087
WHERE select_id = 144 OR select_id IS NULL order by id;
1088
SHOW CREATE VIEW v1;
1089
View Create View character_set_client collation_connection
1090
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
1092
WHERE v1.id IN (SELECT id FROM t1_values
1093
WHERE select_id = 144 OR select_id IS NULL) order by id;
1097
CREATE VIEW v1 AS SELECT INSTR(my_char_30, 'char'),
1098
my_char_30, id FROM t1_values;
1099
SELECT INSTR(my_char_30, 'char'),
1100
my_char_30, id FROM t1_values
1101
WHERE select_id = 143 OR select_id IS NULL order by id;
1102
SHOW CREATE VIEW v1;
1103
View Create View character_set_client collation_connection
1104
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
1106
WHERE v1.id IN (SELECT id FROM t1_values
1107
WHERE select_id = 143 OR select_id IS NULL) order by id;
1111
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_varbinary_1000),
1112
my_varbinary_1000, id FROM t1_values;
1113
SELECT BIT_LENGTH(my_varbinary_1000),
1114
my_varbinary_1000, id FROM t1_values
1115
WHERE select_id = 142 OR select_id IS NULL order by id;
1116
BIT_LENGTH(my_varbinary_1000) my_varbinary_1000 id
1119
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1122
SHOW CREATE VIEW v1;
1123
View Create View character_set_client collation_connection
1124
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
1126
WHERE v1.id IN (SELECT id FROM t1_values
1127
WHERE select_id = 142 OR select_id IS NULL) order by id;
1128
BIT_LENGTH(my_varbinary_1000) my_varbinary_1000 id
1131
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1137
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_binary_30),
1138
my_binary_30, id FROM t1_values;
1139
SELECT BIT_LENGTH(my_binary_30),
1140
my_binary_30, id FROM t1_values
1141
WHERE select_id = 141 OR select_id IS NULL order by id;
1142
BIT_LENGTH(my_binary_30) my_binary_30 id
1145
240 <--------30 characters-------> 3
1148
SHOW CREATE VIEW v1;
1149
View Create View character_set_client collation_connection
1150
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
1152
WHERE v1.id IN (SELECT id FROM t1_values
1153
WHERE select_id = 141 OR select_id IS NULL) order by id;
1154
BIT_LENGTH(my_binary_30) my_binary_30 id
1157
240 <--------30 characters-------> 3
1163
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_varchar_1000),
1164
my_varchar_1000, id FROM t1_values;
1165
SELECT BIT_LENGTH(my_varchar_1000),
1166
my_varchar_1000, id FROM t1_values
1167
WHERE select_id = 140 OR select_id IS NULL order by id;
1168
BIT_LENGTH(my_varchar_1000) my_varchar_1000 id
1171
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1174
SHOW CREATE VIEW v1;
1175
View Create View character_set_client collation_connection
1176
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
1178
WHERE v1.id IN (SELECT id FROM t1_values
1179
WHERE select_id = 140 OR select_id IS NULL) order by id;
1180
BIT_LENGTH(my_varchar_1000) my_varchar_1000 id
1183
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1189
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_char_30),
1190
my_char_30, id FROM t1_values;
1191
SELECT BIT_LENGTH(my_char_30),
1192
my_char_30, id FROM t1_values
1193
WHERE select_id = 139 OR select_id IS NULL order by id;
1194
BIT_LENGTH(my_char_30) my_char_30 id
1197
240 <--------30 characters-------> 3
1200
SHOW CREATE VIEW v1;
1201
View Create View character_set_client collation_connection
1202
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
1204
WHERE v1.id IN (SELECT id FROM t1_values
1205
WHERE select_id = 139 OR select_id IS NULL) order by id;
1206
BIT_LENGTH(my_char_30) my_char_30 id
1209
240 <--------30 characters-------> 3
1215
CREATE VIEW v1 AS SELECT IFNULL(my_year,'IS_NULL'),
1216
my_year, id FROM t1_values;
1217
SELECT IFNULL(my_year,'IS_NULL'),
1218
my_year, id FROM t1_values
1219
WHERE select_id = 138 OR select_id IS NULL order by id;
1220
IFNULL(my_year,'IS_NULL') my_year id
1226
SHOW CREATE VIEW v1;
1227
View Create View character_set_client collation_connection
1228
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
1230
WHERE v1.id IN (SELECT id FROM t1_values
1231
WHERE select_id = 138 OR select_id IS NULL) order by id;
1232
IFNULL(my_year,'IS_NULL') my_year id
1241
CREATE VIEW v1 AS SELECT IFNULL(my_time,'IS_NULL'),
1242
my_time, id FROM t1_values;
1243
SELECT IFNULL(my_time,'IS_NULL'),
1244
my_time, id FROM t1_values
1245
WHERE select_id = 137 OR select_id IS NULL order by id;
1246
IFNULL(my_time,'IS_NULL') my_time id
1248
-838:59:59 -838:59:59 2
1249
838:59:59 838:59:59 3
1252
SHOW CREATE VIEW v1;
1253
View Create View character_set_client collation_connection
1254
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
1256
WHERE v1.id IN (SELECT id FROM t1_values
1257
WHERE select_id = 137 OR select_id IS NULL) order by id;
1258
IFNULL(my_time,'IS_NULL') my_time id
1260
-838:59:59 -838:59:59 2
1261
838:59:59 838:59:59 3
1267
CREATE VIEW v1 AS SELECT IFNULL(my_timestamp,'IS_NULL'),
1268
my_timestamp, id FROM t1_values;
1269
SELECT IFNULL(my_timestamp,'IS_NULL'),
1270
my_timestamp, id FROM t1_values
1271
WHERE select_id = 136 OR select_id IS NULL order by id;
1272
IFNULL(my_timestamp,'IS_NULL') my_timestamp id
1273
0000-00-00 00:00:00 0000-00-00 00:00:00 1
1274
1970-01-01 03:00:01 1970-01-01 03:00:01 2
1275
2038-01-01 02:59:59 2038-01-01 02:59:59 3
1276
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1277
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1278
SHOW CREATE VIEW v1;
1279
View Create View character_set_client collation_connection
1280
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
1282
WHERE v1.id IN (SELECT id FROM t1_values
1283
WHERE select_id = 136 OR select_id IS NULL) order by id;
1284
IFNULL(my_timestamp,'IS_NULL') my_timestamp id
1285
0000-00-00 00:00:00 0000-00-00 00:00:00 1
1286
1970-01-01 03:00:01 1970-01-01 03:00:01 2
1287
2038-01-01 02:59:59 2038-01-01 02:59:59 3
1288
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1289
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1293
CREATE VIEW v1 AS SELECT IFNULL(my_date,'IS_NULL'),
1294
my_date, id FROM t1_values;
1295
SELECT IFNULL(my_date,'IS_NULL'),
1296
my_date, id FROM t1_values
1297
WHERE select_id = 135 OR select_id IS NULL order by id;
1298
IFNULL(my_date,'IS_NULL') my_date id
1300
0001-01-01 0001-01-01 2
1301
9999-12-31 9999-12-31 3
1302
2004-02-29 2004-02-29 4
1303
2005-06-28 2005-06-28 5
1304
SHOW CREATE VIEW v1;
1305
View Create View character_set_client collation_connection
1306
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
1308
WHERE v1.id IN (SELECT id FROM t1_values
1309
WHERE select_id = 135 OR select_id IS NULL) order by id;
1310
IFNULL(my_date,'IS_NULL') my_date id
1312
0001-01-01 0001-01-01 2
1313
9999-12-31 9999-12-31 3
1314
2004-02-29 2004-02-29 4
1315
2005-06-28 2005-06-28 5
1319
CREATE VIEW v1 AS SELECT IFNULL(my_datetime,'IS_NULL'),
1320
my_datetime, id FROM t1_values;
1321
SELECT IFNULL(my_datetime,'IS_NULL'),
1322
my_datetime, id FROM t1_values
1323
WHERE select_id = 134 OR select_id IS NULL order by id;
1324
IFNULL(my_datetime,'IS_NULL') my_datetime id
1326
0001-01-01 00:00:00 0001-01-01 00:00:00 2
1327
9999-12-31 23:59:59 9999-12-31 23:59:59 3
1328
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1329
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1330
SHOW CREATE VIEW v1;
1331
View Create View character_set_client collation_connection
1332
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
1334
WHERE v1.id IN (SELECT id FROM t1_values
1335
WHERE select_id = 134 OR select_id IS NULL) order by id;
1336
IFNULL(my_datetime,'IS_NULL') my_datetime id
1338
0001-01-01 00:00:00 0001-01-01 00:00:00 2
1339
9999-12-31 23:59:59 9999-12-31 23:59:59 3
1340
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1341
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1345
CREATE VIEW v1 AS SELECT IFNULL(my_double,'IS_NULL'),
1346
my_double, id FROM t1_values;
1347
SELECT IFNULL(my_double,'IS_NULL'),
1348
my_double, id FROM t1_values
1349
WHERE select_id = 133 OR select_id IS NULL order by id;
1350
IFNULL(my_double,'IS_NULL') my_double id
1352
-1.7976931348623e308 -1.7976931348623e308 2
1353
1.7976931348623e308 1.7976931348623e308 3
1356
SHOW CREATE VIEW v1;
1357
View Create View character_set_client collation_connection
1358
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
1360
WHERE v1.id IN (SELECT id FROM t1_values
1361
WHERE select_id = 133 OR select_id IS NULL) order by id;
1362
IFNULL(my_double,'IS_NULL') my_double id
1364
-1.7976931348623e308 -1.7976931348623e308 2
1365
1.7976931348623e308 1.7976931348623e308 3
1371
CREATE VIEW v1 AS SELECT IFNULL(my_decimal,'IS_NULL'),
1372
my_decimal, id FROM t1_values;
1373
SELECT IFNULL(my_decimal,'IS_NULL'),
1374
my_decimal, id FROM t1_values
1375
WHERE select_id = 132 OR select_id IS NULL order by id;
1376
IFNULL(my_decimal,'IS_NULL') my_decimal id
1378
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
1379
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
1380
0.000000000000000000000000000000 0.000000000000000000000000000000 4
1381
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
1382
SHOW CREATE VIEW v1;
1383
View Create View character_set_client collation_connection
1384
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
1386
WHERE v1.id IN (SELECT id FROM t1_values
1387
WHERE select_id = 132 OR select_id IS NULL) order by id;
1388
IFNULL(my_decimal,'IS_NULL') my_decimal id
1390
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
1391
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
1392
0.000000000000000000000000000000 0.000000000000000000000000000000 4
1393
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
1397
CREATE VIEW v1 AS SELECT IFNULL(my_bigint,'IS_NULL'),
1398
my_bigint, id FROM t1_values;
1399
SELECT IFNULL(my_bigint,'IS_NULL'),
1400
my_bigint, id FROM t1_values
1401
WHERE select_id = 131 OR select_id IS NULL order by id;
1402
IFNULL(my_bigint,'IS_NULL') my_bigint id
1404
-9223372036854775808 -9223372036854775808 2
1405
9223372036854775807 9223372036854775807 3
1408
SHOW CREATE VIEW v1;
1409
View Create View character_set_client collation_connection
1410
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
1412
WHERE v1.id IN (SELECT id FROM t1_values
1413
WHERE select_id = 131 OR select_id IS NULL) order by id;
1414
IFNULL(my_bigint,'IS_NULL') my_bigint id
1416
-9223372036854775808 -9223372036854775808 2
1417
9223372036854775807 9223372036854775807 3
1423
CREATE VIEW v1 AS SELECT IFNULL(my_varbinary_1000,'IS_NULL'),
1424
my_varbinary_1000, id FROM t1_values;
1425
SELECT IFNULL(my_varbinary_1000,'IS_NULL'),
1426
my_varbinary_1000, id FROM t1_values
1427
WHERE select_id = 130 OR select_id IS NULL order by id;
1428
IFNULL(my_varbinary_1000,'IS_NULL') my_varbinary_1000 id
1431
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1432
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1434
SHOW CREATE VIEW v1;
1435
View Create View character_set_client collation_connection
1436
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
1438
WHERE v1.id IN (SELECT id FROM t1_values
1439
WHERE select_id = 130 OR select_id IS NULL) order by id;
1440
IFNULL(my_varbinary_1000,'IS_NULL') my_varbinary_1000 id
1443
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1444
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1449
CREATE VIEW v1 AS SELECT IFNULL(my_binary_30,'IS_NULL'),
1450
my_binary_30, id FROM t1_values;
1451
SELECT IFNULL(my_binary_30,'IS_NULL'),
1452
my_binary_30, id FROM t1_values
1453
WHERE select_id = 129 OR select_id IS NULL order by id;
1454
IFNULL(my_binary_30,'IS_NULL') my_binary_30 id
1457
<--------30 characters-------> <--------30 characters-------> 3
1458
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1460
SHOW CREATE VIEW v1;
1461
View Create View character_set_client collation_connection
1462
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
1464
WHERE v1.id IN (SELECT id FROM t1_values
1465
WHERE select_id = 129 OR select_id IS NULL) order by id;
1466
IFNULL(my_binary_30,'IS_NULL') my_binary_30 id
1469
<--------30 characters-------> <--------30 characters-------> 3
1470
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1475
CREATE VIEW v1 AS SELECT IFNULL(my_varchar_1000,'IS_NULL'),
1476
my_varchar_1000, id FROM t1_values;
1477
SELECT IFNULL(my_varchar_1000,'IS_NULL'),
1478
my_varchar_1000, id FROM t1_values
1479
WHERE select_id = 128 OR select_id IS NULL order by id;
1480
IFNULL(my_varchar_1000,'IS_NULL') my_varchar_1000 id
1483
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1484
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1486
SHOW CREATE VIEW v1;
1487
View Create View character_set_client collation_connection
1488
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
1490
WHERE v1.id IN (SELECT id FROM t1_values
1491
WHERE select_id = 128 OR select_id IS NULL) order by id;
1492
IFNULL(my_varchar_1000,'IS_NULL') my_varchar_1000 id
1495
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1496
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1501
CREATE VIEW v1 AS SELECT IFNULL(my_char_30,'IS_NULL'),
1502
my_char_30, id FROM t1_values;
1503
SELECT IFNULL(my_char_30,'IS_NULL'),
1504
my_char_30, id FROM t1_values
1505
WHERE select_id = 127 OR select_id IS NULL order by id;
1506
IFNULL(my_char_30,'IS_NULL') my_char_30 id
1509
<--------30 characters-------> <--------30 characters-------> 3
1510
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1512
SHOW CREATE VIEW v1;
1513
View Create View character_set_client collation_connection
1514
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
1516
WHERE v1.id IN (SELECT id FROM t1_values
1517
WHERE select_id = 127 OR select_id IS NULL) order by id;
1518
IFNULL(my_char_30,'IS_NULL') my_char_30 id
1521
<--------30 characters-------> <--------30 characters-------> 3
1522
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1527
CREATE VIEW v1 AS SELECT IF(my_year IS NULL, 'IS NULL',
1528
'IS NOT NULL'), my_year, id FROM t1_values;
1529
SELECT IF(my_year IS NULL, 'IS NULL',
1530
'IS NOT NULL'), my_year, id FROM t1_values
1531
WHERE select_id = 126 OR select_id IS NULL order by id;
1532
IF(my_year IS NULL, 'IS NULL',
1533
'IS NOT NULL') my_year id
1539
SHOW CREATE VIEW v1;
1540
View Create View character_set_client collation_connection
1541
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',
1542
'IS NOT NULL')`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1544
WHERE v1.id IN (SELECT id FROM t1_values
1545
WHERE select_id = 126 OR select_id IS NULL) order by id;
1546
IF(my_year IS NULL, 'IS NULL',
1547
'IS NOT NULL') my_year id
1556
CREATE VIEW v1 AS SELECT IF(my_time IS NULL, 'IS NULL',
1557
'IS NOT NULL'), my_time, id FROM t1_values;
1558
SELECT IF(my_time IS NULL, 'IS NULL',
1559
'IS NOT NULL'), my_time, id FROM t1_values
1560
WHERE select_id = 125 OR select_id IS NULL order by id;
1561
IF(my_time IS NULL, 'IS NULL',
1562
'IS NOT NULL') my_time id
1564
IS NOT NULL -838:59:59 2
1565
IS NOT NULL 838:59:59 3
1566
IS NOT NULL 13:00:00 4
1567
IS NOT NULL 10:00:00 5
1568
SHOW CREATE VIEW v1;
1569
View Create View character_set_client collation_connection
1570
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',
1571
'IS NOT NULL')`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1573
WHERE v1.id IN (SELECT id FROM t1_values
1574
WHERE select_id = 125 OR select_id IS NULL) order by id;
1575
IF(my_time IS NULL, 'IS NULL',
1576
'IS NOT NULL') my_time id
1578
IS NOT NULL -838:59:59 2
1579
IS NOT NULL 838:59:59 3
1580
IS NOT NULL 13:00:00 4
1581
IS NOT NULL 10:00:00 5
1585
CREATE VIEW v1 AS SELECT IF(my_timestamp IS NULL, 'IS NULL',
1586
'IS NOT NULL'), my_timestamp, id FROM t1_values;
1587
SELECT IF(my_timestamp IS NULL, 'IS NULL',
1588
'IS NOT NULL'), my_timestamp, id FROM t1_values
1589
WHERE select_id = 124 OR select_id IS NULL order by id;
1590
IF(my_timestamp IS NULL, 'IS NULL',
1591
'IS NOT NULL') my_timestamp id
1592
IS NOT NULL 0000-00-00 00:00:00 1
1593
IS NOT NULL 1970-01-01 03:00:01 2
1594
IS NOT NULL 2038-01-01 02:59:59 3
1595
IS NOT NULL 2004-02-29 23:59:59 4
1596
IS NOT NULL 2005-06-28 10:00:00 5
1597
SHOW CREATE VIEW v1;
1598
View Create View character_set_client collation_connection
1599
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',
1600
'IS NOT NULL')`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1602
WHERE v1.id IN (SELECT id FROM t1_values
1603
WHERE select_id = 124 OR select_id IS NULL) order by id;
1604
IF(my_timestamp IS NULL, 'IS NULL',
1605
'IS NOT NULL') my_timestamp id
1606
IS NOT NULL 0000-00-00 00:00:00 1
1607
IS NOT NULL 1970-01-01 03:00:01 2
1608
IS NOT NULL 2038-01-01 02:59:59 3
1609
IS NOT NULL 2004-02-29 23:59:59 4
1610
IS NOT NULL 2005-06-28 10:00:00 5
1614
CREATE VIEW v1 AS SELECT IF(my_date IS NULL, 'IS NULL',
1615
'IS NOT NULL'), my_date, id FROM t1_values;
1616
SELECT IF(my_date IS NULL, 'IS NULL',
1617
'IS NOT NULL'), my_date, id FROM t1_values
1618
WHERE select_id = 123 OR select_id IS NULL order by id;
1619
IF(my_date IS NULL, 'IS NULL',
1620
'IS NOT NULL') my_date id
1622
IS NOT NULL 0001-01-01 2
1623
IS NOT NULL 9999-12-31 3
1624
IS NOT NULL 2004-02-29 4
1625
IS NOT NULL 2005-06-28 5
1626
SHOW CREATE VIEW v1;
1627
View Create View character_set_client collation_connection
1628
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',
1629
'IS NOT NULL')`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1631
WHERE v1.id IN (SELECT id FROM t1_values
1632
WHERE select_id = 123 OR select_id IS NULL) order by id;
1633
IF(my_date IS NULL, 'IS NULL',
1634
'IS NOT NULL') my_date id
1636
IS NOT NULL 0001-01-01 2
1637
IS NOT NULL 9999-12-31 3
1638
IS NOT NULL 2004-02-29 4
1639
IS NOT NULL 2005-06-28 5
1643
CREATE VIEW v1 AS SELECT IF(my_datetime IS NULL, 'IS NULL',
1644
'IS NOT NULL'), my_datetime, id FROM t1_values;
1645
SELECT IF(my_datetime IS NULL, 'IS NULL',
1646
'IS NOT NULL'), my_datetime, id FROM t1_values
1647
WHERE select_id = 122 OR select_id IS NULL order by id;
1648
IF(my_datetime IS NULL, 'IS NULL',
1649
'IS NOT NULL') my_datetime id
1651
IS NOT NULL 0001-01-01 00:00:00 2
1652
IS NOT NULL 9999-12-31 23:59:59 3
1653
IS NOT NULL 2004-02-29 23:59:59 4
1654
IS NOT NULL 2005-06-28 10:00:00 5
1655
SHOW CREATE VIEW v1;
1656
View Create View character_set_client collation_connection
1657
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',
1658
'IS NOT NULL')`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1660
WHERE v1.id IN (SELECT id FROM t1_values
1661
WHERE select_id = 122 OR select_id IS NULL) order by id;
1662
IF(my_datetime IS NULL, 'IS NULL',
1663
'IS NOT NULL') my_datetime id
1665
IS NOT NULL 0001-01-01 00:00:00 2
1666
IS NOT NULL 9999-12-31 23:59:59 3
1667
IS NOT NULL 2004-02-29 23:59:59 4
1668
IS NOT NULL 2005-06-28 10:00:00 5
1672
CREATE VIEW v1 AS SELECT IF(my_double IS NULL, 'IS NULL',
1673
'IS NOT NULL'), my_double, id FROM t1_values;
1674
SELECT IF(my_double IS NULL, 'IS NULL',
1675
'IS NOT NULL'), my_double, id FROM t1_values
1676
WHERE select_id = 121 OR select_id IS NULL order by id;
1677
IF(my_double IS NULL, 'IS NULL',
1678
'IS NOT NULL') my_double id
1680
IS NOT NULL -1.7976931348623e308 2
1681
IS NOT NULL 1.7976931348623e308 3
1684
SHOW CREATE VIEW v1;
1685
View Create View character_set_client collation_connection
1686
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',
1687
'IS NOT NULL')`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1689
WHERE v1.id IN (SELECT id FROM t1_values
1690
WHERE select_id = 121 OR select_id IS NULL) order by id;
1691
IF(my_double IS NULL, 'IS NULL',
1692
'IS NOT NULL') my_double id
1694
IS NOT NULL -1.7976931348623e308 2
1695
IS NOT NULL 1.7976931348623e308 3
1701
CREATE VIEW v1 AS SELECT IF(my_decimal IS NULL, 'IS NULL',
1702
'IS NOT NULL'), my_decimal, id FROM t1_values;
1703
SELECT IF(my_decimal IS NULL, 'IS NULL',
1704
'IS NOT NULL'), my_decimal, id FROM t1_values
1705
WHERE select_id = 120 OR select_id IS NULL order by id;
1706
IF(my_decimal IS NULL, 'IS NULL',
1707
'IS NOT NULL') my_decimal id
1709
IS NOT NULL -9999999999999999999999999999999999.999999999999999999999999999999 2
1710
IS NOT NULL 9999999999999999999999999999999999.999999999999999999999999999999 3
1711
IS NOT NULL 0.000000000000000000000000000000 4
1712
IS NOT NULL -1.000000000000000000000000000000 5
1713
SHOW CREATE VIEW v1;
1714
View Create View character_set_client collation_connection
1715
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',
1716
'IS NOT NULL')`,`t1_values`.`my_decimal` AS `my_decimal`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1718
WHERE v1.id IN (SELECT id FROM t1_values
1719
WHERE select_id = 120 OR select_id IS NULL) order by id;
1720
IF(my_decimal IS NULL, 'IS NULL',
1721
'IS NOT NULL') my_decimal id
1723
IS NOT NULL -9999999999999999999999999999999999.999999999999999999999999999999 2
1724
IS NOT NULL 9999999999999999999999999999999999.999999999999999999999999999999 3
1725
IS NOT NULL 0.000000000000000000000000000000 4
1726
IS NOT NULL -1.000000000000000000000000000000 5
1730
CREATE VIEW v1 AS SELECT IF(my_bigint IS NULL, 'IS NULL',
1731
'IS NOT NULL'), my_bigint, id FROM t1_values;
1732
SELECT IF(my_bigint IS NULL, 'IS NULL',
1733
'IS NOT NULL'), my_bigint, id FROM t1_values
1734
WHERE select_id = 119 OR select_id IS NULL order by id;
1735
IF(my_bigint IS NULL, 'IS NULL',
1736
'IS NOT NULL') my_bigint id
1738
IS NOT NULL -9223372036854775808 2
1739
IS NOT NULL 9223372036854775807 3
1742
SHOW CREATE VIEW v1;
1743
View Create View character_set_client collation_connection
1744
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',
1745
'IS NOT NULL')`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1747
WHERE v1.id IN (SELECT id FROM t1_values
1748
WHERE select_id = 119 OR select_id IS NULL) order by id;
1749
IF(my_bigint IS NULL, 'IS NULL',
1750
'IS NOT NULL') my_bigint id
1752
IS NOT NULL -9223372036854775808 2
1753
IS NOT NULL 9223372036854775807 3
1759
CREATE VIEW v1 AS SELECT IF(my_varbinary_1000 IS NULL, 'IS NULL',
1760
'IS NOT NULL'), my_varbinary_1000, id FROM t1_values;
1761
SELECT IF(my_varbinary_1000 IS NULL, 'IS NULL',
1762
'IS NOT NULL'), my_varbinary_1000, id FROM t1_values
1763
WHERE select_id = 118 OR select_id IS NULL order by id;
1764
IF(my_varbinary_1000 IS NULL, 'IS NULL',
1765
'IS NOT NULL') my_varbinary_1000 id
1768
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1769
IS NOT NULL ---äÖüß@µ*$-- 4
1771
SHOW CREATE VIEW v1;
1772
View Create View character_set_client collation_connection
1773
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',
1774
'IS NOT NULL')`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1776
WHERE v1.id IN (SELECT id FROM t1_values
1777
WHERE select_id = 118 OR select_id IS NULL) order by id;
1778
IF(my_varbinary_1000 IS NULL, 'IS NULL',
1779
'IS NOT NULL') my_varbinary_1000 id
1782
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1783
IS NOT NULL ---äÖüß@µ*$-- 4
1788
CREATE VIEW v1 AS SELECT IF(my_binary_30 IS NULL, 'IS NULL',
1789
'IS NOT NULL'), my_binary_30, id FROM t1_values;
1790
SELECT IF(my_binary_30 IS NULL, 'IS NULL',
1791
'IS NOT NULL'), my_binary_30, id FROM t1_values
1792
WHERE select_id = 117 OR select_id IS NULL order by id;
1793
IF(my_binary_30 IS NULL, 'IS NULL',
1794
'IS NOT NULL') my_binary_30 id
1797
IS NOT NULL <--------30 characters-------> 3
1798
IS NOT NULL ---äÖüß@µ*$-- 4
1800
SHOW CREATE VIEW v1;
1801
View Create View character_set_client collation_connection
1802
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',
1803
'IS NOT NULL')`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1805
WHERE v1.id IN (SELECT id FROM t1_values
1806
WHERE select_id = 117 OR select_id IS NULL) order by id;
1807
IF(my_binary_30 IS NULL, 'IS NULL',
1808
'IS NOT NULL') my_binary_30 id
1811
IS NOT NULL <--------30 characters-------> 3
1812
IS NOT NULL ---äÖüß@µ*$-- 4
1817
CREATE VIEW v1 AS SELECT IF(my_varchar_1000 IS NULL, 'IS NULL',
1818
'IS NOT NULL'), my_varchar_1000, id FROM t1_values;
1819
SELECT IF(my_varchar_1000 IS NULL, 'IS NULL',
1820
'IS NOT NULL'), my_varchar_1000, id FROM t1_values
1821
WHERE select_id = 116 OR select_id IS NULL order by id;
1822
IF(my_varchar_1000 IS NULL, 'IS NULL',
1823
'IS NOT NULL') my_varchar_1000 id
1826
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1827
IS NOT NULL ---äÖüß@µ*$-- 4
1829
SHOW CREATE VIEW v1;
1830
View Create View character_set_client collation_connection
1831
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',
1832
'IS NOT NULL')`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1834
WHERE v1.id IN (SELECT id FROM t1_values
1835
WHERE select_id = 116 OR select_id IS NULL) order by id;
1836
IF(my_varchar_1000 IS NULL, 'IS NULL',
1837
'IS NOT NULL') my_varchar_1000 id
1840
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1841
IS NOT NULL ---äÖüß@µ*$-- 4
1846
CREATE VIEW v1 AS SELECT IF(my_char_30 IS NULL, 'IS NULL',
1847
'IS NOT NULL'), my_char_30, id FROM t1_values;
1848
SELECT IF(my_char_30 IS NULL, 'IS NULL',
1849
'IS NOT NULL'), my_char_30, id FROM t1_values
1850
WHERE select_id = 115 OR select_id IS NULL order by id;
1851
IF(my_char_30 IS NULL, 'IS NULL',
1852
'IS NOT NULL') my_char_30 id
1855
IS NOT NULL <--------30 characters-------> 3
1856
IS NOT NULL ---äÖüß@µ*$-- 4
1858
SHOW CREATE VIEW v1;
1859
View Create View character_set_client collation_connection
1860
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',
1861
'IS NOT NULL')`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1863
WHERE v1.id IN (SELECT id FROM t1_values
1864
WHERE select_id = 115 OR select_id IS NULL) order by id;
1865
IF(my_char_30 IS NULL, 'IS NULL',
1866
'IS NOT NULL') my_char_30 id
1869
IS NOT NULL <--------30 characters-------> 3
1870
IS NOT NULL ---äÖüß@µ*$-- 4
1875
CREATE VIEW v1 AS SELECT IF(my_year, 'IS TRUE', 'IS NOT TRUE'),
1876
my_year, id FROM t1_values;
1877
SELECT IF(my_year, 'IS TRUE', 'IS NOT TRUE'),
1878
my_year, id FROM t1_values
1879
WHERE select_id = 114 OR select_id IS NULL order by id;
1880
IF(my_year, 'IS TRUE', 'IS NOT TRUE') my_year id
1886
SHOW CREATE VIEW v1;
1887
View Create View character_set_client collation_connection
1888
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
1890
WHERE v1.id IN (SELECT id FROM t1_values
1891
WHERE select_id = 114 OR select_id IS NULL) order by id;
1892
IF(my_year, 'IS TRUE', 'IS NOT TRUE') my_year id
1901
CREATE VIEW v1 AS SELECT IF(my_time, 'IS TRUE', 'IS NOT TRUE'),
1902
my_time, id FROM t1_values;
1903
SELECT IF(my_time, 'IS TRUE', 'IS NOT TRUE'),
1904
my_time, id FROM t1_values
1905
WHERE select_id = 113 OR select_id IS NULL order by id;
1906
IF(my_time, 'IS TRUE', 'IS NOT TRUE') my_time id
1908
IS TRUE -838:59:59 2
1912
SHOW CREATE VIEW v1;
1913
View Create View character_set_client collation_connection
1914
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
1916
WHERE v1.id IN (SELECT id FROM t1_values
1917
WHERE select_id = 113 OR select_id IS NULL) order by id;
1918
IF(my_time, 'IS TRUE', 'IS NOT TRUE') my_time id
1920
IS TRUE -838:59:59 2
1927
CREATE VIEW v1 AS SELECT IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE'),
1928
my_timestamp, id FROM t1_values;
1929
SELECT IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE'),
1930
my_timestamp, id FROM t1_values
1931
WHERE select_id = 112 OR select_id IS NULL order by id;
1932
IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE') my_timestamp id
1933
IS NOT TRUE 0000-00-00 00:00:00 1
1934
IS TRUE 1970-01-01 03:00:01 2
1935
IS TRUE 2038-01-01 02:59:59 3
1936
IS TRUE 2004-02-29 23:59:59 4
1937
IS TRUE 2005-06-28 10:00:00 5
1938
SHOW CREATE VIEW v1;
1939
View Create View character_set_client collation_connection
1940
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
1942
WHERE v1.id IN (SELECT id FROM t1_values
1943
WHERE select_id = 112 OR select_id IS NULL) order by id;
1944
IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE') my_timestamp id
1945
IS NOT TRUE 0000-00-00 00:00:00 1
1946
IS TRUE 1970-01-01 03:00:01 2
1947
IS TRUE 2038-01-01 02:59:59 3
1948
IS TRUE 2004-02-29 23:59:59 4
1949
IS TRUE 2005-06-28 10:00:00 5
1953
CREATE VIEW v1 AS SELECT IF(my_date, 'IS TRUE', 'IS NOT TRUE'),
1954
my_date, id FROM t1_values;
1955
SELECT IF(my_date, 'IS TRUE', 'IS NOT TRUE'),
1956
my_date, id FROM t1_values
1957
WHERE select_id = 111 OR select_id IS NULL order by id;
1958
IF(my_date, 'IS TRUE', 'IS NOT TRUE') my_date id
1960
IS TRUE 0001-01-01 2
1961
IS TRUE 9999-12-31 3
1962
IS TRUE 2004-02-29 4
1963
IS TRUE 2005-06-28 5
1964
SHOW CREATE VIEW v1;
1965
View Create View character_set_client collation_connection
1966
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
1968
WHERE v1.id IN (SELECT id FROM t1_values
1969
WHERE select_id = 111 OR select_id IS NULL) order by id;
1970
IF(my_date, 'IS TRUE', 'IS NOT TRUE') my_date id
1972
IS TRUE 0001-01-01 2
1973
IS TRUE 9999-12-31 3
1974
IS TRUE 2004-02-29 4
1975
IS TRUE 2005-06-28 5
1979
CREATE VIEW v1 AS SELECT IF(my_datetime, 'IS TRUE', 'IS NOT TRUE'),
1980
my_datetime, id FROM t1_values;
1981
SELECT IF(my_datetime, 'IS TRUE', 'IS NOT TRUE'),
1982
my_datetime, id FROM t1_values
1983
WHERE select_id = 110 OR select_id IS NULL order by id;
1984
IF(my_datetime, 'IS TRUE', 'IS NOT TRUE') my_datetime id
1986
IS TRUE 0001-01-01 00:00:00 2
1987
IS TRUE 9999-12-31 23:59:59 3
1988
IS TRUE 2004-02-29 23:59:59 4
1989
IS TRUE 2005-06-28 10:00:00 5
1990
SHOW CREATE VIEW v1;
1991
View Create View character_set_client collation_connection
1992
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
1994
WHERE v1.id IN (SELECT id FROM t1_values
1995
WHERE select_id = 110 OR select_id IS NULL) order by id;
1996
IF(my_datetime, 'IS TRUE', 'IS NOT TRUE') my_datetime id
1998
IS TRUE 0001-01-01 00:00:00 2
1999
IS TRUE 9999-12-31 23:59:59 3
2000
IS TRUE 2004-02-29 23:59:59 4
2001
IS TRUE 2005-06-28 10:00:00 5
2005
CREATE VIEW v1 AS SELECT IF(my_double, 'IS TRUE', 'IS NOT TRUE'),
2006
my_double, id FROM t1_values;
2007
SELECT IF(my_double, 'IS TRUE', 'IS NOT TRUE'),
2008
my_double, id FROM t1_values
2009
WHERE select_id = 109 OR select_id IS NULL order by id;
2010
IF(my_double, 'IS TRUE', 'IS NOT TRUE') my_double id
2012
IS TRUE -1.7976931348623e308 2
2013
IS TRUE 1.7976931348623e308 3
2016
SHOW CREATE VIEW v1;
2017
View Create View character_set_client collation_connection
2018
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
2020
WHERE v1.id IN (SELECT id FROM t1_values
2021
WHERE select_id = 109 OR select_id IS NULL) order by id;
2022
IF(my_double, 'IS TRUE', 'IS NOT TRUE') my_double id
2024
IS TRUE -1.7976931348623e308 2
2025
IS TRUE 1.7976931348623e308 3
2031
CREATE VIEW v1 AS SELECT IF(my_decimal, 'IS TRUE', 'IS NOT TRUE'),
2032
my_decimal, id FROM t1_values;
2033
SELECT IF(my_decimal, 'IS TRUE', 'IS NOT TRUE'),
2034
my_decimal, id FROM t1_values
2035
WHERE select_id = 108 OR select_id IS NULL order by id;
2036
IF(my_decimal, 'IS TRUE', 'IS NOT TRUE') my_decimal id
2038
IS TRUE -9999999999999999999999999999999999.999999999999999999999999999999 2
2039
IS TRUE 9999999999999999999999999999999999.999999999999999999999999999999 3
2040
IS NOT TRUE 0.000000000000000000000000000000 4
2041
IS TRUE -1.000000000000000000000000000000 5
2042
SHOW CREATE VIEW v1;
2043
View Create View character_set_client collation_connection
2044
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
2046
WHERE v1.id IN (SELECT id FROM t1_values
2047
WHERE select_id = 108 OR select_id IS NULL) order by id;
2048
IF(my_decimal, 'IS TRUE', 'IS NOT TRUE') my_decimal id
2050
IS TRUE -9999999999999999999999999999999999.999999999999999999999999999999 2
2051
IS TRUE 9999999999999999999999999999999999.999999999999999999999999999999 3
2052
IS NOT TRUE 0.000000000000000000000000000000 4
2053
IS TRUE -1.000000000000000000000000000000 5
2057
CREATE VIEW v1 AS SELECT IF(my_bigint, 'IS TRUE', 'IS NOT TRUE'),
2058
my_bigint, id FROM t1_values;
2059
SELECT IF(my_bigint, 'IS TRUE', 'IS NOT TRUE'),
2060
my_bigint, id FROM t1_values
2061
WHERE select_id = 107 OR select_id IS NULL order by id;
2062
IF(my_bigint, 'IS TRUE', 'IS NOT TRUE') my_bigint id
2064
IS TRUE -9223372036854775808 2
2065
IS TRUE 9223372036854775807 3
2068
SHOW CREATE VIEW v1;
2069
View Create View character_set_client collation_connection
2070
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
2072
WHERE v1.id IN (SELECT id FROM t1_values
2073
WHERE select_id = 107 OR select_id IS NULL) order by id;
2074
IF(my_bigint, 'IS TRUE', 'IS NOT TRUE') my_bigint id
2076
IS TRUE -9223372036854775808 2
2077
IS TRUE 9223372036854775807 3
2083
CREATE VIEW v1 AS SELECT IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE'),
2084
my_varbinary_1000, id FROM t1_values;
2085
SELECT IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE'),
2086
my_varbinary_1000, id FROM t1_values
2087
WHERE select_id = 106 OR select_id IS NULL order by id;
2088
IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE') my_varbinary_1000 id
2091
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2092
IS NOT TRUE ---äÖüß@µ*$-- 4
2094
SHOW CREATE VIEW v1;
2095
View Create View character_set_client collation_connection
2096
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
2098
WHERE v1.id IN (SELECT id FROM t1_values
2099
WHERE select_id = 106 OR select_id IS NULL) order by id;
2100
IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE') my_varbinary_1000 id
2103
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2104
IS NOT TRUE ---äÖüß@µ*$-- 4
2109
CREATE VIEW v1 AS SELECT IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE'),
2110
my_binary_30, id FROM t1_values;
2111
SELECT IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE'),
2112
my_binary_30, id FROM t1_values
2113
WHERE select_id = 105 OR select_id IS NULL order by id;
2114
IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE') my_binary_30 id
2117
IS NOT TRUE <--------30 characters-------> 3
2118
IS NOT TRUE ---äÖüß@µ*$-- 4
2121
Warning 1292 Truncated incorrect DOUBLE value: ''
2122
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2123
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2124
Warning 1292 Truncated incorrect DOUBLE value: '-1'
2125
SHOW CREATE VIEW v1;
2126
View Create View character_set_client collation_connection
2127
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
2129
WHERE v1.id IN (SELECT id FROM t1_values
2130
WHERE select_id = 105 OR select_id IS NULL) order by id;
2131
IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE') my_binary_30 id
2134
IS NOT TRUE <--------30 characters-------> 3
2135
IS NOT TRUE ---äÖüß@µ*$-- 4
2138
Warning 1292 Truncated incorrect DOUBLE value: ''
2139
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2140
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2141
Warning 1292 Truncated incorrect DOUBLE value: '-1'
2145
CREATE VIEW v1 AS SELECT IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE'),
2146
my_varchar_1000, id FROM t1_values;
2147
SELECT IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE'),
2148
my_varchar_1000, id FROM t1_values
2149
WHERE select_id = 104 OR select_id IS NULL order by id;
2150
IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE') my_varchar_1000 id
2153
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2154
IS NOT TRUE ---äÖüß@µ*$-- 4
2156
SHOW CREATE VIEW v1;
2157
View Create View character_set_client collation_connection
2158
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
2160
WHERE v1.id IN (SELECT id FROM t1_values
2161
WHERE select_id = 104 OR select_id IS NULL) order by id;
2162
IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE') my_varchar_1000 id
2165
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2166
IS NOT TRUE ---äÖüß@µ*$-- 4
2171
CREATE VIEW v1 AS SELECT IF(my_char_30, 'IS TRUE', 'IS NOT TRUE'),
2172
my_char_30, id FROM t1_values;
2173
SELECT IF(my_char_30, 'IS TRUE', 'IS NOT TRUE'),
2174
my_char_30, id FROM t1_values
2175
WHERE select_id = 103 OR select_id IS NULL order by id;
2176
IF(my_char_30, 'IS TRUE', 'IS NOT TRUE') my_char_30 id
2179
IS NOT TRUE <--------30 characters-------> 3
2180
IS NOT TRUE ---äÖüß@µ*$-- 4
2183
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2184
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2185
SHOW CREATE VIEW v1;
2186
View Create View character_set_client collation_connection
2187
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
2189
WHERE v1.id IN (SELECT id FROM t1_values
2190
WHERE select_id = 103 OR select_id IS NULL) order by id;
2191
IF(my_char_30, 'IS TRUE', 'IS NOT TRUE') my_char_30 id
2194
IS NOT TRUE <--------30 characters-------> 3
2195
IS NOT TRUE ---äÖüß@µ*$-- 4
2198
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2199
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2203
CREATE VIEW v1 AS SELECT CONVERT(my_varbinary_1000 USING koi8r),
2204
my_varbinary_1000, id FROM t1_values;
2205
SELECT CONVERT(my_varbinary_1000 USING koi8r),
2206
my_varbinary_1000, id FROM t1_values
2207
WHERE select_id = 102 OR select_id IS NULL order by id;
2208
CONVERT(my_varbinary_1000 USING koi8r) my_varbinary_1000 id
2211
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2212
---???????�@??*$-- ---äÖüß@µ*$-- 4
2214
SHOW CREATE VIEW v1;
2215
View Create View character_set_client collation_connection
2216
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
2218
WHERE v1.id IN (SELECT id FROM t1_values
2219
WHERE select_id = 102 OR select_id IS NULL) order by id;
2220
CONVERT(my_varbinary_1000 USING koi8r) my_varbinary_1000 id
2223
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2224
---???????�@??*$-- ---äÖüß@µ*$-- 4
2229
CREATE VIEW v1 AS SELECT CONVERT(my_binary_30 USING koi8r),
2230
my_binary_30, id FROM t1_values;
2231
SELECT CONVERT(my_binary_30 USING koi8r),
2232
my_binary_30, id FROM t1_values
2233
WHERE select_id = 101 OR select_id IS NULL order by id;
2234
CONVERT(my_binary_30 USING koi8r) my_binary_30 id
2237
<--------30 characters-------> <--------30 characters-------> 3
2238
---???????�@??*$-- ---äÖüß@µ*$-- 4
2240
SHOW CREATE VIEW v1;
2241
View Create View character_set_client collation_connection
2242
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
2244
WHERE v1.id IN (SELECT id FROM t1_values
2245
WHERE select_id = 101 OR select_id IS NULL) order by id;
2246
CONVERT(my_binary_30 USING koi8r) my_binary_30 id
2249
<--------30 characters-------> <--------30 characters-------> 3
2250
---???????�@??*$-- ---äÖüß@µ*$-- 4
2255
CREATE VIEW v1 AS SELECT CONVERT(my_varchar_1000 USING koi8r),
2256
my_varchar_1000, id FROM t1_values;
2257
SELECT CONVERT(my_varchar_1000 USING koi8r),
2258
my_varchar_1000, id FROM t1_values
2259
WHERE select_id = 100 OR select_id IS NULL order by id;
2260
CONVERT(my_varchar_1000 USING koi8r) my_varchar_1000 id
2263
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2264
---????????@??*$-- ---äÖüß@µ*$-- 4
2266
SHOW CREATE VIEW v1;
2267
View Create View character_set_client collation_connection
2268
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
2270
WHERE v1.id IN (SELECT id FROM t1_values
2271
WHERE select_id = 100 OR select_id IS NULL) order by id;
2272
CONVERT(my_varchar_1000 USING koi8r) my_varchar_1000 id
2275
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2276
---????????@??*$-- ---äÖüß@µ*$-- 4
2281
CREATE VIEW v1 AS SELECT CONVERT(my_char_30 USING koi8r),
2282
my_char_30, id FROM t1_values;
2283
SELECT CONVERT(my_char_30 USING koi8r),
2284
my_char_30, id FROM t1_values
2285
WHERE select_id = 99 OR select_id IS NULL order by id;
2286
CONVERT(my_char_30 USING koi8r) my_char_30 id
2289
<--------30 characters-------> <--------30 characters-------> 3
2290
---????????@??*$-- ---äÖüß@µ*$-- 4
2292
SHOW CREATE VIEW v1;
2293
View Create View character_set_client collation_connection
2294
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
2296
WHERE v1.id IN (SELECT id FROM t1_values
2297
WHERE select_id = 99 OR select_id IS NULL) order by id;
2298
CONVERT(my_char_30 USING koi8r) my_char_30 id
2301
<--------30 characters-------> <--------30 characters-------> 3
2302
---????????@??*$-- ---äÖüß@µ*$-- 4
2307
CREATE VIEW v1 AS SELECT CONVERT(my_varbinary_1000 USING utf8),
2308
my_varbinary_1000, id FROM t1_values;
2309
SELECT CONVERT(my_varbinary_1000 USING utf8),
2310
my_varbinary_1000, id FROM t1_values
2311
WHERE select_id = 98 OR select_id IS NULL order by id;
2312
CONVERT(my_varbinary_1000 USING utf8) my_varbinary_1000 id
2315
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2316
---����@�*$-- ---äÖüß@µ*$-- 4
2318
SHOW CREATE VIEW v1;
2319
View Create View character_set_client collation_connection
2320
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
2322
WHERE v1.id IN (SELECT id FROM t1_values
2323
WHERE select_id = 98 OR select_id IS NULL) order by id;
2324
CONVERT(my_varbinary_1000 USING utf8) my_varbinary_1000 id
2327
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2328
---����@�*$-- ---äÖüß@µ*$-- 4
2333
CREATE VIEW v1 AS SELECT CONVERT(my_binary_30 USING utf8),
2334
my_binary_30, id FROM t1_values;
2335
SELECT CONVERT(my_binary_30 USING utf8),
2336
my_binary_30, id FROM t1_values
2337
WHERE select_id = 97 OR select_id IS NULL order by id;
2338
CONVERT(my_binary_30 USING utf8) my_binary_30 id
2341
<--------30 characters-------> <--------30 characters-------> 3
2342
---����@�*$-- ---äÖüß@µ*$-- 4
2344
SHOW CREATE VIEW v1;
2345
View Create View character_set_client collation_connection
2346
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
2348
WHERE v1.id IN (SELECT id FROM t1_values
2349
WHERE select_id = 97 OR select_id IS NULL) order by id;
2350
CONVERT(my_binary_30 USING utf8) my_binary_30 id
2353
<--------30 characters-------> <--------30 characters-------> 3
2354
---����@�*$-- ---äÖüß@µ*$-- 4
2359
CREATE VIEW v1 AS SELECT CONVERT(my_varchar_1000 USING utf8),
2360
my_varchar_1000, id FROM t1_values;
2361
SELECT CONVERT(my_varchar_1000 USING utf8),
2362
my_varchar_1000, id FROM t1_values
2363
WHERE select_id = 96 OR select_id IS NULL order by id;
2364
CONVERT(my_varchar_1000 USING utf8) my_varchar_1000 id
2367
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2368
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2370
SHOW CREATE VIEW v1;
2371
View Create View character_set_client collation_connection
2372
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
2374
WHERE v1.id IN (SELECT id FROM t1_values
2375
WHERE select_id = 96 OR select_id IS NULL) order by id;
2376
CONVERT(my_varchar_1000 USING utf8) my_varchar_1000 id
2379
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2380
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2385
CREATE VIEW v1 AS SELECT CONVERT(my_char_30 USING utf8),
2386
my_char_30, id FROM t1_values;
2387
SELECT CONVERT(my_char_30 USING utf8),
2388
my_char_30, id FROM t1_values
2389
WHERE select_id = 95 OR select_id IS NULL order by id;
2390
CONVERT(my_char_30 USING utf8) my_char_30 id
2393
<--------30 characters-------> <--------30 characters-------> 3
2394
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2396
SHOW CREATE VIEW v1;
2397
View Create View character_set_client collation_connection
2398
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
2400
WHERE v1.id IN (SELECT id FROM t1_values
2401
WHERE select_id = 95 OR select_id IS NULL) order by id;
2402
CONVERT(my_char_30 USING utf8) my_char_30 id
2405
<--------30 characters-------> <--------30 characters-------> 3
2406
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2411
CREATE VIEW v1 AS SELECT CAST(my_year AS UNSIGNED INTEGER),
2412
my_year, id FROM t1_values;
2413
SELECT CAST(my_year AS UNSIGNED INTEGER),
2414
my_year, id FROM t1_values
2415
WHERE select_id = 94 OR select_id IS NULL order by id;
2416
CAST(my_year AS UNSIGNED INTEGER) my_year id
2422
SHOW CREATE VIEW v1;
2423
View Create View character_set_client collation_connection
2424
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
2426
WHERE v1.id IN (SELECT id FROM t1_values
2427
WHERE select_id = 94 OR select_id IS NULL) order by id;
2428
CAST(my_year AS UNSIGNED INTEGER) my_year id
2437
CREATE VIEW v1 AS SELECT CAST(my_time AS UNSIGNED INTEGER),
2438
my_time, id FROM t1_values;
2439
SELECT CAST(my_time AS UNSIGNED INTEGER),
2440
my_time, id FROM t1_values
2441
WHERE select_id = 93 OR select_id IS NULL order by id;
2442
CAST(my_time AS UNSIGNED INTEGER) my_time id
2444
18446744073701165657 -838:59:59 2
2448
SHOW CREATE VIEW v1;
2449
View Create View character_set_client collation_connection
2450
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
2452
WHERE v1.id IN (SELECT id FROM t1_values
2453
WHERE select_id = 93 OR select_id IS NULL) order by id;
2454
CAST(my_time AS UNSIGNED INTEGER) my_time id
2456
18446744073701165657 -838:59:59 2
2463
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS UNSIGNED INTEGER),
2464
my_timestamp, id FROM t1_values;
2465
SELECT CAST(my_timestamp AS UNSIGNED INTEGER),
2466
my_timestamp, id FROM t1_values
2467
WHERE select_id = 92 OR select_id IS NULL order by id;
2468
CAST(my_timestamp AS UNSIGNED INTEGER) my_timestamp id
2469
0 0000-00-00 00:00:00 1
2470
19700101030001 1970-01-01 03:00:01 2
2471
20380101025959 2038-01-01 02:59:59 3
2472
20040229235959 2004-02-29 23:59:59 4
2473
20050628100000 2005-06-28 10:00:00 5
2474
SHOW CREATE VIEW v1;
2475
View Create View character_set_client collation_connection
2476
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
2478
WHERE v1.id IN (SELECT id FROM t1_values
2479
WHERE select_id = 92 OR select_id IS NULL) order by id;
2480
CAST(my_timestamp AS UNSIGNED INTEGER) my_timestamp id
2481
0 0000-00-00 00:00:00 1
2482
19700101030001 1970-01-01 03:00:01 2
2483
20380101025959 2038-01-01 02:59:59 3
2484
20040229235959 2004-02-29 23:59:59 4
2485
20050628100000 2005-06-28 10:00:00 5
2489
CREATE VIEW v1 AS SELECT CAST(my_date AS UNSIGNED INTEGER),
2490
my_date, id FROM t1_values;
2491
SELECT CAST(my_date AS UNSIGNED INTEGER),
2492
my_date, id FROM t1_values
2493
WHERE select_id = 91 OR select_id IS NULL order by id;
2494
CAST(my_date AS UNSIGNED INTEGER) my_date id
2497
99991231 9999-12-31 3
2498
20040229 2004-02-29 4
2499
20050628 2005-06-28 5
2500
SHOW CREATE VIEW v1;
2501
View Create View character_set_client collation_connection
2502
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
2504
WHERE v1.id IN (SELECT id FROM t1_values
2505
WHERE select_id = 91 OR select_id IS NULL) order by id;
2506
CAST(my_date AS UNSIGNED INTEGER) my_date id
2509
99991231 9999-12-31 3
2510
20040229 2004-02-29 4
2511
20050628 2005-06-28 5
2515
CREATE VIEW v1 AS SELECT CAST(my_datetime AS UNSIGNED INTEGER),
2516
my_datetime, id FROM t1_values;
2517
SELECT CAST(my_datetime AS UNSIGNED INTEGER),
2518
my_datetime, id FROM t1_values
2519
WHERE select_id = 90 OR select_id IS NULL order by id;
2520
CAST(my_datetime AS UNSIGNED INTEGER) my_datetime id
2522
10101000000 0001-01-01 00:00:00 2
2523
99991231235959 9999-12-31 23:59:59 3
2524
20040229235959 2004-02-29 23:59:59 4
2525
20050628100000 2005-06-28 10:00:00 5
2526
SHOW CREATE VIEW v1;
2527
View Create View character_set_client collation_connection
2528
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
2530
WHERE v1.id IN (SELECT id FROM t1_values
2531
WHERE select_id = 90 OR select_id IS NULL) order by id;
2532
CAST(my_datetime AS UNSIGNED INTEGER) my_datetime id
2534
10101000000 0001-01-01 00:00:00 2
2535
99991231235959 9999-12-31 23:59:59 3
2536
20040229235959 2004-02-29 23:59:59 4
2537
20050628100000 2005-06-28 10:00:00 5
2541
CREATE VIEW v1 AS SELECT CAST(my_double AS UNSIGNED INTEGER),
2542
my_double, id FROM t1_values;
2543
SELECT CAST(my_double AS UNSIGNED INTEGER),
2544
my_double, id FROM t1_values
2545
WHERE select_id = 89 OR select_id IS NULL order by id;
2546
CAST(my_double AS UNSIGNED INTEGER) my_double id
2548
9223372036854775808 -1.7976931348623e308 2
2549
9223372036854775807 1.7976931348623e308 3
2551
18446744073709551615 -1 5
2553
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2554
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2555
SHOW CREATE VIEW v1;
2556
View Create View character_set_client collation_connection
2557
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
2559
WHERE v1.id IN (SELECT id FROM t1_values
2560
WHERE select_id = 89 OR select_id IS NULL) order by id;
2561
CAST(my_double AS UNSIGNED INTEGER) my_double id
2563
9223372036854775808 -1.7976931348623e308 2
2564
9223372036854775807 1.7976931348623e308 3
2566
18446744073709551615 -1 5
2568
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2569
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2573
CREATE VIEW v1 AS SELECT CAST(my_decimal AS UNSIGNED INTEGER),
2574
my_decimal, id FROM t1_values;
2575
SELECT CAST(my_decimal AS UNSIGNED INTEGER),
2576
my_decimal, id FROM t1_values
2577
WHERE select_id = 88 OR select_id IS NULL order by id;
2578
CAST(my_decimal AS UNSIGNED INTEGER) my_decimal id
2580
0 -9999999999999999999999999999999999.999999999999999999999999999999 2
2581
18446744073709551615 9999999999999999999999999999999999.999999999999999999999999999999 3
2582
0 0.000000000000000000000000000000 4
2583
0 -1.000000000000000000000000000000 5
2585
Error 1292 Truncated incorrect DECIMAL value: ''
2586
Error 1292 Truncated incorrect DECIMAL value: ''
2587
Error 1292 Truncated incorrect DECIMAL value: ''
2588
SHOW CREATE VIEW v1;
2589
View Create View character_set_client collation_connection
2590
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
2592
WHERE v1.id IN (SELECT id FROM t1_values
2593
WHERE select_id = 88 OR select_id IS NULL) order by id;
2594
CAST(my_decimal AS UNSIGNED INTEGER) my_decimal id
2596
0 -9999999999999999999999999999999999.999999999999999999999999999999 2
2597
18446744073709551615 9999999999999999999999999999999999.999999999999999999999999999999 3
2598
0 0.000000000000000000000000000000 4
2599
0 -1.000000000000000000000000000000 5
2601
Error 1292 Truncated incorrect DECIMAL value: ''
2602
Error 1292 Truncated incorrect DECIMAL value: ''
2603
Error 1292 Truncated incorrect DECIMAL value: ''
2607
CREATE VIEW v1 AS SELECT CAST(my_bigint AS UNSIGNED INTEGER),
2608
my_bigint, id FROM t1_values;
2609
SELECT CAST(my_bigint AS UNSIGNED INTEGER),
2610
my_bigint, id FROM t1_values
2611
WHERE select_id = 87 OR select_id IS NULL order by id;
2612
CAST(my_bigint AS UNSIGNED INTEGER) my_bigint id
2614
9223372036854775808 -9223372036854775808 2
2615
9223372036854775807 9223372036854775807 3
2617
18446744073709551615 -1 5
2618
SHOW CREATE VIEW v1;
2619
View Create View character_set_client collation_connection
2620
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
2622
WHERE v1.id IN (SELECT id FROM t1_values
2623
WHERE select_id = 87 OR select_id IS NULL) order by id;
2624
CAST(my_bigint AS UNSIGNED INTEGER) my_bigint id
2626
9223372036854775808 -9223372036854775808 2
2627
9223372036854775807 9223372036854775807 3
2629
18446744073709551615 -1 5
2633
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS UNSIGNED INTEGER),
2634
my_varbinary_1000, id FROM t1_values;
2635
SELECT CAST(my_varbinary_1000 AS UNSIGNED INTEGER),
2636
my_varbinary_1000, id FROM t1_values
2637
WHERE select_id = 86 OR select_id IS NULL order by id;
2638
CAST(my_varbinary_1000 AS UNSIGNED INTEGER) my_varbinary_1000 id
2641
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2643
18446744073709551615 -1 5
2645
Warning 1292 Truncated incorrect INTEGER value: ''
2646
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2647
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2648
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2649
SHOW CREATE VIEW v1;
2650
View Create View character_set_client collation_connection
2651
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
2653
WHERE v1.id IN (SELECT id FROM t1_values
2654
WHERE select_id = 86 OR select_id IS NULL) order by id;
2655
CAST(my_varbinary_1000 AS UNSIGNED INTEGER) my_varbinary_1000 id
2658
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2660
18446744073709551615 -1 5
2662
Warning 1292 Truncated incorrect INTEGER value: ''
2663
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2664
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2665
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2669
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS UNSIGNED INTEGER),
2670
my_binary_30, id FROM t1_values;
2671
SELECT CAST(my_binary_30 AS UNSIGNED INTEGER),
2672
my_binary_30, id FROM t1_values
2673
WHERE select_id = 85 OR select_id IS NULL order by id;
2674
CAST(my_binary_30 AS UNSIGNED INTEGER) my_binary_30 id
2677
0 <--------30 characters-------> 3
2679
18446744073709551615 -1 5
2681
Warning 1292 Truncated incorrect INTEGER value: ''
2682
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2683
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2684
Warning 1292 Truncated incorrect INTEGER value: '-1'
2685
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2686
SHOW CREATE VIEW v1;
2687
View Create View character_set_client collation_connection
2688
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
2690
WHERE v1.id IN (SELECT id FROM t1_values
2691
WHERE select_id = 85 OR select_id IS NULL) order by id;
2692
CAST(my_binary_30 AS UNSIGNED INTEGER) my_binary_30 id
2695
0 <--------30 characters-------> 3
2697
18446744073709551615 -1 5
2699
Warning 1292 Truncated incorrect INTEGER value: ''
2700
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2701
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2702
Warning 1292 Truncated incorrect INTEGER value: '-1'
2703
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2707
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS UNSIGNED INTEGER),
2708
my_varchar_1000, id FROM t1_values;
2709
SELECT CAST(my_varchar_1000 AS UNSIGNED INTEGER),
2710
my_varchar_1000, id FROM t1_values
2711
WHERE select_id = 84 OR select_id IS NULL order by id;
2712
CAST(my_varchar_1000 AS UNSIGNED INTEGER) my_varchar_1000 id
2715
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2717
18446744073709551615 -1 5
2719
Warning 1292 Truncated incorrect INTEGER value: ''
2720
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2721
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2722
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2723
SHOW CREATE VIEW v1;
2724
View Create View character_set_client collation_connection
2725
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
2727
WHERE v1.id IN (SELECT id FROM t1_values
2728
WHERE select_id = 84 OR select_id IS NULL) order by id;
2729
CAST(my_varchar_1000 AS UNSIGNED INTEGER) my_varchar_1000 id
2732
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2734
18446744073709551615 -1 5
2736
Warning 1292 Truncated incorrect INTEGER value: ''
2737
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2738
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2739
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2743
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS UNSIGNED INTEGER),
2744
my_char_30, id FROM t1_values;
2745
SELECT CAST(my_char_30 AS UNSIGNED INTEGER),
2746
my_char_30, id FROM t1_values
2747
WHERE select_id = 83 OR select_id IS NULL order by id;
2748
CAST(my_char_30 AS UNSIGNED INTEGER) my_char_30 id
2751
0 <--------30 characters-------> 3
2753
18446744073709551615 -1 5
2755
Warning 1292 Truncated incorrect INTEGER value: ''
2756
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2757
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$--'
2758
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2759
SHOW CREATE VIEW v1;
2760
View Create View character_set_client collation_connection
2761
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
2763
WHERE v1.id IN (SELECT id FROM t1_values
2764
WHERE select_id = 83 OR select_id IS NULL) order by id;
2765
CAST(my_char_30 AS UNSIGNED INTEGER) my_char_30 id
2768
0 <--------30 characters-------> 3
2770
18446744073709551615 -1 5
2772
Warning 1292 Truncated incorrect INTEGER value: ''
2773
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2774
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$--'
2775
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2779
CREATE VIEW v1 AS SELECT CAST(my_year AS SIGNED INTEGER),
2780
my_year, id FROM t1_values;
2781
SELECT CAST(my_year AS SIGNED INTEGER),
2782
my_year, id FROM t1_values
2783
WHERE select_id = 82 OR select_id IS NULL order by id;
2784
CAST(my_year AS SIGNED INTEGER) my_year id
2790
SHOW CREATE VIEW v1;
2791
View Create View character_set_client collation_connection
2792
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
2794
WHERE v1.id IN (SELECT id FROM t1_values
2795
WHERE select_id = 82 OR select_id IS NULL) order by id;
2796
CAST(my_year AS SIGNED INTEGER) my_year id
2805
CREATE VIEW v1 AS SELECT CAST(my_time AS SIGNED INTEGER),
2806
my_time, id FROM t1_values;
2807
SELECT CAST(my_time AS SIGNED INTEGER),
2808
my_time, id FROM t1_values
2809
WHERE select_id = 81 OR select_id IS NULL order by id;
2810
CAST(my_time AS SIGNED INTEGER) my_time id
2812
-8385959 -838:59:59 2
2816
SHOW CREATE VIEW v1;
2817
View Create View character_set_client collation_connection
2818
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
2820
WHERE v1.id IN (SELECT id FROM t1_values
2821
WHERE select_id = 81 OR select_id IS NULL) order by id;
2822
CAST(my_time AS SIGNED INTEGER) my_time id
2824
-8385959 -838:59:59 2
2831
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS SIGNED INTEGER),
2832
my_timestamp, id FROM t1_values;
2833
SELECT CAST(my_timestamp AS SIGNED INTEGER),
2834
my_timestamp, id FROM t1_values
2835
WHERE select_id = 80 OR select_id IS NULL order by id;
2836
CAST(my_timestamp AS SIGNED INTEGER) my_timestamp id
2837
0 0000-00-00 00:00:00 1
2838
19700101030001 1970-01-01 03:00:01 2
2839
20380101025959 2038-01-01 02:59:59 3
2840
20040229235959 2004-02-29 23:59:59 4
2841
20050628100000 2005-06-28 10:00:00 5
2842
SHOW CREATE VIEW v1;
2843
View Create View character_set_client collation_connection
2844
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
2846
WHERE v1.id IN (SELECT id FROM t1_values
2847
WHERE select_id = 80 OR select_id IS NULL) order by id;
2848
CAST(my_timestamp AS SIGNED INTEGER) my_timestamp id
2849
0 0000-00-00 00:00:00 1
2850
19700101030001 1970-01-01 03:00:01 2
2851
20380101025959 2038-01-01 02:59:59 3
2852
20040229235959 2004-02-29 23:59:59 4
2853
20050628100000 2005-06-28 10:00:00 5
2857
CREATE VIEW v1 AS SELECT CAST(my_date AS SIGNED INTEGER),
2858
my_date, id FROM t1_values;
2859
SELECT CAST(my_date AS SIGNED INTEGER),
2860
my_date, id FROM t1_values
2861
WHERE select_id = 79 OR select_id IS NULL order by id;
2862
CAST(my_date AS SIGNED INTEGER) my_date id
2865
99991231 9999-12-31 3
2866
20040229 2004-02-29 4
2867
20050628 2005-06-28 5
2868
SHOW CREATE VIEW v1;
2869
View Create View character_set_client collation_connection
2870
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
2872
WHERE v1.id IN (SELECT id FROM t1_values
2873
WHERE select_id = 79 OR select_id IS NULL) order by id;
2874
CAST(my_date AS SIGNED INTEGER) my_date id
2877
99991231 9999-12-31 3
2878
20040229 2004-02-29 4
2879
20050628 2005-06-28 5
2883
CREATE VIEW v1 AS SELECT CAST(my_datetime AS SIGNED INTEGER),
2884
my_datetime, id FROM t1_values;
2885
SELECT CAST(my_datetime AS SIGNED INTEGER),
2886
my_datetime, id FROM t1_values
2887
WHERE select_id = 78 OR select_id IS NULL order by id;
2888
CAST(my_datetime AS SIGNED INTEGER) my_datetime id
2890
10101000000 0001-01-01 00:00:00 2
2891
99991231235959 9999-12-31 23:59:59 3
2892
20040229235959 2004-02-29 23:59:59 4
2893
20050628100000 2005-06-28 10:00:00 5
2894
SHOW CREATE VIEW v1;
2895
View Create View character_set_client collation_connection
2896
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
2898
WHERE v1.id IN (SELECT id FROM t1_values
2899
WHERE select_id = 78 OR select_id IS NULL) order by id;
2900
CAST(my_datetime AS SIGNED INTEGER) my_datetime id
2902
10101000000 0001-01-01 00:00:00 2
2903
99991231235959 9999-12-31 23:59:59 3
2904
20040229235959 2004-02-29 23:59:59 4
2905
20050628100000 2005-06-28 10:00:00 5
2909
CREATE VIEW v1 AS SELECT CAST(my_double AS SIGNED INTEGER),
2910
my_double, id FROM t1_values;
2911
SELECT CAST(my_double AS SIGNED INTEGER),
2912
my_double, id FROM t1_values
2913
WHERE select_id = 77 OR select_id IS NULL order by id;
2914
CAST(my_double AS SIGNED INTEGER) my_double id
2916
-9223372036854775808 -1.7976931348623e308 2
2917
9223372036854775807 1.7976931348623e308 3
2921
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2922
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2923
SHOW CREATE VIEW v1;
2924
View Create View character_set_client collation_connection
2925
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
2927
WHERE v1.id IN (SELECT id FROM t1_values
2928
WHERE select_id = 77 OR select_id IS NULL) order by id;
2929
CAST(my_double AS SIGNED INTEGER) my_double id
2931
-9223372036854775808 -1.7976931348623e308 2
2932
9223372036854775807 1.7976931348623e308 3
2936
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2937
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2941
CREATE VIEW v1 AS SELECT CAST(my_decimal AS SIGNED INTEGER),
2942
my_decimal, id FROM t1_values;
2943
SELECT CAST(my_decimal AS SIGNED INTEGER),
2944
my_decimal, id FROM t1_values
2945
WHERE select_id = 76 OR select_id IS NULL order by id;
2946
CAST(my_decimal AS SIGNED INTEGER) my_decimal id
2948
-9223372036854775808 -9999999999999999999999999999999999.999999999999999999999999999999 2
2949
9223372036854775807 9999999999999999999999999999999999.999999999999999999999999999999 3
2950
0 0.000000000000000000000000000000 4
2951
-1 -1.000000000000000000000000000000 5
2953
Error 1292 Truncated incorrect DECIMAL value: ''
2954
Error 1292 Truncated incorrect DECIMAL value: ''
2955
SHOW CREATE VIEW v1;
2956
View Create View character_set_client collation_connection
2957
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
2959
WHERE v1.id IN (SELECT id FROM t1_values
2960
WHERE select_id = 76 OR select_id IS NULL) order by id;
2961
CAST(my_decimal AS SIGNED INTEGER) my_decimal id
2963
-9223372036854775808 -9999999999999999999999999999999999.999999999999999999999999999999 2
2964
9223372036854775807 9999999999999999999999999999999999.999999999999999999999999999999 3
2965
0 0.000000000000000000000000000000 4
2966
-1 -1.000000000000000000000000000000 5
2968
Error 1292 Truncated incorrect DECIMAL value: ''
2969
Error 1292 Truncated incorrect DECIMAL value: ''
2973
CREATE VIEW v1 AS SELECT CAST(my_bigint AS SIGNED INTEGER),
2974
my_bigint, id FROM t1_values;
2975
SELECT CAST(my_bigint AS SIGNED INTEGER),
2976
my_bigint, id FROM t1_values
2977
WHERE select_id = 75 OR select_id IS NULL order by id;
2978
CAST(my_bigint AS SIGNED INTEGER) my_bigint id
2980
-9223372036854775808 -9223372036854775808 2
2981
9223372036854775807 9223372036854775807 3
2984
SHOW CREATE VIEW v1;
2985
View Create View character_set_client collation_connection
2986
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
2988
WHERE v1.id IN (SELECT id FROM t1_values
2989
WHERE select_id = 75 OR select_id IS NULL) order by id;
2990
CAST(my_bigint AS SIGNED INTEGER) my_bigint id
2992
-9223372036854775808 -9223372036854775808 2
2993
9223372036854775807 9223372036854775807 3
2999
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS SIGNED INTEGER),
3000
my_varbinary_1000, id FROM t1_values;
3001
SELECT CAST(my_varbinary_1000 AS SIGNED INTEGER),
3002
my_varbinary_1000, id FROM t1_values
3003
WHERE select_id = 74 OR select_id IS NULL order by id;
3004
CAST(my_varbinary_1000 AS SIGNED INTEGER) my_varbinary_1000 id
3007
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3011
Warning 1292 Truncated incorrect INTEGER value: ''
3012
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3013
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3014
SHOW CREATE VIEW v1;
3015
View Create View character_set_client collation_connection
3016
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
3018
WHERE v1.id IN (SELECT id FROM t1_values
3019
WHERE select_id = 74 OR select_id IS NULL) order by id;
3020
CAST(my_varbinary_1000 AS SIGNED INTEGER) my_varbinary_1000 id
3023
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3027
Warning 1292 Truncated incorrect INTEGER value: ''
3028
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3029
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3033
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS SIGNED INTEGER),
3034
my_binary_30, id FROM t1_values;
3035
SELECT CAST(my_binary_30 AS SIGNED INTEGER),
3036
my_binary_30, id FROM t1_values
3037
WHERE select_id = 73 OR select_id IS NULL order by id;
3038
CAST(my_binary_30 AS SIGNED INTEGER) my_binary_30 id
3041
0 <--------30 characters-------> 3
3045
Warning 1292 Truncated incorrect INTEGER value: ''
3046
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3047
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3048
Warning 1292 Truncated incorrect INTEGER value: '-1'
3049
SHOW CREATE VIEW v1;
3050
View Create View character_set_client collation_connection
3051
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
3053
WHERE v1.id IN (SELECT id FROM t1_values
3054
WHERE select_id = 73 OR select_id IS NULL) order by id;
3055
CAST(my_binary_30 AS SIGNED INTEGER) my_binary_30 id
3058
0 <--------30 characters-------> 3
3062
Warning 1292 Truncated incorrect INTEGER value: ''
3063
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3064
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3065
Warning 1292 Truncated incorrect INTEGER value: '-1'
3069
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS SIGNED INTEGER),
3070
my_varchar_1000, id FROM t1_values;
3071
SELECT CAST(my_varchar_1000 AS SIGNED INTEGER),
3072
my_varchar_1000, id FROM t1_values
3073
WHERE select_id = 72 OR select_id IS NULL order by id;
3074
CAST(my_varchar_1000 AS SIGNED INTEGER) my_varchar_1000 id
3077
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3081
Warning 1292 Truncated incorrect INTEGER value: ''
3082
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3083
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3084
SHOW CREATE VIEW v1;
3085
View Create View character_set_client collation_connection
3086
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
3088
WHERE v1.id IN (SELECT id FROM t1_values
3089
WHERE select_id = 72 OR select_id IS NULL) order by id;
3090
CAST(my_varchar_1000 AS SIGNED INTEGER) my_varchar_1000 id
3093
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3097
Warning 1292 Truncated incorrect INTEGER value: ''
3098
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3099
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3103
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS SIGNED INTEGER),
3104
my_char_30, id FROM t1_values;
3105
SELECT CAST(my_char_30 AS SIGNED INTEGER),
3106
my_char_30, id FROM t1_values
3107
WHERE select_id = 71 OR select_id IS NULL order by id;
3108
CAST(my_char_30 AS SIGNED INTEGER) my_char_30 id
3111
0 <--------30 characters-------> 3
3115
Warning 1292 Truncated incorrect INTEGER value: ''
3116
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3117
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$--'
3118
SHOW CREATE VIEW v1;
3119
View Create View character_set_client collation_connection
3120
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
3122
WHERE v1.id IN (SELECT id FROM t1_values
3123
WHERE select_id = 71 OR select_id IS NULL) order by id;
3124
CAST(my_char_30 AS SIGNED INTEGER) my_char_30 id
3127
0 <--------30 characters-------> 3
3131
Warning 1292 Truncated incorrect INTEGER value: ''
3132
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3133
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$--'
3137
CREATE VIEW v1 AS SELECT CAST(my_year AS DECIMAL(37,2)),
3138
my_year, id FROM t1_values;
3139
SELECT CAST(my_year AS DECIMAL(37,2)),
3140
my_year, id FROM t1_values
3141
WHERE select_id = 70 OR select_id IS NULL order by id;
3142
CAST(my_year AS DECIMAL(37,2)) my_year id
3148
SHOW CREATE VIEW v1;
3149
View Create View character_set_client collation_connection
3150
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
3152
WHERE v1.id IN (SELECT id FROM t1_values
3153
WHERE select_id = 70 OR select_id IS NULL) order by id;
3154
CAST(my_year AS DECIMAL(37,2)) my_year id
3163
CREATE VIEW v1 AS SELECT CAST(my_time AS DECIMAL(37,2)),
3164
my_time, id FROM t1_values;
3165
SELECT CAST(my_time AS DECIMAL(37,2)),
3166
my_time, id FROM t1_values
3167
WHERE select_id = 69 OR select_id IS NULL order by id;
3168
CAST(my_time AS DECIMAL(37,2)) my_time id
3170
-8385959.00 -838:59:59 2
3171
8385959.00 838:59:59 3
3172
130000.00 13:00:00 4
3173
100000.00 10:00:00 5
3174
SHOW CREATE VIEW v1;
3175
View Create View character_set_client collation_connection
3176
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
3178
WHERE v1.id IN (SELECT id FROM t1_values
3179
WHERE select_id = 69 OR select_id IS NULL) order by id;
3180
CAST(my_time AS DECIMAL(37,2)) my_time id
3182
-8385959.00 -838:59:59 2
3183
8385959.00 838:59:59 3
3184
130000.00 13:00:00 4
3185
100000.00 10:00:00 5
3189
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DECIMAL(37,2)),
3190
my_timestamp, id FROM t1_values;
3191
SELECT CAST(my_timestamp AS DECIMAL(37,2)),
3192
my_timestamp, id FROM t1_values
3193
WHERE select_id = 68 OR select_id IS NULL order by id;
3194
CAST(my_timestamp AS DECIMAL(37,2)) my_timestamp id
3195
0.00 0000-00-00 00:00:00 1
3196
19700101030001.00 1970-01-01 03:00:01 2
3197
20380101025959.00 2038-01-01 02:59:59 3
3198
20040229235959.00 2004-02-29 23:59:59 4
3199
20050628100000.00 2005-06-28 10:00:00 5
3200
SHOW CREATE VIEW v1;
3201
View Create View character_set_client collation_connection
3202
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
3204
WHERE v1.id IN (SELECT id FROM t1_values
3205
WHERE select_id = 68 OR select_id IS NULL) order by id;
3206
CAST(my_timestamp AS DECIMAL(37,2)) my_timestamp id
3207
0.00 0000-00-00 00:00:00 1
3208
19700101030001.00 1970-01-01 03:00:01 2
3209
20380101025959.00 2038-01-01 02:59:59 3
3210
20040229235959.00 2004-02-29 23:59:59 4
3211
20050628100000.00 2005-06-28 10:00:00 5
3215
CREATE VIEW v1 AS SELECT CAST(my_date AS DECIMAL(37,2)),
3216
my_date, id FROM t1_values;
3217
SELECT CAST(my_date AS DECIMAL(37,2)),
3218
my_date, id FROM t1_values
3219
WHERE select_id = 67 OR select_id IS NULL order by id;
3220
CAST(my_date AS DECIMAL(37,2)) my_date id
3222
10101.00 0001-01-01 2
3223
99991231.00 9999-12-31 3
3224
20040229.00 2004-02-29 4
3225
20050628.00 2005-06-28 5
3226
SHOW CREATE VIEW v1;
3227
View Create View character_set_client collation_connection
3228
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
3230
WHERE v1.id IN (SELECT id FROM t1_values
3231
WHERE select_id = 67 OR select_id IS NULL) order by id;
3232
CAST(my_date AS DECIMAL(37,2)) my_date id
3234
10101.00 0001-01-01 2
3235
99991231.00 9999-12-31 3
3236
20040229.00 2004-02-29 4
3237
20050628.00 2005-06-28 5
3241
CREATE VIEW v1 AS SELECT CAST(my_datetime AS DECIMAL(37,2)),
3242
my_datetime, id FROM t1_values;
3243
SELECT CAST(my_datetime AS DECIMAL(37,2)),
3244
my_datetime, id FROM t1_values
3245
WHERE select_id = 66 OR select_id IS NULL order by id;
3246
CAST(my_datetime AS DECIMAL(37,2)) my_datetime id
3248
10101000000.00 0001-01-01 00:00:00 2
3249
99991231235959.00 9999-12-31 23:59:59 3
3250
20040229235959.00 2004-02-29 23:59:59 4
3251
20050628100000.00 2005-06-28 10:00:00 5
3252
SHOW CREATE VIEW v1;
3253
View Create View character_set_client collation_connection
3254
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
3256
WHERE v1.id IN (SELECT id FROM t1_values
3257
WHERE select_id = 66 OR select_id IS NULL) order by id;
3258
CAST(my_datetime AS DECIMAL(37,2)) my_datetime id
3260
10101000000.00 0001-01-01 00:00:00 2
3261
99991231235959.00 9999-12-31 23:59:59 3
3262
20040229235959.00 2004-02-29 23:59:59 4
3263
20050628100000.00 2005-06-28 10:00:00 5
3267
CREATE VIEW v1 AS SELECT CAST(my_double AS DECIMAL(37,2)),
3268
my_double, id FROM t1_values;
3269
SELECT CAST(my_double AS DECIMAL(37,2)),
3270
my_double, id FROM t1_values
3271
WHERE select_id = 65 OR select_id IS NULL order by id;
3272
CAST(my_double AS DECIMAL(37,2)) my_double id
3274
-99999999999999999999999999999999999.99 -1.7976931348623e308 2
3275
99999999999999999999999999999999999.99 1.7976931348623e308 3
3278
-3333.33 -3333.3333 30
3280
Error 1292 Truncated incorrect DECIMAL value: ''
3281
Error 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3282
Error 1292 Truncated incorrect DECIMAL value: ''
3283
Error 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3284
SHOW CREATE VIEW v1;
3285
View Create View character_set_client collation_connection
3286
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
3288
WHERE v1.id IN (SELECT id FROM t1_values
3289
WHERE select_id = 65 OR select_id IS NULL) order by id;
3290
CAST(my_double AS DECIMAL(37,2)) my_double id
3292
-99999999999999999999999999999999999.99 -1.7976931348623e308 2
3293
99999999999999999999999999999999999.99 1.7976931348623e308 3
3296
-3333.33 -3333.3333 30
3298
Error 1292 Truncated incorrect DECIMAL value: ''
3299
Error 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3300
Error 1292 Truncated incorrect DECIMAL value: ''
3301
Error 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3305
CREATE VIEW v1 AS SELECT CAST(my_decimal AS DECIMAL(37,2)),
3306
my_decimal, id FROM t1_values;
3307
SELECT CAST(my_decimal AS DECIMAL(37,2)),
3308
my_decimal, id FROM t1_values
3309
WHERE select_id = 64 OR select_id IS NULL order by id;
3310
CAST(my_decimal AS DECIMAL(37,2)) my_decimal id
3312
-10000000000000000000000000000000000.00 -9999999999999999999999999999999999.999999999999999999999999999999 2
3313
10000000000000000000000000000000000.00 9999999999999999999999999999999999.999999999999999999999999999999 3
3314
0.00 0.000000000000000000000000000000 4
3315
-1.00 -1.000000000000000000000000000000 5
3316
SHOW CREATE VIEW v1;
3317
View Create View character_set_client collation_connection
3318
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
3320
WHERE v1.id IN (SELECT id FROM t1_values
3321
WHERE select_id = 64 OR select_id IS NULL) order by id;
3322
CAST(my_decimal AS DECIMAL(37,2)) my_decimal id
3324
-10000000000000000000000000000000000.00 -9999999999999999999999999999999999.999999999999999999999999999999 2
3325
10000000000000000000000000000000000.00 9999999999999999999999999999999999.999999999999999999999999999999 3
3326
0.00 0.000000000000000000000000000000 4
3327
-1.00 -1.000000000000000000000000000000 5
3331
CREATE VIEW v1 AS SELECT CAST(my_bigint AS DECIMAL(37,2)),
3332
my_bigint, id FROM t1_values;
3333
SELECT CAST(my_bigint AS DECIMAL(37,2)),
3334
my_bigint, id FROM t1_values
3335
WHERE select_id = 63 OR select_id IS NULL order by id;
3336
CAST(my_bigint AS DECIMAL(37,2)) my_bigint id
3338
-9223372036854775808.00 -9223372036854775808 2
3339
9223372036854775807.00 9223372036854775807 3
3342
SHOW CREATE VIEW v1;
3343
View Create View character_set_client collation_connection
3344
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
3346
WHERE v1.id IN (SELECT id FROM t1_values
3347
WHERE select_id = 63 OR select_id IS NULL) order by id;
3348
CAST(my_bigint AS DECIMAL(37,2)) my_bigint id
3350
-9223372036854775808.00 -9223372036854775808 2
3351
9223372036854775807.00 9223372036854775807 3
3357
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DECIMAL(37,2)),
3358
my_varbinary_1000, id FROM t1_values;
3359
SELECT CAST(my_varbinary_1000 AS DECIMAL(37,2)),
3360
my_varbinary_1000, id FROM t1_values
3361
WHERE select_id = 62 OR select_id IS NULL order by id;
3362
CAST(my_varbinary_1000 AS DECIMAL(37,2)) my_varbinary_1000 id
3365
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3366
0.00 ---äÖüß@µ*$-- 4
3368
-3333.33 -3333.3333 29
3370
Error 1366 Incorrect decimal value: '' for column '' at row -1
3371
Error 1366 Incorrect decimal value: '' for column '' at row -1
3372
Error 1366 Incorrect decimal value: '' for column '' at row -1
3373
SHOW CREATE VIEW v1;
3374
View Create View character_set_client collation_connection
3375
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
3377
WHERE v1.id IN (SELECT id FROM t1_values
3378
WHERE select_id = 62 OR select_id IS NULL) order by id;
3379
CAST(my_varbinary_1000 AS DECIMAL(37,2)) my_varbinary_1000 id
3382
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3383
0.00 ---äÖüß@µ*$-- 4
3385
-3333.33 -3333.3333 29
3387
Error 1366 Incorrect decimal value: '' for column '' at row -1
3388
Error 1366 Incorrect decimal value: '' for column '' at row -1
3389
Error 1366 Incorrect decimal value: '' for column '' at row -1
3393
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DECIMAL(37,2)),
3394
my_binary_30, id FROM t1_values;
3395
SELECT CAST(my_binary_30 AS DECIMAL(37,2)),
3396
my_binary_30, id FROM t1_values
3397
WHERE select_id = 61 OR select_id IS NULL order by id;
3398
CAST(my_binary_30 AS DECIMAL(37,2)) my_binary_30 id
3401
0.00 <--------30 characters-------> 3
3402
0.00 ---äÖüß@µ*$-- 4
3404
-3333.33 -3333.3333 28
3406
Error 1366 Incorrect decimal value: '' for column '' at row -1
3407
Warning 1292 Truncated incorrect DECIMAL value: ''
3408
Error 1366 Incorrect decimal value: '' for column '' at row -1
3409
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3410
Error 1366 Incorrect decimal value: '' for column '' at row -1
3411
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3412
Warning 1292 Truncated incorrect DECIMAL value: '-1'
3413
Warning 1292 Truncated incorrect DECIMAL value: '-3333.3333'
3414
SHOW CREATE VIEW v1;
3415
View Create View character_set_client collation_connection
3416
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
3418
WHERE v1.id IN (SELECT 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'
3439
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DECIMAL(37,2)),
3440
my_varchar_1000, id FROM t1_values;
3441
SELECT CAST(my_varchar_1000 AS DECIMAL(37,2)),
3442
my_varchar_1000, id FROM t1_values
3443
WHERE select_id = 60 OR select_id IS NULL order by id;
3444
CAST(my_varchar_1000 AS DECIMAL(37,2)) my_varchar_1000 id
3447
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3448
0.00 ---äÖüß@µ*$-- 4
3450
-3333.33 -3333.3333 27
3452
Error 1366 Incorrect decimal value: '' for column '' at row -1
3453
Error 1366 Incorrect decimal value: '' for column '' at row -1
3454
Error 1366 Incorrect decimal value: '' for column '' at row -1
3455
SHOW CREATE VIEW v1;
3456
View Create View character_set_client collation_connection
3457
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
3459
WHERE v1.id IN (SELECT id FROM t1_values
3460
WHERE select_id = 60 OR select_id IS NULL) order by id;
3461
CAST(my_varchar_1000 AS DECIMAL(37,2)) my_varchar_1000 id
3464
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3465
0.00 ---äÖüß@µ*$-- 4
3467
-3333.33 -3333.3333 27
3469
Error 1366 Incorrect decimal value: '' for column '' at row -1
3470
Error 1366 Incorrect decimal value: '' for column '' at row -1
3471
Error 1366 Incorrect decimal value: '' for column '' at row -1
3475
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DECIMAL(37,2)),
3476
my_char_30, id FROM t1_values;
3477
SELECT CAST(my_char_30 AS DECIMAL(37,2)),
3478
my_char_30, id FROM t1_values
3479
WHERE select_id = 59 OR select_id IS NULL order by id;
3480
CAST(my_char_30 AS DECIMAL(37,2)) my_char_30 id
3483
0.00 <--------30 characters-------> 3
3484
0.00 ---äÖüß@µ*$-- 4
3486
-3333.33 -3333.3333 26
3488
Error 1366 Incorrect decimal value: '' for column '' at row -1
3489
Warning 1292 Truncated incorrect DECIMAL value: ' '
3490
Error 1366 Incorrect decimal value: '' for column '' at row -1
3491
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3492
Error 1366 Incorrect decimal value: '' for column '' at row -1
3493
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3494
SHOW CREATE VIEW v1;
3495
View Create View character_set_client collation_connection
3496
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
3498
WHERE v1.id IN (SELECT id FROM t1_values
3499
WHERE select_id = 59 OR select_id IS NULL) order by id;
3500
CAST(my_char_30 AS DECIMAL(37,2)) my_char_30 id
3503
0.00 <--------30 characters-------> 3
3504
0.00 ---äÖüß@µ*$-- 4
3506
-3333.33 -3333.3333 26
3508
Error 1366 Incorrect decimal value: '' for column '' at row -1
3509
Warning 1292 Truncated incorrect DECIMAL value: ' '
3510
Error 1366 Incorrect decimal value: '' for column '' at row -1
3511
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3512
Error 1366 Incorrect decimal value: '' for column '' at row -1
3513
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3517
CREATE VIEW v1 AS SELECT CAST(my_year AS TIME),
3518
my_year, id FROM t1_values;
3519
SELECT CAST(my_year AS TIME),
3520
my_year, id FROM t1_values
3521
WHERE select_id = 58 OR select_id IS NULL order by id;
3522
CAST(my_year AS TIME) my_year id
3528
SHOW CREATE VIEW v1;
3529
View Create View character_set_client collation_connection
3530
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
3532
WHERE v1.id IN (SELECT id FROM t1_values
3533
WHERE select_id = 58 OR select_id IS NULL) order by id;
3534
CAST(my_year AS TIME) my_year id
3543
CREATE VIEW v1 AS SELECT CAST(my_time AS TIME),
3544
my_time, id FROM t1_values;
3545
SELECT CAST(my_time AS TIME),
3546
my_time, id FROM t1_values
3547
WHERE select_id = 57 OR select_id IS NULL order by id;
3548
CAST(my_time AS TIME) my_time id
3550
-838:59:59 -838:59:59 2
3551
838:59:59 838:59:59 3
3554
SHOW CREATE VIEW v1;
3555
View Create View character_set_client collation_connection
3556
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
3558
WHERE v1.id IN (SELECT id FROM t1_values
3559
WHERE select_id = 57 OR select_id IS NULL) order by id;
3560
CAST(my_time AS TIME) my_time id
3562
-838:59:59 -838:59:59 2
3563
838:59:59 838:59:59 3
3569
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS TIME),
3570
my_timestamp, id FROM t1_values;
3571
SELECT CAST(my_timestamp AS TIME),
3572
my_timestamp, id FROM t1_values
3573
WHERE select_id = 56 OR select_id IS NULL order by id;
3574
CAST(my_timestamp AS TIME) my_timestamp id
3575
00:00:00 0000-00-00 00:00:00 1
3576
03:00:01 1970-01-01 03:00:01 2
3577
02:59:59 2038-01-01 02:59:59 3
3578
23:59:59 2004-02-29 23:59:59 4
3579
10:00:00 2005-06-28 10:00:00 5
3580
SHOW CREATE VIEW v1;
3581
View Create View character_set_client collation_connection
3582
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
3584
WHERE v1.id IN (SELECT id FROM t1_values
3585
WHERE select_id = 56 OR select_id IS NULL) order by id;
3586
CAST(my_timestamp AS TIME) my_timestamp id
3587
00:00:00 0000-00-00 00:00:00 1
3588
03:00:01 1970-01-01 03:00:01 2
3589
02:59:59 2038-01-01 02:59:59 3
3590
23:59:59 2004-02-29 23:59:59 4
3591
10:00:00 2005-06-28 10:00:00 5
3595
CREATE VIEW v1 AS SELECT CAST(my_date AS TIME),
3596
my_date, id FROM t1_values;
3597
SELECT CAST(my_date AS TIME),
3598
my_date, id FROM t1_values
3599
WHERE select_id = 55 OR select_id IS NULL order by id;
3600
CAST(my_date AS TIME) my_date id
3602
00:00:00 0001-01-01 2
3603
00:00:00 9999-12-31 3
3604
00:00:00 2004-02-29 4
3605
00:00:00 2005-06-28 5
3606
SHOW CREATE VIEW v1;
3607
View Create View character_set_client collation_connection
3608
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
3610
WHERE v1.id IN (SELECT id FROM t1_values
3611
WHERE select_id = 55 OR select_id IS NULL) order by id;
3612
CAST(my_date AS TIME) my_date id
3614
00:00:00 0001-01-01 2
3615
00:00:00 9999-12-31 3
3616
00:00:00 2004-02-29 4
3617
00:00:00 2005-06-28 5
3621
CREATE VIEW v1 AS SELECT CAST(my_datetime AS TIME),
3622
my_datetime, id FROM t1_values;
3623
SELECT CAST(my_datetime AS TIME),
3624
my_datetime, id FROM t1_values
3625
WHERE select_id = 54 OR select_id IS NULL order by id;
3626
CAST(my_datetime AS TIME) my_datetime id
3628
00:00:00 0001-01-01 00:00:00 2
3629
23:59:59 9999-12-31 23:59:59 3
3630
23:59:59 2004-02-29 23:59:59 4
3631
10:00:00 2005-06-28 10:00:00 5
3632
SHOW CREATE VIEW v1;
3633
View Create View character_set_client collation_connection
3634
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
3636
WHERE v1.id IN (SELECT id FROM t1_values
3637
WHERE select_id = 54 OR select_id IS NULL) order by id;
3638
CAST(my_datetime AS TIME) my_datetime id
3640
00:00:00 0001-01-01 00:00:00 2
3641
23:59:59 9999-12-31 23:59:59 3
3642
23:59:59 2004-02-29 23:59:59 4
3643
10:00:00 2005-06-28 10:00:00 5
3647
CREATE VIEW v1 AS SELECT CAST(my_double AS TIME),
3648
my_double, id FROM t1_values;
3649
SELECT CAST(my_double AS TIME),
3650
my_double, id FROM t1_values
3651
WHERE select_id = 53 OR select_id IS NULL order by id;
3652
CAST(my_double AS TIME) my_double id
3654
NULL -1.7976931348623e308 2
3655
NULL 1.7976931348623e308 3
3660
Warning 1292 Truncated incorrect time value: '-1.7976931348623e308'
3661
Warning 1292 Truncated incorrect time value: '1.7976931348623e308'
3662
SHOW CREATE VIEW v1;
3663
View Create View character_set_client collation_connection
3664
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
3666
WHERE v1.id IN (SELECT id FROM t1_values
3667
WHERE select_id = 53 OR select_id IS NULL) order by id;
3668
CAST(my_double AS TIME) my_double id
3670
NULL -1.7976931348623e308 2
3671
NULL 1.7976931348623e308 3
3676
Warning 1292 Truncated incorrect time value: '-1.7976931348623e308'
3677
Warning 1292 Truncated incorrect time value: '1.7976931348623e308'
3681
CREATE VIEW v1 AS SELECT CAST(my_bigint AS TIME),
3682
my_bigint, id FROM t1_values;
3683
SELECT CAST(my_bigint AS TIME),
3684
my_bigint, id FROM t1_values
3685
WHERE select_id = 52 OR select_id IS NULL order by id;
3686
CAST(my_bigint AS TIME) my_bigint id
3688
NULL -9223372036854775808 2
3689
NULL 9223372036854775807 3
3694
Warning 1292 Truncated incorrect time value: '-9223372036854775808'
3695
Warning 1292 Truncated incorrect time value: '9223372036854775807'
3696
SHOW CREATE VIEW v1;
3697
View Create View character_set_client collation_connection
3698
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
3700
WHERE v1.id IN (SELECT id FROM t1_values
3701
WHERE select_id = 52 OR select_id IS NULL) order by id;
3702
CAST(my_bigint AS TIME) my_bigint id
3704
NULL -9223372036854775808 2
3705
NULL 9223372036854775807 3
3710
Warning 1292 Truncated incorrect time value: '-9223372036854775808'
3711
Warning 1292 Truncated incorrect time value: '9223372036854775807'
3715
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS TIME),
3716
my_varbinary_1000, id FROM t1_values;
3717
SELECT CAST(my_varbinary_1000 AS TIME),
3718
my_varbinary_1000, id FROM t1_values
3719
WHERE select_id = 51 OR select_id IS NULL order by id;
3720
CAST(my_varbinary_1000 AS TIME) my_varbinary_1000 id
3723
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3724
-00:00:00 ---äÖüß@µ*$-- 4
3728
Warning 1292 Truncated incorrect time value: ''
3729
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3730
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3731
SHOW CREATE VIEW v1;
3732
View Create View character_set_client collation_connection
3733
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
3735
WHERE v1.id IN (SELECT id FROM t1_values
3736
WHERE select_id = 51 OR select_id IS NULL) order by id;
3737
CAST(my_varbinary_1000 AS TIME) my_varbinary_1000 id
3740
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3741
-00:00:00 ---äÖüß@µ*$-- 4
3745
Warning 1292 Truncated incorrect time value: ''
3746
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3747
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3751
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS TIME),
3752
my_binary_30, id FROM t1_values;
3753
SELECT CAST(my_binary_30 AS TIME),
3754
my_binary_30, id FROM t1_values
3755
WHERE select_id = 50 OR select_id IS NULL order by id;
3756
CAST(my_binary_30 AS TIME) my_binary_30 id
3759
00:00:00 <--------30 characters-------> 3
3760
-00:00:00 ---äÖüß@µ*$-- 4
3764
Warning 1292 Truncated incorrect time value: ''
3765
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3766
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3767
Warning 1292 Truncated incorrect time value: '-1'
3768
Warning 1292 Truncated incorrect time value: '1 17:58'
3769
SHOW CREATE VIEW v1;
3770
View Create View character_set_client collation_connection
3771
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
3773
WHERE v1.id IN (SELECT id FROM t1_values
3774
WHERE select_id = 50 OR select_id IS NULL) order by id;
3775
CAST(my_binary_30 AS TIME) my_binary_30 id
3778
00:00:00 <--------30 characters-------> 3
3779
-00:00:00 ---äÖüß@µ*$-- 4
3783
Warning 1292 Truncated incorrect time value: ''
3784
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3785
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3786
Warning 1292 Truncated incorrect time value: '-1'
3787
Warning 1292 Truncated incorrect time value: '1 17:58'
3791
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS TIME),
3792
my_varchar_1000, id FROM t1_values;
3793
SELECT CAST(my_varchar_1000 AS TIME),
3794
my_varchar_1000, id FROM t1_values
3795
WHERE select_id = 49 OR select_id IS NULL order by id;
3796
CAST(my_varchar_1000 AS TIME) my_varchar_1000 id
3799
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3800
-00:00:00 ---äÖüß@µ*$-- 4
3804
Warning 1292 Truncated incorrect time value: ''
3805
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3806
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3807
SHOW CREATE VIEW v1;
3808
View Create View character_set_client collation_connection
3809
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
3811
WHERE v1.id IN (SELECT id FROM t1_values
3812
WHERE select_id = 49 OR select_id IS NULL) order by id;
3813
CAST(my_varchar_1000 AS TIME) my_varchar_1000 id
3816
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3817
-00:00:00 ---äÖüß@µ*$-- 4
3821
Warning 1292 Truncated incorrect time value: ''
3822
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3823
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3827
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS TIME),
3828
my_char_30, id FROM t1_values;
3829
SELECT CAST(my_char_30 AS TIME),
3830
my_char_30, id FROM t1_values
3831
WHERE select_id = 48 OR select_id IS NULL order by id;
3832
CAST(my_char_30 AS TIME) my_char_30 id
3835
00:00:00 <--------30 characters-------> 3
3836
-00:00:00 ---äÖüß@µ*$-- 4
3840
Warning 1292 Truncated incorrect time value: ''
3841
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3842
Warning 1292 Truncated incorrect time value: ' ---����@�*$--'
3843
SHOW CREATE VIEW v1;
3844
View Create View character_set_client collation_connection
3845
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
3847
WHERE v1.id IN (SELECT id FROM t1_values
3848
WHERE select_id = 48 OR select_id IS NULL) order by id;
3849
CAST(my_char_30 AS TIME) my_char_30 id
3852
00:00:00 <--------30 characters-------> 3
3853
-00:00:00 ---äÖüß@µ*$-- 4
3857
Warning 1292 Truncated incorrect time value: ''
3858
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3859
Warning 1292 Truncated incorrect time value: ' ---����@�*$--'
3863
CREATE VIEW v1 AS SELECT CAST(my_year AS DATETIME),
3864
my_year, id FROM t1_values;
3865
SELECT CAST(my_year AS DATETIME),
3866
my_year, id FROM t1_values
3867
WHERE select_id = 47 OR select_id IS NULL order by id;
3868
CAST(my_year AS DATETIME) my_year id
3875
Warning 1292 Incorrect datetime value: '1901'
3876
Warning 1292 Incorrect datetime value: '2155'
3877
Warning 1292 Incorrect datetime value: '2000'
3878
Warning 1292 Incorrect datetime value: '2005'
3879
SHOW CREATE VIEW v1;
3880
View Create View character_set_client collation_connection
3881
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
3883
WHERE v1.id IN (SELECT id FROM t1_values
3884
WHERE select_id = 47 OR select_id IS NULL) order by id;
3885
CAST(my_year AS DATETIME) my_year id
3892
Warning 1292 Incorrect datetime value: '1901'
3893
Warning 1292 Incorrect datetime value: '2155'
3894
Warning 1292 Incorrect datetime value: '2000'
3895
Warning 1292 Incorrect datetime value: '2005'
3899
CREATE VIEW v1 AS SELECT CAST(my_time AS DATETIME),
3900
my_time, id FROM t1_values;
3901
SELECT CAST(my_time AS DATETIME),
3902
my_time, id FROM t1_values
3903
WHERE select_id = 46 OR select_id IS NULL order by id;
3904
CAST(my_time AS DATETIME) my_time id
3906
0000-00-00 00:00:00 -838:59:59 2
3907
0000-00-00 00:00:00 838:59:59 3
3908
0000-00-00 13:00:00 13:00:00 4
3909
0000-00-00 10:00:00 10:00:00 5
3911
Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3912
Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3913
SHOW CREATE VIEW v1;
3914
View Create View character_set_client collation_connection
3915
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
3917
WHERE v1.id IN (SELECT id FROM t1_values
3918
WHERE select_id = 46 OR select_id IS NULL) order by id;
3919
CAST(my_time AS DATETIME) my_time id
3921
0000-00-00 00:00:00 -838:59:59 2
3922
0000-00-00 00:00:00 838:59:59 3
3923
0000-00-00 13:00:00 13:00:00 4
3924
0000-00-00 10:00:00 10:00:00 5
3926
Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3927
Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3931
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DATETIME),
3932
my_timestamp, id FROM t1_values;
3933
SELECT CAST(my_timestamp AS DATETIME),
3934
my_timestamp, id FROM t1_values
3935
WHERE select_id = 45 OR select_id IS NULL order by id;
3936
CAST(my_timestamp AS DATETIME) my_timestamp id
3937
0000-00-00 00:00:00 0000-00-00 00:00:00 1
3938
1970-01-01 03:00:01 1970-01-01 03:00:01 2
3939
2038-01-01 02:59:59 2038-01-01 02:59:59 3
3940
2004-02-29 23:59:59 2004-02-29 23:59:59 4
3941
2005-06-28 10:00:00 2005-06-28 10:00:00 5
3942
SHOW CREATE VIEW v1;
3943
View Create View character_set_client collation_connection
3944
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
3946
WHERE v1.id IN (SELECT id FROM t1_values
3947
WHERE select_id = 45 OR select_id IS NULL) order by id;
3948
CAST(my_timestamp AS DATETIME) my_timestamp id
3949
0000-00-00 00:00:00 0000-00-00 00:00:00 1
3950
1970-01-01 03:00:01 1970-01-01 03:00:01 2
3951
2038-01-01 02:59:59 2038-01-01 02:59:59 3
3952
2004-02-29 23:59:59 2004-02-29 23:59:59 4
3953
2005-06-28 10:00:00 2005-06-28 10:00:00 5
3957
CREATE VIEW v1 AS SELECT CAST(my_date AS DATETIME),
3958
my_date, id FROM t1_values;
3959
SELECT CAST(my_date AS DATETIME),
3960
my_date, id FROM t1_values
3961
WHERE select_id = 44 OR select_id IS NULL order by id;
3962
CAST(my_date AS DATETIME) my_date id
3964
0001-01-01 00:00:00 0001-01-01 2
3965
9999-12-31 00:00:00 9999-12-31 3
3966
2004-02-29 00:00:00 2004-02-29 4
3967
2005-06-28 00:00:00 2005-06-28 5
3968
SHOW CREATE VIEW v1;
3969
View Create View character_set_client collation_connection
3970
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
3972
WHERE v1.id IN (SELECT id FROM t1_values
3973
WHERE select_id = 44 OR select_id IS NULL) order by id;
3974
CAST(my_date AS DATETIME) my_date id
3976
0001-01-01 00:00:00 0001-01-01 2
3977
9999-12-31 00:00:00 9999-12-31 3
3978
2004-02-29 00:00:00 2004-02-29 4
3979
2005-06-28 00:00:00 2005-06-28 5
3983
CREATE VIEW v1 AS SELECT CAST(my_datetime AS DATETIME),
3984
my_datetime, id FROM t1_values;
3985
SELECT CAST(my_datetime AS DATETIME),
3986
my_datetime, id FROM t1_values
3987
WHERE select_id = 43 OR select_id IS NULL order by id;
3988
CAST(my_datetime AS DATETIME) my_datetime id
3990
0001-01-01 00:00:00 0001-01-01 00:00:00 2
3991
9999-12-31 23:59:59 9999-12-31 23:59:59 3
3992
2004-02-29 23:59:59 2004-02-29 23:59:59 4
3993
2005-06-28 10:00:00 2005-06-28 10:00:00 5
3994
SHOW CREATE VIEW v1;
3995
View Create View character_set_client collation_connection
3996
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
3998
WHERE v1.id IN (SELECT id FROM t1_values
3999
WHERE select_id = 43 OR select_id IS NULL) order by id;
4000
CAST(my_datetime AS DATETIME) my_datetime id
4002
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4003
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4004
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4005
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4009
CREATE VIEW v1 AS SELECT CAST(my_double AS DATETIME),
4010
my_double, id FROM t1_values;
4011
SELECT CAST(my_double AS DATETIME),
4012
my_double, id FROM t1_values
4013
WHERE select_id = 42 OR select_id IS NULL order by id;
4014
CAST(my_double AS DATETIME) my_double id
4016
NULL -1.7976931348623e308 2
4017
NULL 1.7976931348623e308 3
4020
NULL 200506271758 19
4022
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4023
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4024
Warning 1292 Incorrect datetime value: '0'
4025
Warning 1292 Incorrect datetime value: '-1'
4026
Warning 1292 Incorrect datetime value: '200506271758'
4027
SHOW CREATE VIEW v1;
4028
View Create View character_set_client collation_connection
4029
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
4031
WHERE v1.id IN (SELECT id FROM t1_values
4032
WHERE select_id = 42 OR select_id IS NULL) order by id;
4033
CAST(my_double AS DATETIME) my_double id
4035
NULL -1.7976931348623e308 2
4036
NULL 1.7976931348623e308 3
4039
NULL 200506271758 19
4041
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4042
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4043
Warning 1292 Incorrect datetime value: '0'
4044
Warning 1292 Incorrect datetime value: '-1'
4045
Warning 1292 Incorrect datetime value: '200506271758'
4049
CREATE VIEW v1 AS SELECT CAST(my_bigint AS DATETIME),
4050
my_bigint, id FROM t1_values;
4051
SELECT CAST(my_bigint AS DATETIME),
4052
my_bigint, id FROM t1_values
4053
WHERE select_id = 41 OR select_id IS NULL order by id;
4054
CAST(my_bigint AS DATETIME) my_bigint id
4056
NULL -9223372036854775808 2
4057
NULL 9223372036854775807 3
4060
NULL 200506271758 18
4062
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4063
Warning 1292 Incorrect datetime value: '9223372036854775807'
4064
Warning 1292 Incorrect datetime value: '0'
4065
Warning 1292 Incorrect datetime value: '-1'
4066
Warning 1292 Incorrect datetime value: '200506271758'
4067
SHOW CREATE VIEW v1;
4068
View Create View character_set_client collation_connection
4069
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
4071
WHERE v1.id IN (SELECT id FROM t1_values
4072
WHERE select_id = 41 OR select_id IS NULL) order by id;
4073
CAST(my_bigint AS DATETIME) my_bigint id
4075
NULL -9223372036854775808 2
4076
NULL 9223372036854775807 3
4079
NULL 200506271758 18
4081
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4082
Warning 1292 Incorrect datetime value: '9223372036854775807'
4083
Warning 1292 Incorrect datetime value: '0'
4084
Warning 1292 Incorrect datetime value: '-1'
4085
Warning 1292 Incorrect datetime value: '200506271758'
4089
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DATETIME),
4090
my_varbinary_1000, id FROM t1_values;
4091
SELECT CAST(my_varbinary_1000 AS DATETIME),
4092
my_varbinary_1000, id FROM t1_values
4093
WHERE select_id = 40 OR select_id IS NULL order by id;
4094
CAST(my_varbinary_1000 AS DATETIME) my_varbinary_1000 id
4097
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4098
NULL ---äÖüß@µ*$-- 4
4100
2005-06-27 17:58:00 2005-06-27 17:58 17
4102
Warning 1292 Incorrect datetime value: ''
4103
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4104
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4105
Warning 1292 Incorrect datetime value: '-1'
4106
SHOW CREATE VIEW v1;
4107
View Create View character_set_client collation_connection
4108
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
4110
WHERE v1.id IN (SELECT id FROM t1_values
4111
WHERE select_id = 40 OR select_id IS NULL) order by id;
4112
CAST(my_varbinary_1000 AS DATETIME) my_varbinary_1000 id
4115
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4116
NULL ---äÖüß@µ*$-- 4
4118
2005-06-27 17:58:00 2005-06-27 17:58 17
4120
Warning 1292 Incorrect datetime value: ''
4121
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4122
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4123
Warning 1292 Incorrect datetime value: '-1'
4127
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DATETIME),
4128
my_binary_30, id FROM t1_values;
4129
SELECT CAST(my_binary_30 AS DATETIME),
4130
my_binary_30, id FROM t1_values
4131
WHERE select_id = 39 OR select_id IS NULL order by id;
4132
CAST(my_binary_30 AS DATETIME) my_binary_30 id
4135
NULL <--------30 characters-------> 3
4136
NULL ---äÖüß@µ*$-- 4
4138
2005-06-27 17:58:00 2005-06-27 17:58 16
4140
Warning 1292 Incorrect datetime value: ''
4141
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4142
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4143
Warning 1292 Incorrect datetime value: '-1'
4144
Warning 1292 Truncated incorrect datetime value: '2005-06-27 17:58'
4145
SHOW CREATE VIEW v1;
4146
View Create View character_set_client collation_connection
4147
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
4149
WHERE v1.id IN (SELECT id FROM t1_values
4150
WHERE select_id = 39 OR select_id IS NULL) order by id;
4151
CAST(my_binary_30 AS DATETIME) my_binary_30 id
4154
NULL <--------30 characters-------> 3
4155
NULL ---äÖüß@µ*$-- 4
4157
2005-06-27 17:58:00 2005-06-27 17:58 16
4159
Warning 1292 Incorrect datetime value: ''
4160
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4161
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4162
Warning 1292 Incorrect datetime value: '-1'
4163
Warning 1292 Truncated incorrect datetime value: '2005-06-27 17:58'
4167
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DATETIME),
4168
my_varchar_1000, id FROM t1_values;
4169
SELECT CAST(my_varchar_1000 AS DATETIME),
4170
my_varchar_1000, id FROM t1_values
4171
WHERE select_id = 38 OR select_id IS NULL order by id;
4172
CAST(my_varchar_1000 AS DATETIME) my_varchar_1000 id
4175
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4176
NULL ---äÖüß@µ*$-- 4
4178
2005-06-27 17:58:00 2005-06-27 17:58 15
4180
Warning 1292 Incorrect datetime value: ''
4181
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4182
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4183
Warning 1292 Incorrect datetime value: '-1'
4184
SHOW CREATE VIEW v1;
4185
View Create View character_set_client collation_connection
4186
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
4188
WHERE v1.id IN (SELECT id FROM t1_values
4189
WHERE select_id = 38 OR select_id IS NULL) order by id;
4190
CAST(my_varchar_1000 AS DATETIME) my_varchar_1000 id
4193
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4194
NULL ---äÖüß@µ*$-- 4
4196
2005-06-27 17:58:00 2005-06-27 17:58 15
4198
Warning 1292 Incorrect datetime value: ''
4199
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4200
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4201
Warning 1292 Incorrect datetime value: '-1'
4205
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DATETIME),
4206
my_char_30, id FROM t1_values;
4207
SELECT CAST(my_char_30 AS DATETIME),
4208
my_char_30, id FROM t1_values
4209
WHERE select_id = 37 OR select_id IS NULL order by id;
4210
CAST(my_char_30 AS DATETIME) my_char_30 id
4213
NULL <--------30 characters-------> 3
4214
NULL ---äÖüß@µ*$-- 4
4216
2005-06-27 17:58:00 2005-06-27 17:58 14
4218
Warning 1292 Incorrect datetime value: ''
4219
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4220
Warning 1292 Incorrect datetime value: ' ---����@�*$--'
4221
Warning 1292 Incorrect datetime value: '-1'
4222
SHOW CREATE VIEW v1;
4223
View Create View character_set_client collation_connection
4224
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
4226
WHERE v1.id IN (SELECT id FROM t1_values
4227
WHERE select_id = 37 OR select_id IS NULL) order by id;
4228
CAST(my_char_30 AS DATETIME) my_char_30 id
4231
NULL <--------30 characters-------> 3
4232
NULL ---äÖüß@µ*$-- 4
4234
2005-06-27 17:58:00 2005-06-27 17:58 14
4236
Warning 1292 Incorrect datetime value: ''
4237
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4238
Warning 1292 Incorrect datetime value: ' ---����@�*$--'
4239
Warning 1292 Incorrect datetime value: '-1'
4243
CREATE VIEW v1 AS SELECT CAST(my_year AS DATE),
4244
my_year, id FROM t1_values;
4245
SELECT CAST(my_year AS DATE),
4246
my_year, id FROM t1_values
4247
WHERE select_id = 36 OR select_id IS NULL order by id;
4248
CAST(my_year AS DATE) my_year id
4255
Warning 1292 Incorrect datetime value: '1901'
4256
Warning 1292 Incorrect datetime value: '2155'
4257
Warning 1292 Incorrect datetime value: '2000'
4258
Warning 1292 Incorrect datetime value: '2005'
4259
SHOW CREATE VIEW v1;
4260
View Create View character_set_client collation_connection
4261
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
4263
WHERE v1.id IN (SELECT id FROM t1_values
4264
WHERE select_id = 36 OR select_id IS NULL) order by id;
4265
CAST(my_year AS DATE) my_year id
4272
Warning 1292 Incorrect datetime value: '1901'
4273
Warning 1292 Incorrect datetime value: '2155'
4274
Warning 1292 Incorrect datetime value: '2000'
4275
Warning 1292 Incorrect datetime value: '2005'
4279
CREATE VIEW v1 AS SELECT CAST(my_time AS DATE),
4280
my_time, id FROM t1_values;
4281
SELECT CAST(my_time AS DATE),
4282
my_time, id FROM t1_values
4283
WHERE select_id = 35 OR select_id IS NULL order by id;
4284
CAST(my_time AS DATE) my_time id
4286
0000-00-00 -838:59:59 2
4287
0000-00-00 838:59:59 3
4288
0000-00-00 13:00:00 4
4289
0000-00-00 10:00:00 5
4290
SHOW CREATE VIEW v1;
4291
View Create View character_set_client collation_connection
4292
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
4294
WHERE v1.id IN (SELECT id FROM t1_values
4295
WHERE select_id = 35 OR select_id IS NULL) order by id;
4296
CAST(my_time AS DATE) my_time id
4298
0000-00-00 -838:59:59 2
4299
0000-00-00 838:59:59 3
4300
0000-00-00 13:00:00 4
4301
0000-00-00 10:00:00 5
4305
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DATE),
4306
my_timestamp, id FROM t1_values;
4307
SELECT CAST(my_timestamp AS DATE),
4308
my_timestamp, id FROM t1_values
4309
WHERE select_id = 34 OR select_id IS NULL order by id;
4310
CAST(my_timestamp AS DATE) my_timestamp id
4311
0000-00-00 0000-00-00 00:00:00 1
4312
1970-01-01 1970-01-01 03:00:01 2
4313
2038-01-01 2038-01-01 02:59:59 3
4314
2004-02-29 2004-02-29 23:59:59 4
4315
2005-06-28 2005-06-28 10:00:00 5
4316
SHOW CREATE VIEW v1;
4317
View Create View character_set_client collation_connection
4318
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
4320
WHERE v1.id IN (SELECT id FROM t1_values
4321
WHERE select_id = 34 OR select_id IS NULL) order by id;
4322
CAST(my_timestamp AS DATE) my_timestamp id
4323
0000-00-00 0000-00-00 00:00:00 1
4324
1970-01-01 1970-01-01 03:00:01 2
4325
2038-01-01 2038-01-01 02:59:59 3
4326
2004-02-29 2004-02-29 23:59:59 4
4327
2005-06-28 2005-06-28 10:00:00 5
4331
CREATE VIEW v1 AS SELECT CAST(my_date AS DATE),
4332
my_date, id FROM t1_values;
4333
SELECT CAST(my_date AS DATE),
4334
my_date, id FROM t1_values
4335
WHERE select_id = 33 OR select_id IS NULL order by id;
4336
CAST(my_date AS DATE) my_date id
4338
0001-01-01 0001-01-01 2
4339
9999-12-31 9999-12-31 3
4340
2004-02-29 2004-02-29 4
4341
2005-06-28 2005-06-28 5
4342
SHOW CREATE VIEW v1;
4343
View Create View character_set_client collation_connection
4344
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
4346
WHERE v1.id IN (SELECT id FROM t1_values
4347
WHERE select_id = 33 OR select_id IS NULL) order by id;
4348
CAST(my_date AS DATE) my_date id
4350
0001-01-01 0001-01-01 2
4351
9999-12-31 9999-12-31 3
4352
2004-02-29 2004-02-29 4
4353
2005-06-28 2005-06-28 5
4357
CREATE VIEW v1 AS SELECT CAST(my_datetime AS DATE),
4358
my_datetime, id FROM t1_values;
4359
SELECT CAST(my_datetime AS DATE),
4360
my_datetime, id FROM t1_values
4361
WHERE select_id = 32 OR select_id IS NULL order by id;
4362
CAST(my_datetime AS DATE) my_datetime id
4364
0001-01-01 0001-01-01 00:00:00 2
4365
9999-12-31 9999-12-31 23:59:59 3
4366
2004-02-29 2004-02-29 23:59:59 4
4367
2005-06-28 2005-06-28 10:00:00 5
4368
SHOW CREATE VIEW v1;
4369
View Create View character_set_client collation_connection
4370
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
4372
WHERE v1.id IN (SELECT id FROM t1_values
4373
WHERE select_id = 32 OR select_id IS NULL) order by id;
4374
CAST(my_datetime AS DATE) my_datetime id
4376
0001-01-01 0001-01-01 00:00:00 2
4377
9999-12-31 9999-12-31 23:59:59 3
4378
2004-02-29 2004-02-29 23:59:59 4
4379
2005-06-28 2005-06-28 10:00:00 5
4383
CREATE VIEW v1 AS SELECT CAST(my_double AS DATE),
4384
my_double, id FROM t1_values;
4385
SELECT CAST(my_double AS DATE),
4386
my_double, id FROM t1_values
4387
WHERE select_id = 31 OR select_id IS NULL order by id;
4388
CAST(my_double AS DATE) my_double id
4390
NULL -1.7976931348623e308 2
4391
NULL 1.7976931348623e308 3
4394
2005-06-27 20050627 13
4396
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4397
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4398
Warning 1292 Incorrect datetime value: '0'
4399
Warning 1292 Incorrect datetime value: '-1'
4400
SHOW CREATE VIEW v1;
4401
View Create View character_set_client collation_connection
4402
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
4404
WHERE v1.id IN (SELECT id FROM t1_values
4405
WHERE select_id = 31 OR select_id IS NULL) order by id;
4406
CAST(my_double AS DATE) my_double id
4408
NULL -1.7976931348623e308 2
4409
NULL 1.7976931348623e308 3
4412
2005-06-27 20050627 13
4414
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4415
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4416
Warning 1292 Incorrect datetime value: '0'
4417
Warning 1292 Incorrect datetime value: '-1'
4421
CREATE VIEW v1 AS SELECT CAST(my_bigint AS DATE),
4422
my_bigint, id FROM t1_values;
4423
SELECT CAST(my_bigint AS DATE),
4424
my_bigint, id FROM t1_values
4425
WHERE select_id = 30 OR select_id IS NULL order by id;
4426
CAST(my_bigint AS DATE) my_bigint id
4428
NULL -9223372036854775808 2
4429
NULL 9223372036854775807 3
4432
2005-06-27 20050627 12
4434
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4435
Warning 1292 Incorrect datetime value: '9223372036854775807'
4436
Warning 1292 Incorrect datetime value: '0'
4437
Warning 1292 Incorrect datetime value: '-1'
4438
SHOW CREATE VIEW v1;
4439
View Create View character_set_client collation_connection
4440
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
4442
WHERE v1.id IN (SELECT id FROM t1_values
4443
WHERE select_id = 30 OR select_id IS NULL) order by id;
4444
CAST(my_bigint AS DATE) my_bigint id
4446
NULL -9223372036854775808 2
4447
NULL 9223372036854775807 3
4450
2005-06-27 20050627 12
4452
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4453
Warning 1292 Incorrect datetime value: '9223372036854775807'
4454
Warning 1292 Incorrect datetime value: '0'
4455
Warning 1292 Incorrect datetime value: '-1'
4459
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DATE),
4460
my_varbinary_1000, id FROM t1_values;
4461
SELECT CAST(my_varbinary_1000 AS DATE),
4462
my_varbinary_1000, id FROM t1_values
4463
WHERE select_id = 29 OR select_id IS NULL order by id;
4464
CAST(my_varbinary_1000 AS DATE) my_varbinary_1000 id
4467
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4468
NULL ---äÖüß@µ*$-- 4
4470
2005-06-27 2005-06-27 11
4472
Warning 1292 Incorrect datetime value: ''
4473
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4474
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4475
Warning 1292 Incorrect datetime value: '-1'
4476
SHOW CREATE VIEW v1;
4477
View Create View character_set_client collation_connection
4478
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
4480
WHERE v1.id IN (SELECT id FROM t1_values
4481
WHERE select_id = 29 OR select_id IS NULL) order by id;
4482
CAST(my_varbinary_1000 AS DATE) my_varbinary_1000 id
4485
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4486
NULL ---äÖüß@µ*$-- 4
4488
2005-06-27 2005-06-27 11
4490
Warning 1292 Incorrect datetime value: ''
4491
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4492
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4493
Warning 1292 Incorrect datetime value: '-1'
4497
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DATE),
4498
my_binary_30, id FROM t1_values;
4499
SELECT CAST(my_binary_30 AS DATE),
4500
my_binary_30, id FROM t1_values
4501
WHERE select_id = 28 OR select_id IS NULL order by id;
4502
CAST(my_binary_30 AS DATE) my_binary_30 id
4505
NULL <--------30 characters-------> 3
4506
NULL ---äÖüß@µ*$-- 4
4508
2005-06-27 2005-06-27 10
4510
Warning 1292 Incorrect datetime value: ''
4511
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4512
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4513
Warning 1292 Incorrect datetime value: '-1'
4514
Warning 1292 Truncated incorrect date value: '2005-06-27'
4515
SHOW CREATE VIEW v1;
4516
View Create View character_set_client collation_connection
4517
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
4519
WHERE v1.id IN (SELECT id FROM t1_values
4520
WHERE select_id = 28 OR select_id IS NULL) order by id;
4521
CAST(my_binary_30 AS DATE) my_binary_30 id
4524
NULL <--------30 characters-------> 3
4525
NULL ---äÖüß@µ*$-- 4
4527
2005-06-27 2005-06-27 10
4529
Warning 1292 Incorrect datetime value: ''
4530
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4531
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4532
Warning 1292 Incorrect datetime value: '-1'
4533
Warning 1292 Truncated incorrect date value: '2005-06-27'
4537
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DATE),
4538
my_varchar_1000, id FROM t1_values;
4539
SELECT CAST(my_varchar_1000 AS DATE),
4540
my_varchar_1000, id FROM t1_values
4541
WHERE select_id = 27 OR select_id IS NULL order by id;
4542
CAST(my_varchar_1000 AS DATE) my_varchar_1000 id
4545
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4546
NULL ---äÖüß@µ*$-- 4
4548
2005-06-27 2005-06-27 9
4550
Warning 1292 Incorrect datetime value: ''
4551
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4552
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4553
Warning 1292 Incorrect datetime value: '-1'
4554
SHOW CREATE VIEW v1;
4555
View Create View character_set_client collation_connection
4556
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
4558
WHERE v1.id IN (SELECT id FROM t1_values
4559
WHERE select_id = 27 OR select_id IS NULL) order by id;
4560
CAST(my_varchar_1000 AS DATE) my_varchar_1000 id
4563
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4564
NULL ---äÖüß@µ*$-- 4
4566
2005-06-27 2005-06-27 9
4568
Warning 1292 Incorrect datetime value: ''
4569
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4570
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4571
Warning 1292 Incorrect datetime value: '-1'
4575
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DATE),
4576
my_char_30, id FROM t1_values;
4577
SELECT CAST(my_char_30 AS DATE),
4578
my_char_30, id FROM t1_values
4579
WHERE select_id = 26 OR select_id IS NULL order by id;
4580
CAST(my_char_30 AS DATE) my_char_30 id
4583
NULL <--------30 characters-------> 3
4584
NULL ---äÖüß@µ*$-- 4
4586
2005-06-27 2005-06-27 8
4588
Warning 1292 Incorrect datetime value: ''
4589
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4590
Warning 1292 Incorrect datetime value: ' ---����@�*$--'
4591
Warning 1292 Incorrect datetime value: '-1'
4592
SHOW CREATE VIEW v1;
4593
View Create View character_set_client collation_connection
4594
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
4596
WHERE v1.id IN (SELECT id FROM t1_values
4597
WHERE select_id = 26 OR select_id IS NULL) order by id;
4598
CAST(my_char_30 AS DATE) my_char_30 id
4601
NULL <--------30 characters-------> 3
4602
NULL ---äÖüß@µ*$-- 4
4604
2005-06-27 2005-06-27 8
4606
Warning 1292 Incorrect datetime value: ''
4607
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4608
Warning 1292 Incorrect datetime value: ' ---����@�*$--'
4609
Warning 1292 Incorrect datetime value: '-1'
4613
CREATE VIEW v1 AS SELECT CAST(my_year AS CHAR),
4614
my_year, id FROM t1_values;
4615
SELECT CAST(my_year AS CHAR),
4616
my_year, id FROM t1_values
4617
WHERE select_id = 25 OR select_id IS NULL order by id;
4618
CAST(my_year AS CHAR) my_year id
4624
SHOW CREATE VIEW v1;
4625
View Create View character_set_client collation_connection
4626
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
4628
WHERE v1.id IN (SELECT id FROM t1_values
4629
WHERE select_id = 25 OR select_id IS NULL) order by id;
4630
CAST(my_year AS CHAR) my_year id
4639
CREATE VIEW v1 AS SELECT CAST(my_time AS CHAR),
4640
my_time, id FROM t1_values;
4641
SELECT CAST(my_time AS CHAR),
4642
my_time, id FROM t1_values
4643
WHERE select_id = 24 OR select_id IS NULL order by id;
4644
CAST(my_time AS CHAR) my_time id
4646
-838:59:59 -838:59:59 2
4647
838:59:59 838:59:59 3
4650
SHOW CREATE VIEW v1;
4651
View Create View character_set_client collation_connection
4652
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
4654
WHERE v1.id IN (SELECT id FROM t1_values
4655
WHERE select_id = 24 OR select_id IS NULL) order by id;
4656
CAST(my_time AS CHAR) my_time id
4658
-838:59:59 -838:59:59 2
4659
838:59:59 838:59:59 3
4665
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS CHAR),
4666
my_timestamp, id FROM t1_values;
4667
SELECT CAST(my_timestamp AS CHAR),
4668
my_timestamp, id FROM t1_values
4669
WHERE select_id = 23 OR select_id IS NULL order by id;
4670
CAST(my_timestamp AS CHAR) my_timestamp id
4671
0000-00-00 00:00:00 0000-00-00 00:00:00 1
4672
1970-01-01 03:00:01 1970-01-01 03:00:01 2
4673
2038-01-01 02:59:59 2038-01-01 02:59:59 3
4674
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4675
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4676
SHOW CREATE VIEW v1;
4677
View Create View character_set_client collation_connection
4678
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
4680
WHERE v1.id IN (SELECT id FROM t1_values
4681
WHERE select_id = 23 OR select_id IS NULL) order by id;
4682
CAST(my_timestamp AS CHAR) my_timestamp id
4683
0000-00-00 00:00:00 0000-00-00 00:00:00 1
4684
1970-01-01 03:00:01 1970-01-01 03:00:01 2
4685
2038-01-01 02:59:59 2038-01-01 02:59:59 3
4686
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4687
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4691
CREATE VIEW v1 AS SELECT CAST(my_date AS CHAR),
4692
my_date, id FROM t1_values;
4693
SELECT CAST(my_date AS CHAR),
4694
my_date, id FROM t1_values
4695
WHERE select_id = 22 OR select_id IS NULL order by id;
4696
CAST(my_date AS CHAR) my_date id
4698
0001-01-01 0001-01-01 2
4699
9999-12-31 9999-12-31 3
4700
2004-02-29 2004-02-29 4
4701
2005-06-28 2005-06-28 5
4702
SHOW CREATE VIEW v1;
4703
View Create View character_set_client collation_connection
4704
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
4706
WHERE v1.id IN (SELECT id FROM t1_values
4707
WHERE select_id = 22 OR select_id IS NULL) order by id;
4708
CAST(my_date AS CHAR) my_date id
4710
0001-01-01 0001-01-01 2
4711
9999-12-31 9999-12-31 3
4712
2004-02-29 2004-02-29 4
4713
2005-06-28 2005-06-28 5
4717
CREATE VIEW v1 AS SELECT CAST(my_datetime AS CHAR),
4718
my_datetime, id FROM t1_values;
4719
SELECT CAST(my_datetime AS CHAR),
4720
my_datetime, id FROM t1_values
4721
WHERE select_id = 21 OR select_id IS NULL order by id;
4722
CAST(my_datetime AS CHAR) my_datetime id
4724
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4725
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4726
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4727
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4728
SHOW CREATE VIEW v1;
4729
View Create View character_set_client collation_connection
4730
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
4732
WHERE v1.id IN (SELECT id FROM t1_values
4733
WHERE select_id = 21 OR select_id IS NULL) order by id;
4734
CAST(my_datetime AS CHAR) my_datetime id
4736
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4737
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4738
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4739
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4743
CREATE VIEW v1 AS SELECT CAST(my_double AS CHAR),
4744
my_double, id FROM t1_values;
4745
SELECT CAST(my_double AS CHAR),
4746
my_double, id FROM t1_values
4747
WHERE select_id = 20 OR select_id IS NULL order by id;
4748
CAST(my_double AS CHAR) my_double id
4750
-1.7976931348623e308 -1.7976931348623e308 2
4751
1.7976931348623e308 1.7976931348623e308 3
4754
SHOW CREATE VIEW v1;
4755
View Create View character_set_client collation_connection
4756
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
4758
WHERE v1.id IN (SELECT id FROM t1_values
4759
WHERE select_id = 20 OR select_id IS NULL) order by id;
4760
CAST(my_double AS CHAR) my_double id
4762
-1.7976931348623e308 -1.7976931348623e308 2
4763
1.7976931348623e308 1.7976931348623e308 3
4769
CREATE VIEW v1 AS SELECT CAST(my_decimal AS CHAR),
4770
my_decimal, id FROM t1_values;
4771
SELECT CAST(my_decimal AS CHAR),
4772
my_decimal, id FROM t1_values
4773
WHERE select_id = 19 OR select_id IS NULL order by id;
4774
CAST(my_decimal AS CHAR) my_decimal id
4776
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
4777
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
4778
0.000000000000000000000000000000 0.000000000000000000000000000000 4
4779
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
4780
SHOW CREATE VIEW v1;
4781
View Create View character_set_client collation_connection
4782
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
4784
WHERE v1.id IN (SELECT id FROM t1_values
4785
WHERE select_id = 19 OR select_id IS NULL) order by id;
4786
CAST(my_decimal AS CHAR) my_decimal id
4788
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
4789
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
4790
0.000000000000000000000000000000 0.000000000000000000000000000000 4
4791
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
4795
CREATE VIEW v1 AS SELECT CAST(my_bigint AS CHAR),
4796
my_bigint, id FROM t1_values;
4797
SELECT CAST(my_bigint AS CHAR),
4798
my_bigint, id FROM t1_values
4799
WHERE select_id = 18 OR select_id IS NULL order by id;
4800
CAST(my_bigint AS CHAR) my_bigint id
4802
-9223372036854775808 -9223372036854775808 2
4803
9223372036854775807 9223372036854775807 3
4806
SHOW CREATE VIEW v1;
4807
View Create View character_set_client collation_connection
4808
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
4810
WHERE v1.id IN (SELECT id FROM t1_values
4811
WHERE select_id = 18 OR select_id IS NULL) order by id;
4812
CAST(my_bigint AS CHAR) my_bigint id
4814
-9223372036854775808 -9223372036854775808 2
4815
9223372036854775807 9223372036854775807 3
4821
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS CHAR),
4822
my_varbinary_1000, id FROM t1_values;
4823
SELECT CAST(my_varbinary_1000 AS CHAR),
4824
my_varbinary_1000, id FROM t1_values
4825
WHERE select_id = 17 OR select_id IS NULL order by id;
4826
CAST(my_varbinary_1000 AS CHAR) my_varbinary_1000 id
4829
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4830
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4832
SHOW CREATE VIEW v1;
4833
View Create View character_set_client collation_connection
4834
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
4836
WHERE v1.id IN (SELECT id FROM t1_values
4837
WHERE select_id = 17 OR select_id IS NULL) order by id;
4838
CAST(my_varbinary_1000 AS CHAR) my_varbinary_1000 id
4841
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4842
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4847
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS CHAR),
4848
my_binary_30, id FROM t1_values;
4849
SELECT CAST(my_binary_30 AS CHAR),
4850
my_binary_30, id FROM t1_values
4851
WHERE select_id = 16 OR select_id IS NULL order by id;
4852
CAST(my_binary_30 AS CHAR) my_binary_30 id
4855
<--------30 characters-------> <--------30 characters-------> 3
4856
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4858
SHOW CREATE VIEW v1;
4859
View Create View character_set_client collation_connection
4860
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
4862
WHERE v1.id IN (SELECT id FROM t1_values
4863
WHERE select_id = 16 OR select_id IS NULL) order by id;
4864
CAST(my_binary_30 AS CHAR) my_binary_30 id
4867
<--------30 characters-------> <--------30 characters-------> 3
4868
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4873
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS CHAR),
4874
my_varchar_1000, id FROM t1_values;
4875
SELECT CAST(my_varchar_1000 AS CHAR),
4876
my_varchar_1000, id FROM t1_values
4877
WHERE select_id = 15 OR select_id IS NULL order by id;
4878
CAST(my_varchar_1000 AS CHAR) my_varchar_1000 id
4881
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4882
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4884
SHOW CREATE VIEW v1;
4885
View Create View character_set_client collation_connection
4886
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
4888
WHERE v1.id IN (SELECT id FROM t1_values
4889
WHERE select_id = 15 OR select_id IS NULL) order by id;
4890
CAST(my_varchar_1000 AS CHAR) my_varchar_1000 id
4893
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4894
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4899
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS CHAR),
4900
my_char_30, id FROM t1_values;
4901
SELECT CAST(my_char_30 AS CHAR),
4902
my_char_30, id FROM t1_values
4903
WHERE select_id = 14 OR select_id IS NULL order by id;
4904
CAST(my_char_30 AS CHAR) my_char_30 id
4907
<--------30 characters-------> <--------30 characters-------> 3
4908
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4910
SHOW CREATE VIEW v1;
4911
View Create View character_set_client collation_connection
4912
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
4914
WHERE v1.id IN (SELECT id FROM t1_values
4915
WHERE select_id = 14 OR select_id IS NULL) order by id;
4916
CAST(my_char_30 AS CHAR) my_char_30 id
4919
<--------30 characters-------> <--------30 characters-------> 3
4920
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4925
CREATE VIEW v1 AS SELECT CAST(my_year AS BINARY),
4926
my_year, id FROM t1_values;
4927
SELECT CAST(my_year AS BINARY),
4928
my_year, id FROM t1_values
4929
WHERE select_id = 13 OR select_id IS NULL order by id;
4930
CAST(my_year AS BINARY) my_year id
4936
SHOW CREATE VIEW v1;
4937
View Create View character_set_client collation_connection
4938
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
4940
WHERE v1.id IN (SELECT id FROM t1_values
4941
WHERE select_id = 13 OR select_id IS NULL) order by id;
4942
CAST(my_year AS BINARY) my_year id
4951
CREATE VIEW v1 AS SELECT CAST(my_time AS BINARY),
4952
my_time, id FROM t1_values;
4953
SELECT CAST(my_time AS BINARY),
4954
my_time, id FROM t1_values
4955
WHERE select_id = 12 OR select_id IS NULL order by id;
4956
CAST(my_time AS BINARY) my_time id
4958
-838:59:59 -838:59:59 2
4959
838:59:59 838:59:59 3
4962
SHOW CREATE VIEW v1;
4963
View Create View character_set_client collation_connection
4964
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
4966
WHERE v1.id IN (SELECT id FROM t1_values
4967
WHERE select_id = 12 OR select_id IS NULL) order by id;
4968
CAST(my_time AS BINARY) my_time id
4970
-838:59:59 -838:59:59 2
4971
838:59:59 838:59:59 3
4977
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS BINARY),
4978
my_timestamp, id FROM t1_values;
4979
SELECT CAST(my_timestamp AS BINARY),
4980
my_timestamp, id FROM t1_values
4981
WHERE select_id = 11 OR select_id IS NULL order by id;
4982
CAST(my_timestamp AS BINARY) my_timestamp id
4983
0000-00-00 00:00:00 0000-00-00 00:00:00 1
4984
1970-01-01 03:00:01 1970-01-01 03:00:01 2
4985
2038-01-01 02:59:59 2038-01-01 02:59:59 3
4986
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4987
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4988
SHOW CREATE VIEW v1;
4989
View Create View character_set_client collation_connection
4990
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
4992
WHERE v1.id IN (SELECT id FROM t1_values
4993
WHERE select_id = 11 OR select_id IS NULL) order by id;
4994
CAST(my_timestamp AS BINARY) my_timestamp id
4995
0000-00-00 00:00:00 0000-00-00 00:00:00 1
4996
1970-01-01 03:00:01 1970-01-01 03:00:01 2
4997
2038-01-01 02:59:59 2038-01-01 02:59:59 3
4998
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4999
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5003
CREATE VIEW v1 AS SELECT CAST(my_date AS BINARY),
5004
my_date, id FROM t1_values;
5005
SELECT CAST(my_date AS BINARY),
5006
my_date, id FROM t1_values
5007
WHERE select_id = 10 OR select_id IS NULL order by id;
5008
CAST(my_date AS BINARY) my_date id
5010
0001-01-01 0001-01-01 2
5011
9999-12-31 9999-12-31 3
5012
2004-02-29 2004-02-29 4
5013
2005-06-28 2005-06-28 5
5014
SHOW CREATE VIEW v1;
5015
View Create View character_set_client collation_connection
5016
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
5018
WHERE v1.id IN (SELECT id FROM t1_values
5019
WHERE select_id = 10 OR select_id IS NULL) order by id;
5020
CAST(my_date AS BINARY) my_date id
5022
0001-01-01 0001-01-01 2
5023
9999-12-31 9999-12-31 3
5024
2004-02-29 2004-02-29 4
5025
2005-06-28 2005-06-28 5
5029
CREATE VIEW v1 AS SELECT CAST(my_datetime AS BINARY),
5030
my_datetime, id FROM t1_values;
5031
SELECT CAST(my_datetime AS BINARY),
5032
my_datetime, id FROM t1_values
5033
WHERE select_id = 9 OR select_id IS NULL order by id;
5034
CAST(my_datetime AS BINARY) my_datetime id
5036
0001-01-01 00:00:00 0001-01-01 00:00:00 2
5037
9999-12-31 23:59:59 9999-12-31 23:59:59 3
5038
2004-02-29 23:59:59 2004-02-29 23:59:59 4
5039
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5040
SHOW CREATE VIEW v1;
5041
View Create View character_set_client collation_connection
5042
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
5044
WHERE v1.id IN (SELECT id FROM t1_values
5045
WHERE select_id = 9 OR select_id IS NULL) order by id;
5046
CAST(my_datetime AS BINARY) my_datetime id
5048
0001-01-01 00:00:00 0001-01-01 00:00:00 2
5049
9999-12-31 23:59:59 9999-12-31 23:59:59 3
5050
2004-02-29 23:59:59 2004-02-29 23:59:59 4
5051
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5055
CREATE VIEW v1 AS SELECT CAST(my_double AS BINARY),
5056
my_double, id FROM t1_values;
5057
SELECT CAST(my_double AS BINARY),
5058
my_double, id FROM t1_values
5059
WHERE select_id = 8 OR select_id IS NULL order by id;
5060
CAST(my_double AS BINARY) my_double id
5062
-1.7976931348623e308 -1.7976931348623e308 2
5063
1.7976931348623e308 1.7976931348623e308 3
5066
SHOW CREATE VIEW v1;
5067
View Create View character_set_client collation_connection
5068
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
5070
WHERE v1.id IN (SELECT id FROM t1_values
5071
WHERE select_id = 8 OR select_id IS NULL) order by id;
5072
CAST(my_double AS BINARY) my_double id
5074
-1.7976931348623e308 -1.7976931348623e308 2
5075
1.7976931348623e308 1.7976931348623e308 3
5081
CREATE VIEW v1 AS SELECT CAST(my_decimal AS BINARY),
5082
my_decimal, id FROM t1_values;
5083
SELECT CAST(my_decimal AS BINARY),
5084
my_decimal, id FROM t1_values
5085
WHERE select_id = 7 OR select_id IS NULL order by id;
5086
CAST(my_decimal AS BINARY) my_decimal id
5088
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
5089
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
5090
0.000000000000000000000000000000 0.000000000000000000000000000000 4
5091
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
5092
SHOW CREATE VIEW v1;
5093
View Create View character_set_client collation_connection
5094
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
5096
WHERE v1.id IN (SELECT id FROM t1_values
5097
WHERE select_id = 7 OR select_id IS NULL) order by id;
5098
CAST(my_decimal AS BINARY) my_decimal id
5100
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
5101
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
5102
0.000000000000000000000000000000 0.000000000000000000000000000000 4
5103
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
5107
CREATE VIEW v1 AS SELECT CAST(my_bigint AS BINARY),
5108
my_bigint, id FROM t1_values;
5109
SELECT CAST(my_bigint AS BINARY),
5110
my_bigint, id FROM t1_values
5111
WHERE select_id = 6 OR select_id IS NULL order by id;
5112
CAST(my_bigint AS BINARY) my_bigint id
5114
-9223372036854775808 -9223372036854775808 2
5115
9223372036854775807 9223372036854775807 3
5118
SHOW CREATE VIEW v1;
5119
View Create View character_set_client collation_connection
5120
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
5122
WHERE v1.id IN (SELECT id FROM t1_values
5123
WHERE select_id = 6 OR select_id IS NULL) order by id;
5124
CAST(my_bigint AS BINARY) my_bigint id
5126
-9223372036854775808 -9223372036854775808 2
5127
9223372036854775807 9223372036854775807 3
5133
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS BINARY),
5134
my_varbinary_1000, id FROM t1_values;
5135
SELECT CAST(my_varbinary_1000 AS BINARY),
5136
my_varbinary_1000, id FROM t1_values
5137
WHERE select_id = 5 OR select_id IS NULL order by id;
5138
CAST(my_varbinary_1000 AS BINARY) my_varbinary_1000 id
5141
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5142
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5144
SHOW CREATE VIEW v1;
5145
View Create View character_set_client collation_connection
5146
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
5148
WHERE v1.id IN (SELECT id FROM t1_values
5149
WHERE select_id = 5 OR select_id IS NULL) order by id;
5150
CAST(my_varbinary_1000 AS BINARY) my_varbinary_1000 id
5153
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5154
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5159
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS BINARY),
5160
my_binary_30, id FROM t1_values;
5161
SELECT CAST(my_binary_30 AS BINARY),
5162
my_binary_30, id FROM t1_values
5163
WHERE select_id = 4 OR select_id IS NULL order by id;
5164
CAST(my_binary_30 AS BINARY) my_binary_30 id
5167
<--------30 characters-------> <--------30 characters-------> 3
5168
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5170
SHOW CREATE VIEW v1;
5171
View Create View character_set_client collation_connection
5172
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
5174
WHERE v1.id IN (SELECT id FROM t1_values
5175
WHERE select_id = 4 OR select_id IS NULL) order by id;
5176
CAST(my_binary_30 AS BINARY) my_binary_30 id
5179
<--------30 characters-------> <--------30 characters-------> 3
5180
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5185
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS BINARY),
5186
my_varchar_1000, id FROM t1_values;
5187
SELECT CAST(my_varchar_1000 AS BINARY),
5188
my_varchar_1000, id FROM t1_values
5189
WHERE select_id = 3 OR select_id IS NULL order by id;
5190
CAST(my_varchar_1000 AS BINARY) my_varchar_1000 id
5193
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5194
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5196
SHOW CREATE VIEW v1;
5197
View Create View character_set_client collation_connection
5198
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
5200
WHERE v1.id IN (SELECT id FROM t1_values
5201
WHERE select_id = 3 OR select_id IS NULL) order by id;
5202
CAST(my_varchar_1000 AS BINARY) my_varchar_1000 id
5205
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5206
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5211
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS BINARY),
5212
my_char_30, id FROM t1_values;
5213
SELECT CAST(my_char_30 AS BINARY),
5214
my_char_30, id FROM t1_values
5215
WHERE select_id = 2 OR select_id IS NULL order by id;
5216
CAST(my_char_30 AS BINARY) my_char_30 id
5219
<--------30 characters-------> <--------30 characters-------> 3
5220
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5222
SHOW CREATE VIEW v1;
5223
View Create View character_set_client collation_connection
5224
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
5226
WHERE v1.id IN (SELECT id FROM t1_values
5227
WHERE select_id = 2 OR select_id IS NULL) order by id;
5228
CAST(my_char_30 AS BINARY) my_char_30 id
5231
<--------30 characters-------> <--------30 characters-------> 3
5232
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5237
CREATE VIEW v1 AS SELECT sqrt(my_bigint), my_bigint, id FROM t1_values;
5238
SELECT sqrt(my_bigint), my_bigint, id FROM t1_values
5239
WHERE select_id = 1 OR select_id IS NULL order by id;
5240
sqrt(my_bigint) my_bigint id
5242
NULL -9223372036854775808 2
5243
3037000499.97605 9223372036854775807 3
5248
SHOW CREATE VIEW v1;
5249
View Create View character_set_client collation_connection
5250
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
5252
WHERE v1.id IN (SELECT id FROM t1_values
5253
WHERE select_id = 1 OR select_id IS NULL) order by id;
5254
sqrt(my_bigint) my_bigint id
5256
NULL -9223372036854775808 2
5257
3037000499.97605 9223372036854775807 3
5265
DROP TABLE t1_selects, t1_modes, t1_values;
added
removed
mysql-test/suite/funcs_1/r/innodb_func_view.result
