1
SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
2
SET timestamp=UNIX_TIMESTAMP('2010-01-01');
3
DROP TABLE IF EXISTS t1_selects, t1_modes, t1_values;
4
DROP VIEW IF EXISTS v1;
7
id BIGINT AUTO_INCREMENT,
10
) ENGINE = <engine_to_be_tested>;
11
ALTER TABLE t1_values ADD my_char_30 CHAR(30);
12
ALTER TABLE t1_values ADD my_varchar_1000 VARCHAR(1000);
13
ALTER TABLE t1_values ADD my_binary_30 BINARY(30);
14
ALTER TABLE t1_values ADD my_varbinary_1000 VARBINARY(1000);
15
ALTER TABLE t1_values ADD my_datetime DATETIME;
16
ALTER TABLE t1_values ADD my_date DATE;
17
ALTER TABLE t1_values ADD ts_dummy TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
18
ALTER TABLE t1_values ADD my_timestamp TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00';
19
ALTER TABLE t1_values ADD my_time TIME;
20
ALTER TABLE t1_values ADD my_year YEAR;
21
ALTER TABLE t1_values ADD my_bigint BIGINT;
22
ALTER TABLE t1_values ADD my_double DOUBLE;
23
ALTER TABLE t1_values ADD my_decimal DECIMAL(64,30);
24
SET sql_mode = 'traditional';
25
INSERT INTO t1_values SET id = 0;
26
INSERT INTO t1_values SET
30
my_varbinary_1000 = '',
31
my_datetime = '0001-01-01 00:00:00',
32
my_date = '0001-01-01',
33
my_timestamp = '1970-01-01 03:00:01',
34
my_time = '-838:59:59',
36
my_bigint = -9223372036854775808,
37
my_decimal = -9999999999999999999999999999999999.999999999999999999999999999999 ,
38
my_double = -1.7976931348623E+308;
39
INSERT INTO t1_values SET
40
my_char_30 = '<--------30 characters------->',
41
my_varchar_1000 = CONCAT('<---------1000 characters',
42
RPAD('',965,'-'),'--------->'),
43
my_binary_30 = '<--------30 characters------->',
44
my_varbinary_1000 = CONCAT('<---------1000 characters',
45
RPAD('',965,'-'),'--------->'),
46
my_datetime = '9999-12-31 23:59:59',
47
my_date = '9999-12-31',
48
my_timestamp = '2038-01-01 02:59:59',
49
my_time = '838:59:59',
51
my_bigint = 9223372036854775807,
52
my_decimal = +9999999999999999999999999999999999.999999999999999999999999999999 ,
53
my_double = 1.7976931348623E+308;
54
INSERT INTO t1_values SET
55
my_char_30 = ' ---äÖüß@µ*$-- ',
56
my_varchar_1000 = ' ---äÖüß@µ*$-- ',
57
my_binary_30 = ' ---äÖüß@µ*$-- ',
58
my_varbinary_1000 = ' ---äÖüß@µ*$-- ',
59
my_datetime = '2004-02-29 23:59:59',
60
my_date = '2004-02-29',
61
my_timestamp = '2004-02-29 23:59:59',
67
INSERT INTO t1_values SET
69
my_varchar_1000 = '-1',
71
my_varbinary_1000 = '-1',
72
my_datetime = '2005-06-28 10:00:00',
73
my_date = '2005-06-28',
74
my_timestamp = '2005-06-28 10:00:00',
78
my_decimal = -1.000000000000000000000000000000,
80
PREPARE ins_sel_with_result FROM "INSERT INTO t1_selects SET my_select = @my_select,
81
disable_result = 'No'" ;
82
PREPARE ins_sel_no_result FROM "INSERT INTO t1_selects SET my_select = @my_select,
83
disable_result = 'Yes'" ;
84
SET sql_mode = 'traditional';
85
SET @my_select = 'SELECT sqrt(my_bigint), my_bigint, id FROM t1_values';
86
INSERT INTO t1_values SET select_id = @select_id,
88
INSERT INTO t1_values SET select_id = @select_id,
90
##### 1.1.1. CAST --> BINARY
91
##### 1.1.2. CAST --> CHAR
92
##### 1.1.3. CAST --> DATE
93
INSERT INTO t1_values SET select_id = @select_id,
94
my_char_30 = '2005-06-27';
95
INSERT INTO t1_values SET select_id = @select_id,
96
my_varchar_1000 = '2005-06-27';
97
INSERT INTO t1_values SET select_id = @select_id,
98
my_binary_30 = '2005-06-27';
99
INSERT INTO t1_values SET select_id = @select_id,
100
my_varbinary_1000 = '2005-06-27';
101
INSERT INTO t1_values SET select_id = @select_id,
102
my_bigint = 20050627;
103
INSERT INTO t1_values SET select_id = @select_id,
104
my_double = +20.050627E+6;
105
##### 1.1.4. CAST --> DATETIME
106
INSERT INTO t1_values SET select_id = @select_id,
107
my_char_30 = '2005-06-27 17:58';
108
INSERT INTO t1_values SET select_id = @select_id,
109
my_varchar_1000 = '2005-06-27 17:58';
110
INSERT INTO t1_values SET select_id = @select_id,
111
my_binary_30 = '2005-06-27 17:58';
112
INSERT INTO t1_values SET select_id = @select_id,
113
my_varbinary_1000 = '2005-06-27 17:58';
114
INSERT INTO t1_values SET select_id = @select_id,
115
my_bigint = 200506271758;
116
INSERT INTO t1_values SET select_id = @select_id,
117
my_double = +0.0200506271758E+13;
118
##### 1.1.5. CAST --> TIME
119
INSERT INTO t1_values SET select_id = @select_id,
120
my_char_30 = '1 17:58';
121
INSERT INTO t1_values SET select_id = @select_id,
122
my_varchar_1000 = '1 17:58';
123
INSERT INTO t1_values SET select_id = @select_id,
124
my_binary_30 = '1 17:58';
125
INSERT INTO t1_values SET select_id = @select_id,
126
my_varbinary_1000 = '1 17:58';
127
INSERT INTO t1_values SET select_id = @select_id,
129
INSERT INTO t1_values SET select_id = @select_id,
130
my_double = +1.758E+3;
131
##### 1.1.6. CAST --> DECIMAL
132
INSERT INTO t1_values SET select_id = @select_id,
133
my_char_30 = '-3333.3333';
134
INSERT INTO t1_values SET select_id = @select_id,
135
my_varchar_1000 = '-3333.3333';
136
INSERT INTO t1_values SET select_id = @select_id,
137
my_binary_30 = '-3333.3333';
138
INSERT INTO t1_values SET select_id = @select_id,
139
my_varbinary_1000 = '-3333.3333';
140
INSERT INTO t1_values SET select_id = @select_id,
141
my_double = -0.33333333E+4;
142
##### 1.1.7. CAST --> SIGNED INTEGER
144
"Attention: CAST --> SIGNED INTEGER
145
Bug#5913 Traditional mode: BIGINT range not correctly delimited
146
Status: To be fixed later"
147
--------------------------------------------------------------------------------
148
##### 1.1.8. CAST --> UNSIGNED INTEGER
150
"Attention: CAST --> UNSIGNED INTEGER
151
The file with expected results suffers from Bug 5913"
152
--------------------------------------------------------------------------------
154
some statements disabled because of
155
Bug#5913 Traditional mode: BIGINT range not correctly delimited
156
--------------------------------------------------------------------------------
157
SET @my_select = 'SELECT CONVERT(my_char_30 USING utf8),
158
my_char_30, id FROM t1_values';
159
SET @my_select = 'SELECT CONVERT(my_varchar_1000 USING utf8),
160
my_varchar_1000, id FROM t1_values';
161
SET @my_select = 'SELECT CONVERT(my_binary_30 USING utf8),
162
my_binary_30, id FROM t1_values';
163
SET @my_select = 'SELECT CONVERT(my_varbinary_1000 USING utf8),
164
my_varbinary_1000, id FROM t1_values';
165
SET @my_select = 'SELECT CONVERT(my_char_30 USING koi8r),
166
my_char_30, id FROM t1_values';
167
SET @my_select = 'SELECT CONVERT(my_varchar_1000 USING koi8r),
168
my_varchar_1000, id FROM t1_values';
169
SET @my_select = 'SELECT CONVERT(my_binary_30 USING koi8r),
170
my_binary_30, id FROM t1_values';
171
SET @my_select = 'SELECT CONVERT(my_varbinary_1000 USING koi8r),
172
my_varbinary_1000, id FROM t1_values';
173
SET @my_select = 'SELECT BIT_LENGTH(my_char_30),
174
my_char_30, id FROM t1_values';
175
SET @my_select = 'SELECT BIT_LENGTH(my_varchar_1000),
176
my_varchar_1000, id FROM t1_values';
177
SET @my_select = 'SELECT BIT_LENGTH(my_binary_30),
178
my_binary_30, id FROM t1_values';
179
SET @my_select = 'SELECT BIT_LENGTH(my_varbinary_1000),
180
my_varbinary_1000, id FROM t1_values';
181
SET @my_select = 'SELECT INSTR(my_char_30, ''char''),
182
my_char_30, id FROM t1_values';
183
SET @my_select = 'SELECT LCASE(my_varchar_1000),
184
my_varchar_1000, id FROM t1_values';
186
'SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values';
188
'SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values';
190
'SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values';
192
'SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values';
194
'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_bigint), my_bigint, id FROM t1_values';
196
'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_decimal), my_decimal, id FROM t1_values';
198
'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_double), my_double, id FROM t1_values';
199
SET @my_select = 'SELECT LENGTH(my_char_30),
200
my_char_30, id FROM t1_values';
201
SET @my_select = 'SELECT LENGTH(my_varchar_1000),
202
my_varchar_1000, id FROM t1_values';
203
SET @my_select = 'SELECT LENGTH(my_binary_30),
204
my_binary_30, id FROM t1_values';
205
SET @my_select = 'SELECT LENGTH(my_varbinary_1000),
206
my_varbinary_1000, id FROM t1_values';
208
'SELECT LOAD_FILE(''<MYSQLTEST_VARDIR>/std_data/funcs_1/load_file.txt'')
211
SET @my_select = 'SELECT LOCATE(''char'', my_char_30),
212
my_char_30, id FROM t1_values';
213
SET @my_select = 'SELECT LOCATE(''char'', my_varchar_1000),
214
my_varchar_1000, id FROM t1_values';
215
SET @my_select = 'SELECT LOCATE(''char'', my_binary_30),
216
my_binary_30, id FROM t1_values';
217
SET @my_select = 'SELECT LOCATE(''char'', my_varbinary_1000),
218
my_varbinary_1000, id FROM t1_values';
219
SET @my_select = 'SELECT LOCATE(my_char_30, my_char_30 ),
220
my_char_30, id FROM t1_values';
221
SET @my_select = 'SELECT LOCATE(my_char_30, my_varchar_1000 ),
222
my_char_30, my_varchar_1000 id FROM t1_values';
223
SET @my_select = 'SELECT LOCATE(my_char_30, my_binary_30 ),
224
my_char_30, my_binary_30 id FROM t1_values';
225
SET @my_select = 'SELECT LOCATE(my_char_30, my_varbinary_1000 ),
226
my_char_30, my_varbinary_1000 id FROM t1_values';
227
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
228
my_varchar_1000, id FROM t1_values';
229
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_char_30 ),
230
my_varchar_1000, my_char_30 id FROM t1_values';
231
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_binary_30 ),
232
my_varchar_1000, my_binary_30 id FROM t1_values';
233
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
234
my_varchar_1000, my_varbinary_1000 id FROM t1_values';
235
SET @my_select = 'SELECT LOCATE(my_binary_30, my_binary_30 ),
236
my_binary_30, id FROM t1_values';
237
SET @my_select = 'SELECT LOCATE(my_binary_30, my_char_30 ),
238
my_binary_30, my_char_30 id FROM t1_values';
239
SET @my_select = 'SELECT LOCATE(my_binary_30, my_varchar_1000 ),
240
my_binary_30, my_varchar_1000 id FROM t1_values';
241
SET @my_select = 'SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
242
my_binary_30, my_varbinary_1000 id FROM t1_values';
243
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
244
my_varbinary_1000, id FROM t1_values';
245
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_char_30 ),
246
my_varbinary_1000, my_char_30 id FROM t1_values';
247
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
248
my_varbinary_1000, my_varchar_1000 id FROM t1_values';
249
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
250
my_varbinary_1000, my_binary_30 id FROM t1_values';
251
SET @my_select = 'SELECT LOCATE(''-'', my_char_30, 3),
252
my_char_30, id FROM t1_values';
253
SET @my_select = 'SELECT LOCATE(''-'', my_varchar_1000, 3),
254
my_varchar_1000, id FROM t1_values';
255
SET @my_select = 'SELECT LOCATE(''-'', my_binary_30, 3),
256
my_binary_30, id FROM t1_values';
257
SET @my_select = 'SELECT LOCATE(''-'', my_varbinary_1000, 3),
258
my_varbinary_1000, id FROM t1_values';
259
SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_bigint),
260
my_bigint, id FROM t1_values';
261
SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_double),
262
my_double, id FROM t1_values';
263
SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_decimal),
264
my_decimal, id FROM t1_values';
265
SET @my_select = 'SELECT LOWER(my_char_30),
266
my_char_30, id FROM t1_values';
267
SET @my_select = 'SELECT LOWER(my_varchar_1000),
268
my_varchar_1000, id FROM t1_values';
269
SET @my_select = 'SELECT LOWER(my_binary_30),
270
my_binary_30, id FROM t1_values';
271
SET @my_select = 'SELECT LOWER(my_varbinary_1000),
272
my_varbinary_1000, id FROM t1_values';
273
SET @my_select = 'SELECT LTRIM(my_char_30),
274
my_char_30, id FROM t1_values';
275
SET @my_select = 'SELECT LTRIM(my_varchar_1000),
276
my_varchar_1000, id FROM t1_values';
277
SET @my_select = 'SELECT LTRIM(my_binary_30),
278
my_binary_30, id FROM t1_values';
279
SET @my_select = 'SELECT LTRIM(my_varbinary_1000),
280
my_varbinary_1000, id FROM t1_values';
282
'SELECT CONCAT(''A'',my_char_30), my_char_30, id FROM t1_values';
283
SET @my_select = 'SELECT my_char_30, id FROM t1_values';
284
INSERT INTO t1_values SET select_id = @select_id,
285
my_char_30 = 'Viana do Castelo';
288
"# The basic preparations end and the main test starts here"
289
--------------------------------------------------------------------------------
290
CREATE VIEW v1 AS SELECT my_char_30, id FROM t1_values;
291
SELECT my_char_30, id FROM t1_values
292
WHERE select_id = 193 OR select_id IS NULL order by id;
294
View Create View character_set_client collation_connection
295
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
297
WHERE v1.id IN (SELECT id FROM t1_values
298
WHERE select_id = 193 OR select_id IS NULL) order by id;
302
CREATE VIEW v1 AS SELECT CONCAT('A',my_char_30), my_char_30, id FROM t1_values;
303
SELECT CONCAT('A',my_char_30), my_char_30, id FROM t1_values
304
WHERE select_id = 192 OR select_id IS NULL order by id;
305
CONCAT('A',my_char_30) my_char_30 id
308
A<--------30 characters-------> <--------30 characters-------> 3
309
A ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
312
View Create View character_set_client collation_connection
313
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
315
WHERE v1.id IN (SELECT id FROM t1_values
316
WHERE select_id = 192 OR select_id IS NULL) order by id;
317
CONCAT('A',my_char_30) my_char_30 id
320
A<--------30 characters-------> <--------30 characters-------> 3
321
A ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
326
CREATE VIEW v1 AS SELECT LTRIM(my_varbinary_1000),
327
my_varbinary_1000, id FROM t1_values;
328
SELECT LTRIM(my_varbinary_1000),
329
my_varbinary_1000, id FROM t1_values
330
WHERE select_id = 191 OR select_id IS NULL order by id;
332
View Create View character_set_client collation_connection
333
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
335
WHERE v1.id IN (SELECT id FROM t1_values
336
WHERE select_id = 191 OR select_id IS NULL) order by id;
340
CREATE VIEW v1 AS SELECT LTRIM(my_binary_30),
341
my_binary_30, id FROM t1_values;
342
SELECT LTRIM(my_binary_30),
343
my_binary_30, id FROM t1_values
344
WHERE select_id = 190 OR select_id IS NULL order by id;
346
View Create View character_set_client collation_connection
347
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
349
WHERE v1.id IN (SELECT id FROM t1_values
350
WHERE select_id = 190 OR select_id IS NULL) order by id;
354
CREATE VIEW v1 AS SELECT LTRIM(my_varchar_1000),
355
my_varchar_1000, id FROM t1_values;
356
SELECT LTRIM(my_varchar_1000),
357
my_varchar_1000, id FROM t1_values
358
WHERE select_id = 189 OR select_id IS NULL order by id;
360
View Create View character_set_client collation_connection
361
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
363
WHERE v1.id IN (SELECT id FROM t1_values
364
WHERE select_id = 189 OR select_id IS NULL) order by id;
368
CREATE VIEW v1 AS SELECT LTRIM(my_char_30),
369
my_char_30, id FROM t1_values;
370
SELECT LTRIM(my_char_30),
371
my_char_30, id FROM t1_values
372
WHERE select_id = 188 OR select_id IS NULL order by id;
374
View Create View character_set_client collation_connection
375
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
377
WHERE v1.id IN (SELECT id FROM t1_values
378
WHERE select_id = 188 OR select_id IS NULL) order by id;
382
CREATE VIEW v1 AS SELECT LOWER(my_varbinary_1000),
383
my_varbinary_1000, id FROM t1_values;
384
SELECT LOWER(my_varbinary_1000),
385
my_varbinary_1000, id FROM t1_values
386
WHERE select_id = 187 OR select_id IS NULL order by id;
388
View Create View character_set_client collation_connection
389
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
391
WHERE v1.id IN (SELECT id FROM t1_values
392
WHERE select_id = 187 OR select_id IS NULL) order by id;
396
CREATE VIEW v1 AS SELECT LOWER(my_binary_30),
397
my_binary_30, id FROM t1_values;
398
SELECT LOWER(my_binary_30),
399
my_binary_30, id FROM t1_values
400
WHERE select_id = 186 OR select_id IS NULL order by id;
402
View Create View character_set_client collation_connection
403
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
405
WHERE v1.id IN (SELECT id FROM t1_values
406
WHERE select_id = 186 OR select_id IS NULL) order by id;
410
CREATE VIEW v1 AS SELECT LOWER(my_varchar_1000),
411
my_varchar_1000, id FROM t1_values;
412
SELECT LOWER(my_varchar_1000),
413
my_varchar_1000, id FROM t1_values
414
WHERE select_id = 185 OR select_id IS NULL order by id;
416
View Create View character_set_client collation_connection
417
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
419
WHERE v1.id IN (SELECT id FROM t1_values
420
WHERE select_id = 185 OR select_id IS NULL) order by id;
424
CREATE VIEW v1 AS SELECT LOWER(my_char_30),
425
my_char_30, id FROM t1_values;
426
SELECT LOWER(my_char_30),
427
my_char_30, id FROM t1_values
428
WHERE select_id = 184 OR select_id IS NULL order by id;
430
View Create View character_set_client collation_connection
431
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
433
WHERE v1.id IN (SELECT id FROM t1_values
434
WHERE select_id = 184 OR select_id IS NULL) order by id;
438
CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_decimal),
439
my_decimal, id FROM t1_values;
440
SELECT LOCATE('-', ' - -ABC', my_decimal),
441
my_decimal, id FROM t1_values
442
WHERE select_id = 183 OR select_id IS NULL order by id;
444
View Create View character_set_client collation_connection
445
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
447
WHERE v1.id IN (SELECT id FROM t1_values
448
WHERE select_id = 183 OR select_id IS NULL) order by id;
452
CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_double),
453
my_double, id FROM t1_values;
454
SELECT LOCATE('-', ' - -ABC', my_double),
455
my_double, id FROM t1_values
456
WHERE select_id = 182 OR select_id IS NULL order by id;
458
View Create View character_set_client collation_connection
459
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
461
WHERE v1.id IN (SELECT id FROM t1_values
462
WHERE select_id = 182 OR select_id IS NULL) order by id;
466
CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_bigint),
467
my_bigint, id FROM t1_values;
468
SELECT LOCATE('-', ' - -ABC', my_bigint),
469
my_bigint, id FROM t1_values
470
WHERE select_id = 181 OR select_id IS NULL order by id;
472
View Create View character_set_client collation_connection
473
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
475
WHERE v1.id IN (SELECT id FROM t1_values
476
WHERE select_id = 181 OR select_id IS NULL) order by id;
480
CREATE VIEW v1 AS SELECT LOCATE('-', my_varbinary_1000, 3),
481
my_varbinary_1000, id FROM t1_values;
482
SELECT LOCATE('-', my_varbinary_1000, 3),
483
my_varbinary_1000, id FROM t1_values
484
WHERE select_id = 180 OR select_id IS NULL order by id;
486
View Create View character_set_client collation_connection
487
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
489
WHERE v1.id IN (SELECT id FROM t1_values
490
WHERE select_id = 180 OR select_id IS NULL) order by id;
494
CREATE VIEW v1 AS SELECT LOCATE('-', my_binary_30, 3),
495
my_binary_30, id FROM t1_values;
496
SELECT LOCATE('-', my_binary_30, 3),
497
my_binary_30, id FROM t1_values
498
WHERE select_id = 179 OR select_id IS NULL order by id;
500
View Create View character_set_client collation_connection
501
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
503
WHERE v1.id IN (SELECT id FROM t1_values
504
WHERE select_id = 179 OR select_id IS NULL) order by id;
508
CREATE VIEW v1 AS SELECT LOCATE('-', my_varchar_1000, 3),
509
my_varchar_1000, id FROM t1_values;
510
SELECT LOCATE('-', my_varchar_1000, 3),
511
my_varchar_1000, id FROM t1_values
512
WHERE select_id = 178 OR select_id IS NULL order by id;
514
View Create View character_set_client collation_connection
515
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
517
WHERE v1.id IN (SELECT id FROM t1_values
518
WHERE select_id = 178 OR select_id IS NULL) order by id;
522
CREATE VIEW v1 AS SELECT LOCATE('-', my_char_30, 3),
523
my_char_30, id FROM t1_values;
524
SELECT LOCATE('-', my_char_30, 3),
525
my_char_30, id FROM t1_values
526
WHERE select_id = 177 OR select_id IS NULL order by id;
528
View Create View character_set_client collation_connection
529
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
531
WHERE v1.id IN (SELECT id FROM t1_values
532
WHERE select_id = 177 OR select_id IS NULL) order by id;
536
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
537
my_varbinary_1000, my_binary_30 id FROM t1_values;
538
SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
539
my_varbinary_1000, my_binary_30 id FROM t1_values
540
WHERE select_id = 176 OR select_id IS NULL order by id;
542
View Create View character_set_client collation_connection
543
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
545
WHERE v1.id IN (SELECT id FROM t1_values
546
WHERE select_id = 176 OR select_id IS NULL) order by id;
550
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
551
my_varbinary_1000, my_varchar_1000 id FROM t1_values;
552
SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
553
my_varbinary_1000, my_varchar_1000 id FROM t1_values
554
WHERE select_id = 175 OR select_id IS NULL order by id;
556
View Create View character_set_client collation_connection
557
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
559
WHERE v1.id IN (SELECT id FROM t1_values
560
WHERE select_id = 175 OR select_id IS NULL) order by id;
564
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_char_30 ),
565
my_varbinary_1000, my_char_30 id FROM t1_values;
566
SELECT LOCATE(my_varbinary_1000, my_char_30 ),
567
my_varbinary_1000, my_char_30 id FROM t1_values
568
WHERE select_id = 174 OR select_id IS NULL order by id;
570
View Create View character_set_client collation_connection
571
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
573
WHERE v1.id IN (SELECT id FROM t1_values
574
WHERE select_id = 174 OR select_id IS NULL) order by id;
578
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
579
my_varbinary_1000, id FROM t1_values;
580
SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
581
my_varbinary_1000, id FROM t1_values
582
WHERE select_id = 173 OR select_id IS NULL order by id;
584
View Create View character_set_client collation_connection
585
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
587
WHERE v1.id IN (SELECT id FROM t1_values
588
WHERE select_id = 173 OR select_id IS NULL) order by id;
592
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
593
my_binary_30, my_varbinary_1000 id FROM t1_values;
594
SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
595
my_binary_30, my_varbinary_1000 id FROM t1_values
596
WHERE select_id = 172 OR select_id IS NULL order by id;
598
View Create View character_set_client collation_connection
599
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
601
WHERE v1.id IN (SELECT id FROM t1_values
602
WHERE select_id = 172 OR select_id IS NULL) order by id;
606
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_varchar_1000 ),
607
my_binary_30, my_varchar_1000 id FROM t1_values;
608
SELECT LOCATE(my_binary_30, my_varchar_1000 ),
609
my_binary_30, my_varchar_1000 id FROM t1_values
610
WHERE select_id = 171 OR select_id IS NULL order by id;
612
View Create View character_set_client collation_connection
613
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
615
WHERE v1.id IN (SELECT id FROM t1_values
616
WHERE select_id = 171 OR select_id IS NULL) order by id;
620
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_char_30 ),
621
my_binary_30, my_char_30 id FROM t1_values;
622
SELECT LOCATE(my_binary_30, my_char_30 ),
623
my_binary_30, my_char_30 id FROM t1_values
624
WHERE select_id = 170 OR select_id IS NULL order by id;
626
View Create View character_set_client collation_connection
627
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
629
WHERE v1.id IN (SELECT id FROM t1_values
630
WHERE select_id = 170 OR select_id IS NULL) order by id;
634
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_binary_30 ),
635
my_binary_30, id FROM t1_values;
636
SELECT LOCATE(my_binary_30, my_binary_30 ),
637
my_binary_30, id FROM t1_values
638
WHERE select_id = 169 OR select_id IS NULL order by id;
640
View Create View character_set_client collation_connection
641
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
643
WHERE v1.id IN (SELECT id FROM t1_values
644
WHERE select_id = 169 OR select_id IS NULL) order by id;
648
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
649
my_varchar_1000, my_varbinary_1000 id FROM t1_values;
650
SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
651
my_varchar_1000, my_varbinary_1000 id FROM t1_values
652
WHERE select_id = 168 OR select_id IS NULL order by id;
654
View Create View character_set_client collation_connection
655
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
657
WHERE v1.id IN (SELECT id FROM t1_values
658
WHERE select_id = 168 OR select_id IS NULL) order by id;
662
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_binary_30 ),
663
my_varchar_1000, my_binary_30 id FROM t1_values;
664
SELECT LOCATE(my_varchar_1000, my_binary_30 ),
665
my_varchar_1000, my_binary_30 id FROM t1_values
666
WHERE select_id = 167 OR select_id IS NULL order by id;
668
View Create View character_set_client collation_connection
669
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
671
WHERE v1.id IN (SELECT id FROM t1_values
672
WHERE select_id = 167 OR select_id IS NULL) order by id;
676
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_char_30 ),
677
my_varchar_1000, my_char_30 id FROM t1_values;
678
SELECT LOCATE(my_varchar_1000, my_char_30 ),
679
my_varchar_1000, my_char_30 id FROM t1_values
680
WHERE select_id = 166 OR select_id IS NULL order by id;
682
View Create View character_set_client collation_connection
683
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
685
WHERE v1.id IN (SELECT id FROM t1_values
686
WHERE select_id = 166 OR select_id IS NULL) order by id;
690
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
691
my_varchar_1000, id FROM t1_values;
692
SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
693
my_varchar_1000, id FROM t1_values
694
WHERE select_id = 165 OR select_id IS NULL order by id;
696
View Create View character_set_client collation_connection
697
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
699
WHERE v1.id IN (SELECT id FROM t1_values
700
WHERE select_id = 165 OR select_id IS NULL) order by id;
704
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_varbinary_1000 ),
705
my_char_30, my_varbinary_1000 id FROM t1_values;
706
SELECT LOCATE(my_char_30, my_varbinary_1000 ),
707
my_char_30, my_varbinary_1000 id FROM t1_values
708
WHERE select_id = 164 OR select_id IS NULL order by id;
710
View Create View character_set_client collation_connection
711
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
713
WHERE v1.id IN (SELECT id FROM t1_values
714
WHERE select_id = 164 OR select_id IS NULL) order by id;
718
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_binary_30 ),
719
my_char_30, my_binary_30 id FROM t1_values;
720
SELECT LOCATE(my_char_30, my_binary_30 ),
721
my_char_30, my_binary_30 id FROM t1_values
722
WHERE select_id = 163 OR select_id IS NULL order by id;
724
View Create View character_set_client collation_connection
725
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
727
WHERE v1.id IN (SELECT id FROM t1_values
728
WHERE select_id = 163 OR select_id IS NULL) order by id;
732
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_varchar_1000 ),
733
my_char_30, my_varchar_1000 id FROM t1_values;
734
SELECT LOCATE(my_char_30, my_varchar_1000 ),
735
my_char_30, my_varchar_1000 id FROM t1_values
736
WHERE select_id = 162 OR select_id IS NULL order by id;
738
View Create View character_set_client collation_connection
739
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
741
WHERE v1.id IN (SELECT id FROM t1_values
742
WHERE select_id = 162 OR select_id IS NULL) order by id;
746
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_char_30 ),
747
my_char_30, id FROM t1_values;
748
SELECT LOCATE(my_char_30, my_char_30 ),
749
my_char_30, id FROM t1_values
750
WHERE select_id = 161 OR select_id IS NULL order by id;
752
View Create View character_set_client collation_connection
753
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
755
WHERE v1.id IN (SELECT id FROM t1_values
756
WHERE select_id = 161 OR select_id IS NULL) order by id;
760
CREATE VIEW v1 AS SELECT LOCATE('char', my_varbinary_1000),
761
my_varbinary_1000, id FROM t1_values;
762
SELECT LOCATE('char', my_varbinary_1000),
763
my_varbinary_1000, id FROM t1_values
764
WHERE select_id = 160 OR select_id IS NULL order by id;
766
View Create View character_set_client collation_connection
767
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
769
WHERE v1.id IN (SELECT id FROM t1_values
770
WHERE select_id = 160 OR select_id IS NULL) order by id;
774
CREATE VIEW v1 AS SELECT LOCATE('char', my_binary_30),
775
my_binary_30, id FROM t1_values;
776
SELECT LOCATE('char', my_binary_30),
777
my_binary_30, id FROM t1_values
778
WHERE select_id = 159 OR select_id IS NULL order by id;
780
View Create View character_set_client collation_connection
781
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
783
WHERE v1.id IN (SELECT id FROM t1_values
784
WHERE select_id = 159 OR select_id IS NULL) order by id;
788
CREATE VIEW v1 AS SELECT LOCATE('char', my_varchar_1000),
789
my_varchar_1000, id FROM t1_values;
790
SELECT LOCATE('char', my_varchar_1000),
791
my_varchar_1000, id FROM t1_values
792
WHERE select_id = 158 OR select_id IS NULL order by id;
794
View Create View character_set_client collation_connection
795
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
797
WHERE v1.id IN (SELECT id FROM t1_values
798
WHERE select_id = 158 OR select_id IS NULL) order by id;
802
CREATE VIEW v1 AS SELECT LOCATE('char', my_char_30),
803
my_char_30, id FROM t1_values;
804
SELECT LOCATE('char', my_char_30),
805
my_char_30, id FROM t1_values
806
WHERE select_id = 157 OR select_id IS NULL order by id;
808
View Create View character_set_client collation_connection
809
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
811
WHERE v1.id IN (SELECT id FROM t1_values
812
WHERE select_id = 157 OR select_id IS NULL) order by id;
816
CREATE VIEW v1 AS SELECT LOAD_FILE('<MYSQLTEST_VARDIR>/std_data/funcs_1/load_file.txt')
819
SELECT LOAD_FILE('<MYSQLTEST_VARDIR>/std_data/funcs_1/load_file.txt')
822
WHERE select_id = 156 OR select_id IS NULL order by id;
824
Here is content from load_file
826
Here is content from load_file
828
Here is content from load_file
830
Here is content from load_file
832
Here is content from load_file
835
View Create View character_set_client collation_connection
836
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select load_file('<MYSQLTEST_VARDIR>/std_data/funcs_1/load_file.txt') AS `my_col`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
838
WHERE v1.id IN (SELECT id FROM t1_values
839
WHERE select_id = 156 OR select_id IS NULL) order by id;
841
Here is content from load_file
843
Here is content from load_file
845
Here is content from load_file
847
Here is content from load_file
849
Here is content from load_file
854
CREATE VIEW v1 AS SELECT LENGTH(my_varbinary_1000),
855
my_varbinary_1000, id FROM t1_values;
856
SELECT LENGTH(my_varbinary_1000),
857
my_varbinary_1000, id FROM t1_values
858
WHERE select_id = 155 OR select_id IS NULL order by id;
860
View Create View character_set_client collation_connection
861
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
863
WHERE v1.id IN (SELECT id FROM t1_values
864
WHERE select_id = 155 OR select_id IS NULL) order by id;
868
CREATE VIEW v1 AS SELECT LENGTH(my_binary_30),
869
my_binary_30, id FROM t1_values;
870
SELECT LENGTH(my_binary_30),
871
my_binary_30, id FROM t1_values
872
WHERE select_id = 154 OR select_id IS NULL order by id;
874
View Create View character_set_client collation_connection
875
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
877
WHERE v1.id IN (SELECT id FROM t1_values
878
WHERE select_id = 154 OR select_id IS NULL) order by id;
882
CREATE VIEW v1 AS SELECT LENGTH(my_varchar_1000),
883
my_varchar_1000, id FROM t1_values;
884
SELECT LENGTH(my_varchar_1000),
885
my_varchar_1000, id FROM t1_values
886
WHERE select_id = 153 OR select_id IS NULL order by id;
888
View Create View character_set_client collation_connection
889
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
891
WHERE v1.id IN (SELECT id FROM t1_values
892
WHERE select_id = 153 OR select_id IS NULL) order by id;
896
CREATE VIEW v1 AS SELECT LENGTH(my_char_30),
897
my_char_30, id FROM t1_values;
898
SELECT LENGTH(my_char_30),
899
my_char_30, id FROM t1_values
900
WHERE select_id = 152 OR select_id IS NULL order by id;
902
View Create View character_set_client collation_connection
903
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
905
WHERE v1.id IN (SELECT id FROM t1_values
906
WHERE select_id = 152 OR select_id IS NULL) order by id;
910
CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double), my_double, id FROM t1_values;
911
SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double), my_double, id FROM t1_values
912
WHERE select_id = 151 OR select_id IS NULL order by id;
913
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double) my_double id
915
-1.7976931348623e308 2
916
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 1.7976931348623e308 3
920
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
921
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
923
View Create View character_set_client collation_connection
924
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
926
WHERE v1.id IN (SELECT id FROM t1_values
927
WHERE select_id = 151 OR select_id IS NULL) order by id;
928
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double) my_double id
930
-1.7976931348623e308 2
931
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 1.7976931348623e308 3
935
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
936
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
940
CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal), my_decimal, id FROM t1_values;
941
SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal), my_decimal, id FROM t1_values
942
WHERE select_id = 150 OR select_id IS NULL order by id;
943
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal) my_decimal id
945
-9999999999999999999999999999999999.999999999999999999999999999999 2
946
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9999999999999999999999999999999999.999999999999999999999999999999 3
947
0.000000000000000000000000000000 4
948
-1.000000000000000000000000000000 5
950
Warning 1292 Truncated incorrect DECIMAL value: ''
951
Warning 1292 Truncated incorrect DECIMAL value: ''
953
View Create View character_set_client collation_connection
954
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
956
WHERE v1.id IN (SELECT id FROM t1_values
957
WHERE select_id = 150 OR select_id IS NULL) order by id;
958
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal) my_decimal id
960
-9999999999999999999999999999999999.999999999999999999999999999999 2
961
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9999999999999999999999999999999999.999999999999999999999999999999 3
962
0.000000000000000000000000000000 4
963
-1.000000000000000000000000000000 5
965
Warning 1292 Truncated incorrect DECIMAL value: ''
966
Warning 1292 Truncated incorrect DECIMAL value: ''
970
CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint), my_bigint, id FROM t1_values;
971
SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint), my_bigint, id FROM t1_values
972
WHERE select_id = 149 OR select_id IS NULL order by id;
973
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint) my_bigint id
975
-9223372036854775808 2
976
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9223372036854775807 3
980
View Create View character_set_client collation_connection
981
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
983
WHERE v1.id IN (SELECT id FROM t1_values
984
WHERE select_id = 149 OR select_id IS NULL) order by id;
985
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint) my_bigint id
987
-9223372036854775808 2
988
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9223372036854775807 3
994
CREATE VIEW v1 AS SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values;
995
SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values
996
WHERE select_id = 148 OR select_id IS NULL order by id;
997
LEFT(my_varbinary_1000, 2) my_varbinary_1000 id
1000
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1003
SHOW CREATE VIEW v1;
1004
View Create View character_set_client collation_connection
1005
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
1007
WHERE v1.id IN (SELECT id FROM t1_values
1008
WHERE select_id = 148 OR select_id IS NULL) order by id;
1009
LEFT(my_varbinary_1000, 2) my_varbinary_1000 id
1012
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1018
CREATE VIEW v1 AS SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values;
1019
SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values
1020
WHERE select_id = 147 OR select_id IS NULL order by id;
1021
LEFT(my_binary_30, 2) my_binary_30 id
1024
<- <--------30 characters-------> 3
1027
SHOW CREATE VIEW v1;
1028
View Create View character_set_client collation_connection
1029
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
1031
WHERE v1.id IN (SELECT id FROM t1_values
1032
WHERE select_id = 147 OR select_id IS NULL) order by id;
1033
LEFT(my_binary_30, 2) my_binary_30 id
1036
<- <--------30 characters-------> 3
1042
CREATE VIEW v1 AS SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values;
1043
SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values
1044
WHERE select_id = 146 OR select_id IS NULL order by id;
1045
LEFT(my_varchar_1000, 2) my_varchar_1000 id
1048
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1051
SHOW CREATE VIEW v1;
1052
View Create View character_set_client collation_connection
1053
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
1055
WHERE v1.id IN (SELECT id FROM t1_values
1056
WHERE select_id = 146 OR select_id IS NULL) order by id;
1057
LEFT(my_varchar_1000, 2) my_varchar_1000 id
1060
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1066
CREATE VIEW v1 AS SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values;
1067
SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values
1068
WHERE select_id = 145 OR select_id IS NULL order by id;
1069
LEFT(my_char_30, 2) my_char_30 id
1072
<- <--------30 characters-------> 3
1075
SHOW CREATE VIEW v1;
1076
View Create View character_set_client collation_connection
1077
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
1079
WHERE v1.id IN (SELECT id FROM t1_values
1080
WHERE select_id = 145 OR select_id IS NULL) order by id;
1081
LEFT(my_char_30, 2) my_char_30 id
1084
<- <--------30 characters-------> 3
1090
CREATE VIEW v1 AS SELECT LCASE(my_varchar_1000),
1091
my_varchar_1000, id FROM t1_values;
1092
SELECT LCASE(my_varchar_1000),
1093
my_varchar_1000, id FROM t1_values
1094
WHERE select_id = 144 OR select_id IS NULL order by id;
1095
SHOW CREATE VIEW v1;
1096
View Create View character_set_client collation_connection
1097
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
1099
WHERE v1.id IN (SELECT id FROM t1_values
1100
WHERE select_id = 144 OR select_id IS NULL) order by id;
1104
CREATE VIEW v1 AS SELECT INSTR(my_char_30, 'char'),
1105
my_char_30, id FROM t1_values;
1106
SELECT INSTR(my_char_30, 'char'),
1107
my_char_30, id FROM t1_values
1108
WHERE select_id = 143 OR select_id IS NULL order by id;
1109
SHOW CREATE VIEW v1;
1110
View Create View character_set_client collation_connection
1111
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
1113
WHERE v1.id IN (SELECT id FROM t1_values
1114
WHERE select_id = 143 OR select_id IS NULL) order by id;
1118
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_varbinary_1000),
1119
my_varbinary_1000, id FROM t1_values;
1120
SELECT BIT_LENGTH(my_varbinary_1000),
1121
my_varbinary_1000, id FROM t1_values
1122
WHERE select_id = 142 OR select_id IS NULL order by id;
1123
BIT_LENGTH(my_varbinary_1000) my_varbinary_1000 id
1126
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1129
SHOW CREATE VIEW v1;
1130
View Create View character_set_client collation_connection
1131
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
1133
WHERE v1.id IN (SELECT id FROM t1_values
1134
WHERE select_id = 142 OR select_id IS NULL) order by id;
1135
BIT_LENGTH(my_varbinary_1000) my_varbinary_1000 id
1138
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1144
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_binary_30),
1145
my_binary_30, id FROM t1_values;
1146
SELECT BIT_LENGTH(my_binary_30),
1147
my_binary_30, id FROM t1_values
1148
WHERE select_id = 141 OR select_id IS NULL order by id;
1149
BIT_LENGTH(my_binary_30) my_binary_30 id
1152
240 <--------30 characters-------> 3
1155
SHOW CREATE VIEW v1;
1156
View Create View character_set_client collation_connection
1157
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
1159
WHERE v1.id IN (SELECT id FROM t1_values
1160
WHERE select_id = 141 OR select_id IS NULL) order by id;
1161
BIT_LENGTH(my_binary_30) my_binary_30 id
1164
240 <--------30 characters-------> 3
1170
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_varchar_1000),
1171
my_varchar_1000, id FROM t1_values;
1172
SELECT BIT_LENGTH(my_varchar_1000),
1173
my_varchar_1000, id FROM t1_values
1174
WHERE select_id = 140 OR select_id IS NULL order by id;
1175
BIT_LENGTH(my_varchar_1000) my_varchar_1000 id
1178
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1181
SHOW CREATE VIEW v1;
1182
View Create View character_set_client collation_connection
1183
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
1185
WHERE v1.id IN (SELECT id FROM t1_values
1186
WHERE select_id = 140 OR select_id IS NULL) order by id;
1187
BIT_LENGTH(my_varchar_1000) my_varchar_1000 id
1190
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1196
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_char_30),
1197
my_char_30, id FROM t1_values;
1198
SELECT BIT_LENGTH(my_char_30),
1199
my_char_30, id FROM t1_values
1200
WHERE select_id = 139 OR select_id IS NULL order by id;
1201
BIT_LENGTH(my_char_30) my_char_30 id
1204
240 <--------30 characters-------> 3
1207
SHOW CREATE VIEW v1;
1208
View Create View character_set_client collation_connection
1209
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
1211
WHERE v1.id IN (SELECT id FROM t1_values
1212
WHERE select_id = 139 OR select_id IS NULL) order by id;
1213
BIT_LENGTH(my_char_30) my_char_30 id
1216
240 <--------30 characters-------> 3
1222
CREATE VIEW v1 AS SELECT IFNULL(my_year,'IS_NULL'),
1223
my_year, id FROM t1_values;
1224
SELECT IFNULL(my_year,'IS_NULL'),
1225
my_year, id FROM t1_values
1226
WHERE select_id = 138 OR select_id IS NULL order by id;
1227
IFNULL(my_year,'IS_NULL') my_year id
1233
SHOW CREATE VIEW v1;
1234
View Create View character_set_client collation_connection
1235
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
1237
WHERE v1.id IN (SELECT id FROM t1_values
1238
WHERE select_id = 138 OR select_id IS NULL) order by id;
1239
IFNULL(my_year,'IS_NULL') my_year id
1248
CREATE VIEW v1 AS SELECT IFNULL(my_time,'IS_NULL'),
1249
my_time, id FROM t1_values;
1250
SELECT IFNULL(my_time,'IS_NULL'),
1251
my_time, id FROM t1_values
1252
WHERE select_id = 137 OR select_id IS NULL order by id;
1253
IFNULL(my_time,'IS_NULL') my_time id
1255
-838:59:59 -838:59:59 2
1256
838:59:59 838:59:59 3
1259
SHOW CREATE VIEW v1;
1260
View Create View character_set_client collation_connection
1261
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
1263
WHERE v1.id IN (SELECT id FROM t1_values
1264
WHERE select_id = 137 OR select_id IS NULL) order by id;
1265
IFNULL(my_time,'IS_NULL') my_time id
1267
-838:59:59 -838:59:59 2
1268
838:59:59 838:59:59 3
1274
CREATE VIEW v1 AS SELECT IFNULL(my_timestamp,'IS_NULL'),
1275
my_timestamp, id FROM t1_values;
1276
SELECT IFNULL(my_timestamp,'IS_NULL'),
1277
my_timestamp, id FROM t1_values
1278
WHERE select_id = 136 OR select_id IS NULL order by id;
1279
IFNULL(my_timestamp,'IS_NULL') my_timestamp id
1280
0000-00-00 00:00:00 0000-00-00 00:00:00 1
1281
1970-01-01 03:00:01 1970-01-01 03:00:01 2
1282
2038-01-01 02:59:59 2038-01-01 02:59:59 3
1283
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1284
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1285
SHOW CREATE VIEW v1;
1286
View Create View character_set_client collation_connection
1287
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
1289
WHERE v1.id IN (SELECT id FROM t1_values
1290
WHERE select_id = 136 OR select_id IS NULL) order by id;
1291
IFNULL(my_timestamp,'IS_NULL') my_timestamp id
1292
0000-00-00 00:00:00 0000-00-00 00:00:00 1
1293
1970-01-01 03:00:01 1970-01-01 03:00:01 2
1294
2038-01-01 02:59:59 2038-01-01 02:59:59 3
1295
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1296
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1300
CREATE VIEW v1 AS SELECT IFNULL(my_date,'IS_NULL'),
1301
my_date, id FROM t1_values;
1302
SELECT IFNULL(my_date,'IS_NULL'),
1303
my_date, id FROM t1_values
1304
WHERE select_id = 135 OR select_id IS NULL order by id;
1305
IFNULL(my_date,'IS_NULL') my_date id
1307
0001-01-01 0001-01-01 2
1308
9999-12-31 9999-12-31 3
1309
2004-02-29 2004-02-29 4
1310
2005-06-28 2005-06-28 5
1311
SHOW CREATE VIEW v1;
1312
View Create View character_set_client collation_connection
1313
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
1315
WHERE v1.id IN (SELECT id FROM t1_values
1316
WHERE select_id = 135 OR select_id IS NULL) order by id;
1317
IFNULL(my_date,'IS_NULL') my_date id
1319
0001-01-01 0001-01-01 2
1320
9999-12-31 9999-12-31 3
1321
2004-02-29 2004-02-29 4
1322
2005-06-28 2005-06-28 5
1326
CREATE VIEW v1 AS SELECT IFNULL(my_datetime,'IS_NULL'),
1327
my_datetime, id FROM t1_values;
1328
SELECT IFNULL(my_datetime,'IS_NULL'),
1329
my_datetime, id FROM t1_values
1330
WHERE select_id = 134 OR select_id IS NULL order by id;
1331
IFNULL(my_datetime,'IS_NULL') my_datetime id
1333
0001-01-01 00:00:00 0001-01-01 00:00:00 2
1334
9999-12-31 23:59:59 9999-12-31 23:59:59 3
1335
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1336
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1337
SHOW CREATE VIEW v1;
1338
View Create View character_set_client collation_connection
1339
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
1341
WHERE v1.id IN (SELECT id FROM t1_values
1342
WHERE select_id = 134 OR select_id IS NULL) order by id;
1343
IFNULL(my_datetime,'IS_NULL') my_datetime id
1345
0001-01-01 00:00:00 0001-01-01 00:00:00 2
1346
9999-12-31 23:59:59 9999-12-31 23:59:59 3
1347
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1348
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1352
CREATE VIEW v1 AS SELECT IFNULL(my_double,'IS_NULL'),
1353
my_double, id FROM t1_values;
1354
SELECT IFNULL(my_double,'IS_NULL'),
1355
my_double, id FROM t1_values
1356
WHERE select_id = 133 OR select_id IS NULL order by id;
1357
IFNULL(my_double,'IS_NULL') my_double id
1359
-1.7976931348623e308 -1.7976931348623e308 2
1360
1.7976931348623e308 1.7976931348623e308 3
1363
SHOW CREATE VIEW v1;
1364
View Create View character_set_client collation_connection
1365
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
1367
WHERE v1.id IN (SELECT id FROM t1_values
1368
WHERE select_id = 133 OR select_id IS NULL) order by id;
1369
IFNULL(my_double,'IS_NULL') my_double id
1371
-1.7976931348623e308 -1.7976931348623e308 2
1372
1.7976931348623e308 1.7976931348623e308 3
1378
CREATE VIEW v1 AS SELECT IFNULL(my_decimal,'IS_NULL'),
1379
my_decimal, id FROM t1_values;
1380
SELECT IFNULL(my_decimal,'IS_NULL'),
1381
my_decimal, id FROM t1_values
1382
WHERE select_id = 132 OR select_id IS NULL order by id;
1383
IFNULL(my_decimal,'IS_NULL') my_decimal id
1385
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
1386
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
1387
0.000000000000000000000000000000 0.000000000000000000000000000000 4
1388
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
1389
SHOW CREATE VIEW v1;
1390
View Create View character_set_client collation_connection
1391
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
1393
WHERE v1.id IN (SELECT id FROM t1_values
1394
WHERE select_id = 132 OR select_id IS NULL) order by id;
1395
IFNULL(my_decimal,'IS_NULL') my_decimal id
1397
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
1398
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
1399
0.000000000000000000000000000000 0.000000000000000000000000000000 4
1400
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
1404
CREATE VIEW v1 AS SELECT IFNULL(my_bigint,'IS_NULL'),
1405
my_bigint, id FROM t1_values;
1406
SELECT IFNULL(my_bigint,'IS_NULL'),
1407
my_bigint, id FROM t1_values
1408
WHERE select_id = 131 OR select_id IS NULL order by id;
1409
IFNULL(my_bigint,'IS_NULL') my_bigint id
1411
-9223372036854775808 -9223372036854775808 2
1412
9223372036854775807 9223372036854775807 3
1415
SHOW CREATE VIEW v1;
1416
View Create View character_set_client collation_connection
1417
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
1419
WHERE v1.id IN (SELECT id FROM t1_values
1420
WHERE select_id = 131 OR select_id IS NULL) order by id;
1421
IFNULL(my_bigint,'IS_NULL') my_bigint id
1423
-9223372036854775808 -9223372036854775808 2
1424
9223372036854775807 9223372036854775807 3
1430
CREATE VIEW v1 AS SELECT IFNULL(my_varbinary_1000,'IS_NULL'),
1431
my_varbinary_1000, id FROM t1_values;
1432
SELECT IFNULL(my_varbinary_1000,'IS_NULL'),
1433
my_varbinary_1000, id FROM t1_values
1434
WHERE select_id = 130 OR select_id IS NULL order by id;
1435
IFNULL(my_varbinary_1000,'IS_NULL') my_varbinary_1000 id
1438
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1439
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1441
SHOW CREATE VIEW v1;
1442
View Create View character_set_client collation_connection
1443
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
1445
WHERE v1.id IN (SELECT id FROM t1_values
1446
WHERE select_id = 130 OR select_id IS NULL) order by id;
1447
IFNULL(my_varbinary_1000,'IS_NULL') my_varbinary_1000 id
1450
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1451
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1456
CREATE VIEW v1 AS SELECT IFNULL(my_binary_30,'IS_NULL'),
1457
my_binary_30, id FROM t1_values;
1458
SELECT IFNULL(my_binary_30,'IS_NULL'),
1459
my_binary_30, id FROM t1_values
1460
WHERE select_id = 129 OR select_id IS NULL order by id;
1461
IFNULL(my_binary_30,'IS_NULL') my_binary_30 id
1464
<--------30 characters-------> <--------30 characters-------> 3
1465
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1467
SHOW CREATE VIEW v1;
1468
View Create View character_set_client collation_connection
1469
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
1471
WHERE v1.id IN (SELECT id FROM t1_values
1472
WHERE select_id = 129 OR select_id IS NULL) order by id;
1473
IFNULL(my_binary_30,'IS_NULL') my_binary_30 id
1476
<--------30 characters-------> <--------30 characters-------> 3
1477
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1482
CREATE VIEW v1 AS SELECT IFNULL(my_varchar_1000,'IS_NULL'),
1483
my_varchar_1000, id FROM t1_values;
1484
SELECT IFNULL(my_varchar_1000,'IS_NULL'),
1485
my_varchar_1000, id FROM t1_values
1486
WHERE select_id = 128 OR select_id IS NULL order by id;
1487
IFNULL(my_varchar_1000,'IS_NULL') my_varchar_1000 id
1490
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1491
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1493
SHOW CREATE VIEW v1;
1494
View Create View character_set_client collation_connection
1495
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
1497
WHERE v1.id IN (SELECT id FROM t1_values
1498
WHERE select_id = 128 OR select_id IS NULL) order by id;
1499
IFNULL(my_varchar_1000,'IS_NULL') my_varchar_1000 id
1502
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1503
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1508
CREATE VIEW v1 AS SELECT IFNULL(my_char_30,'IS_NULL'),
1509
my_char_30, id FROM t1_values;
1510
SELECT IFNULL(my_char_30,'IS_NULL'),
1511
my_char_30, id FROM t1_values
1512
WHERE select_id = 127 OR select_id IS NULL order by id;
1513
IFNULL(my_char_30,'IS_NULL') my_char_30 id
1516
<--------30 characters-------> <--------30 characters-------> 3
1517
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1519
SHOW CREATE VIEW v1;
1520
View Create View character_set_client collation_connection
1521
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
1523
WHERE v1.id IN (SELECT id FROM t1_values
1524
WHERE select_id = 127 OR select_id IS NULL) order by id;
1525
IFNULL(my_char_30,'IS_NULL') my_char_30 id
1528
<--------30 characters-------> <--------30 characters-------> 3
1529
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1534
CREATE VIEW v1 AS SELECT IF(my_year IS NULL, 'IS NULL',
1535
'IS NOT NULL'), my_year, id FROM t1_values;
1536
SELECT IF(my_year IS NULL, 'IS NULL',
1537
'IS NOT NULL'), my_year, id FROM t1_values
1538
WHERE select_id = 126 OR select_id IS NULL order by id;
1539
IF(my_year IS NULL, 'IS NULL',
1540
'IS NOT NULL') my_year id
1546
SHOW CREATE VIEW v1;
1547
View Create View character_set_client collation_connection
1548
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',
1549
'IS NOT NULL')`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1551
WHERE v1.id IN (SELECT id FROM t1_values
1552
WHERE select_id = 126 OR select_id IS NULL) order by id;
1553
IF(my_year IS NULL, 'IS NULL',
1554
'IS NOT NULL') my_year id
1563
CREATE VIEW v1 AS SELECT IF(my_time IS NULL, 'IS NULL',
1564
'IS NOT NULL'), my_time, id FROM t1_values;
1565
SELECT IF(my_time IS NULL, 'IS NULL',
1566
'IS NOT NULL'), my_time, id FROM t1_values
1567
WHERE select_id = 125 OR select_id IS NULL order by id;
1568
IF(my_time IS NULL, 'IS NULL',
1569
'IS NOT NULL') my_time id
1571
IS NOT NULL -838:59:59 2
1572
IS NOT NULL 838:59:59 3
1573
IS NOT NULL 13:00:00 4
1574
IS NOT NULL 10:00:00 5
1575
SHOW CREATE VIEW v1;
1576
View Create View character_set_client collation_connection
1577
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',
1578
'IS NOT NULL')`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1580
WHERE v1.id IN (SELECT id FROM t1_values
1581
WHERE select_id = 125 OR select_id IS NULL) order by id;
1582
IF(my_time IS NULL, 'IS NULL',
1583
'IS NOT NULL') my_time id
1585
IS NOT NULL -838:59:59 2
1586
IS NOT NULL 838:59:59 3
1587
IS NOT NULL 13:00:00 4
1588
IS NOT NULL 10:00:00 5
1592
CREATE VIEW v1 AS SELECT IF(my_timestamp IS NULL, 'IS NULL',
1593
'IS NOT NULL'), my_timestamp, id FROM t1_values;
1594
SELECT IF(my_timestamp IS NULL, 'IS NULL',
1595
'IS NOT NULL'), my_timestamp, id FROM t1_values
1596
WHERE select_id = 124 OR select_id IS NULL order by id;
1597
IF(my_timestamp IS NULL, 'IS NULL',
1598
'IS NOT NULL') my_timestamp id
1599
IS NOT NULL 0000-00-00 00:00:00 1
1600
IS NOT NULL 1970-01-01 03:00:01 2
1601
IS NOT NULL 2038-01-01 02:59:59 3
1602
IS NOT NULL 2004-02-29 23:59:59 4
1603
IS NOT NULL 2005-06-28 10:00:00 5
1604
SHOW CREATE VIEW v1;
1605
View Create View character_set_client collation_connection
1606
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',
1607
'IS NOT NULL')`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1609
WHERE v1.id IN (SELECT id FROM t1_values
1610
WHERE select_id = 124 OR select_id IS NULL) order by id;
1611
IF(my_timestamp IS NULL, 'IS NULL',
1612
'IS NOT NULL') my_timestamp id
1613
IS NOT NULL 0000-00-00 00:00:00 1
1614
IS NOT NULL 1970-01-01 03:00:01 2
1615
IS NOT NULL 2038-01-01 02:59:59 3
1616
IS NOT NULL 2004-02-29 23:59:59 4
1617
IS NOT NULL 2005-06-28 10:00:00 5
1621
CREATE VIEW v1 AS SELECT IF(my_date IS NULL, 'IS NULL',
1622
'IS NOT NULL'), my_date, id FROM t1_values;
1623
SELECT IF(my_date IS NULL, 'IS NULL',
1624
'IS NOT NULL'), my_date, id FROM t1_values
1625
WHERE select_id = 123 OR select_id IS NULL order by id;
1626
IF(my_date IS NULL, 'IS NULL',
1627
'IS NOT NULL') my_date id
1629
IS NOT NULL 0001-01-01 2
1630
IS NOT NULL 9999-12-31 3
1631
IS NOT NULL 2004-02-29 4
1632
IS NOT NULL 2005-06-28 5
1633
SHOW CREATE VIEW v1;
1634
View Create View character_set_client collation_connection
1635
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',
1636
'IS NOT NULL')`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1638
WHERE v1.id IN (SELECT id FROM t1_values
1639
WHERE select_id = 123 OR select_id IS NULL) order by id;
1640
IF(my_date IS NULL, 'IS NULL',
1641
'IS NOT NULL') my_date id
1643
IS NOT NULL 0001-01-01 2
1644
IS NOT NULL 9999-12-31 3
1645
IS NOT NULL 2004-02-29 4
1646
IS NOT NULL 2005-06-28 5
1650
CREATE VIEW v1 AS SELECT IF(my_datetime IS NULL, 'IS NULL',
1651
'IS NOT NULL'), my_datetime, id FROM t1_values;
1652
SELECT IF(my_datetime IS NULL, 'IS NULL',
1653
'IS NOT NULL'), my_datetime, id FROM t1_values
1654
WHERE select_id = 122 OR select_id IS NULL order by id;
1655
IF(my_datetime IS NULL, 'IS NULL',
1656
'IS NOT NULL') my_datetime id
1658
IS NOT NULL 0001-01-01 00:00:00 2
1659
IS NOT NULL 9999-12-31 23:59:59 3
1660
IS NOT NULL 2004-02-29 23:59:59 4
1661
IS NOT NULL 2005-06-28 10:00:00 5
1662
SHOW CREATE VIEW v1;
1663
View Create View character_set_client collation_connection
1664
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',
1665
'IS NOT NULL')`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1667
WHERE v1.id IN (SELECT id FROM t1_values
1668
WHERE select_id = 122 OR select_id IS NULL) order by id;
1669
IF(my_datetime IS NULL, 'IS NULL',
1670
'IS NOT NULL') my_datetime id
1672
IS NOT NULL 0001-01-01 00:00:00 2
1673
IS NOT NULL 9999-12-31 23:59:59 3
1674
IS NOT NULL 2004-02-29 23:59:59 4
1675
IS NOT NULL 2005-06-28 10:00:00 5
1679
CREATE VIEW v1 AS SELECT IF(my_double IS NULL, 'IS NULL',
1680
'IS NOT NULL'), my_double, id FROM t1_values;
1681
SELECT IF(my_double IS NULL, 'IS NULL',
1682
'IS NOT NULL'), my_double, id FROM t1_values
1683
WHERE select_id = 121 OR select_id IS NULL order by id;
1684
IF(my_double IS NULL, 'IS NULL',
1685
'IS NOT NULL') my_double id
1687
IS NOT NULL -1.7976931348623e308 2
1688
IS NOT NULL 1.7976931348623e308 3
1691
SHOW CREATE VIEW v1;
1692
View Create View character_set_client collation_connection
1693
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',
1694
'IS NOT NULL')`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1696
WHERE v1.id IN (SELECT id FROM t1_values
1697
WHERE select_id = 121 OR select_id IS NULL) order by id;
1698
IF(my_double IS NULL, 'IS NULL',
1699
'IS NOT NULL') my_double id
1701
IS NOT NULL -1.7976931348623e308 2
1702
IS NOT NULL 1.7976931348623e308 3
1708
CREATE VIEW v1 AS SELECT IF(my_decimal IS NULL, 'IS NULL',
1709
'IS NOT NULL'), my_decimal, id FROM t1_values;
1710
SELECT IF(my_decimal IS NULL, 'IS NULL',
1711
'IS NOT NULL'), my_decimal, id FROM t1_values
1712
WHERE select_id = 120 OR select_id IS NULL order by id;
1713
IF(my_decimal IS NULL, 'IS NULL',
1714
'IS NOT NULL') my_decimal id
1716
IS NOT NULL -9999999999999999999999999999999999.999999999999999999999999999999 2
1717
IS NOT NULL 9999999999999999999999999999999999.999999999999999999999999999999 3
1718
IS NOT NULL 0.000000000000000000000000000000 4
1719
IS NOT NULL -1.000000000000000000000000000000 5
1720
SHOW CREATE VIEW v1;
1721
View Create View character_set_client collation_connection
1722
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',
1723
'IS NOT NULL')`,`t1_values`.`my_decimal` AS `my_decimal`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1725
WHERE v1.id IN (SELECT id FROM t1_values
1726
WHERE select_id = 120 OR select_id IS NULL) order by id;
1727
IF(my_decimal IS NULL, 'IS NULL',
1728
'IS NOT NULL') my_decimal id
1730
IS NOT NULL -9999999999999999999999999999999999.999999999999999999999999999999 2
1731
IS NOT NULL 9999999999999999999999999999999999.999999999999999999999999999999 3
1732
IS NOT NULL 0.000000000000000000000000000000 4
1733
IS NOT NULL -1.000000000000000000000000000000 5
1737
CREATE VIEW v1 AS SELECT IF(my_bigint IS NULL, 'IS NULL',
1738
'IS NOT NULL'), my_bigint, id FROM t1_values;
1739
SELECT IF(my_bigint IS NULL, 'IS NULL',
1740
'IS NOT NULL'), my_bigint, id FROM t1_values
1741
WHERE select_id = 119 OR select_id IS NULL order by id;
1742
IF(my_bigint IS NULL, 'IS NULL',
1743
'IS NOT NULL') my_bigint id
1745
IS NOT NULL -9223372036854775808 2
1746
IS NOT NULL 9223372036854775807 3
1749
SHOW CREATE VIEW v1;
1750
View Create View character_set_client collation_connection
1751
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',
1752
'IS NOT NULL')`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1754
WHERE v1.id IN (SELECT id FROM t1_values
1755
WHERE select_id = 119 OR select_id IS NULL) order by id;
1756
IF(my_bigint IS NULL, 'IS NULL',
1757
'IS NOT NULL') my_bigint id
1759
IS NOT NULL -9223372036854775808 2
1760
IS NOT NULL 9223372036854775807 3
1766
CREATE VIEW v1 AS SELECT IF(my_varbinary_1000 IS NULL, 'IS NULL',
1767
'IS NOT NULL'), my_varbinary_1000, id FROM t1_values;
1768
SELECT IF(my_varbinary_1000 IS NULL, 'IS NULL',
1769
'IS NOT NULL'), my_varbinary_1000, id FROM t1_values
1770
WHERE select_id = 118 OR select_id IS NULL order by id;
1771
IF(my_varbinary_1000 IS NULL, 'IS NULL',
1772
'IS NOT NULL') my_varbinary_1000 id
1775
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1776
IS NOT NULL ---äÖüß@µ*$-- 4
1778
SHOW CREATE VIEW v1;
1779
View Create View character_set_client collation_connection
1780
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',
1781
'IS NOT NULL')`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1783
WHERE v1.id IN (SELECT id FROM t1_values
1784
WHERE select_id = 118 OR select_id IS NULL) order by id;
1785
IF(my_varbinary_1000 IS NULL, 'IS NULL',
1786
'IS NOT NULL') my_varbinary_1000 id
1789
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1790
IS NOT NULL ---äÖüß@µ*$-- 4
1795
CREATE VIEW v1 AS SELECT IF(my_binary_30 IS NULL, 'IS NULL',
1796
'IS NOT NULL'), my_binary_30, id FROM t1_values;
1797
SELECT IF(my_binary_30 IS NULL, 'IS NULL',
1798
'IS NOT NULL'), my_binary_30, id FROM t1_values
1799
WHERE select_id = 117 OR select_id IS NULL order by id;
1800
IF(my_binary_30 IS NULL, 'IS NULL',
1801
'IS NOT NULL') my_binary_30 id
1804
IS NOT NULL <--------30 characters-------> 3
1805
IS NOT NULL ---äÖüß@µ*$-- 4
1807
SHOW CREATE VIEW v1;
1808
View Create View character_set_client collation_connection
1809
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',
1810
'IS NOT NULL')`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1812
WHERE v1.id IN (SELECT id FROM t1_values
1813
WHERE select_id = 117 OR select_id IS NULL) order by id;
1814
IF(my_binary_30 IS NULL, 'IS NULL',
1815
'IS NOT NULL') my_binary_30 id
1818
IS NOT NULL <--------30 characters-------> 3
1819
IS NOT NULL ---äÖüß@µ*$-- 4
1824
CREATE VIEW v1 AS SELECT IF(my_varchar_1000 IS NULL, 'IS NULL',
1825
'IS NOT NULL'), my_varchar_1000, id FROM t1_values;
1826
SELECT IF(my_varchar_1000 IS NULL, 'IS NULL',
1827
'IS NOT NULL'), my_varchar_1000, id FROM t1_values
1828
WHERE select_id = 116 OR select_id IS NULL order by id;
1829
IF(my_varchar_1000 IS NULL, 'IS NULL',
1830
'IS NOT NULL') my_varchar_1000 id
1833
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1834
IS NOT NULL ---äÖüß@µ*$-- 4
1836
SHOW CREATE VIEW v1;
1837
View Create View character_set_client collation_connection
1838
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',
1839
'IS NOT NULL')`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1841
WHERE v1.id IN (SELECT id FROM t1_values
1842
WHERE select_id = 116 OR select_id IS NULL) order by id;
1843
IF(my_varchar_1000 IS NULL, 'IS NULL',
1844
'IS NOT NULL') my_varchar_1000 id
1847
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1848
IS NOT NULL ---äÖüß@µ*$-- 4
1853
CREATE VIEW v1 AS SELECT IF(my_char_30 IS NULL, 'IS NULL',
1854
'IS NOT NULL'), my_char_30, id FROM t1_values;
1855
SELECT IF(my_char_30 IS NULL, 'IS NULL',
1856
'IS NOT NULL'), my_char_30, id FROM t1_values
1857
WHERE select_id = 115 OR select_id IS NULL order by id;
1858
IF(my_char_30 IS NULL, 'IS NULL',
1859
'IS NOT NULL') my_char_30 id
1862
IS NOT NULL <--------30 characters-------> 3
1863
IS NOT NULL ---äÖüß@µ*$-- 4
1865
SHOW CREATE VIEW v1;
1866
View Create View character_set_client collation_connection
1867
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',
1868
'IS NOT NULL')`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1870
WHERE v1.id IN (SELECT id FROM t1_values
1871
WHERE select_id = 115 OR select_id IS NULL) order by id;
1872
IF(my_char_30 IS NULL, 'IS NULL',
1873
'IS NOT NULL') my_char_30 id
1876
IS NOT NULL <--------30 characters-------> 3
1877
IS NOT NULL ---äÖüß@µ*$-- 4
1882
CREATE VIEW v1 AS SELECT IF(my_year, 'IS TRUE', 'IS NOT TRUE'),
1883
my_year, id FROM t1_values;
1884
SELECT IF(my_year, 'IS TRUE', 'IS NOT TRUE'),
1885
my_year, id FROM t1_values
1886
WHERE select_id = 114 OR select_id IS NULL order by id;
1887
IF(my_year, 'IS TRUE', 'IS NOT TRUE') my_year id
1893
SHOW CREATE VIEW v1;
1894
View Create View character_set_client collation_connection
1895
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
1897
WHERE v1.id IN (SELECT id FROM t1_values
1898
WHERE select_id = 114 OR select_id IS NULL) order by id;
1899
IF(my_year, 'IS TRUE', 'IS NOT TRUE') my_year id
1908
CREATE VIEW v1 AS SELECT IF(my_time, 'IS TRUE', 'IS NOT TRUE'),
1909
my_time, id FROM t1_values;
1910
SELECT IF(my_time, 'IS TRUE', 'IS NOT TRUE'),
1911
my_time, id FROM t1_values
1912
WHERE select_id = 113 OR select_id IS NULL order by id;
1913
IF(my_time, 'IS TRUE', 'IS NOT TRUE') my_time id
1915
IS TRUE -838:59:59 2
1919
SHOW CREATE VIEW v1;
1920
View Create View character_set_client collation_connection
1921
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
1923
WHERE v1.id IN (SELECT id FROM t1_values
1924
WHERE select_id = 113 OR select_id IS NULL) order by id;
1925
IF(my_time, 'IS TRUE', 'IS NOT TRUE') my_time id
1927
IS TRUE -838:59:59 2
1934
CREATE VIEW v1 AS SELECT IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE'),
1935
my_timestamp, id FROM t1_values;
1936
SELECT IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE'),
1937
my_timestamp, id FROM t1_values
1938
WHERE select_id = 112 OR select_id IS NULL order by id;
1939
IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE') my_timestamp id
1940
IS NOT TRUE 0000-00-00 00:00:00 1
1941
IS TRUE 1970-01-01 03:00:01 2
1942
IS TRUE 2038-01-01 02:59:59 3
1943
IS TRUE 2004-02-29 23:59:59 4
1944
IS TRUE 2005-06-28 10:00:00 5
1945
SHOW CREATE VIEW v1;
1946
View Create View character_set_client collation_connection
1947
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
1949
WHERE v1.id IN (SELECT id FROM t1_values
1950
WHERE select_id = 112 OR select_id IS NULL) order by id;
1951
IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE') my_timestamp id
1952
IS NOT TRUE 0000-00-00 00:00:00 1
1953
IS TRUE 1970-01-01 03:00:01 2
1954
IS TRUE 2038-01-01 02:59:59 3
1955
IS TRUE 2004-02-29 23:59:59 4
1956
IS TRUE 2005-06-28 10:00:00 5
1960
CREATE VIEW v1 AS SELECT IF(my_date, 'IS TRUE', 'IS NOT TRUE'),
1961
my_date, id FROM t1_values;
1962
SELECT IF(my_date, 'IS TRUE', 'IS NOT TRUE'),
1963
my_date, id FROM t1_values
1964
WHERE select_id = 111 OR select_id IS NULL order by id;
1965
IF(my_date, 'IS TRUE', 'IS NOT TRUE') my_date id
1967
IS TRUE 0001-01-01 2
1968
IS TRUE 9999-12-31 3
1969
IS TRUE 2004-02-29 4
1970
IS TRUE 2005-06-28 5
1971
SHOW CREATE VIEW v1;
1972
View Create View character_set_client collation_connection
1973
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
1975
WHERE v1.id IN (SELECT id FROM t1_values
1976
WHERE select_id = 111 OR select_id IS NULL) order by id;
1977
IF(my_date, 'IS TRUE', 'IS NOT TRUE') my_date id
1979
IS TRUE 0001-01-01 2
1980
IS TRUE 9999-12-31 3
1981
IS TRUE 2004-02-29 4
1982
IS TRUE 2005-06-28 5
1986
CREATE VIEW v1 AS SELECT IF(my_datetime, 'IS TRUE', 'IS NOT TRUE'),
1987
my_datetime, id FROM t1_values;
1988
SELECT IF(my_datetime, 'IS TRUE', 'IS NOT TRUE'),
1989
my_datetime, id FROM t1_values
1990
WHERE select_id = 110 OR select_id IS NULL order by id;
1991
IF(my_datetime, 'IS TRUE', 'IS NOT TRUE') my_datetime id
1993
IS TRUE 0001-01-01 00:00:00 2
1994
IS TRUE 9999-12-31 23:59:59 3
1995
IS TRUE 2004-02-29 23:59:59 4
1996
IS TRUE 2005-06-28 10:00:00 5
1997
SHOW CREATE VIEW v1;
1998
View Create View character_set_client collation_connection
1999
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
2001
WHERE v1.id IN (SELECT id FROM t1_values
2002
WHERE select_id = 110 OR select_id IS NULL) order by id;
2003
IF(my_datetime, 'IS TRUE', 'IS NOT TRUE') my_datetime id
2005
IS TRUE 0001-01-01 00:00:00 2
2006
IS TRUE 9999-12-31 23:59:59 3
2007
IS TRUE 2004-02-29 23:59:59 4
2008
IS TRUE 2005-06-28 10:00:00 5
2012
CREATE VIEW v1 AS SELECT IF(my_double, 'IS TRUE', 'IS NOT TRUE'),
2013
my_double, id FROM t1_values;
2014
SELECT IF(my_double, 'IS TRUE', 'IS NOT TRUE'),
2015
my_double, id FROM t1_values
2016
WHERE select_id = 109 OR select_id IS NULL order by id;
2017
IF(my_double, 'IS TRUE', 'IS NOT TRUE') my_double id
2019
IS TRUE -1.7976931348623e308 2
2020
IS TRUE 1.7976931348623e308 3
2023
SHOW CREATE VIEW v1;
2024
View Create View character_set_client collation_connection
2025
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
2027
WHERE v1.id IN (SELECT id FROM t1_values
2028
WHERE select_id = 109 OR select_id IS NULL) order by id;
2029
IF(my_double, 'IS TRUE', 'IS NOT TRUE') my_double id
2031
IS TRUE -1.7976931348623e308 2
2032
IS TRUE 1.7976931348623e308 3
2038
CREATE VIEW v1 AS SELECT IF(my_decimal, 'IS TRUE', 'IS NOT TRUE'),
2039
my_decimal, id FROM t1_values;
2040
SELECT IF(my_decimal, 'IS TRUE', 'IS NOT TRUE'),
2041
my_decimal, id FROM t1_values
2042
WHERE select_id = 108 OR select_id IS NULL order by id;
2043
IF(my_decimal, 'IS TRUE', 'IS NOT TRUE') my_decimal id
2045
IS TRUE -9999999999999999999999999999999999.999999999999999999999999999999 2
2046
IS TRUE 9999999999999999999999999999999999.999999999999999999999999999999 3
2047
IS NOT TRUE 0.000000000000000000000000000000 4
2048
IS TRUE -1.000000000000000000000000000000 5
2049
SHOW CREATE VIEW v1;
2050
View Create View character_set_client collation_connection
2051
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
2053
WHERE v1.id IN (SELECT id FROM t1_values
2054
WHERE select_id = 108 OR select_id IS NULL) order by id;
2055
IF(my_decimal, 'IS TRUE', 'IS NOT TRUE') my_decimal id
2057
IS TRUE -9999999999999999999999999999999999.999999999999999999999999999999 2
2058
IS TRUE 9999999999999999999999999999999999.999999999999999999999999999999 3
2059
IS NOT TRUE 0.000000000000000000000000000000 4
2060
IS TRUE -1.000000000000000000000000000000 5
2064
CREATE VIEW v1 AS SELECT IF(my_bigint, 'IS TRUE', 'IS NOT TRUE'),
2065
my_bigint, id FROM t1_values;
2066
SELECT IF(my_bigint, 'IS TRUE', 'IS NOT TRUE'),
2067
my_bigint, id FROM t1_values
2068
WHERE select_id = 107 OR select_id IS NULL order by id;
2069
IF(my_bigint, 'IS TRUE', 'IS NOT TRUE') my_bigint id
2071
IS TRUE -9223372036854775808 2
2072
IS TRUE 9223372036854775807 3
2075
SHOW CREATE VIEW v1;
2076
View Create View character_set_client collation_connection
2077
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
2079
WHERE v1.id IN (SELECT id FROM t1_values
2080
WHERE select_id = 107 OR select_id IS NULL) order by id;
2081
IF(my_bigint, 'IS TRUE', 'IS NOT TRUE') my_bigint id
2083
IS TRUE -9223372036854775808 2
2084
IS TRUE 9223372036854775807 3
2090
CREATE VIEW v1 AS SELECT IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE'),
2091
my_varbinary_1000, id FROM t1_values;
2092
SELECT IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE'),
2093
my_varbinary_1000, id FROM t1_values
2094
WHERE select_id = 106 OR select_id IS NULL order by id;
2095
IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE') my_varbinary_1000 id
2098
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2099
IS NOT TRUE ---äÖüß@µ*$-- 4
2102
Warning 1292 Truncated incorrect DOUBLE value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2103
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2104
SHOW CREATE VIEW v1;
2105
View Create View character_set_client collation_connection
2106
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
2108
WHERE v1.id IN (SELECT id FROM t1_values
2109
WHERE select_id = 106 OR select_id IS NULL) order by id;
2110
IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE') my_varbinary_1000 id
2113
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2114
IS NOT TRUE ---äÖüß@µ*$-- 4
2117
Warning 1292 Truncated incorrect DOUBLE value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2118
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2122
CREATE VIEW v1 AS SELECT IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE'),
2123
my_binary_30, id FROM t1_values;
2124
SELECT IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE'),
2125
my_binary_30, id FROM t1_values
2126
WHERE select_id = 105 OR select_id IS NULL order by id;
2127
IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE') my_binary_30 id
2130
IS NOT TRUE <--------30 characters-------> 3
2131
IS NOT TRUE ---äÖüß@µ*$-- 4
2134
Warning 1292 Truncated incorrect DOUBLE value: '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
2135
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2136
Warning 1292 Truncated incorrect DOUBLE value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
2137
Warning 1292 Truncated incorrect DOUBLE value: '-1\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
2138
SHOW CREATE VIEW v1;
2139
View Create View character_set_client collation_connection
2140
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
2142
WHERE v1.id IN (SELECT id FROM t1_values
2143
WHERE select_id = 105 OR select_id IS NULL) order by id;
2144
IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE') my_binary_30 id
2147
IS NOT TRUE <--------30 characters-------> 3
2148
IS NOT TRUE ---äÖüß@µ*$-- 4
2151
Warning 1292 Truncated incorrect DOUBLE value: '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
2152
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2153
Warning 1292 Truncated incorrect DOUBLE value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
2154
Warning 1292 Truncated incorrect DOUBLE value: '-1\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
2158
CREATE VIEW v1 AS SELECT IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE'),
2159
my_varchar_1000, id FROM t1_values;
2160
SELECT IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE'),
2161
my_varchar_1000, id FROM t1_values
2162
WHERE select_id = 104 OR select_id IS NULL order by id;
2163
IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE') my_varchar_1000 id
2166
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2167
IS NOT TRUE ---äÖüß@µ*$-- 4
2170
Warning 1292 Truncated incorrect DOUBLE value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2171
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2172
SHOW CREATE VIEW v1;
2173
View Create View character_set_client collation_connection
2174
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
2176
WHERE v1.id IN (SELECT id FROM t1_values
2177
WHERE select_id = 104 OR select_id IS NULL) order by id;
2178
IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE') my_varchar_1000 id
2181
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2182
IS NOT TRUE ---äÖüß@µ*$-- 4
2185
Warning 1292 Truncated incorrect DOUBLE value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2186
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2190
CREATE VIEW v1 AS SELECT IF(my_char_30, 'IS TRUE', 'IS NOT TRUE'),
2191
my_char_30, id FROM t1_values;
2192
SELECT IF(my_char_30, 'IS TRUE', 'IS NOT TRUE'),
2193
my_char_30, id FROM t1_values
2194
WHERE select_id = 103 OR select_id IS NULL order by id;
2195
IF(my_char_30, 'IS TRUE', 'IS NOT TRUE') my_char_30 id
2198
IS NOT TRUE <--------30 characters-------> 3
2199
IS NOT TRUE ---äÖüß@µ*$-- 4
2202
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2203
Warning 1292 Truncated incorrect DOUBLE value: ' ---äÖüß@µ*$-- '
2204
SHOW CREATE VIEW v1;
2205
View Create View character_set_client collation_connection
2206
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
2208
WHERE v1.id IN (SELECT id FROM t1_values
2209
WHERE select_id = 103 OR select_id IS NULL) order by id;
2210
IF(my_char_30, 'IS TRUE', 'IS NOT TRUE') my_char_30 id
2213
IS NOT TRUE <--------30 characters-------> 3
2214
IS NOT TRUE ---äÖüß@µ*$-- 4
2217
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2218
Warning 1292 Truncated incorrect DOUBLE value: ' ---äÖüß@µ*$-- '
2222
CREATE VIEW v1 AS SELECT CONVERT(my_varbinary_1000 USING koi8r),
2223
my_varbinary_1000, id FROM t1_values;
2224
SELECT CONVERT(my_varbinary_1000 USING koi8r),
2225
my_varbinary_1000, id FROM t1_values
2226
WHERE select_id = 102 OR select_id IS NULL order by id;
2227
CONVERT(my_varbinary_1000 USING koi8r) my_varbinary_1000 id
2230
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2231
---???????�@??*$-- ---äÖüß@µ*$-- 4
2233
SHOW CREATE VIEW v1;
2234
View Create View character_set_client collation_connection
2235
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
2237
WHERE v1.id IN (SELECT id FROM t1_values
2238
WHERE select_id = 102 OR select_id IS NULL) order by id;
2239
CONVERT(my_varbinary_1000 USING koi8r) my_varbinary_1000 id
2242
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2243
---???????�@??*$-- ---äÖüß@µ*$-- 4
2248
CREATE VIEW v1 AS SELECT CONVERT(my_binary_30 USING koi8r),
2249
my_binary_30, id FROM t1_values;
2250
SELECT CONVERT(my_binary_30 USING koi8r),
2251
my_binary_30, id FROM t1_values
2252
WHERE select_id = 101 OR select_id IS NULL order by id;
2253
CONVERT(my_binary_30 USING koi8r) my_binary_30 id
2256
<--------30 characters-------> <--------30 characters-------> 3
2257
---???????�@??*$-- ---äÖüß@µ*$-- 4
2259
SHOW CREATE VIEW v1;
2260
View Create View character_set_client collation_connection
2261
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
2263
WHERE v1.id IN (SELECT id FROM t1_values
2264
WHERE select_id = 101 OR select_id IS NULL) order by id;
2265
CONVERT(my_binary_30 USING koi8r) my_binary_30 id
2268
<--------30 characters-------> <--------30 characters-------> 3
2269
---???????�@??*$-- ---äÖüß@µ*$-- 4
2274
CREATE VIEW v1 AS SELECT CONVERT(my_varchar_1000 USING koi8r),
2275
my_varchar_1000, id FROM t1_values;
2276
SELECT CONVERT(my_varchar_1000 USING koi8r),
2277
my_varchar_1000, id FROM t1_values
2278
WHERE select_id = 100 OR select_id IS NULL order by id;
2279
CONVERT(my_varchar_1000 USING koi8r) my_varchar_1000 id
2282
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2283
---????????@??*$-- ---äÖüß@µ*$-- 4
2285
SHOW CREATE VIEW v1;
2286
View Create View character_set_client collation_connection
2287
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
2289
WHERE v1.id IN (SELECT id FROM t1_values
2290
WHERE select_id = 100 OR select_id IS NULL) order by id;
2291
CONVERT(my_varchar_1000 USING koi8r) my_varchar_1000 id
2294
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2295
---????????@??*$-- ---äÖüß@µ*$-- 4
2300
CREATE VIEW v1 AS SELECT CONVERT(my_char_30 USING koi8r),
2301
my_char_30, id FROM t1_values;
2302
SELECT CONVERT(my_char_30 USING koi8r),
2303
my_char_30, id FROM t1_values
2304
WHERE select_id = 99 OR select_id IS NULL order by id;
2305
CONVERT(my_char_30 USING koi8r) my_char_30 id
2308
<--------30 characters-------> <--------30 characters-------> 3
2309
---????????@??*$-- ---äÖüß@µ*$-- 4
2311
SHOW CREATE VIEW v1;
2312
View Create View character_set_client collation_connection
2313
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
2315
WHERE v1.id IN (SELECT id FROM t1_values
2316
WHERE select_id = 99 OR select_id IS NULL) order by id;
2317
CONVERT(my_char_30 USING koi8r) my_char_30 id
2320
<--------30 characters-------> <--------30 characters-------> 3
2321
---????????@??*$-- ---äÖüß@µ*$-- 4
2326
CREATE VIEW v1 AS SELECT CONVERT(my_varbinary_1000 USING utf8),
2327
my_varbinary_1000, id FROM t1_values;
2328
SELECT CONVERT(my_varbinary_1000 USING utf8),
2329
my_varbinary_1000, id FROM t1_values
2330
WHERE select_id = 98 OR select_id IS NULL order by id;
2331
CONVERT(my_varbinary_1000 USING utf8) my_varbinary_1000 id
2334
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2335
---����@�*$-- ---äÖüß@µ*$-- 4
2337
SHOW CREATE VIEW v1;
2338
View Create View character_set_client collation_connection
2339
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
2341
WHERE v1.id IN (SELECT id FROM t1_values
2342
WHERE select_id = 98 OR select_id IS NULL) order by id;
2343
CONVERT(my_varbinary_1000 USING utf8) my_varbinary_1000 id
2346
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2347
---����@�*$-- ---äÖüß@µ*$-- 4
2352
CREATE VIEW v1 AS SELECT CONVERT(my_binary_30 USING utf8),
2353
my_binary_30, id FROM t1_values;
2354
SELECT CONVERT(my_binary_30 USING utf8),
2355
my_binary_30, id FROM t1_values
2356
WHERE select_id = 97 OR select_id IS NULL order by id;
2357
CONVERT(my_binary_30 USING utf8) my_binary_30 id
2360
<--------30 characters-------> <--------30 characters-------> 3
2361
---����@�*$-- ---äÖüß@µ*$-- 4
2363
SHOW CREATE VIEW v1;
2364
View Create View character_set_client collation_connection
2365
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
2367
WHERE v1.id IN (SELECT id FROM t1_values
2368
WHERE select_id = 97 OR select_id IS NULL) order by id;
2369
CONVERT(my_binary_30 USING utf8) my_binary_30 id
2372
<--------30 characters-------> <--------30 characters-------> 3
2373
---����@�*$-- ---äÖüß@µ*$-- 4
2378
CREATE VIEW v1 AS SELECT CONVERT(my_varchar_1000 USING utf8),
2379
my_varchar_1000, id FROM t1_values;
2380
SELECT CONVERT(my_varchar_1000 USING utf8),
2381
my_varchar_1000, id FROM t1_values
2382
WHERE select_id = 96 OR select_id IS NULL order by id;
2383
CONVERT(my_varchar_1000 USING utf8) my_varchar_1000 id
2386
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2387
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2389
SHOW CREATE VIEW v1;
2390
View Create View character_set_client collation_connection
2391
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
2393
WHERE v1.id IN (SELECT id FROM t1_values
2394
WHERE select_id = 96 OR select_id IS NULL) order by id;
2395
CONVERT(my_varchar_1000 USING utf8) my_varchar_1000 id
2398
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2399
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2404
CREATE VIEW v1 AS SELECT CONVERT(my_char_30 USING utf8),
2405
my_char_30, id FROM t1_values;
2406
SELECT CONVERT(my_char_30 USING utf8),
2407
my_char_30, id FROM t1_values
2408
WHERE select_id = 95 OR select_id IS NULL order by id;
2409
CONVERT(my_char_30 USING utf8) my_char_30 id
2412
<--------30 characters-------> <--------30 characters-------> 3
2413
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2415
SHOW CREATE VIEW v1;
2416
View Create View character_set_client collation_connection
2417
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
2419
WHERE v1.id IN (SELECT id FROM t1_values
2420
WHERE select_id = 95 OR select_id IS NULL) order by id;
2421
CONVERT(my_char_30 USING utf8) my_char_30 id
2424
<--------30 characters-------> <--------30 characters-------> 3
2425
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2430
CREATE VIEW v1 AS SELECT CAST(my_year AS UNSIGNED INTEGER),
2431
my_year, id FROM t1_values;
2432
SELECT CAST(my_year AS UNSIGNED INTEGER),
2433
my_year, id FROM t1_values
2434
WHERE select_id = 94 OR select_id IS NULL order by id;
2435
CAST(my_year AS UNSIGNED INTEGER) my_year id
2441
SHOW CREATE VIEW v1;
2442
View Create View character_set_client collation_connection
2443
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
2445
WHERE v1.id IN (SELECT id FROM t1_values
2446
WHERE select_id = 94 OR select_id IS NULL) order by id;
2447
CAST(my_year AS UNSIGNED INTEGER) my_year id
2456
CREATE VIEW v1 AS SELECT CAST(my_time AS UNSIGNED INTEGER),
2457
my_time, id FROM t1_values;
2458
SELECT CAST(my_time AS UNSIGNED INTEGER),
2459
my_time, id FROM t1_values
2460
WHERE select_id = 93 OR select_id IS NULL order by id;
2461
CAST(my_time AS UNSIGNED INTEGER) my_time id
2463
18446744073701165657 -838:59:59 2
2467
SHOW CREATE VIEW v1;
2468
View Create View character_set_client collation_connection
2469
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
2471
WHERE v1.id IN (SELECT id FROM t1_values
2472
WHERE select_id = 93 OR select_id IS NULL) order by id;
2473
CAST(my_time AS UNSIGNED INTEGER) my_time id
2475
18446744073701165657 -838:59:59 2
2482
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS UNSIGNED INTEGER),
2483
my_timestamp, id FROM t1_values;
2484
SELECT CAST(my_timestamp AS UNSIGNED INTEGER),
2485
my_timestamp, id FROM t1_values
2486
WHERE select_id = 92 OR select_id IS NULL order by id;
2487
CAST(my_timestamp AS UNSIGNED INTEGER) my_timestamp id
2488
0 0000-00-00 00:00:00 1
2489
19700101030001 1970-01-01 03:00:01 2
2490
20380101025959 2038-01-01 02:59:59 3
2491
20040229235959 2004-02-29 23:59:59 4
2492
20050628100000 2005-06-28 10:00:00 5
2493
SHOW CREATE VIEW v1;
2494
View Create View character_set_client collation_connection
2495
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
2497
WHERE v1.id IN (SELECT id FROM t1_values
2498
WHERE select_id = 92 OR select_id IS NULL) order by id;
2499
CAST(my_timestamp AS UNSIGNED INTEGER) my_timestamp id
2500
0 0000-00-00 00:00:00 1
2501
19700101030001 1970-01-01 03:00:01 2
2502
20380101025959 2038-01-01 02:59:59 3
2503
20040229235959 2004-02-29 23:59:59 4
2504
20050628100000 2005-06-28 10:00:00 5
2508
CREATE VIEW v1 AS SELECT CAST(my_date AS UNSIGNED INTEGER),
2509
my_date, id FROM t1_values;
2510
SELECT CAST(my_date AS UNSIGNED INTEGER),
2511
my_date, id FROM t1_values
2512
WHERE select_id = 91 OR select_id IS NULL order by id;
2513
CAST(my_date AS UNSIGNED INTEGER) my_date id
2516
99991231 9999-12-31 3
2517
20040229 2004-02-29 4
2518
20050628 2005-06-28 5
2519
SHOW CREATE VIEW v1;
2520
View Create View character_set_client collation_connection
2521
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
2523
WHERE v1.id IN (SELECT id FROM t1_values
2524
WHERE select_id = 91 OR select_id IS NULL) order by id;
2525
CAST(my_date AS UNSIGNED INTEGER) my_date id
2528
99991231 9999-12-31 3
2529
20040229 2004-02-29 4
2530
20050628 2005-06-28 5
2534
CREATE VIEW v1 AS SELECT CAST(my_datetime AS UNSIGNED INTEGER),
2535
my_datetime, id FROM t1_values;
2536
SELECT CAST(my_datetime AS UNSIGNED INTEGER),
2537
my_datetime, id FROM t1_values
2538
WHERE select_id = 90 OR select_id IS NULL order by id;
2539
CAST(my_datetime AS UNSIGNED INTEGER) my_datetime id
2541
10101000000 0001-01-01 00:00:00 2
2542
99991231235959 9999-12-31 23:59:59 3
2543
20040229235959 2004-02-29 23:59:59 4
2544
20050628100000 2005-06-28 10:00:00 5
2545
SHOW CREATE VIEW v1;
2546
View Create View character_set_client collation_connection
2547
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
2549
WHERE v1.id IN (SELECT id FROM t1_values
2550
WHERE select_id = 90 OR select_id IS NULL) order by id;
2551
CAST(my_datetime AS UNSIGNED INTEGER) my_datetime id
2553
10101000000 0001-01-01 00:00:00 2
2554
99991231235959 9999-12-31 23:59:59 3
2555
20040229235959 2004-02-29 23:59:59 4
2556
20050628100000 2005-06-28 10:00:00 5
2560
CREATE VIEW v1 AS SELECT CAST(my_double AS UNSIGNED INTEGER),
2561
my_double, id FROM t1_values;
2562
SELECT CAST(my_double AS UNSIGNED INTEGER),
2563
my_double, id FROM t1_values
2564
WHERE select_id = 89 OR select_id IS NULL order by id;
2565
CAST(my_double AS UNSIGNED INTEGER) my_double id
2567
9223372036854775808 -1.7976931348623e308 2
2568
9223372036854775807 1.7976931348623e308 3
2570
18446744073709551615 -1 5
2572
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2573
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2574
SHOW CREATE VIEW v1;
2575
View Create View character_set_client collation_connection
2576
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
2578
WHERE v1.id IN (SELECT id FROM t1_values
2579
WHERE select_id = 89 OR select_id IS NULL) order by id;
2580
CAST(my_double AS UNSIGNED INTEGER) my_double id
2582
9223372036854775808 -1.7976931348623e308 2
2583
9223372036854775807 1.7976931348623e308 3
2585
18446744073709551615 -1 5
2587
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2588
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2592
CREATE VIEW v1 AS SELECT CAST(my_decimal AS UNSIGNED INTEGER),
2593
my_decimal, id FROM t1_values;
2594
SELECT CAST(my_decimal AS UNSIGNED INTEGER),
2595
my_decimal, id FROM t1_values
2596
WHERE select_id = 88 OR select_id IS NULL order by id;
2597
CAST(my_decimal AS UNSIGNED INTEGER) my_decimal id
2599
0 -9999999999999999999999999999999999.999999999999999999999999999999 2
2600
18446744073709551615 9999999999999999999999999999999999.999999999999999999999999999999 3
2601
0 0.000000000000000000000000000000 4
2602
0 -1.000000000000000000000000000000 5
2604
Warning 1292 Truncated incorrect DECIMAL value: ''
2605
Warning 1292 Truncated incorrect DECIMAL value: ''
2606
Warning 1292 Truncated incorrect DECIMAL value: ''
2607
SHOW CREATE VIEW v1;
2608
View Create View character_set_client collation_connection
2609
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
2611
WHERE v1.id IN (SELECT id FROM t1_values
2612
WHERE select_id = 88 OR select_id IS NULL) order by id;
2613
CAST(my_decimal AS UNSIGNED INTEGER) my_decimal id
2615
0 -9999999999999999999999999999999999.999999999999999999999999999999 2
2616
18446744073709551615 9999999999999999999999999999999999.999999999999999999999999999999 3
2617
0 0.000000000000000000000000000000 4
2618
0 -1.000000000000000000000000000000 5
2620
Warning 1292 Truncated incorrect DECIMAL value: ''
2621
Warning 1292 Truncated incorrect DECIMAL value: ''
2622
Warning 1292 Truncated incorrect DECIMAL value: ''
2626
CREATE VIEW v1 AS SELECT CAST(my_bigint AS UNSIGNED INTEGER),
2627
my_bigint, id FROM t1_values;
2628
SELECT CAST(my_bigint AS UNSIGNED INTEGER),
2629
my_bigint, id FROM t1_values
2630
WHERE select_id = 87 OR select_id IS NULL order by id;
2631
CAST(my_bigint AS UNSIGNED INTEGER) my_bigint id
2633
9223372036854775808 -9223372036854775808 2
2634
9223372036854775807 9223372036854775807 3
2636
18446744073709551615 -1 5
2637
SHOW CREATE VIEW v1;
2638
View Create View character_set_client collation_connection
2639
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
2641
WHERE v1.id IN (SELECT id FROM t1_values
2642
WHERE select_id = 87 OR select_id IS NULL) order by id;
2643
CAST(my_bigint AS UNSIGNED INTEGER) my_bigint id
2645
9223372036854775808 -9223372036854775808 2
2646
9223372036854775807 9223372036854775807 3
2648
18446744073709551615 -1 5
2652
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS UNSIGNED INTEGER),
2653
my_varbinary_1000, id FROM t1_values;
2654
SELECT CAST(my_varbinary_1000 AS UNSIGNED INTEGER),
2655
my_varbinary_1000, id FROM t1_values
2656
WHERE select_id = 86 OR select_id IS NULL order by id;
2657
CAST(my_varbinary_1000 AS UNSIGNED INTEGER) my_varbinary_1000 id
2660
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2662
18446744073709551615 -1 5
2664
Warning 1292 Truncated incorrect INTEGER value: ''
2665
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2666
Warning 1292 Truncated incorrect INTEGER value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- '
2667
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2668
SHOW CREATE VIEW v1;
2669
View Create View character_set_client collation_connection
2670
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
2672
WHERE v1.id IN (SELECT id FROM t1_values
2673
WHERE select_id = 86 OR select_id IS NULL) order by id;
2674
CAST(my_varbinary_1000 AS UNSIGNED INTEGER) my_varbinary_1000 id
2677
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2679
18446744073709551615 -1 5
2681
Warning 1292 Truncated incorrect INTEGER value: ''
2682
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2683
Warning 1292 Truncated incorrect INTEGER value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- '
2684
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2688
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS UNSIGNED INTEGER),
2689
my_binary_30, id FROM t1_values;
2690
SELECT CAST(my_binary_30 AS UNSIGNED INTEGER),
2691
my_binary_30, id FROM t1_values
2692
WHERE select_id = 85 OR select_id IS NULL order by id;
2693
CAST(my_binary_30 AS UNSIGNED INTEGER) my_binary_30 id
2696
0 <--------30 characters-------> 3
2698
18446744073709551615 -1 5
2700
Warning 1292 Truncated incorrect INTEGER value: '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
2701
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2702
Warning 1292 Truncated incorrect INTEGER value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
2703
Warning 1292 Truncated incorrect INTEGER value: '-1\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
2704
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2705
SHOW CREATE VIEW v1;
2706
View Create View character_set_client collation_connection
2707
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
2709
WHERE v1.id IN (SELECT id FROM t1_values
2710
WHERE select_id = 85 OR select_id IS NULL) order by id;
2711
CAST(my_binary_30 AS UNSIGNED INTEGER) my_binary_30 id
2714
0 <--------30 characters-------> 3
2716
18446744073709551615 -1 5
2718
Warning 1292 Truncated incorrect INTEGER value: '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
2719
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2720
Warning 1292 Truncated incorrect INTEGER value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
2721
Warning 1292 Truncated incorrect INTEGER value: '-1\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
2722
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2726
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS UNSIGNED INTEGER),
2727
my_varchar_1000, id FROM t1_values;
2728
SELECT CAST(my_varchar_1000 AS UNSIGNED INTEGER),
2729
my_varchar_1000, id FROM t1_values
2730
WHERE select_id = 84 OR select_id IS NULL order by id;
2731
CAST(my_varchar_1000 AS UNSIGNED INTEGER) my_varchar_1000 id
2734
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2736
18446744073709551615 -1 5
2738
Warning 1292 Truncated incorrect INTEGER value: ''
2739
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2740
Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
2741
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2742
SHOW CREATE VIEW v1;
2743
View Create View character_set_client collation_connection
2744
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
2746
WHERE v1.id IN (SELECT id FROM t1_values
2747
WHERE select_id = 84 OR select_id IS NULL) order by id;
2748
CAST(my_varchar_1000 AS UNSIGNED INTEGER) my_varchar_1000 id
2751
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2753
18446744073709551615 -1 5
2755
Warning 1292 Truncated incorrect INTEGER value: ''
2756
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2757
Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
2758
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2762
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS UNSIGNED INTEGER),
2763
my_char_30, id FROM t1_values;
2764
SELECT CAST(my_char_30 AS UNSIGNED INTEGER),
2765
my_char_30, id FROM t1_values
2766
WHERE select_id = 83 OR select_id IS NULL order by id;
2767
CAST(my_char_30 AS UNSIGNED INTEGER) my_char_30 id
2770
0 <--------30 characters-------> 3
2772
18446744073709551615 -1 5
2774
Warning 1292 Truncated incorrect INTEGER value: ''
2775
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2776
Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$--'
2777
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2778
SHOW CREATE VIEW v1;
2779
View Create View character_set_client collation_connection
2780
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
2782
WHERE v1.id IN (SELECT id FROM t1_values
2783
WHERE select_id = 83 OR select_id IS NULL) order by id;
2784
CAST(my_char_30 AS UNSIGNED INTEGER) my_char_30 id
2787
0 <--------30 characters-------> 3
2789
18446744073709551615 -1 5
2791
Warning 1292 Truncated incorrect INTEGER value: ''
2792
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2793
Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$--'
2794
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2798
CREATE VIEW v1 AS SELECT CAST(my_year AS SIGNED INTEGER),
2799
my_year, id FROM t1_values;
2800
SELECT CAST(my_year AS SIGNED INTEGER),
2801
my_year, id FROM t1_values
2802
WHERE select_id = 82 OR select_id IS NULL order by id;
2803
CAST(my_year AS SIGNED INTEGER) my_year id
2809
SHOW CREATE VIEW v1;
2810
View Create View character_set_client collation_connection
2811
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
2813
WHERE v1.id IN (SELECT id FROM t1_values
2814
WHERE select_id = 82 OR select_id IS NULL) order by id;
2815
CAST(my_year AS SIGNED INTEGER) my_year id
2824
CREATE VIEW v1 AS SELECT CAST(my_time AS SIGNED INTEGER),
2825
my_time, id FROM t1_values;
2826
SELECT CAST(my_time AS SIGNED INTEGER),
2827
my_time, id FROM t1_values
2828
WHERE select_id = 81 OR select_id IS NULL order by id;
2829
CAST(my_time AS SIGNED INTEGER) my_time id
2831
-8385959 -838:59:59 2
2835
SHOW CREATE VIEW v1;
2836
View Create View character_set_client collation_connection
2837
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
2839
WHERE v1.id IN (SELECT id FROM t1_values
2840
WHERE select_id = 81 OR select_id IS NULL) order by id;
2841
CAST(my_time AS SIGNED INTEGER) my_time id
2843
-8385959 -838:59:59 2
2850
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS SIGNED INTEGER),
2851
my_timestamp, id FROM t1_values;
2852
SELECT CAST(my_timestamp AS SIGNED INTEGER),
2853
my_timestamp, id FROM t1_values
2854
WHERE select_id = 80 OR select_id IS NULL order by id;
2855
CAST(my_timestamp AS SIGNED INTEGER) my_timestamp id
2856
0 0000-00-00 00:00:00 1
2857
19700101030001 1970-01-01 03:00:01 2
2858
20380101025959 2038-01-01 02:59:59 3
2859
20040229235959 2004-02-29 23:59:59 4
2860
20050628100000 2005-06-28 10:00:00 5
2861
SHOW CREATE VIEW v1;
2862
View Create View character_set_client collation_connection
2863
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
2865
WHERE v1.id IN (SELECT id FROM t1_values
2866
WHERE select_id = 80 OR select_id IS NULL) order by id;
2867
CAST(my_timestamp AS SIGNED INTEGER) my_timestamp id
2868
0 0000-00-00 00:00:00 1
2869
19700101030001 1970-01-01 03:00:01 2
2870
20380101025959 2038-01-01 02:59:59 3
2871
20040229235959 2004-02-29 23:59:59 4
2872
20050628100000 2005-06-28 10:00:00 5
2876
CREATE VIEW v1 AS SELECT CAST(my_date AS SIGNED INTEGER),
2877
my_date, id FROM t1_values;
2878
SELECT CAST(my_date AS SIGNED INTEGER),
2879
my_date, id FROM t1_values
2880
WHERE select_id = 79 OR select_id IS NULL order by id;
2881
CAST(my_date AS SIGNED INTEGER) my_date id
2884
99991231 9999-12-31 3
2885
20040229 2004-02-29 4
2886
20050628 2005-06-28 5
2887
SHOW CREATE VIEW v1;
2888
View Create View character_set_client collation_connection
2889
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
2891
WHERE v1.id IN (SELECT id FROM t1_values
2892
WHERE select_id = 79 OR select_id IS NULL) order by id;
2893
CAST(my_date AS SIGNED INTEGER) my_date id
2896
99991231 9999-12-31 3
2897
20040229 2004-02-29 4
2898
20050628 2005-06-28 5
2902
CREATE VIEW v1 AS SELECT CAST(my_datetime AS SIGNED INTEGER),
2903
my_datetime, id FROM t1_values;
2904
SELECT CAST(my_datetime AS SIGNED INTEGER),
2905
my_datetime, id FROM t1_values
2906
WHERE select_id = 78 OR select_id IS NULL order by id;
2907
CAST(my_datetime AS SIGNED INTEGER) my_datetime id
2909
10101000000 0001-01-01 00:00:00 2
2910
99991231235959 9999-12-31 23:59:59 3
2911
20040229235959 2004-02-29 23:59:59 4
2912
20050628100000 2005-06-28 10:00:00 5
2913
SHOW CREATE VIEW v1;
2914
View Create View character_set_client collation_connection
2915
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
2917
WHERE v1.id IN (SELECT id FROM t1_values
2918
WHERE select_id = 78 OR select_id IS NULL) order by id;
2919
CAST(my_datetime AS SIGNED INTEGER) my_datetime id
2921
10101000000 0001-01-01 00:00:00 2
2922
99991231235959 9999-12-31 23:59:59 3
2923
20040229235959 2004-02-29 23:59:59 4
2924
20050628100000 2005-06-28 10:00:00 5
2928
CREATE VIEW v1 AS SELECT CAST(my_double AS SIGNED INTEGER),
2929
my_double, id FROM t1_values;
2930
SELECT CAST(my_double AS SIGNED INTEGER),
2931
my_double, id FROM t1_values
2932
WHERE select_id = 77 OR select_id IS NULL order by id;
2933
CAST(my_double AS SIGNED INTEGER) my_double id
2935
-9223372036854775808 -1.7976931348623e308 2
2936
9223372036854775807 1.7976931348623e308 3
2940
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2941
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2942
SHOW CREATE VIEW v1;
2943
View Create View character_set_client collation_connection
2944
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
2946
WHERE v1.id IN (SELECT id FROM t1_values
2947
WHERE select_id = 77 OR select_id IS NULL) order by id;
2948
CAST(my_double AS SIGNED INTEGER) my_double id
2950
-9223372036854775808 -1.7976931348623e308 2
2951
9223372036854775807 1.7976931348623e308 3
2955
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2956
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2960
CREATE VIEW v1 AS SELECT CAST(my_decimal AS SIGNED INTEGER),
2961
my_decimal, id FROM t1_values;
2962
SELECT CAST(my_decimal AS SIGNED INTEGER),
2963
my_decimal, id FROM t1_values
2964
WHERE select_id = 76 OR select_id IS NULL order by id;
2965
CAST(my_decimal AS SIGNED INTEGER) my_decimal id
2967
-9223372036854775808 -9999999999999999999999999999999999.999999999999999999999999999999 2
2968
9223372036854775807 9999999999999999999999999999999999.999999999999999999999999999999 3
2969
0 0.000000000000000000000000000000 4
2970
-1 -1.000000000000000000000000000000 5
2972
Warning 1292 Truncated incorrect DECIMAL value: ''
2973
Warning 1292 Truncated incorrect DECIMAL value: ''
2974
SHOW CREATE VIEW v1;
2975
View Create View character_set_client collation_connection
2976
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
2978
WHERE v1.id IN (SELECT id FROM t1_values
2979
WHERE select_id = 76 OR select_id IS NULL) order by id;
2980
CAST(my_decimal AS SIGNED INTEGER) my_decimal id
2982
-9223372036854775808 -9999999999999999999999999999999999.999999999999999999999999999999 2
2983
9223372036854775807 9999999999999999999999999999999999.999999999999999999999999999999 3
2984
0 0.000000000000000000000000000000 4
2985
-1 -1.000000000000000000000000000000 5
2987
Warning 1292 Truncated incorrect DECIMAL value: ''
2988
Warning 1292 Truncated incorrect DECIMAL value: ''
2992
CREATE VIEW v1 AS SELECT CAST(my_bigint AS SIGNED INTEGER),
2993
my_bigint, id FROM t1_values;
2994
SELECT CAST(my_bigint AS SIGNED INTEGER),
2995
my_bigint, id FROM t1_values
2996
WHERE select_id = 75 OR select_id IS NULL order by id;
2997
CAST(my_bigint AS SIGNED INTEGER) my_bigint id
2999
-9223372036854775808 -9223372036854775808 2
3000
9223372036854775807 9223372036854775807 3
3003
SHOW CREATE VIEW v1;
3004
View Create View character_set_client collation_connection
3005
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
3007
WHERE v1.id IN (SELECT id FROM t1_values
3008
WHERE select_id = 75 OR select_id IS NULL) order by id;
3009
CAST(my_bigint AS SIGNED INTEGER) my_bigint id
3011
-9223372036854775808 -9223372036854775808 2
3012
9223372036854775807 9223372036854775807 3
3018
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS SIGNED INTEGER),
3019
my_varbinary_1000, id FROM t1_values;
3020
SELECT CAST(my_varbinary_1000 AS SIGNED INTEGER),
3021
my_varbinary_1000, id FROM t1_values
3022
WHERE select_id = 74 OR select_id IS NULL order by id;
3023
CAST(my_varbinary_1000 AS SIGNED INTEGER) my_varbinary_1000 id
3026
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3030
Warning 1292 Truncated incorrect INTEGER value: ''
3031
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3032
Warning 1292 Truncated incorrect INTEGER value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- '
3033
SHOW CREATE VIEW v1;
3034
View Create View character_set_client collation_connection
3035
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
3037
WHERE v1.id IN (SELECT id FROM t1_values
3038
WHERE select_id = 74 OR select_id IS NULL) order by id;
3039
CAST(my_varbinary_1000 AS SIGNED INTEGER) my_varbinary_1000 id
3042
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3046
Warning 1292 Truncated incorrect INTEGER value: ''
3047
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3048
Warning 1292 Truncated incorrect INTEGER value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- '
3052
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS SIGNED INTEGER),
3053
my_binary_30, id FROM t1_values;
3054
SELECT CAST(my_binary_30 AS SIGNED INTEGER),
3055
my_binary_30, id FROM t1_values
3056
WHERE select_id = 73 OR select_id IS NULL order by id;
3057
CAST(my_binary_30 AS SIGNED INTEGER) my_binary_30 id
3060
0 <--------30 characters-------> 3
3064
Warning 1292 Truncated incorrect INTEGER value: '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3065
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3066
Warning 1292 Truncated incorrect INTEGER value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3067
Warning 1292 Truncated incorrect INTEGER value: '-1\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3068
SHOW CREATE VIEW v1;
3069
View Create View character_set_client collation_connection
3070
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
3072
WHERE v1.id IN (SELECT id FROM t1_values
3073
WHERE select_id = 73 OR select_id IS NULL) order by id;
3074
CAST(my_binary_30 AS SIGNED INTEGER) my_binary_30 id
3077
0 <--------30 characters-------> 3
3081
Warning 1292 Truncated incorrect INTEGER value: '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3082
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3083
Warning 1292 Truncated incorrect INTEGER value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3084
Warning 1292 Truncated incorrect INTEGER value: '-1\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3088
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS SIGNED INTEGER),
3089
my_varchar_1000, id FROM t1_values;
3090
SELECT CAST(my_varchar_1000 AS SIGNED INTEGER),
3091
my_varchar_1000, id FROM t1_values
3092
WHERE select_id = 72 OR select_id IS NULL order by id;
3093
CAST(my_varchar_1000 AS SIGNED INTEGER) my_varchar_1000 id
3096
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3100
Warning 1292 Truncated incorrect INTEGER value: ''
3101
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3102
Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
3103
SHOW CREATE VIEW v1;
3104
View Create View character_set_client collation_connection
3105
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
3107
WHERE v1.id IN (SELECT id FROM t1_values
3108
WHERE select_id = 72 OR select_id IS NULL) order by id;
3109
CAST(my_varchar_1000 AS SIGNED INTEGER) my_varchar_1000 id
3112
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3116
Warning 1292 Truncated incorrect INTEGER value: ''
3117
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3118
Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
3122
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS SIGNED INTEGER),
3123
my_char_30, id FROM t1_values;
3124
SELECT CAST(my_char_30 AS SIGNED INTEGER),
3125
my_char_30, id FROM t1_values
3126
WHERE select_id = 71 OR select_id IS NULL order by id;
3127
CAST(my_char_30 AS SIGNED INTEGER) my_char_30 id
3130
0 <--------30 characters-------> 3
3134
Warning 1292 Truncated incorrect INTEGER value: ''
3135
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3136
Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$--'
3137
SHOW CREATE VIEW v1;
3138
View Create View character_set_client collation_connection
3139
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
3141
WHERE v1.id IN (SELECT id FROM t1_values
3142
WHERE select_id = 71 OR select_id IS NULL) order by id;
3143
CAST(my_char_30 AS SIGNED INTEGER) my_char_30 id
3146
0 <--------30 characters-------> 3
3150
Warning 1292 Truncated incorrect INTEGER value: ''
3151
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3152
Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$--'
3156
CREATE VIEW v1 AS SELECT CAST(my_year AS DECIMAL(37,2)),
3157
my_year, id FROM t1_values;
3158
SELECT CAST(my_year AS DECIMAL(37,2)),
3159
my_year, id FROM t1_values
3160
WHERE select_id = 70 OR select_id IS NULL order by id;
3161
CAST(my_year AS DECIMAL(37,2)) my_year id
3167
SHOW CREATE VIEW v1;
3168
View Create View character_set_client collation_connection
3169
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
3171
WHERE v1.id IN (SELECT id FROM t1_values
3172
WHERE select_id = 70 OR select_id IS NULL) order by id;
3173
CAST(my_year AS DECIMAL(37,2)) my_year id
3182
CREATE VIEW v1 AS SELECT CAST(my_time AS DECIMAL(37,2)),
3183
my_time, id FROM t1_values;
3184
SELECT CAST(my_time AS DECIMAL(37,2)),
3185
my_time, id FROM t1_values
3186
WHERE select_id = 69 OR select_id IS NULL order by id;
3187
CAST(my_time AS DECIMAL(37,2)) my_time id
3189
-8385959.00 -838:59:59 2
3190
8385959.00 838:59:59 3
3191
130000.00 13:00:00 4
3192
100000.00 10:00:00 5
3193
SHOW CREATE VIEW v1;
3194
View Create View character_set_client collation_connection
3195
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
3197
WHERE v1.id IN (SELECT id FROM t1_values
3198
WHERE select_id = 69 OR select_id IS NULL) order by id;
3199
CAST(my_time AS DECIMAL(37,2)) my_time id
3201
-8385959.00 -838:59:59 2
3202
8385959.00 838:59:59 3
3203
130000.00 13:00:00 4
3204
100000.00 10:00:00 5
3208
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DECIMAL(37,2)),
3209
my_timestamp, id FROM t1_values;
3210
SELECT CAST(my_timestamp AS DECIMAL(37,2)),
3211
my_timestamp, id FROM t1_values
3212
WHERE select_id = 68 OR select_id IS NULL order by id;
3213
CAST(my_timestamp AS DECIMAL(37,2)) my_timestamp id
3214
0.00 0000-00-00 00:00:00 1
3215
19700101030001.00 1970-01-01 03:00:01 2
3216
20380101025959.00 2038-01-01 02:59:59 3
3217
20040229235959.00 2004-02-29 23:59:59 4
3218
20050628100000.00 2005-06-28 10:00:00 5
3219
SHOW CREATE VIEW v1;
3220
View Create View character_set_client collation_connection
3221
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
3223
WHERE v1.id IN (SELECT id FROM t1_values
3224
WHERE select_id = 68 OR select_id IS NULL) order by id;
3225
CAST(my_timestamp AS DECIMAL(37,2)) my_timestamp id
3226
0.00 0000-00-00 00:00:00 1
3227
19700101030001.00 1970-01-01 03:00:01 2
3228
20380101025959.00 2038-01-01 02:59:59 3
3229
20040229235959.00 2004-02-29 23:59:59 4
3230
20050628100000.00 2005-06-28 10:00:00 5
3234
CREATE VIEW v1 AS SELECT CAST(my_date AS DECIMAL(37,2)),
3235
my_date, id FROM t1_values;
3236
SELECT CAST(my_date AS DECIMAL(37,2)),
3237
my_date, id FROM t1_values
3238
WHERE select_id = 67 OR select_id IS NULL order by id;
3239
CAST(my_date AS DECIMAL(37,2)) my_date id
3241
10101.00 0001-01-01 2
3242
99991231.00 9999-12-31 3
3243
20040229.00 2004-02-29 4
3244
20050628.00 2005-06-28 5
3245
SHOW CREATE VIEW v1;
3246
View Create View character_set_client collation_connection
3247
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
3249
WHERE v1.id IN (SELECT id FROM t1_values
3250
WHERE select_id = 67 OR select_id IS NULL) order by id;
3251
CAST(my_date AS DECIMAL(37,2)) my_date id
3253
10101.00 0001-01-01 2
3254
99991231.00 9999-12-31 3
3255
20040229.00 2004-02-29 4
3256
20050628.00 2005-06-28 5
3260
CREATE VIEW v1 AS SELECT CAST(my_datetime AS DECIMAL(37,2)),
3261
my_datetime, id FROM t1_values;
3262
SELECT CAST(my_datetime AS DECIMAL(37,2)),
3263
my_datetime, id FROM t1_values
3264
WHERE select_id = 66 OR select_id IS NULL order by id;
3265
CAST(my_datetime AS DECIMAL(37,2)) my_datetime id
3267
10101000000.00 0001-01-01 00:00:00 2
3268
99991231235959.00 9999-12-31 23:59:59 3
3269
20040229235959.00 2004-02-29 23:59:59 4
3270
20050628100000.00 2005-06-28 10:00:00 5
3271
SHOW CREATE VIEW v1;
3272
View Create View character_set_client collation_connection
3273
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
3275
WHERE v1.id IN (SELECT id FROM t1_values
3276
WHERE select_id = 66 OR select_id IS NULL) order by id;
3277
CAST(my_datetime AS DECIMAL(37,2)) my_datetime id
3279
10101000000.00 0001-01-01 00:00:00 2
3280
99991231235959.00 9999-12-31 23:59:59 3
3281
20040229235959.00 2004-02-29 23:59:59 4
3282
20050628100000.00 2005-06-28 10:00:00 5
3286
CREATE VIEW v1 AS SELECT CAST(my_double AS DECIMAL(37,2)),
3287
my_double, id FROM t1_values;
3288
SELECT CAST(my_double AS DECIMAL(37,2)),
3289
my_double, id FROM t1_values
3290
WHERE select_id = 65 OR select_id IS NULL order by id;
3291
CAST(my_double AS DECIMAL(37,2)) my_double id
3293
-99999999999999999999999999999999999.99 -1.7976931348623e308 2
3294
99999999999999999999999999999999999.99 1.7976931348623e308 3
3297
-3333.33 -3333.3333 30
3299
Warning 1292 Truncated incorrect DECIMAL value: ''
3300
Warning 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3301
Warning 1292 Truncated incorrect DECIMAL value: ''
3302
Warning 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3303
SHOW CREATE VIEW v1;
3304
View Create View character_set_client collation_connection
3305
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
3307
WHERE v1.id IN (SELECT id FROM t1_values
3308
WHERE select_id = 65 OR select_id IS NULL) order by id;
3309
CAST(my_double AS DECIMAL(37,2)) my_double id
3311
-99999999999999999999999999999999999.99 -1.7976931348623e308 2
3312
99999999999999999999999999999999999.99 1.7976931348623e308 3
3315
-3333.33 -3333.3333 30
3317
Warning 1292 Truncated incorrect DECIMAL value: ''
3318
Warning 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3319
Warning 1292 Truncated incorrect DECIMAL value: ''
3320
Warning 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3324
CREATE VIEW v1 AS SELECT CAST(my_decimal AS DECIMAL(37,2)),
3325
my_decimal, id FROM t1_values;
3326
SELECT CAST(my_decimal AS DECIMAL(37,2)),
3327
my_decimal, id FROM t1_values
3328
WHERE select_id = 64 OR select_id IS NULL order by id;
3329
CAST(my_decimal AS DECIMAL(37,2)) my_decimal id
3331
-10000000000000000000000000000000000.00 -9999999999999999999999999999999999.999999999999999999999999999999 2
3332
10000000000000000000000000000000000.00 9999999999999999999999999999999999.999999999999999999999999999999 3
3333
0.00 0.000000000000000000000000000000 4
3334
-1.00 -1.000000000000000000000000000000 5
3335
SHOW CREATE VIEW v1;
3336
View Create View character_set_client collation_connection
3337
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
3339
WHERE v1.id IN (SELECT id FROM t1_values
3340
WHERE select_id = 64 OR select_id IS NULL) order by id;
3341
CAST(my_decimal AS DECIMAL(37,2)) my_decimal id
3343
-10000000000000000000000000000000000.00 -9999999999999999999999999999999999.999999999999999999999999999999 2
3344
10000000000000000000000000000000000.00 9999999999999999999999999999999999.999999999999999999999999999999 3
3345
0.00 0.000000000000000000000000000000 4
3346
-1.00 -1.000000000000000000000000000000 5
3350
CREATE VIEW v1 AS SELECT CAST(my_bigint AS DECIMAL(37,2)),
3351
my_bigint, id FROM t1_values;
3352
SELECT CAST(my_bigint AS DECIMAL(37,2)),
3353
my_bigint, id FROM t1_values
3354
WHERE select_id = 63 OR select_id IS NULL order by id;
3355
CAST(my_bigint AS DECIMAL(37,2)) my_bigint id
3357
-9223372036854775808.00 -9223372036854775808 2
3358
9223372036854775807.00 9223372036854775807 3
3361
SHOW CREATE VIEW v1;
3362
View Create View character_set_client collation_connection
3363
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
3365
WHERE v1.id IN (SELECT id FROM t1_values
3366
WHERE select_id = 63 OR select_id IS NULL) order by id;
3367
CAST(my_bigint AS DECIMAL(37,2)) my_bigint id
3369
-9223372036854775808.00 -9223372036854775808 2
3370
9223372036854775807.00 9223372036854775807 3
3376
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DECIMAL(37,2)),
3377
my_varbinary_1000, id FROM t1_values;
3378
SELECT CAST(my_varbinary_1000 AS DECIMAL(37,2)),
3379
my_varbinary_1000, id FROM t1_values
3380
WHERE select_id = 62 OR select_id IS NULL order by id;
3381
CAST(my_varbinary_1000 AS DECIMAL(37,2)) my_varbinary_1000 id
3384
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3385
0.00 ---äÖüß@µ*$-- 4
3387
-3333.33 -3333.3333 29
3389
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3390
Warning 1292 Truncated incorrect DECIMAL value: ''
3391
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3392
Warning 1292 Truncated incorrect DECIMAL value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3393
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3394
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3395
SHOW CREATE VIEW v1;
3396
View Create View character_set_client collation_connection
3397
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_varbinary_1000` as decimal(37,2)) AS `CAST(my_varbinary_1000 AS DECIMAL(37,2))`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
3399
WHERE v1.id IN (SELECT id FROM t1_values
3400
WHERE select_id = 62 OR select_id IS NULL) order by id;
3401
CAST(my_varbinary_1000 AS DECIMAL(37,2)) my_varbinary_1000 id
3404
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3405
0.00 ---äÖüß@µ*$-- 4
3407
-3333.33 -3333.3333 29
3409
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3410
Warning 1292 Truncated incorrect DECIMAL value: ''
3411
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3412
Warning 1292 Truncated incorrect DECIMAL value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3413
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3414
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3418
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DECIMAL(37,2)),
3419
my_binary_30, id FROM t1_values;
3420
SELECT CAST(my_binary_30 AS DECIMAL(37,2)),
3421
my_binary_30, id FROM t1_values
3422
WHERE select_id = 61 OR select_id IS NULL order by id;
3423
CAST(my_binary_30 AS DECIMAL(37,2)) my_binary_30 id
3426
0.00 <--------30 characters-------> 3
3427
0.00 ---äÖüß@µ*$-- 4
3429
-3333.33 -3333.3333 28
3431
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3432
Warning 1292 Truncated incorrect DECIMAL value: '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3433
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3434
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3435
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3436
Warning 1292 Truncated incorrect DECIMAL value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3437
Warning 1292 Truncated incorrect DECIMAL value: '-1\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3438
Warning 1292 Truncated incorrect DECIMAL value: '-3333.3333\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3439
SHOW CREATE VIEW v1;
3440
View Create View character_set_client collation_connection
3441
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
3443
WHERE v1.id IN (SELECT id FROM t1_values
3444
WHERE select_id = 61 OR select_id IS NULL) order by id;
3445
CAST(my_binary_30 AS DECIMAL(37,2)) my_binary_30 id
3448
0.00 <--------30 characters-------> 3
3449
0.00 ---äÖüß@µ*$-- 4
3451
-3333.33 -3333.3333 28
3453
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3454
Warning 1292 Truncated incorrect DECIMAL value: '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3455
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3456
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3457
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3458
Warning 1292 Truncated incorrect DECIMAL value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3459
Warning 1292 Truncated incorrect DECIMAL value: '-1\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3460
Warning 1292 Truncated incorrect DECIMAL value: '-3333.3333\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3464
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DECIMAL(37,2)),
3465
my_varchar_1000, id FROM t1_values;
3466
SELECT CAST(my_varchar_1000 AS DECIMAL(37,2)),
3467
my_varchar_1000, id FROM t1_values
3468
WHERE select_id = 60 OR select_id IS NULL order by id;
3469
CAST(my_varchar_1000 AS DECIMAL(37,2)) my_varchar_1000 id
3472
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3473
0.00 ---äÖüß@µ*$-- 4
3475
-3333.33 -3333.3333 27
3477
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3478
Warning 1292 Truncated incorrect DECIMAL value: ''
3479
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3480
Warning 1292 Truncated incorrect DECIMAL value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3481
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3482
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3483
SHOW CREATE VIEW v1;
3484
View Create View character_set_client collation_connection
3485
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
3487
WHERE v1.id IN (SELECT id FROM t1_values
3488
WHERE select_id = 60 OR select_id IS NULL) order by id;
3489
CAST(my_varchar_1000 AS DECIMAL(37,2)) my_varchar_1000 id
3492
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3493
0.00 ---äÖüß@µ*$-- 4
3495
-3333.33 -3333.3333 27
3497
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3498
Warning 1292 Truncated incorrect DECIMAL value: ''
3499
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3500
Warning 1292 Truncated incorrect DECIMAL value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3501
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3502
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3506
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DECIMAL(37,2)),
3507
my_char_30, id FROM t1_values;
3508
SELECT CAST(my_char_30 AS DECIMAL(37,2)),
3509
my_char_30, id FROM t1_values
3510
WHERE select_id = 59 OR select_id IS NULL order by id;
3511
CAST(my_char_30 AS DECIMAL(37,2)) my_char_30 id
3514
0.00 <--------30 characters-------> 3
3515
0.00 ---äÖüß@µ*$-- 4
3517
-3333.33 -3333.3333 26
3519
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3520
Warning 1292 Truncated incorrect DECIMAL value: ' '
3521
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3522
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3523
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3524
Warning 1292 Truncated incorrect DECIMAL value: ' ---äÖüß@µ*$-- '
3525
SHOW CREATE VIEW v1;
3526
View Create View character_set_client collation_connection
3527
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
3529
WHERE v1.id IN (SELECT id FROM t1_values
3530
WHERE select_id = 59 OR select_id IS NULL) order by id;
3531
CAST(my_char_30 AS DECIMAL(37,2)) my_char_30 id
3534
0.00 <--------30 characters-------> 3
3535
0.00 ---äÖüß@µ*$-- 4
3537
-3333.33 -3333.3333 26
3539
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3540
Warning 1292 Truncated incorrect DECIMAL value: ' '
3541
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3542
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3543
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3544
Warning 1292 Truncated incorrect DECIMAL value: ' ---äÖüß@µ*$-- '
3548
CREATE VIEW v1 AS SELECT CAST(my_year AS TIME),
3549
my_year, id FROM t1_values;
3550
SELECT CAST(my_year AS TIME),
3551
my_year, id FROM t1_values
3552
WHERE select_id = 58 OR select_id IS NULL order by id;
3553
CAST(my_year AS TIME) my_year id
3559
SHOW CREATE VIEW v1;
3560
View Create View character_set_client collation_connection
3561
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
3563
WHERE v1.id IN (SELECT id FROM t1_values
3564
WHERE select_id = 58 OR select_id IS NULL) order by id;
3565
CAST(my_year AS TIME) my_year id
3574
CREATE VIEW v1 AS SELECT CAST(my_time AS TIME),
3575
my_time, id FROM t1_values;
3576
SELECT CAST(my_time AS TIME),
3577
my_time, id FROM t1_values
3578
WHERE select_id = 57 OR select_id IS NULL order by id;
3579
CAST(my_time AS TIME) my_time id
3581
-838:59:59 -838:59:59 2
3582
838:59:59 838:59:59 3
3585
SHOW CREATE VIEW v1;
3586
View Create View character_set_client collation_connection
3587
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
3589
WHERE v1.id IN (SELECT id FROM t1_values
3590
WHERE select_id = 57 OR select_id IS NULL) order by id;
3591
CAST(my_time AS TIME) my_time id
3593
-838:59:59 -838:59:59 2
3594
838:59:59 838:59:59 3
3600
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS TIME),
3601
my_timestamp, id FROM t1_values;
3602
SELECT CAST(my_timestamp AS TIME),
3603
my_timestamp, id FROM t1_values
3604
WHERE select_id = 56 OR select_id IS NULL order by id;
3605
CAST(my_timestamp AS TIME) my_timestamp id
3606
00:00:00 0000-00-00 00:00:00 1
3607
03:00:01 1970-01-01 03:00:01 2
3608
02:59:59 2038-01-01 02:59:59 3
3609
23:59:59 2004-02-29 23:59:59 4
3610
10:00:00 2005-06-28 10:00:00 5
3611
SHOW CREATE VIEW v1;
3612
View Create View character_set_client collation_connection
3613
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
3615
WHERE v1.id IN (SELECT id FROM t1_values
3616
WHERE select_id = 56 OR select_id IS NULL) order by id;
3617
CAST(my_timestamp AS TIME) my_timestamp id
3618
00:00:00 0000-00-00 00:00:00 1
3619
03:00:01 1970-01-01 03:00:01 2
3620
02:59:59 2038-01-01 02:59:59 3
3621
23:59:59 2004-02-29 23:59:59 4
3622
10:00:00 2005-06-28 10:00:00 5
3626
CREATE VIEW v1 AS SELECT CAST(my_date AS TIME),
3627
my_date, id FROM t1_values;
3628
SELECT CAST(my_date AS TIME),
3629
my_date, id FROM t1_values
3630
WHERE select_id = 55 OR select_id IS NULL order by id;
3631
CAST(my_date AS TIME) my_date id
3633
00:00:00 0001-01-01 2
3634
00:00:00 9999-12-31 3
3635
00:00:00 2004-02-29 4
3636
00:00:00 2005-06-28 5
3637
SHOW CREATE VIEW v1;
3638
View Create View character_set_client collation_connection
3639
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
3641
WHERE v1.id IN (SELECT id FROM t1_values
3642
WHERE select_id = 55 OR select_id IS NULL) order by id;
3643
CAST(my_date AS TIME) my_date id
3645
00:00:00 0001-01-01 2
3646
00:00:00 9999-12-31 3
3647
00:00:00 2004-02-29 4
3648
00:00:00 2005-06-28 5
3652
CREATE VIEW v1 AS SELECT CAST(my_datetime AS TIME),
3653
my_datetime, id FROM t1_values;
3654
SELECT CAST(my_datetime AS TIME),
3655
my_datetime, id FROM t1_values
3656
WHERE select_id = 54 OR select_id IS NULL order by id;
3657
CAST(my_datetime AS TIME) my_datetime id
3659
00:00:00 0001-01-01 00:00:00 2
3660
23:59:59 9999-12-31 23:59:59 3
3661
23:59:59 2004-02-29 23:59:59 4
3662
10:00:00 2005-06-28 10:00:00 5
3663
SHOW CREATE VIEW v1;
3664
View Create View character_set_client collation_connection
3665
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
3667
WHERE v1.id IN (SELECT id FROM t1_values
3668
WHERE select_id = 54 OR select_id IS NULL) order by id;
3669
CAST(my_datetime AS TIME) my_datetime id
3671
00:00:00 0001-01-01 00:00:00 2
3672
23:59:59 9999-12-31 23:59:59 3
3673
23:59:59 2004-02-29 23:59:59 4
3674
10:00:00 2005-06-28 10:00:00 5
3678
CREATE VIEW v1 AS SELECT CAST(my_double AS TIME),
3679
my_double, id FROM t1_values;
3680
SELECT CAST(my_double AS TIME),
3681
my_double, id FROM t1_values
3682
WHERE select_id = 53 OR select_id IS NULL order by id;
3683
CAST(my_double AS TIME) my_double id
3685
NULL -1.7976931348623e308 2
3686
NULL 1.7976931348623e308 3
3691
Warning 1292 Truncated incorrect time value: '-1.7976931348623e308'
3692
Warning 1292 Truncated incorrect time value: '1.7976931348623e308'
3693
SHOW CREATE VIEW v1;
3694
View Create View character_set_client collation_connection
3695
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
3697
WHERE v1.id IN (SELECT id FROM t1_values
3698
WHERE select_id = 53 OR select_id IS NULL) order by id;
3699
CAST(my_double AS TIME) my_double id
3701
NULL -1.7976931348623e308 2
3702
NULL 1.7976931348623e308 3
3707
Warning 1292 Truncated incorrect time value: '-1.7976931348623e308'
3708
Warning 1292 Truncated incorrect time value: '1.7976931348623e308'
3712
CREATE VIEW v1 AS SELECT CAST(my_bigint AS TIME),
3713
my_bigint, id FROM t1_values;
3714
SELECT CAST(my_bigint AS TIME),
3715
my_bigint, id FROM t1_values
3716
WHERE select_id = 52 OR select_id IS NULL order by id;
3717
CAST(my_bigint AS TIME) my_bigint id
3719
NULL -9223372036854775808 2
3720
NULL 9223372036854775807 3
3725
Warning 1292 Truncated incorrect time value: '-9223372036854775808'
3726
Warning 1292 Truncated incorrect time value: '9223372036854775807'
3727
SHOW CREATE VIEW v1;
3728
View Create View character_set_client collation_connection
3729
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
3731
WHERE v1.id IN (SELECT id FROM t1_values
3732
WHERE select_id = 52 OR select_id IS NULL) order by id;
3733
CAST(my_bigint AS TIME) my_bigint id
3735
NULL -9223372036854775808 2
3736
NULL 9223372036854775807 3
3741
Warning 1292 Truncated incorrect time value: '-9223372036854775808'
3742
Warning 1292 Truncated incorrect time value: '9223372036854775807'
3746
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS TIME),
3747
my_varbinary_1000, id FROM t1_values;
3748
SELECT CAST(my_varbinary_1000 AS TIME),
3749
my_varbinary_1000, id FROM t1_values
3750
WHERE select_id = 51 OR select_id IS NULL order by id;
3751
CAST(my_varbinary_1000 AS TIME) my_varbinary_1000 id
3754
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3755
-00:00:00 ---äÖüß@µ*$-- 4
3759
Warning 1292 Truncated incorrect time value: ''
3760
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3761
Warning 1292 Truncated incorrect time value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- '
3762
SHOW CREATE VIEW v1;
3763
View Create View character_set_client collation_connection
3764
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
3766
WHERE v1.id IN (SELECT id FROM t1_values
3767
WHERE select_id = 51 OR select_id IS NULL) order by id;
3768
CAST(my_varbinary_1000 AS TIME) my_varbinary_1000 id
3771
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3772
-00:00:00 ---äÖüß@µ*$-- 4
3776
Warning 1292 Truncated incorrect time value: ''
3777
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3778
Warning 1292 Truncated incorrect time value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- '
3782
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS TIME),
3783
my_binary_30, id FROM t1_values;
3784
SELECT CAST(my_binary_30 AS TIME),
3785
my_binary_30, id FROM t1_values
3786
WHERE select_id = 50 OR select_id IS NULL order by id;
3787
CAST(my_binary_30 AS TIME) my_binary_30 id
3790
00:00:00 <--------30 characters-------> 3
3791
-00:00:00 ---äÖüß@µ*$-- 4
3795
Warning 1292 Truncated incorrect time value: '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3796
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3797
Warning 1292 Truncated incorrect time value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3798
Warning 1292 Truncated incorrect time value: '-1\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3799
Warning 1292 Truncated incorrect time value: '1 17:58\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3800
SHOW CREATE VIEW v1;
3801
View Create View character_set_client collation_connection
3802
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
3804
WHERE v1.id IN (SELECT id FROM t1_values
3805
WHERE select_id = 50 OR select_id IS NULL) order by id;
3806
CAST(my_binary_30 AS TIME) my_binary_30 id
3809
00:00:00 <--------30 characters-------> 3
3810
-00:00:00 ---äÖüß@µ*$-- 4
3814
Warning 1292 Truncated incorrect time value: '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3815
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3816
Warning 1292 Truncated incorrect time value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3817
Warning 1292 Truncated incorrect time value: '-1\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3818
Warning 1292 Truncated incorrect time value: '1 17:58\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
3822
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS TIME),
3823
my_varchar_1000, id FROM t1_values;
3824
SELECT CAST(my_varchar_1000 AS TIME),
3825
my_varchar_1000, id FROM t1_values
3826
WHERE select_id = 49 OR select_id IS NULL order by id;
3827
CAST(my_varchar_1000 AS TIME) my_varchar_1000 id
3830
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3831
-00:00:00 ---äÖüß@µ*$-- 4
3835
Warning 1292 Truncated incorrect time value: ''
3836
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3837
Warning 1292 Truncated incorrect time value: ' ---äÖüß@µ*$-- '
3838
SHOW CREATE VIEW v1;
3839
View Create View character_set_client collation_connection
3840
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
3842
WHERE v1.id IN (SELECT id FROM t1_values
3843
WHERE select_id = 49 OR select_id IS NULL) order by id;
3844
CAST(my_varchar_1000 AS TIME) my_varchar_1000 id
3847
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3848
-00:00:00 ---äÖüß@µ*$-- 4
3852
Warning 1292 Truncated incorrect time value: ''
3853
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3854
Warning 1292 Truncated incorrect time value: ' ---äÖüß@µ*$-- '
3858
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS TIME),
3859
my_char_30, id FROM t1_values;
3860
SELECT CAST(my_char_30 AS TIME),
3861
my_char_30, id FROM t1_values
3862
WHERE select_id = 48 OR select_id IS NULL order by id;
3863
CAST(my_char_30 AS TIME) my_char_30 id
3866
00:00:00 <--------30 characters-------> 3
3867
-00:00:00 ---äÖüß@µ*$-- 4
3871
Warning 1292 Truncated incorrect time value: ''
3872
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3873
Warning 1292 Truncated incorrect time value: ' ---äÖüß@µ*$--'
3874
SHOW CREATE VIEW v1;
3875
View Create View character_set_client collation_connection
3876
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
3878
WHERE v1.id IN (SELECT id FROM t1_values
3879
WHERE select_id = 48 OR select_id IS NULL) order by id;
3880
CAST(my_char_30 AS TIME) my_char_30 id
3883
00:00:00 <--------30 characters-------> 3
3884
-00:00:00 ---äÖüß@µ*$-- 4
3888
Warning 1292 Truncated incorrect time value: ''
3889
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3890
Warning 1292 Truncated incorrect time value: ' ---äÖüß@µ*$--'
3894
CREATE VIEW v1 AS SELECT CAST(my_year AS DATETIME),
3895
my_year, id FROM t1_values;
3896
SELECT CAST(my_year AS DATETIME),
3897
my_year, id FROM t1_values
3898
WHERE select_id = 47 OR select_id IS NULL order by id;
3899
CAST(my_year AS DATETIME) my_year id
3906
Warning 1292 Incorrect datetime value: '1901'
3907
Warning 1292 Incorrect datetime value: '2155'
3908
Warning 1292 Incorrect datetime value: '2000'
3909
Warning 1292 Incorrect datetime value: '2005'
3910
SHOW CREATE VIEW v1;
3911
View Create View character_set_client collation_connection
3912
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
3914
WHERE v1.id IN (SELECT id FROM t1_values
3915
WHERE select_id = 47 OR select_id IS NULL) order by id;
3916
CAST(my_year AS DATETIME) my_year id
3923
Warning 1292 Incorrect datetime value: '1901'
3924
Warning 1292 Incorrect datetime value: '2155'
3925
Warning 1292 Incorrect datetime value: '2000'
3926
Warning 1292 Incorrect datetime value: '2005'
3930
CREATE VIEW v1 AS SELECT CAST(my_time AS DATETIME),
3931
my_time, id FROM t1_values;
3932
SELECT CAST(my_time AS DATETIME),
3933
my_time, id FROM t1_values
3934
WHERE select_id = 46 OR select_id IS NULL order by id;
3935
CAST(my_time AS DATETIME) my_time id
3937
2009-11-27 01:00:01 -838:59:59 2
3938
2010-02-04 22:59:59 838:59:59 3
3939
2010-01-01 13:00:00 13:00:00 4
3940
2010-01-01 10:00:00 10:00:00 5
3941
SHOW CREATE VIEW v1;
3942
View Create View character_set_client collation_connection
3943
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
3945
WHERE v1.id IN (SELECT id FROM t1_values
3946
WHERE select_id = 46 OR select_id IS NULL) order by id;
3947
CAST(my_time AS DATETIME) my_time id
3949
2009-11-27 01:00:01 -838:59:59 2
3950
2010-02-04 22:59:59 838:59:59 3
3951
2010-01-01 13:00:00 13:00:00 4
3952
2010-01-01 10:00:00 10:00:00 5
3956
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DATETIME),
3957
my_timestamp, id FROM t1_values;
3958
SELECT CAST(my_timestamp AS DATETIME),
3959
my_timestamp, id FROM t1_values
3960
WHERE select_id = 45 OR select_id IS NULL order by id;
3961
CAST(my_timestamp AS DATETIME) my_timestamp id
3962
0000-00-00 00:00:00 0000-00-00 00:00:00 1
3963
1970-01-01 03:00:01 1970-01-01 03:00:01 2
3964
2038-01-01 02:59:59 2038-01-01 02:59:59 3
3965
2004-02-29 23:59:59 2004-02-29 23:59:59 4
3966
2005-06-28 10:00:00 2005-06-28 10:00:00 5
3967
SHOW CREATE VIEW v1;
3968
View Create View character_set_client collation_connection
3969
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
3971
WHERE v1.id IN (SELECT id FROM t1_values
3972
WHERE select_id = 45 OR select_id IS NULL) order by id;
3973
CAST(my_timestamp AS DATETIME) my_timestamp id
3974
0000-00-00 00:00:00 0000-00-00 00:00:00 1
3975
1970-01-01 03:00:01 1970-01-01 03:00:01 2
3976
2038-01-01 02:59:59 2038-01-01 02:59:59 3
3977
2004-02-29 23:59:59 2004-02-29 23:59:59 4
3978
2005-06-28 10:00:00 2005-06-28 10:00:00 5
3982
CREATE VIEW v1 AS SELECT CAST(my_date AS DATETIME),
3983
my_date, id FROM t1_values;
3984
SELECT CAST(my_date AS DATETIME),
3985
my_date, id FROM t1_values
3986
WHERE select_id = 44 OR select_id IS NULL order by id;
3987
CAST(my_date AS DATETIME) my_date id
3989
0001-01-01 00:00:00 0001-01-01 2
3990
9999-12-31 00:00:00 9999-12-31 3
3991
2004-02-29 00:00:00 2004-02-29 4
3992
2005-06-28 00:00:00 2005-06-28 5
3993
SHOW CREATE VIEW v1;
3994
View Create View character_set_client collation_connection
3995
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
3997
WHERE v1.id IN (SELECT id FROM t1_values
3998
WHERE select_id = 44 OR select_id IS NULL) order by id;
3999
CAST(my_date AS DATETIME) my_date id
4001
0001-01-01 00:00:00 0001-01-01 2
4002
9999-12-31 00:00:00 9999-12-31 3
4003
2004-02-29 00:00:00 2004-02-29 4
4004
2005-06-28 00:00:00 2005-06-28 5
4008
CREATE VIEW v1 AS SELECT CAST(my_datetime AS DATETIME),
4009
my_datetime, id FROM t1_values;
4010
SELECT CAST(my_datetime AS DATETIME),
4011
my_datetime, id FROM t1_values
4012
WHERE select_id = 43 OR select_id IS NULL order by id;
4013
CAST(my_datetime AS DATETIME) my_datetime id
4015
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4016
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4017
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4018
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4019
SHOW CREATE VIEW v1;
4020
View Create View character_set_client collation_connection
4021
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
4023
WHERE v1.id IN (SELECT id FROM t1_values
4024
WHERE select_id = 43 OR select_id IS NULL) order by id;
4025
CAST(my_datetime AS DATETIME) my_datetime id
4027
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4028
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4029
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4030
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4034
CREATE VIEW v1 AS SELECT CAST(my_double AS DATETIME),
4035
my_double, id FROM t1_values;
4036
SELECT CAST(my_double AS DATETIME),
4037
my_double, id FROM t1_values
4038
WHERE select_id = 42 OR select_id IS NULL order by id;
4039
CAST(my_double AS DATETIME) my_double id
4041
NULL -1.7976931348623e308 2
4042
NULL 1.7976931348623e308 3
4043
0000-00-00 00:00:00 0 4
4045
NULL 200506271758 19
4047
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4048
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4049
Warning 1292 Incorrect datetime value: '-1'
4050
Warning 1292 Incorrect datetime value: '200506271758'
4051
SHOW CREATE VIEW v1;
4052
View Create View character_set_client collation_connection
4053
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
4055
WHERE v1.id IN (SELECT id FROM t1_values
4056
WHERE select_id = 42 OR select_id IS NULL) order by id;
4057
CAST(my_double AS DATETIME) my_double id
4059
NULL -1.7976931348623e308 2
4060
NULL 1.7976931348623e308 3
4061
0000-00-00 00:00:00 0 4
4063
NULL 200506271758 19
4065
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4066
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4067
Warning 1292 Incorrect datetime value: '-1'
4068
Warning 1292 Incorrect datetime value: '200506271758'
4072
CREATE VIEW v1 AS SELECT CAST(my_bigint AS DATETIME),
4073
my_bigint, id FROM t1_values;
4074
SELECT CAST(my_bigint AS DATETIME),
4075
my_bigint, id FROM t1_values
4076
WHERE select_id = 41 OR select_id IS NULL order by id;
4077
CAST(my_bigint AS DATETIME) my_bigint id
4079
NULL -9223372036854775808 2
4080
NULL 9223372036854775807 3
4081
0000-00-00 00:00:00 0 4
4083
NULL 200506271758 18
4085
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4086
Warning 1292 Incorrect datetime value: '9223372036854775807'
4087
Warning 1292 Incorrect datetime value: '-1'
4088
Warning 1292 Incorrect datetime value: '200506271758'
4089
SHOW CREATE VIEW v1;
4090
View Create View character_set_client collation_connection
4091
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_bigint` as datetime) AS `CAST(my_bigint AS DATETIME)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
4093
WHERE v1.id IN (SELECT id FROM t1_values
4094
WHERE select_id = 41 OR select_id IS NULL) order by id;
4095
CAST(my_bigint AS DATETIME) my_bigint id
4097
NULL -9223372036854775808 2
4098
NULL 9223372036854775807 3
4099
0000-00-00 00:00:00 0 4
4101
NULL 200506271758 18
4103
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4104
Warning 1292 Incorrect datetime value: '9223372036854775807'
4105
Warning 1292 Incorrect datetime value: '-1'
4106
Warning 1292 Incorrect datetime value: '200506271758'
4110
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DATETIME),
4111
my_varbinary_1000, id FROM t1_values;
4112
SELECT CAST(my_varbinary_1000 AS DATETIME),
4113
my_varbinary_1000, id FROM t1_values
4114
WHERE select_id = 40 OR select_id IS NULL order by id;
4115
CAST(my_varbinary_1000 AS DATETIME) my_varbinary_1000 id
4118
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4119
NULL ---äÖüß@µ*$-- 4
4121
2005-06-27 17:58:00 2005-06-27 17:58 17
4123
Warning 1292 Incorrect datetime value: ''
4124
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4125
Warning 1292 Incorrect datetime value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- '
4126
Warning 1292 Incorrect datetime value: '-1'
4127
SHOW CREATE VIEW v1;
4128
View Create View character_set_client collation_connection
4129
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
4131
WHERE v1.id IN (SELECT id FROM t1_values
4132
WHERE select_id = 40 OR select_id IS NULL) order by id;
4133
CAST(my_varbinary_1000 AS DATETIME) my_varbinary_1000 id
4136
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4137
NULL ---äÖüß@µ*$-- 4
4139
2005-06-27 17:58:00 2005-06-27 17:58 17
4141
Warning 1292 Incorrect datetime value: ''
4142
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4143
Warning 1292 Incorrect datetime value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- '
4144
Warning 1292 Incorrect datetime value: '-1'
4148
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DATETIME),
4149
my_binary_30, id FROM t1_values;
4150
SELECT CAST(my_binary_30 AS DATETIME),
4151
my_binary_30, id FROM t1_values
4152
WHERE select_id = 39 OR select_id IS NULL order by id;
4153
CAST(my_binary_30 AS DATETIME) my_binary_30 id
4156
NULL <--------30 characters-------> 3
4157
NULL ---äÖüß@µ*$-- 4
4159
2005-06-27 17:58:00 2005-06-27 17:58 16
4161
Warning 1292 Incorrect datetime value: '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4162
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4163
Warning 1292 Incorrect datetime value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4164
Warning 1292 Incorrect datetime value: '-1\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4165
Warning 1292 Truncated incorrect datetime value: '2005-06-27 17:58\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4166
SHOW CREATE VIEW v1;
4167
View Create View character_set_client collation_connection
4168
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
4170
WHERE v1.id IN (SELECT id FROM t1_values
4171
WHERE select_id = 39 OR select_id IS NULL) order by id;
4172
CAST(my_binary_30 AS DATETIME) my_binary_30 id
4175
NULL <--------30 characters-------> 3
4176
NULL ---äÖüß@µ*$-- 4
4178
2005-06-27 17:58:00 2005-06-27 17:58 16
4180
Warning 1292 Incorrect datetime value: '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4181
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4182
Warning 1292 Incorrect datetime value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4183
Warning 1292 Incorrect datetime value: '-1\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4184
Warning 1292 Truncated incorrect datetime value: '2005-06-27 17:58\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4188
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DATETIME),
4189
my_varchar_1000, id FROM t1_values;
4190
SELECT CAST(my_varchar_1000 AS DATETIME),
4191
my_varchar_1000, id FROM t1_values
4192
WHERE select_id = 38 OR select_id IS NULL order by id;
4193
CAST(my_varchar_1000 AS DATETIME) my_varchar_1000 id
4196
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4197
NULL ---äÖüß@µ*$-- 4
4199
2005-06-27 17:58:00 2005-06-27 17:58 15
4201
Warning 1292 Incorrect datetime value: ''
4202
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4203
Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4204
Warning 1292 Incorrect datetime value: '-1'
4205
SHOW CREATE VIEW v1;
4206
View Create View character_set_client collation_connection
4207
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
4209
WHERE v1.id IN (SELECT id FROM t1_values
4210
WHERE select_id = 38 OR select_id IS NULL) order by id;
4211
CAST(my_varchar_1000 AS DATETIME) my_varchar_1000 id
4214
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4215
NULL ---äÖüß@µ*$-- 4
4217
2005-06-27 17:58:00 2005-06-27 17:58 15
4219
Warning 1292 Incorrect datetime value: ''
4220
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4221
Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4222
Warning 1292 Incorrect datetime value: '-1'
4226
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DATETIME),
4227
my_char_30, id FROM t1_values;
4228
SELECT CAST(my_char_30 AS DATETIME),
4229
my_char_30, id FROM t1_values
4230
WHERE select_id = 37 OR select_id IS NULL order by id;
4231
CAST(my_char_30 AS DATETIME) my_char_30 id
4234
NULL <--------30 characters-------> 3
4235
NULL ---äÖüß@µ*$-- 4
4237
2005-06-27 17:58:00 2005-06-27 17:58 14
4239
Warning 1292 Incorrect datetime value: ''
4240
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4241
Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$--'
4242
Warning 1292 Incorrect datetime value: '-1'
4243
SHOW CREATE VIEW v1;
4244
View Create View character_set_client collation_connection
4245
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
4247
WHERE v1.id IN (SELECT id FROM t1_values
4248
WHERE select_id = 37 OR select_id IS NULL) order by id;
4249
CAST(my_char_30 AS DATETIME) my_char_30 id
4252
NULL <--------30 characters-------> 3
4253
NULL ---äÖüß@µ*$-- 4
4255
2005-06-27 17:58:00 2005-06-27 17:58 14
4257
Warning 1292 Incorrect datetime value: ''
4258
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4259
Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$--'
4260
Warning 1292 Incorrect datetime value: '-1'
4264
CREATE VIEW v1 AS SELECT CAST(my_year AS DATE),
4265
my_year, id FROM t1_values;
4266
SELECT CAST(my_year AS DATE),
4267
my_year, id FROM t1_values
4268
WHERE select_id = 36 OR select_id IS NULL order by id;
4269
CAST(my_year AS DATE) my_year id
4276
Warning 1292 Incorrect datetime value: '1901'
4277
Warning 1292 Incorrect datetime value: '2155'
4278
Warning 1292 Incorrect datetime value: '2000'
4279
Warning 1292 Incorrect datetime value: '2005'
4280
SHOW CREATE VIEW v1;
4281
View Create View character_set_client collation_connection
4282
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
4284
WHERE v1.id IN (SELECT id FROM t1_values
4285
WHERE select_id = 36 OR select_id IS NULL) order by id;
4286
CAST(my_year AS DATE) my_year id
4293
Warning 1292 Incorrect datetime value: '1901'
4294
Warning 1292 Incorrect datetime value: '2155'
4295
Warning 1292 Incorrect datetime value: '2000'
4296
Warning 1292 Incorrect datetime value: '2005'
4300
CREATE VIEW v1 AS SELECT CAST(my_time AS DATE),
4301
my_time, id FROM t1_values;
4302
SELECT CAST(my_time AS DATE),
4303
my_time, id FROM t1_values
4304
WHERE select_id = 35 OR select_id IS NULL order by id;
4305
CAST(my_time AS DATE) my_time id
4307
2009-11-27 -838:59:59 2
4308
2010-02-04 838:59:59 3
4309
2010-01-01 13:00:00 4
4310
2010-01-01 10:00:00 5
4311
SHOW CREATE VIEW v1;
4312
View Create View character_set_client collation_connection
4313
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
4315
WHERE v1.id IN (SELECT id FROM t1_values
4316
WHERE select_id = 35 OR select_id IS NULL) order by id;
4317
CAST(my_time AS DATE) my_time id
4319
2009-11-27 -838:59:59 2
4320
2010-02-04 838:59:59 3
4321
2010-01-01 13:00:00 4
4322
2010-01-01 10:00:00 5
4326
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DATE),
4327
my_timestamp, id FROM t1_values;
4328
SELECT CAST(my_timestamp AS DATE),
4329
my_timestamp, id FROM t1_values
4330
WHERE select_id = 34 OR select_id IS NULL order by id;
4331
CAST(my_timestamp AS DATE) my_timestamp id
4332
0000-00-00 0000-00-00 00:00:00 1
4333
1970-01-01 1970-01-01 03:00:01 2
4334
2038-01-01 2038-01-01 02:59:59 3
4335
2004-02-29 2004-02-29 23:59:59 4
4336
2005-06-28 2005-06-28 10:00:00 5
4337
SHOW CREATE VIEW v1;
4338
View Create View character_set_client collation_connection
4339
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
4341
WHERE v1.id IN (SELECT id FROM t1_values
4342
WHERE select_id = 34 OR select_id IS NULL) order by id;
4343
CAST(my_timestamp AS DATE) my_timestamp id
4344
0000-00-00 0000-00-00 00:00:00 1
4345
1970-01-01 1970-01-01 03:00:01 2
4346
2038-01-01 2038-01-01 02:59:59 3
4347
2004-02-29 2004-02-29 23:59:59 4
4348
2005-06-28 2005-06-28 10:00:00 5
4352
CREATE VIEW v1 AS SELECT CAST(my_date AS DATE),
4353
my_date, id FROM t1_values;
4354
SELECT CAST(my_date AS DATE),
4355
my_date, id FROM t1_values
4356
WHERE select_id = 33 OR select_id IS NULL order by id;
4357
CAST(my_date AS DATE) my_date id
4359
0001-01-01 0001-01-01 2
4360
9999-12-31 9999-12-31 3
4361
2004-02-29 2004-02-29 4
4362
2005-06-28 2005-06-28 5
4363
SHOW CREATE VIEW v1;
4364
View Create View character_set_client collation_connection
4365
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
4367
WHERE v1.id IN (SELECT id FROM t1_values
4368
WHERE select_id = 33 OR select_id IS NULL) order by id;
4369
CAST(my_date AS DATE) my_date id
4371
0001-01-01 0001-01-01 2
4372
9999-12-31 9999-12-31 3
4373
2004-02-29 2004-02-29 4
4374
2005-06-28 2005-06-28 5
4378
CREATE VIEW v1 AS SELECT CAST(my_datetime AS DATE),
4379
my_datetime, id FROM t1_values;
4380
SELECT CAST(my_datetime AS DATE),
4381
my_datetime, id FROM t1_values
4382
WHERE select_id = 32 OR select_id IS NULL order by id;
4383
CAST(my_datetime AS DATE) my_datetime id
4385
0001-01-01 0001-01-01 00:00:00 2
4386
9999-12-31 9999-12-31 23:59:59 3
4387
2004-02-29 2004-02-29 23:59:59 4
4388
2005-06-28 2005-06-28 10:00:00 5
4389
SHOW CREATE VIEW v1;
4390
View Create View character_set_client collation_connection
4391
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
4393
WHERE v1.id IN (SELECT id FROM t1_values
4394
WHERE select_id = 32 OR select_id IS NULL) order by id;
4395
CAST(my_datetime AS DATE) my_datetime id
4397
0001-01-01 0001-01-01 00:00:00 2
4398
9999-12-31 9999-12-31 23:59:59 3
4399
2004-02-29 2004-02-29 23:59:59 4
4400
2005-06-28 2005-06-28 10:00:00 5
4404
CREATE VIEW v1 AS SELECT CAST(my_double AS DATE),
4405
my_double, id FROM t1_values;
4406
SELECT CAST(my_double AS DATE),
4407
my_double, id FROM t1_values
4408
WHERE select_id = 31 OR select_id IS NULL order by id;
4409
CAST(my_double AS DATE) my_double id
4411
NULL -1.7976931348623e308 2
4412
NULL 1.7976931348623e308 3
4415
2005-06-27 20050627 13
4417
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4418
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4419
Warning 1292 Incorrect datetime value: '-1'
4420
SHOW CREATE VIEW v1;
4421
View Create View character_set_client collation_connection
4422
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
4424
WHERE v1.id IN (SELECT id FROM t1_values
4425
WHERE select_id = 31 OR select_id IS NULL) order by id;
4426
CAST(my_double AS DATE) my_double id
4428
NULL -1.7976931348623e308 2
4429
NULL 1.7976931348623e308 3
4432
2005-06-27 20050627 13
4434
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4435
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4436
Warning 1292 Incorrect datetime value: '-1'
4440
CREATE VIEW v1 AS SELECT CAST(my_bigint AS DATE),
4441
my_bigint, id FROM t1_values;
4442
SELECT CAST(my_bigint AS DATE),
4443
my_bigint, id FROM t1_values
4444
WHERE select_id = 30 OR select_id IS NULL order by id;
4445
CAST(my_bigint AS DATE) my_bigint id
4447
NULL -9223372036854775808 2
4448
NULL 9223372036854775807 3
4451
2005-06-27 20050627 12
4453
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4454
Warning 1292 Incorrect datetime value: '9223372036854775807'
4455
Warning 1292 Incorrect datetime value: '-1'
4456
SHOW CREATE VIEW v1;
4457
View Create View character_set_client collation_connection
4458
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
4460
WHERE v1.id IN (SELECT id FROM t1_values
4461
WHERE select_id = 30 OR select_id IS NULL) order by id;
4462
CAST(my_bigint AS DATE) my_bigint id
4464
NULL -9223372036854775808 2
4465
NULL 9223372036854775807 3
4468
2005-06-27 20050627 12
4470
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4471
Warning 1292 Incorrect datetime value: '9223372036854775807'
4472
Warning 1292 Incorrect datetime value: '-1'
4476
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DATE),
4477
my_varbinary_1000, id FROM t1_values;
4478
SELECT CAST(my_varbinary_1000 AS DATE),
4479
my_varbinary_1000, id FROM t1_values
4480
WHERE select_id = 29 OR select_id IS NULL order by id;
4481
CAST(my_varbinary_1000 AS DATE) my_varbinary_1000 id
4484
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4485
NULL ---äÖüß@µ*$-- 4
4487
2005-06-27 2005-06-27 11
4489
Warning 1292 Incorrect datetime value: ''
4490
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4491
Warning 1292 Incorrect datetime value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- '
4492
Warning 1292 Incorrect datetime value: '-1'
4493
SHOW CREATE VIEW v1;
4494
View Create View character_set_client collation_connection
4495
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
4497
WHERE v1.id IN (SELECT id FROM t1_values
4498
WHERE select_id = 29 OR select_id IS NULL) order by id;
4499
CAST(my_varbinary_1000 AS DATE) my_varbinary_1000 id
4502
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4503
NULL ---äÖüß@µ*$-- 4
4505
2005-06-27 2005-06-27 11
4507
Warning 1292 Incorrect datetime value: ''
4508
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4509
Warning 1292 Incorrect datetime value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- '
4510
Warning 1292 Incorrect datetime value: '-1'
4514
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DATE),
4515
my_binary_30, id FROM t1_values;
4516
SELECT CAST(my_binary_30 AS DATE),
4517
my_binary_30, id FROM t1_values
4518
WHERE select_id = 28 OR select_id IS NULL order by id;
4519
CAST(my_binary_30 AS DATE) my_binary_30 id
4522
NULL <--------30 characters-------> 3
4523
NULL ---äÖüß@µ*$-- 4
4525
2005-06-27 2005-06-27 10
4527
Warning 1292 Incorrect datetime value: '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4528
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4529
Warning 1292 Incorrect datetime value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4530
Warning 1292 Incorrect datetime value: '-1\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4531
Warning 1292 Truncated incorrect date value: '2005-06-27\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4532
SHOW CREATE VIEW v1;
4533
View Create View character_set_client collation_connection
4534
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
4536
WHERE v1.id IN (SELECT id FROM t1_values
4537
WHERE select_id = 28 OR select_id IS NULL) order by id;
4538
CAST(my_binary_30 AS DATE) my_binary_30 id
4541
NULL <--------30 characters-------> 3
4542
NULL ---äÖüß@µ*$-- 4
4544
2005-06-27 2005-06-27 10
4546
Warning 1292 Incorrect datetime value: '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4547
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4548
Warning 1292 Incorrect datetime value: ' ---\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$-- \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4549
Warning 1292 Incorrect datetime value: '-1\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4550
Warning 1292 Truncated incorrect date value: '2005-06-27\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'
4554
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DATE),
4555
my_varchar_1000, id FROM t1_values;
4556
SELECT CAST(my_varchar_1000 AS DATE),
4557
my_varchar_1000, id FROM t1_values
4558
WHERE select_id = 27 OR select_id IS NULL order by id;
4559
CAST(my_varchar_1000 AS DATE) my_varchar_1000 id
4562
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4563
NULL ---äÖüß@µ*$-- 4
4565
2005-06-27 2005-06-27 9
4567
Warning 1292 Incorrect datetime value: ''
4568
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4569
Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4570
Warning 1292 Incorrect datetime value: '-1'
4571
SHOW CREATE VIEW v1;
4572
View Create View character_set_client collation_connection
4573
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
4575
WHERE v1.id IN (SELECT id FROM t1_values
4576
WHERE select_id = 27 OR select_id IS NULL) order by id;
4577
CAST(my_varchar_1000 AS DATE) my_varchar_1000 id
4580
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4581
NULL ---äÖüß@µ*$-- 4
4583
2005-06-27 2005-06-27 9
4585
Warning 1292 Incorrect datetime value: ''
4586
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4587
Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4588
Warning 1292 Incorrect datetime value: '-1'
4592
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DATE),
4593
my_char_30, id FROM t1_values;
4594
SELECT CAST(my_char_30 AS DATE),
4595
my_char_30, id FROM t1_values
4596
WHERE select_id = 26 OR select_id IS NULL order by id;
4597
CAST(my_char_30 AS DATE) my_char_30 id
4600
NULL <--------30 characters-------> 3
4601
NULL ---äÖüß@µ*$-- 4
4603
2005-06-27 2005-06-27 8
4605
Warning 1292 Incorrect datetime value: ''
4606
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4607
Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$--'
4608
Warning 1292 Incorrect datetime value: '-1'
4609
SHOW CREATE VIEW v1;
4610
View Create View character_set_client collation_connection
4611
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
4613
WHERE v1.id IN (SELECT id FROM t1_values
4614
WHERE select_id = 26 OR select_id IS NULL) order by id;
4615
CAST(my_char_30 AS DATE) my_char_30 id
4618
NULL <--------30 characters-------> 3
4619
NULL ---äÖüß@µ*$-- 4
4621
2005-06-27 2005-06-27 8
4623
Warning 1292 Incorrect datetime value: ''
4624
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4625
Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$--'
4626
Warning 1292 Incorrect datetime value: '-1'
4630
CREATE VIEW v1 AS SELECT CAST(my_year AS CHAR),
4631
my_year, id FROM t1_values;
4632
SELECT CAST(my_year AS CHAR),
4633
my_year, id FROM t1_values
4634
WHERE select_id = 25 OR select_id IS NULL order by id;
4635
CAST(my_year AS CHAR) my_year id
4641
SHOW CREATE VIEW v1;
4642
View Create View character_set_client collation_connection
4643
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
4645
WHERE v1.id IN (SELECT id FROM t1_values
4646
WHERE select_id = 25 OR select_id IS NULL) order by id;
4647
CAST(my_year AS CHAR) my_year id
4656
CREATE VIEW v1 AS SELECT CAST(my_time AS CHAR),
4657
my_time, id FROM t1_values;
4658
SELECT CAST(my_time AS CHAR),
4659
my_time, id FROM t1_values
4660
WHERE select_id = 24 OR select_id IS NULL order by id;
4661
CAST(my_time AS CHAR) my_time id
4663
-838:59:59 -838:59:59 2
4664
838:59:59 838:59:59 3
4667
SHOW CREATE VIEW v1;
4668
View Create View character_set_client collation_connection
4669
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
4671
WHERE v1.id IN (SELECT id FROM t1_values
4672
WHERE select_id = 24 OR select_id IS NULL) order by id;
4673
CAST(my_time AS CHAR) my_time id
4675
-838:59:59 -838:59:59 2
4676
838:59:59 838:59:59 3
4682
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS CHAR),
4683
my_timestamp, id FROM t1_values;
4684
SELECT CAST(my_timestamp AS CHAR),
4685
my_timestamp, id FROM t1_values
4686
WHERE select_id = 23 OR select_id IS NULL order by id;
4687
CAST(my_timestamp AS CHAR) my_timestamp id
4688
0000-00-00 00:00:00 0000-00-00 00:00:00 1
4689
1970-01-01 03:00:01 1970-01-01 03:00:01 2
4690
2038-01-01 02:59:59 2038-01-01 02:59:59 3
4691
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4692
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4693
SHOW CREATE VIEW v1;
4694
View Create View character_set_client collation_connection
4695
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
4697
WHERE v1.id IN (SELECT id FROM t1_values
4698
WHERE select_id = 23 OR select_id IS NULL) order by id;
4699
CAST(my_timestamp AS CHAR) my_timestamp id
4700
0000-00-00 00:00:00 0000-00-00 00:00:00 1
4701
1970-01-01 03:00:01 1970-01-01 03:00:01 2
4702
2038-01-01 02:59:59 2038-01-01 02:59:59 3
4703
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4704
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4708
CREATE VIEW v1 AS SELECT CAST(my_date AS CHAR),
4709
my_date, id FROM t1_values;
4710
SELECT CAST(my_date AS CHAR),
4711
my_date, id FROM t1_values
4712
WHERE select_id = 22 OR select_id IS NULL order by id;
4713
CAST(my_date AS CHAR) my_date id
4715
0001-01-01 0001-01-01 2
4716
9999-12-31 9999-12-31 3
4717
2004-02-29 2004-02-29 4
4718
2005-06-28 2005-06-28 5
4719
SHOW CREATE VIEW v1;
4720
View Create View character_set_client collation_connection
4721
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
4723
WHERE v1.id IN (SELECT id FROM t1_values
4724
WHERE select_id = 22 OR select_id IS NULL) order by id;
4725
CAST(my_date AS CHAR) my_date id
4727
0001-01-01 0001-01-01 2
4728
9999-12-31 9999-12-31 3
4729
2004-02-29 2004-02-29 4
4730
2005-06-28 2005-06-28 5
4734
CREATE VIEW v1 AS SELECT CAST(my_datetime AS CHAR),
4735
my_datetime, id FROM t1_values;
4736
SELECT CAST(my_datetime AS CHAR),
4737
my_datetime, id FROM t1_values
4738
WHERE select_id = 21 OR select_id IS NULL order by id;
4739
CAST(my_datetime AS CHAR) my_datetime id
4741
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4742
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4743
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4744
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4745
SHOW CREATE VIEW v1;
4746
View Create View character_set_client collation_connection
4747
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
4749
WHERE v1.id IN (SELECT id FROM t1_values
4750
WHERE select_id = 21 OR select_id IS NULL) order by id;
4751
CAST(my_datetime AS CHAR) my_datetime id
4753
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4754
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4755
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4756
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4760
CREATE VIEW v1 AS SELECT CAST(my_double AS CHAR),
4761
my_double, id FROM t1_values;
4762
SELECT CAST(my_double AS CHAR),
4763
my_double, id FROM t1_values
4764
WHERE select_id = 20 OR select_id IS NULL order by id;
4765
CAST(my_double AS CHAR) my_double id
4767
-1.7976931348623e308 -1.7976931348623e308 2
4768
1.7976931348623e308 1.7976931348623e308 3
4771
SHOW CREATE VIEW v1;
4772
View Create View character_set_client collation_connection
4773
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
4775
WHERE v1.id IN (SELECT id FROM t1_values
4776
WHERE select_id = 20 OR select_id IS NULL) order by id;
4777
CAST(my_double AS CHAR) my_double id
4779
-1.7976931348623e308 -1.7976931348623e308 2
4780
1.7976931348623e308 1.7976931348623e308 3
4786
CREATE VIEW v1 AS SELECT CAST(my_decimal AS CHAR),
4787
my_decimal, id FROM t1_values;
4788
SELECT CAST(my_decimal AS CHAR),
4789
my_decimal, id FROM t1_values
4790
WHERE select_id = 19 OR select_id IS NULL order by id;
4791
CAST(my_decimal AS CHAR) my_decimal id
4793
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
4794
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
4795
0.000000000000000000000000000000 0.000000000000000000000000000000 4
4796
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
4797
SHOW CREATE VIEW v1;
4798
View Create View character_set_client collation_connection
4799
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
4801
WHERE v1.id IN (SELECT id FROM t1_values
4802
WHERE select_id = 19 OR select_id IS NULL) order by id;
4803
CAST(my_decimal AS CHAR) my_decimal id
4805
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
4806
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
4807
0.000000000000000000000000000000 0.000000000000000000000000000000 4
4808
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
4812
CREATE VIEW v1 AS SELECT CAST(my_bigint AS CHAR),
4813
my_bigint, id FROM t1_values;
4814
SELECT CAST(my_bigint AS CHAR),
4815
my_bigint, id FROM t1_values
4816
WHERE select_id = 18 OR select_id IS NULL order by id;
4817
CAST(my_bigint AS CHAR) my_bigint id
4819
-9223372036854775808 -9223372036854775808 2
4820
9223372036854775807 9223372036854775807 3
4823
SHOW CREATE VIEW v1;
4824
View Create View character_set_client collation_connection
4825
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
4827
WHERE v1.id IN (SELECT id FROM t1_values
4828
WHERE select_id = 18 OR select_id IS NULL) order by id;
4829
CAST(my_bigint AS CHAR) my_bigint id
4831
-9223372036854775808 -9223372036854775808 2
4832
9223372036854775807 9223372036854775807 3
4838
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS CHAR),
4839
my_varbinary_1000, id FROM t1_values;
4840
SELECT CAST(my_varbinary_1000 AS CHAR),
4841
my_varbinary_1000, id FROM t1_values
4842
WHERE select_id = 17 OR select_id IS NULL order by id;
4843
CAST(my_varbinary_1000 AS CHAR) my_varbinary_1000 id
4846
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4847
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4849
SHOW CREATE VIEW v1;
4850
View Create View character_set_client collation_connection
4851
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
4853
WHERE v1.id IN (SELECT id FROM t1_values
4854
WHERE select_id = 17 OR select_id IS NULL) order by id;
4855
CAST(my_varbinary_1000 AS CHAR) my_varbinary_1000 id
4858
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4859
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4864
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS CHAR),
4865
my_binary_30, id FROM t1_values;
4866
SELECT CAST(my_binary_30 AS CHAR),
4867
my_binary_30, id FROM t1_values
4868
WHERE select_id = 16 OR select_id IS NULL order by id;
4869
CAST(my_binary_30 AS CHAR) my_binary_30 id
4872
<--------30 characters-------> <--------30 characters-------> 3
4873
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4875
SHOW CREATE VIEW v1;
4876
View Create View character_set_client collation_connection
4877
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
4879
WHERE v1.id IN (SELECT id FROM t1_values
4880
WHERE select_id = 16 OR select_id IS NULL) order by id;
4881
CAST(my_binary_30 AS CHAR) my_binary_30 id
4884
<--------30 characters-------> <--------30 characters-------> 3
4885
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4890
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS CHAR),
4891
my_varchar_1000, id FROM t1_values;
4892
SELECT CAST(my_varchar_1000 AS CHAR),
4893
my_varchar_1000, id FROM t1_values
4894
WHERE select_id = 15 OR select_id IS NULL order by id;
4895
CAST(my_varchar_1000 AS CHAR) my_varchar_1000 id
4898
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4899
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4901
SHOW CREATE VIEW v1;
4902
View Create View character_set_client collation_connection
4903
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
4905
WHERE v1.id IN (SELECT id FROM t1_values
4906
WHERE select_id = 15 OR select_id IS NULL) order by id;
4907
CAST(my_varchar_1000 AS CHAR) my_varchar_1000 id
4910
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4911
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4916
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS CHAR),
4917
my_char_30, id FROM t1_values;
4918
SELECT CAST(my_char_30 AS CHAR),
4919
my_char_30, id FROM t1_values
4920
WHERE select_id = 14 OR select_id IS NULL order by id;
4921
CAST(my_char_30 AS CHAR) my_char_30 id
4924
<--------30 characters-------> <--------30 characters-------> 3
4925
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4927
SHOW CREATE VIEW v1;
4928
View Create View character_set_client collation_connection
4929
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
4931
WHERE v1.id IN (SELECT id FROM t1_values
4932
WHERE select_id = 14 OR select_id IS NULL) order by id;
4933
CAST(my_char_30 AS CHAR) my_char_30 id
4936
<--------30 characters-------> <--------30 characters-------> 3
4937
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4942
CREATE VIEW v1 AS SELECT CAST(my_year AS BINARY),
4943
my_year, id FROM t1_values;
4944
SELECT CAST(my_year AS BINARY),
4945
my_year, id FROM t1_values
4946
WHERE select_id = 13 OR select_id IS NULL order by id;
4947
CAST(my_year AS BINARY) my_year id
4953
SHOW CREATE VIEW v1;
4954
View Create View character_set_client collation_connection
4955
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
4957
WHERE v1.id IN (SELECT id FROM t1_values
4958
WHERE select_id = 13 OR select_id IS NULL) order by id;
4959
CAST(my_year AS BINARY) my_year id
4968
CREATE VIEW v1 AS SELECT CAST(my_time AS BINARY),
4969
my_time, id FROM t1_values;
4970
SELECT CAST(my_time AS BINARY),
4971
my_time, id FROM t1_values
4972
WHERE select_id = 12 OR select_id IS NULL order by id;
4973
CAST(my_time AS BINARY) my_time id
4975
-838:59:59 -838:59:59 2
4976
838:59:59 838:59:59 3
4979
SHOW CREATE VIEW v1;
4980
View Create View character_set_client collation_connection
4981
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
4983
WHERE v1.id IN (SELECT id FROM t1_values
4984
WHERE select_id = 12 OR select_id IS NULL) order by id;
4985
CAST(my_time AS BINARY) my_time id
4987
-838:59:59 -838:59:59 2
4988
838:59:59 838:59:59 3
4994
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS BINARY),
4995
my_timestamp, id FROM t1_values;
4996
SELECT CAST(my_timestamp AS BINARY),
4997
my_timestamp, id FROM t1_values
4998
WHERE select_id = 11 OR select_id IS NULL order by id;
4999
CAST(my_timestamp AS BINARY) my_timestamp id
5000
0000-00-00 00:00:00 0000-00-00 00:00:00 1
5001
1970-01-01 03:00:01 1970-01-01 03:00:01 2
5002
2038-01-01 02:59:59 2038-01-01 02:59:59 3
5003
2004-02-29 23:59:59 2004-02-29 23:59:59 4
5004
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5005
SHOW CREATE VIEW v1;
5006
View Create View character_set_client collation_connection
5007
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
5009
WHERE v1.id IN (SELECT id FROM t1_values
5010
WHERE select_id = 11 OR select_id IS NULL) order by id;
5011
CAST(my_timestamp AS BINARY) my_timestamp id
5012
0000-00-00 00:00:00 0000-00-00 00:00:00 1
5013
1970-01-01 03:00:01 1970-01-01 03:00:01 2
5014
2038-01-01 02:59:59 2038-01-01 02:59:59 3
5015
2004-02-29 23:59:59 2004-02-29 23:59:59 4
5016
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5020
CREATE VIEW v1 AS SELECT CAST(my_date AS BINARY),
5021
my_date, id FROM t1_values;
5022
SELECT CAST(my_date AS BINARY),
5023
my_date, id FROM t1_values
5024
WHERE select_id = 10 OR select_id IS NULL order by id;
5025
CAST(my_date AS BINARY) my_date id
5027
0001-01-01 0001-01-01 2
5028
9999-12-31 9999-12-31 3
5029
2004-02-29 2004-02-29 4
5030
2005-06-28 2005-06-28 5
5031
SHOW CREATE VIEW v1;
5032
View Create View character_set_client collation_connection
5033
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
5035
WHERE v1.id IN (SELECT id FROM t1_values
5036
WHERE select_id = 10 OR select_id IS NULL) order by id;
5037
CAST(my_date AS BINARY) my_date id
5039
0001-01-01 0001-01-01 2
5040
9999-12-31 9999-12-31 3
5041
2004-02-29 2004-02-29 4
5042
2005-06-28 2005-06-28 5
5046
CREATE VIEW v1 AS SELECT CAST(my_datetime AS BINARY),
5047
my_datetime, id FROM t1_values;
5048
SELECT CAST(my_datetime AS BINARY),
5049
my_datetime, id FROM t1_values
5050
WHERE select_id = 9 OR select_id IS NULL order by id;
5051
CAST(my_datetime AS BINARY) my_datetime id
5053
0001-01-01 00:00:00 0001-01-01 00:00:00 2
5054
9999-12-31 23:59:59 9999-12-31 23:59:59 3
5055
2004-02-29 23:59:59 2004-02-29 23:59:59 4
5056
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5057
SHOW CREATE VIEW v1;
5058
View Create View character_set_client collation_connection
5059
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
5061
WHERE v1.id IN (SELECT id FROM t1_values
5062
WHERE select_id = 9 OR select_id IS NULL) order by id;
5063
CAST(my_datetime AS BINARY) my_datetime id
5065
0001-01-01 00:00:00 0001-01-01 00:00:00 2
5066
9999-12-31 23:59:59 9999-12-31 23:59:59 3
5067
2004-02-29 23:59:59 2004-02-29 23:59:59 4
5068
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5072
CREATE VIEW v1 AS SELECT CAST(my_double AS BINARY),
5073
my_double, id FROM t1_values;
5074
SELECT CAST(my_double AS BINARY),
5075
my_double, id FROM t1_values
5076
WHERE select_id = 8 OR select_id IS NULL order by id;
5077
CAST(my_double AS BINARY) my_double id
5079
-1.7976931348623e308 -1.7976931348623e308 2
5080
1.7976931348623e308 1.7976931348623e308 3
5083
SHOW CREATE VIEW v1;
5084
View Create View character_set_client collation_connection
5085
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
5087
WHERE v1.id IN (SELECT id FROM t1_values
5088
WHERE select_id = 8 OR select_id IS NULL) order by id;
5089
CAST(my_double AS BINARY) my_double id
5091
-1.7976931348623e308 -1.7976931348623e308 2
5092
1.7976931348623e308 1.7976931348623e308 3
5098
CREATE VIEW v1 AS SELECT CAST(my_decimal AS BINARY),
5099
my_decimal, id FROM t1_values;
5100
SELECT CAST(my_decimal AS BINARY),
5101
my_decimal, id FROM t1_values
5102
WHERE select_id = 7 OR select_id IS NULL order by id;
5103
CAST(my_decimal AS BINARY) my_decimal id
5105
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
5106
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
5107
0.000000000000000000000000000000 0.000000000000000000000000000000 4
5108
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
5109
SHOW CREATE VIEW v1;
5110
View Create View character_set_client collation_connection
5111
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
5113
WHERE v1.id IN (SELECT id FROM t1_values
5114
WHERE select_id = 7 OR select_id IS NULL) order by id;
5115
CAST(my_decimal AS BINARY) my_decimal id
5117
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
5118
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
5119
0.000000000000000000000000000000 0.000000000000000000000000000000 4
5120
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
5124
CREATE VIEW v1 AS SELECT CAST(my_bigint AS BINARY),
5125
my_bigint, id FROM t1_values;
5126
SELECT CAST(my_bigint AS BINARY),
5127
my_bigint, id FROM t1_values
5128
WHERE select_id = 6 OR select_id IS NULL order by id;
5129
CAST(my_bigint AS BINARY) my_bigint id
5131
-9223372036854775808 -9223372036854775808 2
5132
9223372036854775807 9223372036854775807 3
5135
SHOW CREATE VIEW v1;
5136
View Create View character_set_client collation_connection
5137
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
5139
WHERE v1.id IN (SELECT id FROM t1_values
5140
WHERE select_id = 6 OR select_id IS NULL) order by id;
5141
CAST(my_bigint AS BINARY) my_bigint id
5143
-9223372036854775808 -9223372036854775808 2
5144
9223372036854775807 9223372036854775807 3
5150
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS BINARY),
5151
my_varbinary_1000, id FROM t1_values;
5152
SELECT CAST(my_varbinary_1000 AS BINARY),
5153
my_varbinary_1000, id FROM t1_values
5154
WHERE select_id = 5 OR select_id IS NULL order by id;
5155
CAST(my_varbinary_1000 AS BINARY) my_varbinary_1000 id
5158
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5159
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5161
SHOW CREATE VIEW v1;
5162
View Create View character_set_client collation_connection
5163
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
5165
WHERE v1.id IN (SELECT id FROM t1_values
5166
WHERE select_id = 5 OR select_id IS NULL) order by id;
5167
CAST(my_varbinary_1000 AS BINARY) my_varbinary_1000 id
5170
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5171
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5176
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS BINARY),
5177
my_binary_30, id FROM t1_values;
5178
SELECT CAST(my_binary_30 AS BINARY),
5179
my_binary_30, id FROM t1_values
5180
WHERE select_id = 4 OR select_id IS NULL order by id;
5181
CAST(my_binary_30 AS BINARY) my_binary_30 id
5184
<--------30 characters-------> <--------30 characters-------> 3
5185
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5187
SHOW CREATE VIEW v1;
5188
View Create View character_set_client collation_connection
5189
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
5191
WHERE v1.id IN (SELECT id FROM t1_values
5192
WHERE select_id = 4 OR select_id IS NULL) order by id;
5193
CAST(my_binary_30 AS BINARY) my_binary_30 id
5196
<--------30 characters-------> <--------30 characters-------> 3
5197
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5202
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS BINARY),
5203
my_varchar_1000, id FROM t1_values;
5204
SELECT CAST(my_varchar_1000 AS BINARY),
5205
my_varchar_1000, id FROM t1_values
5206
WHERE select_id = 3 OR select_id IS NULL order by id;
5207
CAST(my_varchar_1000 AS BINARY) my_varchar_1000 id
5210
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5211
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5213
SHOW CREATE VIEW v1;
5214
View Create View character_set_client collation_connection
5215
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
5217
WHERE v1.id IN (SELECT id FROM t1_values
5218
WHERE select_id = 3 OR select_id IS NULL) order by id;
5219
CAST(my_varchar_1000 AS BINARY) my_varchar_1000 id
5222
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5223
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5228
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS BINARY),
5229
my_char_30, id FROM t1_values;
5230
SELECT CAST(my_char_30 AS BINARY),
5231
my_char_30, id FROM t1_values
5232
WHERE select_id = 2 OR select_id IS NULL order by id;
5233
CAST(my_char_30 AS BINARY) my_char_30 id
5236
<--------30 characters-------> <--------30 characters-------> 3
5237
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5239
SHOW CREATE VIEW v1;
5240
View Create View character_set_client collation_connection
5241
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
5243
WHERE v1.id IN (SELECT id FROM t1_values
5244
WHERE select_id = 2 OR select_id IS NULL) order by id;
5245
CAST(my_char_30 AS BINARY) my_char_30 id
5248
<--------30 characters-------> <--------30 characters-------> 3
5249
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5254
CREATE VIEW v1 AS SELECT sqrt(my_bigint), my_bigint, id FROM t1_values;
5255
SELECT sqrt(my_bigint), my_bigint, id FROM t1_values
5256
WHERE select_id = 1 OR select_id IS NULL order by id;
5257
sqrt(my_bigint) my_bigint id
5259
NULL -9223372036854775808 2
5260
3037000499.97605 9223372036854775807 3
5265
SHOW CREATE VIEW v1;
5266
View Create View character_set_client collation_connection
5267
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
5269
WHERE v1.id IN (SELECT id FROM t1_values
5270
WHERE select_id = 1 OR select_id IS NULL) order by id;
5271
sqrt(my_bigint) my_bigint id
5273
NULL -9223372036854775808 2
5274
3037000499.97605 9223372036854775807 3
5282
DROP TABLE t1_selects, t1_modes, t1_values;
added
removed
mysql-test/suite/funcs_1/r/myisam_func_view.result
