1
SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
2
DROP TABLE IF EXISTS t1_selects, t1_modes, t1_values;
3
DROP VIEW IF EXISTS v1;
6
id BIGINT AUTO_INCREMENT,
9
) ENGINE = <engine_to_be_tested>;
10
ALTER TABLE t1_values ADD my_char_30 CHAR(30);
11
ALTER TABLE t1_values ADD my_varchar_1000 VARCHAR(1000);
12
ALTER TABLE t1_values ADD my_binary_30 BINARY(30);
13
ALTER TABLE t1_values ADD my_varbinary_1000 VARBINARY(1000);
14
ALTER TABLE t1_values ADD my_datetime DATETIME;
15
ALTER TABLE t1_values ADD my_date DATE;
16
ALTER TABLE t1_values ADD ts_dummy TIMESTAMP;
17
ALTER TABLE t1_values ADD my_timestamp TIMESTAMP;
18
ALTER TABLE t1_values ADD my_time TIME;
19
ALTER TABLE t1_values ADD my_year YEAR;
20
ALTER TABLE t1_values ADD my_bigint BIGINT;
21
ALTER TABLE t1_values ADD my_double DOUBLE;
22
ALTER TABLE t1_values ADD my_decimal DECIMAL(64,30);
23
SET sql_mode = 'traditional';
24
INSERT INTO t1_values SET id = 0;
25
INSERT INTO t1_values SET
29
my_varbinary_1000 = '',
30
my_datetime = '0001-01-01 00:00:00',
31
my_date = '0001-01-01',
32
my_timestamp = '1970-01-01 03:00:01',
33
my_time = '-838:59:59',
35
my_bigint = -9223372036854775808,
36
my_decimal = -9999999999999999999999999999999999.999999999999999999999999999999 ,
37
my_double = -1.7976931348623E+308;
38
INSERT INTO t1_values SET
39
my_char_30 = '<--------30 characters------->',
40
my_varchar_1000 = CONCAT('<---------1000 characters',
41
RPAD('',965,'-'),'--------->'),
42
my_binary_30 = '<--------30 characters------->',
43
my_varbinary_1000 = CONCAT('<---------1000 characters',
44
RPAD('',965,'-'),'--------->'),
45
my_datetime = '9999-12-31 23:59:59',
46
my_date = '9999-12-31',
47
my_timestamp = '2038-01-01 02:59:59',
48
my_time = '838:59:59',
50
my_bigint = 9223372036854775807,
51
my_decimal = +9999999999999999999999999999999999.999999999999999999999999999999 ,
52
my_double = 1.7976931348623E+308;
53
INSERT INTO t1_values SET
54
my_char_30 = ' ---äÖüß@µ*$-- ',
55
my_varchar_1000 = ' ---äÖüß@µ*$-- ',
56
my_binary_30 = ' ---äÖüß@µ*$-- ',
57
my_varbinary_1000 = ' ---äÖüß@µ*$-- ',
58
my_datetime = '2004-02-29 23:59:59',
59
my_date = '2004-02-29',
60
my_timestamp = '2004-02-29 23:59:59',
66
INSERT INTO t1_values SET
68
my_varchar_1000 = '-1',
70
my_varbinary_1000 = '-1',
71
my_datetime = '2005-06-28 10:00:00',
72
my_date = '2005-06-28',
73
my_timestamp = '2005-06-28 10:00:00',
77
my_decimal = -1.000000000000000000000000000000,
79
PREPARE ins_sel_with_result FROM "INSERT INTO t1_selects SET my_select = @my_select,
80
disable_result = 'No'" ;
81
PREPARE ins_sel_no_result FROM "INSERT INTO t1_selects SET my_select = @my_select,
82
disable_result = 'Yes'" ;
83
SET sql_mode = 'traditional';
84
SET @my_select = 'SELECT sqrt(my_bigint), my_bigint, id FROM t1_values';
85
INSERT INTO t1_values SET select_id = @select_id,
87
INSERT INTO t1_values SET select_id = @select_id,
89
##### 1.1.1. CAST --> BINARY
90
##### 1.1.2. CAST --> CHAR
91
##### 1.1.3. CAST --> DATE
92
INSERT INTO t1_values SET select_id = @select_id,
93
my_char_30 = '2005-06-27';
94
INSERT INTO t1_values SET select_id = @select_id,
95
my_varchar_1000 = '2005-06-27';
96
INSERT INTO t1_values SET select_id = @select_id,
97
my_binary_30 = '2005-06-27';
98
INSERT INTO t1_values SET select_id = @select_id,
99
my_varbinary_1000 = '2005-06-27';
100
INSERT INTO t1_values SET select_id = @select_id,
101
my_bigint = 20050627;
102
INSERT INTO t1_values SET select_id = @select_id,
103
my_double = +20.050627E+6;
104
##### 1.1.4. CAST --> DATETIME
105
INSERT INTO t1_values SET select_id = @select_id,
106
my_char_30 = '2005-06-27 17:58';
107
INSERT INTO t1_values SET select_id = @select_id,
108
my_varchar_1000 = '2005-06-27 17:58';
109
INSERT INTO t1_values SET select_id = @select_id,
110
my_binary_30 = '2005-06-27 17:58';
111
INSERT INTO t1_values SET select_id = @select_id,
112
my_varbinary_1000 = '2005-06-27 17:58';
113
INSERT INTO t1_values SET select_id = @select_id,
114
my_bigint = 200506271758;
115
INSERT INTO t1_values SET select_id = @select_id,
116
my_double = +0.0200506271758E+13;
117
##### 1.1.5. CAST --> TIME
118
INSERT INTO t1_values SET select_id = @select_id,
119
my_char_30 = '1 17:58';
120
INSERT INTO t1_values SET select_id = @select_id,
121
my_varchar_1000 = '1 17:58';
122
INSERT INTO t1_values SET select_id = @select_id,
123
my_binary_30 = '1 17:58';
124
INSERT INTO t1_values SET select_id = @select_id,
125
my_varbinary_1000 = '1 17:58';
126
INSERT INTO t1_values SET select_id = @select_id,
128
INSERT INTO t1_values SET select_id = @select_id,
129
my_double = +1.758E+3;
130
##### 1.1.6. CAST --> DECIMAL
131
INSERT INTO t1_values SET select_id = @select_id,
132
my_char_30 = '-3333.3333';
133
INSERT INTO t1_values SET select_id = @select_id,
134
my_varchar_1000 = '-3333.3333';
135
INSERT INTO t1_values SET select_id = @select_id,
136
my_binary_30 = '-3333.3333';
137
INSERT INTO t1_values SET select_id = @select_id,
138
my_varbinary_1000 = '-3333.3333';
139
INSERT INTO t1_values SET select_id = @select_id,
140
my_double = -0.33333333E+4;
141
##### 1.1.7. CAST --> SIGNED INTEGER
143
"Attention: CAST --> SIGNED INTEGER
144
Bug#5913 Traditional mode: BIGINT range not correctly delimited
145
Status: To be fixed later"
146
--------------------------------------------------------------------------------
147
##### 1.1.8. CAST --> UNSIGNED INTEGER
149
"Attention: CAST --> UNSIGNED INTEGER
150
The file with expected results suffers from Bug 5913"
151
--------------------------------------------------------------------------------
153
some statements disabled because of
154
Bug#5913 Traditional mode: BIGINT range not correctly delimited
155
--------------------------------------------------------------------------------
156
SET @my_select = 'SELECT CONVERT(my_char_30 USING utf8),
157
my_char_30, id FROM t1_values';
158
SET @my_select = 'SELECT CONVERT(my_varchar_1000 USING utf8),
159
my_varchar_1000, id FROM t1_values';
160
SET @my_select = 'SELECT CONVERT(my_binary_30 USING utf8),
161
my_binary_30, id FROM t1_values';
162
SET @my_select = 'SELECT CONVERT(my_varbinary_1000 USING utf8),
163
my_varbinary_1000, id FROM t1_values';
164
SET @my_select = 'SELECT CONVERT(my_char_30 USING koi8r),
165
my_char_30, id FROM t1_values';
166
SET @my_select = 'SELECT CONVERT(my_varchar_1000 USING koi8r),
167
my_varchar_1000, id FROM t1_values';
168
SET @my_select = 'SELECT CONVERT(my_binary_30 USING koi8r),
169
my_binary_30, id FROM t1_values';
170
SET @my_select = 'SELECT CONVERT(my_varbinary_1000 USING koi8r),
171
my_varbinary_1000, id FROM t1_values';
172
SET @my_select = 'SELECT BIT_LENGTH(my_char_30),
173
my_char_30, id FROM t1_values';
174
SET @my_select = 'SELECT BIT_LENGTH(my_varchar_1000),
175
my_varchar_1000, id FROM t1_values';
176
SET @my_select = 'SELECT BIT_LENGTH(my_binary_30),
177
my_binary_30, id FROM t1_values';
178
SET @my_select = 'SELECT BIT_LENGTH(my_varbinary_1000),
179
my_varbinary_1000, id FROM t1_values';
180
SET @my_select = 'SELECT INSTR(my_char_30, ''char''),
181
my_char_30, id FROM t1_values';
182
SET @my_select = 'SELECT LCASE(my_varchar_1000),
183
my_varchar_1000, id FROM t1_values';
185
'SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values';
187
'SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values';
189
'SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values';
191
'SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values';
193
'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_bigint), my_bigint, id FROM t1_values';
195
'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_decimal), my_decimal, id FROM t1_values';
197
'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_double), my_double, id FROM t1_values';
198
SET @my_select = 'SELECT LENGTH(my_char_30),
199
my_char_30, id FROM t1_values';
200
SET @my_select = 'SELECT LENGTH(my_varchar_1000),
201
my_varchar_1000, id FROM t1_values';
202
SET @my_select = 'SELECT LENGTH(my_binary_30),
203
my_binary_30, id FROM t1_values';
204
SET @my_select = 'SELECT LENGTH(my_varbinary_1000),
205
my_varbinary_1000, id FROM t1_values';
207
'SELECT LOAD_FILE(''<MYSQLTEST_VARDIR>/std_data/funcs_1/load_file.txt'')
210
SET @my_select = 'SELECT LOCATE(''char'', my_char_30),
211
my_char_30, id FROM t1_values';
212
SET @my_select = 'SELECT LOCATE(''char'', my_varchar_1000),
213
my_varchar_1000, id FROM t1_values';
214
SET @my_select = 'SELECT LOCATE(''char'', my_binary_30),
215
my_binary_30, id FROM t1_values';
216
SET @my_select = 'SELECT LOCATE(''char'', my_varbinary_1000),
217
my_varbinary_1000, id FROM t1_values';
218
SET @my_select = 'SELECT LOCATE(my_char_30, my_char_30 ),
219
my_char_30, id FROM t1_values';
220
SET @my_select = 'SELECT LOCATE(my_char_30, my_varchar_1000 ),
221
my_char_30, my_varchar_1000 id FROM t1_values';
222
SET @my_select = 'SELECT LOCATE(my_char_30, my_binary_30 ),
223
my_char_30, my_binary_30 id FROM t1_values';
224
SET @my_select = 'SELECT LOCATE(my_char_30, my_varbinary_1000 ),
225
my_char_30, my_varbinary_1000 id FROM t1_values';
226
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
227
my_varchar_1000, id FROM t1_values';
228
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_char_30 ),
229
my_varchar_1000, my_char_30 id FROM t1_values';
230
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_binary_30 ),
231
my_varchar_1000, my_binary_30 id FROM t1_values';
232
SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
233
my_varchar_1000, my_varbinary_1000 id FROM t1_values';
234
SET @my_select = 'SELECT LOCATE(my_binary_30, my_binary_30 ),
235
my_binary_30, id FROM t1_values';
236
SET @my_select = 'SELECT LOCATE(my_binary_30, my_char_30 ),
237
my_binary_30, my_char_30 id FROM t1_values';
238
SET @my_select = 'SELECT LOCATE(my_binary_30, my_varchar_1000 ),
239
my_binary_30, my_varchar_1000 id FROM t1_values';
240
SET @my_select = 'SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
241
my_binary_30, my_varbinary_1000 id FROM t1_values';
242
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
243
my_varbinary_1000, id FROM t1_values';
244
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_char_30 ),
245
my_varbinary_1000, my_char_30 id FROM t1_values';
246
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
247
my_varbinary_1000, my_varchar_1000 id FROM t1_values';
248
SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
249
my_varbinary_1000, my_binary_30 id FROM t1_values';
250
SET @my_select = 'SELECT LOCATE(''-'', my_char_30, 3),
251
my_char_30, id FROM t1_values';
252
SET @my_select = 'SELECT LOCATE(''-'', my_varchar_1000, 3),
253
my_varchar_1000, id FROM t1_values';
254
SET @my_select = 'SELECT LOCATE(''-'', my_binary_30, 3),
255
my_binary_30, id FROM t1_values';
256
SET @my_select = 'SELECT LOCATE(''-'', my_varbinary_1000, 3),
257
my_varbinary_1000, id FROM t1_values';
258
SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_bigint),
259
my_bigint, id FROM t1_values';
260
SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_double),
261
my_double, id FROM t1_values';
262
SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_decimal),
263
my_decimal, id FROM t1_values';
264
SET @my_select = 'SELECT LOWER(my_char_30),
265
my_char_30, id FROM t1_values';
266
SET @my_select = 'SELECT LOWER(my_varchar_1000),
267
my_varchar_1000, id FROM t1_values';
268
SET @my_select = 'SELECT LOWER(my_binary_30),
269
my_binary_30, id FROM t1_values';
270
SET @my_select = 'SELECT LOWER(my_varbinary_1000),
271
my_varbinary_1000, id FROM t1_values';
272
SET @my_select = 'SELECT LTRIM(my_char_30),
273
my_char_30, id FROM t1_values';
274
SET @my_select = 'SELECT LTRIM(my_varchar_1000),
275
my_varchar_1000, id FROM t1_values';
276
SET @my_select = 'SELECT LTRIM(my_binary_30),
277
my_binary_30, id FROM t1_values';
278
SET @my_select = 'SELECT LTRIM(my_varbinary_1000),
279
my_varbinary_1000, id FROM t1_values';
281
'SELECT CONCAT(''A'',my_char_30), my_char_30, id FROM t1_values';
282
SET @my_select = 'SELECT my_char_30, id FROM t1_values';
283
INSERT INTO t1_values SET select_id = @select_id,
284
my_char_30 = 'Viana do Castelo';
287
"# The basic preparations end and the main test starts here"
288
--------------------------------------------------------------------------------
289
CREATE VIEW v1 AS SELECT my_char_30, id FROM t1_values;
290
SELECT my_char_30, id FROM t1_values
291
WHERE select_id = 193 OR select_id IS NULL order by id;
293
View Create View character_set_client collation_connection
294
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
296
WHERE v1.id IN (SELECT id FROM t1_values
297
WHERE select_id = 193 OR select_id IS NULL) order by id;
301
CREATE VIEW v1 AS SELECT CONCAT('A',my_char_30), my_char_30, id FROM t1_values;
302
SELECT CONCAT('A',my_char_30), my_char_30, id FROM t1_values
303
WHERE select_id = 192 OR select_id IS NULL order by id;
304
CONCAT('A',my_char_30) my_char_30 id
307
A<--------30 characters-------> <--------30 characters-------> 3
308
A ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
311
View Create View character_set_client collation_connection
312
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
314
WHERE v1.id IN (SELECT id FROM t1_values
315
WHERE select_id = 192 OR select_id IS NULL) order by id;
316
CONCAT('A',my_char_30) my_char_30 id
319
A<--------30 characters-------> <--------30 characters-------> 3
320
A ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
325
CREATE VIEW v1 AS SELECT LTRIM(my_varbinary_1000),
326
my_varbinary_1000, id FROM t1_values;
327
SELECT LTRIM(my_varbinary_1000),
328
my_varbinary_1000, id FROM t1_values
329
WHERE select_id = 191 OR select_id IS NULL order by id;
331
View Create View character_set_client collation_connection
332
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
334
WHERE v1.id IN (SELECT id FROM t1_values
335
WHERE select_id = 191 OR select_id IS NULL) order by id;
339
CREATE VIEW v1 AS SELECT LTRIM(my_binary_30),
340
my_binary_30, id FROM t1_values;
341
SELECT LTRIM(my_binary_30),
342
my_binary_30, id FROM t1_values
343
WHERE select_id = 190 OR select_id IS NULL order by id;
345
View Create View character_set_client collation_connection
346
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
348
WHERE v1.id IN (SELECT id FROM t1_values
349
WHERE select_id = 190 OR select_id IS NULL) order by id;
353
CREATE VIEW v1 AS SELECT LTRIM(my_varchar_1000),
354
my_varchar_1000, id FROM t1_values;
355
SELECT LTRIM(my_varchar_1000),
356
my_varchar_1000, id FROM t1_values
357
WHERE select_id = 189 OR select_id IS NULL order by id;
359
View Create View character_set_client collation_connection
360
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
362
WHERE v1.id IN (SELECT id FROM t1_values
363
WHERE select_id = 189 OR select_id IS NULL) order by id;
367
CREATE VIEW v1 AS SELECT LTRIM(my_char_30),
368
my_char_30, id FROM t1_values;
369
SELECT LTRIM(my_char_30),
370
my_char_30, id FROM t1_values
371
WHERE select_id = 188 OR select_id IS NULL order by id;
373
View Create View character_set_client collation_connection
374
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
376
WHERE v1.id IN (SELECT id FROM t1_values
377
WHERE select_id = 188 OR select_id IS NULL) order by id;
381
CREATE VIEW v1 AS SELECT LOWER(my_varbinary_1000),
382
my_varbinary_1000, id FROM t1_values;
383
SELECT LOWER(my_varbinary_1000),
384
my_varbinary_1000, id FROM t1_values
385
WHERE select_id = 187 OR select_id IS NULL order by id;
387
View Create View character_set_client collation_connection
388
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
390
WHERE v1.id IN (SELECT id FROM t1_values
391
WHERE select_id = 187 OR select_id IS NULL) order by id;
395
CREATE VIEW v1 AS SELECT LOWER(my_binary_30),
396
my_binary_30, id FROM t1_values;
397
SELECT LOWER(my_binary_30),
398
my_binary_30, id FROM t1_values
399
WHERE select_id = 186 OR select_id IS NULL order by id;
401
View Create View character_set_client collation_connection
402
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
404
WHERE v1.id IN (SELECT id FROM t1_values
405
WHERE select_id = 186 OR select_id IS NULL) order by id;
409
CREATE VIEW v1 AS SELECT LOWER(my_varchar_1000),
410
my_varchar_1000, id FROM t1_values;
411
SELECT LOWER(my_varchar_1000),
412
my_varchar_1000, id FROM t1_values
413
WHERE select_id = 185 OR select_id IS NULL order by id;
415
View Create View character_set_client collation_connection
416
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
418
WHERE v1.id IN (SELECT id FROM t1_values
419
WHERE select_id = 185 OR select_id IS NULL) order by id;
423
CREATE VIEW v1 AS SELECT LOWER(my_char_30),
424
my_char_30, id FROM t1_values;
425
SELECT LOWER(my_char_30),
426
my_char_30, id FROM t1_values
427
WHERE select_id = 184 OR select_id IS NULL order by id;
429
View Create View character_set_client collation_connection
430
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
432
WHERE v1.id IN (SELECT id FROM t1_values
433
WHERE select_id = 184 OR select_id IS NULL) order by id;
437
CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_decimal),
438
my_decimal, id FROM t1_values;
439
SELECT LOCATE('-', ' - -ABC', my_decimal),
440
my_decimal, id FROM t1_values
441
WHERE select_id = 183 OR select_id IS NULL order by id;
443
View Create View character_set_client collation_connection
444
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
446
WHERE v1.id IN (SELECT id FROM t1_values
447
WHERE select_id = 183 OR select_id IS NULL) order by id;
451
CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_double),
452
my_double, id FROM t1_values;
453
SELECT LOCATE('-', ' - -ABC', my_double),
454
my_double, id FROM t1_values
455
WHERE select_id = 182 OR select_id IS NULL order by id;
457
View Create View character_set_client collation_connection
458
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
460
WHERE v1.id IN (SELECT id FROM t1_values
461
WHERE select_id = 182 OR select_id IS NULL) order by id;
465
CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_bigint),
466
my_bigint, id FROM t1_values;
467
SELECT LOCATE('-', ' - -ABC', my_bigint),
468
my_bigint, id FROM t1_values
469
WHERE select_id = 181 OR select_id IS NULL order by id;
471
View Create View character_set_client collation_connection
472
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
474
WHERE v1.id IN (SELECT id FROM t1_values
475
WHERE select_id = 181 OR select_id IS NULL) order by id;
479
CREATE VIEW v1 AS SELECT LOCATE('-', my_varbinary_1000, 3),
480
my_varbinary_1000, id FROM t1_values;
481
SELECT LOCATE('-', my_varbinary_1000, 3),
482
my_varbinary_1000, id FROM t1_values
483
WHERE select_id = 180 OR select_id IS NULL order by id;
485
View Create View character_set_client collation_connection
486
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
488
WHERE v1.id IN (SELECT id FROM t1_values
489
WHERE select_id = 180 OR select_id IS NULL) order by id;
493
CREATE VIEW v1 AS SELECT LOCATE('-', my_binary_30, 3),
494
my_binary_30, id FROM t1_values;
495
SELECT LOCATE('-', my_binary_30, 3),
496
my_binary_30, id FROM t1_values
497
WHERE select_id = 179 OR select_id IS NULL order by id;
499
View Create View character_set_client collation_connection
500
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
502
WHERE v1.id IN (SELECT id FROM t1_values
503
WHERE select_id = 179 OR select_id IS NULL) order by id;
507
CREATE VIEW v1 AS SELECT LOCATE('-', my_varchar_1000, 3),
508
my_varchar_1000, id FROM t1_values;
509
SELECT LOCATE('-', my_varchar_1000, 3),
510
my_varchar_1000, id FROM t1_values
511
WHERE select_id = 178 OR select_id IS NULL order by id;
513
View Create View character_set_client collation_connection
514
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
516
WHERE v1.id IN (SELECT id FROM t1_values
517
WHERE select_id = 178 OR select_id IS NULL) order by id;
521
CREATE VIEW v1 AS SELECT LOCATE('-', my_char_30, 3),
522
my_char_30, id FROM t1_values;
523
SELECT LOCATE('-', my_char_30, 3),
524
my_char_30, id FROM t1_values
525
WHERE select_id = 177 OR select_id IS NULL order by id;
527
View Create View character_set_client collation_connection
528
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
530
WHERE v1.id IN (SELECT id FROM t1_values
531
WHERE select_id = 177 OR select_id IS NULL) order by id;
535
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
536
my_varbinary_1000, my_binary_30 id FROM t1_values;
537
SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
538
my_varbinary_1000, my_binary_30 id FROM t1_values
539
WHERE select_id = 176 OR select_id IS NULL order by id;
541
View Create View character_set_client collation_connection
542
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
544
WHERE v1.id IN (SELECT id FROM t1_values
545
WHERE select_id = 176 OR select_id IS NULL) order by id;
549
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
550
my_varbinary_1000, my_varchar_1000 id FROM t1_values;
551
SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
552
my_varbinary_1000, my_varchar_1000 id FROM t1_values
553
WHERE select_id = 175 OR select_id IS NULL order by id;
555
View Create View character_set_client collation_connection
556
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
558
WHERE v1.id IN (SELECT id FROM t1_values
559
WHERE select_id = 175 OR select_id IS NULL) order by id;
563
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_char_30 ),
564
my_varbinary_1000, my_char_30 id FROM t1_values;
565
SELECT LOCATE(my_varbinary_1000, my_char_30 ),
566
my_varbinary_1000, my_char_30 id FROM t1_values
567
WHERE select_id = 174 OR select_id IS NULL order by id;
569
View Create View character_set_client collation_connection
570
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
572
WHERE v1.id IN (SELECT id FROM t1_values
573
WHERE select_id = 174 OR select_id IS NULL) order by id;
577
CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
578
my_varbinary_1000, id FROM t1_values;
579
SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
580
my_varbinary_1000, id FROM t1_values
581
WHERE select_id = 173 OR select_id IS NULL order by id;
583
View Create View character_set_client collation_connection
584
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
586
WHERE v1.id IN (SELECT id FROM t1_values
587
WHERE select_id = 173 OR select_id IS NULL) order by id;
591
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
592
my_binary_30, my_varbinary_1000 id FROM t1_values;
593
SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
594
my_binary_30, my_varbinary_1000 id FROM t1_values
595
WHERE select_id = 172 OR select_id IS NULL order by id;
597
View Create View character_set_client collation_connection
598
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
600
WHERE v1.id IN (SELECT id FROM t1_values
601
WHERE select_id = 172 OR select_id IS NULL) order by id;
605
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_varchar_1000 ),
606
my_binary_30, my_varchar_1000 id FROM t1_values;
607
SELECT LOCATE(my_binary_30, my_varchar_1000 ),
608
my_binary_30, my_varchar_1000 id FROM t1_values
609
WHERE select_id = 171 OR select_id IS NULL order by id;
611
View Create View character_set_client collation_connection
612
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
614
WHERE v1.id IN (SELECT id FROM t1_values
615
WHERE select_id = 171 OR select_id IS NULL) order by id;
619
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_char_30 ),
620
my_binary_30, my_char_30 id FROM t1_values;
621
SELECT LOCATE(my_binary_30, my_char_30 ),
622
my_binary_30, my_char_30 id FROM t1_values
623
WHERE select_id = 170 OR select_id IS NULL order by id;
625
View Create View character_set_client collation_connection
626
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
628
WHERE v1.id IN (SELECT id FROM t1_values
629
WHERE select_id = 170 OR select_id IS NULL) order by id;
633
CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_binary_30 ),
634
my_binary_30, id FROM t1_values;
635
SELECT LOCATE(my_binary_30, my_binary_30 ),
636
my_binary_30, id FROM t1_values
637
WHERE select_id = 169 OR select_id IS NULL order by id;
639
View Create View character_set_client collation_connection
640
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
642
WHERE v1.id IN (SELECT id FROM t1_values
643
WHERE select_id = 169 OR select_id IS NULL) order by id;
647
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
648
my_varchar_1000, my_varbinary_1000 id FROM t1_values;
649
SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
650
my_varchar_1000, my_varbinary_1000 id FROM t1_values
651
WHERE select_id = 168 OR select_id IS NULL order by id;
653
View Create View character_set_client collation_connection
654
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
656
WHERE v1.id IN (SELECT id FROM t1_values
657
WHERE select_id = 168 OR select_id IS NULL) order by id;
661
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_binary_30 ),
662
my_varchar_1000, my_binary_30 id FROM t1_values;
663
SELECT LOCATE(my_varchar_1000, my_binary_30 ),
664
my_varchar_1000, my_binary_30 id FROM t1_values
665
WHERE select_id = 167 OR select_id IS NULL order by id;
667
View Create View character_set_client collation_connection
668
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
670
WHERE v1.id IN (SELECT id FROM t1_values
671
WHERE select_id = 167 OR select_id IS NULL) order by id;
675
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_char_30 ),
676
my_varchar_1000, my_char_30 id FROM t1_values;
677
SELECT LOCATE(my_varchar_1000, my_char_30 ),
678
my_varchar_1000, my_char_30 id FROM t1_values
679
WHERE select_id = 166 OR select_id IS NULL order by id;
681
View Create View character_set_client collation_connection
682
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
684
WHERE v1.id IN (SELECT id FROM t1_values
685
WHERE select_id = 166 OR select_id IS NULL) order by id;
689
CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
690
my_varchar_1000, id FROM t1_values;
691
SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
692
my_varchar_1000, id FROM t1_values
693
WHERE select_id = 165 OR select_id IS NULL order by id;
695
View Create View character_set_client collation_connection
696
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
698
WHERE v1.id IN (SELECT id FROM t1_values
699
WHERE select_id = 165 OR select_id IS NULL) order by id;
703
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_varbinary_1000 ),
704
my_char_30, my_varbinary_1000 id FROM t1_values;
705
SELECT LOCATE(my_char_30, my_varbinary_1000 ),
706
my_char_30, my_varbinary_1000 id FROM t1_values
707
WHERE select_id = 164 OR select_id IS NULL order by id;
709
View Create View character_set_client collation_connection
710
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
712
WHERE v1.id IN (SELECT id FROM t1_values
713
WHERE select_id = 164 OR select_id IS NULL) order by id;
717
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_binary_30 ),
718
my_char_30, my_binary_30 id FROM t1_values;
719
SELECT LOCATE(my_char_30, my_binary_30 ),
720
my_char_30, my_binary_30 id FROM t1_values
721
WHERE select_id = 163 OR select_id IS NULL order by id;
723
View Create View character_set_client collation_connection
724
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
726
WHERE v1.id IN (SELECT id FROM t1_values
727
WHERE select_id = 163 OR select_id IS NULL) order by id;
731
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_varchar_1000 ),
732
my_char_30, my_varchar_1000 id FROM t1_values;
733
SELECT LOCATE(my_char_30, my_varchar_1000 ),
734
my_char_30, my_varchar_1000 id FROM t1_values
735
WHERE select_id = 162 OR select_id IS NULL order by id;
737
View Create View character_set_client collation_connection
738
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
740
WHERE v1.id IN (SELECT id FROM t1_values
741
WHERE select_id = 162 OR select_id IS NULL) order by id;
745
CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_char_30 ),
746
my_char_30, id FROM t1_values;
747
SELECT LOCATE(my_char_30, my_char_30 ),
748
my_char_30, id FROM t1_values
749
WHERE select_id = 161 OR select_id IS NULL order by id;
751
View Create View character_set_client collation_connection
752
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
754
WHERE v1.id IN (SELECT id FROM t1_values
755
WHERE select_id = 161 OR select_id IS NULL) order by id;
759
CREATE VIEW v1 AS SELECT LOCATE('char', my_varbinary_1000),
760
my_varbinary_1000, id FROM t1_values;
761
SELECT LOCATE('char', my_varbinary_1000),
762
my_varbinary_1000, id FROM t1_values
763
WHERE select_id = 160 OR select_id IS NULL order by id;
765
View Create View character_set_client collation_connection
766
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
768
WHERE v1.id IN (SELECT id FROM t1_values
769
WHERE select_id = 160 OR select_id IS NULL) order by id;
773
CREATE VIEW v1 AS SELECT LOCATE('char', my_binary_30),
774
my_binary_30, id FROM t1_values;
775
SELECT LOCATE('char', my_binary_30),
776
my_binary_30, id FROM t1_values
777
WHERE select_id = 159 OR select_id IS NULL order by id;
779
View Create View character_set_client collation_connection
780
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
782
WHERE v1.id IN (SELECT id FROM t1_values
783
WHERE select_id = 159 OR select_id IS NULL) order by id;
787
CREATE VIEW v1 AS SELECT LOCATE('char', my_varchar_1000),
788
my_varchar_1000, id FROM t1_values;
789
SELECT LOCATE('char', my_varchar_1000),
790
my_varchar_1000, id FROM t1_values
791
WHERE select_id = 158 OR select_id IS NULL order by id;
793
View Create View character_set_client collation_connection
794
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
796
WHERE v1.id IN (SELECT id FROM t1_values
797
WHERE select_id = 158 OR select_id IS NULL) order by id;
801
CREATE VIEW v1 AS SELECT LOCATE('char', my_char_30),
802
my_char_30, id FROM t1_values;
803
SELECT LOCATE('char', my_char_30),
804
my_char_30, id FROM t1_values
805
WHERE select_id = 157 OR select_id IS NULL order by id;
807
View Create View character_set_client collation_connection
808
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
810
WHERE v1.id IN (SELECT id FROM t1_values
811
WHERE select_id = 157 OR select_id IS NULL) order by id;
815
CREATE VIEW v1 AS SELECT LOAD_FILE('<MYSQLTEST_VARDIR>/std_data/funcs_1/load_file.txt')
818
SELECT LOAD_FILE('<MYSQLTEST_VARDIR>/std_data/funcs_1/load_file.txt')
821
WHERE select_id = 156 OR select_id IS NULL order by id;
823
Here is content from load_file
825
Here is content from load_file
827
Here is content from load_file
829
Here is content from load_file
831
Here is content from load_file
834
View Create View character_set_client collation_connection
835
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
837
WHERE v1.id IN (SELECT id FROM t1_values
838
WHERE select_id = 156 OR select_id IS NULL) order by id;
840
Here is content from load_file
842
Here is content from load_file
844
Here is content from load_file
846
Here is content from load_file
848
Here is content from load_file
853
CREATE VIEW v1 AS SELECT LENGTH(my_varbinary_1000),
854
my_varbinary_1000, id FROM t1_values;
855
SELECT LENGTH(my_varbinary_1000),
856
my_varbinary_1000, id FROM t1_values
857
WHERE select_id = 155 OR select_id IS NULL order by id;
859
View Create View character_set_client collation_connection
860
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
862
WHERE v1.id IN (SELECT id FROM t1_values
863
WHERE select_id = 155 OR select_id IS NULL) order by id;
867
CREATE VIEW v1 AS SELECT LENGTH(my_binary_30),
868
my_binary_30, id FROM t1_values;
869
SELECT LENGTH(my_binary_30),
870
my_binary_30, id FROM t1_values
871
WHERE select_id = 154 OR select_id IS NULL order by id;
873
View Create View character_set_client collation_connection
874
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
876
WHERE v1.id IN (SELECT id FROM t1_values
877
WHERE select_id = 154 OR select_id IS NULL) order by id;
881
CREATE VIEW v1 AS SELECT LENGTH(my_varchar_1000),
882
my_varchar_1000, id FROM t1_values;
883
SELECT LENGTH(my_varchar_1000),
884
my_varchar_1000, id FROM t1_values
885
WHERE select_id = 153 OR select_id IS NULL order by id;
887
View Create View character_set_client collation_connection
888
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
890
WHERE v1.id IN (SELECT id FROM t1_values
891
WHERE select_id = 153 OR select_id IS NULL) order by id;
895
CREATE VIEW v1 AS SELECT LENGTH(my_char_30),
896
my_char_30, id FROM t1_values;
897
SELECT LENGTH(my_char_30),
898
my_char_30, id FROM t1_values
899
WHERE select_id = 152 OR select_id IS NULL order by id;
901
View Create View character_set_client collation_connection
902
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
904
WHERE v1.id IN (SELECT id FROM t1_values
905
WHERE select_id = 152 OR select_id IS NULL) order by id;
909
CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double), my_double, id FROM t1_values;
910
SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double), my_double, id FROM t1_values
911
WHERE select_id = 151 OR select_id IS NULL order by id;
912
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double) my_double id
914
-1.7976931348623e308 2
915
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 1.7976931348623e308 3
919
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
920
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
922
View Create View character_set_client collation_connection
923
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
925
WHERE v1.id IN (SELECT id FROM t1_values
926
WHERE select_id = 151 OR select_id IS NULL) order by id;
927
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double) my_double id
929
-1.7976931348623e308 2
930
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 1.7976931348623e308 3
934
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
935
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
939
CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal), my_decimal, id FROM t1_values;
940
SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal), my_decimal, id FROM t1_values
941
WHERE select_id = 150 OR select_id IS NULL order by id;
942
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal) my_decimal id
944
-9999999999999999999999999999999999.999999999999999999999999999999 2
945
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9999999999999999999999999999999999.999999999999999999999999999999 3
946
0.000000000000000000000000000000 4
947
-1.000000000000000000000000000000 5
949
Warning 1292 Truncated incorrect DECIMAL value: ''
950
Warning 1292 Truncated incorrect DECIMAL value: ''
952
View Create View character_set_client collation_connection
953
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
955
WHERE v1.id IN (SELECT id FROM t1_values
956
WHERE select_id = 150 OR select_id IS NULL) order by id;
957
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal) my_decimal id
959
-9999999999999999999999999999999999.999999999999999999999999999999 2
960
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9999999999999999999999999999999999.999999999999999999999999999999 3
961
0.000000000000000000000000000000 4
962
-1.000000000000000000000000000000 5
964
Warning 1292 Truncated incorrect DECIMAL value: ''
965
Warning 1292 Truncated incorrect DECIMAL value: ''
969
CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint), my_bigint, id FROM t1_values;
970
SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint), my_bigint, id FROM t1_values
971
WHERE select_id = 149 OR select_id IS NULL order by id;
972
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint) my_bigint id
974
-9223372036854775808 2
975
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9223372036854775807 3
979
View Create View character_set_client collation_connection
980
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
982
WHERE v1.id IN (SELECT id FROM t1_values
983
WHERE select_id = 149 OR select_id IS NULL) order by id;
984
LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint) my_bigint id
986
-9223372036854775808 2
987
AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9223372036854775807 3
993
CREATE VIEW v1 AS SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values;
994
SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values
995
WHERE select_id = 148 OR select_id IS NULL order by id;
996
LEFT(my_varbinary_1000, 2) my_varbinary_1000 id
999
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1002
SHOW CREATE VIEW v1;
1003
View Create View character_set_client collation_connection
1004
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
1006
WHERE v1.id IN (SELECT id FROM t1_values
1007
WHERE select_id = 148 OR select_id IS NULL) order by id;
1008
LEFT(my_varbinary_1000, 2) my_varbinary_1000 id
1011
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1017
CREATE VIEW v1 AS SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values;
1018
SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values
1019
WHERE select_id = 147 OR select_id IS NULL order by id;
1020
LEFT(my_binary_30, 2) my_binary_30 id
1023
<- <--------30 characters-------> 3
1026
SHOW CREATE VIEW v1;
1027
View Create View character_set_client collation_connection
1028
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
1030
WHERE v1.id IN (SELECT id FROM t1_values
1031
WHERE select_id = 147 OR select_id IS NULL) order by id;
1032
LEFT(my_binary_30, 2) my_binary_30 id
1035
<- <--------30 characters-------> 3
1041
CREATE VIEW v1 AS SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values;
1042
SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values
1043
WHERE select_id = 146 OR select_id IS NULL order by id;
1044
LEFT(my_varchar_1000, 2) my_varchar_1000 id
1047
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1050
SHOW CREATE VIEW v1;
1051
View Create View character_set_client collation_connection
1052
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
1054
WHERE v1.id IN (SELECT id FROM t1_values
1055
WHERE select_id = 146 OR select_id IS NULL) order by id;
1056
LEFT(my_varchar_1000, 2) my_varchar_1000 id
1059
<- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1065
CREATE VIEW v1 AS SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values;
1066
SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values
1067
WHERE select_id = 145 OR select_id IS NULL order by id;
1068
LEFT(my_char_30, 2) my_char_30 id
1071
<- <--------30 characters-------> 3
1074
SHOW CREATE VIEW v1;
1075
View Create View character_set_client collation_connection
1076
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
1078
WHERE v1.id IN (SELECT id FROM t1_values
1079
WHERE select_id = 145 OR select_id IS NULL) order by id;
1080
LEFT(my_char_30, 2) my_char_30 id
1083
<- <--------30 characters-------> 3
1089
CREATE VIEW v1 AS SELECT LCASE(my_varchar_1000),
1090
my_varchar_1000, id FROM t1_values;
1091
SELECT LCASE(my_varchar_1000),
1092
my_varchar_1000, id FROM t1_values
1093
WHERE select_id = 144 OR select_id IS NULL order by id;
1094
SHOW CREATE VIEW v1;
1095
View Create View character_set_client collation_connection
1096
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
1098
WHERE v1.id IN (SELECT id FROM t1_values
1099
WHERE select_id = 144 OR select_id IS NULL) order by id;
1103
CREATE VIEW v1 AS SELECT INSTR(my_char_30, 'char'),
1104
my_char_30, id FROM t1_values;
1105
SELECT INSTR(my_char_30, 'char'),
1106
my_char_30, id FROM t1_values
1107
WHERE select_id = 143 OR select_id IS NULL order by id;
1108
SHOW CREATE VIEW v1;
1109
View Create View character_set_client collation_connection
1110
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
1112
WHERE v1.id IN (SELECT id FROM t1_values
1113
WHERE select_id = 143 OR select_id IS NULL) order by id;
1117
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_varbinary_1000),
1118
my_varbinary_1000, id FROM t1_values;
1119
SELECT BIT_LENGTH(my_varbinary_1000),
1120
my_varbinary_1000, id FROM t1_values
1121
WHERE select_id = 142 OR select_id IS NULL order by id;
1122
BIT_LENGTH(my_varbinary_1000) my_varbinary_1000 id
1125
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1128
SHOW CREATE VIEW v1;
1129
View Create View character_set_client collation_connection
1130
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
1132
WHERE v1.id IN (SELECT id FROM t1_values
1133
WHERE select_id = 142 OR select_id IS NULL) order by id;
1134
BIT_LENGTH(my_varbinary_1000) my_varbinary_1000 id
1137
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1143
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_binary_30),
1144
my_binary_30, id FROM t1_values;
1145
SELECT BIT_LENGTH(my_binary_30),
1146
my_binary_30, id FROM t1_values
1147
WHERE select_id = 141 OR select_id IS NULL order by id;
1148
BIT_LENGTH(my_binary_30) my_binary_30 id
1151
240 <--------30 characters-------> 3
1154
SHOW CREATE VIEW v1;
1155
View Create View character_set_client collation_connection
1156
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
1158
WHERE v1.id IN (SELECT id FROM t1_values
1159
WHERE select_id = 141 OR select_id IS NULL) order by id;
1160
BIT_LENGTH(my_binary_30) my_binary_30 id
1163
240 <--------30 characters-------> 3
1169
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_varchar_1000),
1170
my_varchar_1000, id FROM t1_values;
1171
SELECT BIT_LENGTH(my_varchar_1000),
1172
my_varchar_1000, id FROM t1_values
1173
WHERE select_id = 140 OR select_id IS NULL order by id;
1174
BIT_LENGTH(my_varchar_1000) my_varchar_1000 id
1177
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1180
SHOW CREATE VIEW v1;
1181
View Create View character_set_client collation_connection
1182
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
1184
WHERE v1.id IN (SELECT id FROM t1_values
1185
WHERE select_id = 140 OR select_id IS NULL) order by id;
1186
BIT_LENGTH(my_varchar_1000) my_varchar_1000 id
1189
8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1195
CREATE VIEW v1 AS SELECT BIT_LENGTH(my_char_30),
1196
my_char_30, id FROM t1_values;
1197
SELECT BIT_LENGTH(my_char_30),
1198
my_char_30, id FROM t1_values
1199
WHERE select_id = 139 OR select_id IS NULL order by id;
1200
BIT_LENGTH(my_char_30) my_char_30 id
1203
240 <--------30 characters-------> 3
1206
SHOW CREATE VIEW v1;
1207
View Create View character_set_client collation_connection
1208
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
1210
WHERE v1.id IN (SELECT id FROM t1_values
1211
WHERE select_id = 139 OR select_id IS NULL) order by id;
1212
BIT_LENGTH(my_char_30) my_char_30 id
1215
240 <--------30 characters-------> 3
1221
CREATE VIEW v1 AS SELECT IFNULL(my_year,'IS_NULL'),
1222
my_year, id FROM t1_values;
1223
SELECT IFNULL(my_year,'IS_NULL'),
1224
my_year, id FROM t1_values
1225
WHERE select_id = 138 OR select_id IS NULL order by id;
1226
IFNULL(my_year,'IS_NULL') my_year id
1232
SHOW CREATE VIEW v1;
1233
View Create View character_set_client collation_connection
1234
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
1236
WHERE v1.id IN (SELECT id FROM t1_values
1237
WHERE select_id = 138 OR select_id IS NULL) order by id;
1238
IFNULL(my_year,'IS_NULL') my_year id
1247
CREATE VIEW v1 AS SELECT IFNULL(my_time,'IS_NULL'),
1248
my_time, id FROM t1_values;
1249
SELECT IFNULL(my_time,'IS_NULL'),
1250
my_time, id FROM t1_values
1251
WHERE select_id = 137 OR select_id IS NULL order by id;
1252
IFNULL(my_time,'IS_NULL') my_time id
1254
-838:59:59 -838:59:59 2
1255
838:59:59 838:59:59 3
1258
SHOW CREATE VIEW v1;
1259
View Create View character_set_client collation_connection
1260
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
1262
WHERE v1.id IN (SELECT id FROM t1_values
1263
WHERE select_id = 137 OR select_id IS NULL) order by id;
1264
IFNULL(my_time,'IS_NULL') my_time id
1266
-838:59:59 -838:59:59 2
1267
838:59:59 838:59:59 3
1273
CREATE VIEW v1 AS SELECT IFNULL(my_timestamp,'IS_NULL'),
1274
my_timestamp, id FROM t1_values;
1275
SELECT IFNULL(my_timestamp,'IS_NULL'),
1276
my_timestamp, id FROM t1_values
1277
WHERE select_id = 136 OR select_id IS NULL order by id;
1278
IFNULL(my_timestamp,'IS_NULL') my_timestamp id
1279
0000-00-00 00:00:00 0000-00-00 00:00:00 1
1280
1970-01-01 03:00:01 1970-01-01 03:00:01 2
1281
2038-01-01 02:59:59 2038-01-01 02:59:59 3
1282
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1283
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1284
SHOW CREATE VIEW v1;
1285
View Create View character_set_client collation_connection
1286
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
1288
WHERE v1.id IN (SELECT id FROM t1_values
1289
WHERE select_id = 136 OR select_id IS NULL) order by id;
1290
IFNULL(my_timestamp,'IS_NULL') my_timestamp id
1291
0000-00-00 00:00:00 0000-00-00 00:00:00 1
1292
1970-01-01 03:00:01 1970-01-01 03:00:01 2
1293
2038-01-01 02:59:59 2038-01-01 02:59:59 3
1294
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1295
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1299
CREATE VIEW v1 AS SELECT IFNULL(my_date,'IS_NULL'),
1300
my_date, id FROM t1_values;
1301
SELECT IFNULL(my_date,'IS_NULL'),
1302
my_date, id FROM t1_values
1303
WHERE select_id = 135 OR select_id IS NULL order by id;
1304
IFNULL(my_date,'IS_NULL') my_date id
1306
0001-01-01 0001-01-01 2
1307
9999-12-31 9999-12-31 3
1308
2004-02-29 2004-02-29 4
1309
2005-06-28 2005-06-28 5
1310
SHOW CREATE VIEW v1;
1311
View Create View character_set_client collation_connection
1312
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
1314
WHERE v1.id IN (SELECT id FROM t1_values
1315
WHERE select_id = 135 OR select_id IS NULL) order by id;
1316
IFNULL(my_date,'IS_NULL') my_date id
1318
0001-01-01 0001-01-01 2
1319
9999-12-31 9999-12-31 3
1320
2004-02-29 2004-02-29 4
1321
2005-06-28 2005-06-28 5
1325
CREATE VIEW v1 AS SELECT IFNULL(my_datetime,'IS_NULL'),
1326
my_datetime, id FROM t1_values;
1327
SELECT IFNULL(my_datetime,'IS_NULL'),
1328
my_datetime, id FROM t1_values
1329
WHERE select_id = 134 OR select_id IS NULL order by id;
1330
IFNULL(my_datetime,'IS_NULL') my_datetime id
1332
0001-01-01 00:00:00 0001-01-01 00:00:00 2
1333
9999-12-31 23:59:59 9999-12-31 23:59:59 3
1334
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1335
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1336
SHOW CREATE VIEW v1;
1337
View Create View character_set_client collation_connection
1338
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
1340
WHERE v1.id IN (SELECT id FROM t1_values
1341
WHERE select_id = 134 OR select_id IS NULL) order by id;
1342
IFNULL(my_datetime,'IS_NULL') my_datetime id
1344
0001-01-01 00:00:00 0001-01-01 00:00:00 2
1345
9999-12-31 23:59:59 9999-12-31 23:59:59 3
1346
2004-02-29 23:59:59 2004-02-29 23:59:59 4
1347
2005-06-28 10:00:00 2005-06-28 10:00:00 5
1351
CREATE VIEW v1 AS SELECT IFNULL(my_double,'IS_NULL'),
1352
my_double, id FROM t1_values;
1353
SELECT IFNULL(my_double,'IS_NULL'),
1354
my_double, id FROM t1_values
1355
WHERE select_id = 133 OR select_id IS NULL order by id;
1356
IFNULL(my_double,'IS_NULL') my_double id
1358
-1.7976931348623e308 -1.7976931348623e308 2
1359
1.7976931348623e308 1.7976931348623e308 3
1362
SHOW CREATE VIEW v1;
1363
View Create View character_set_client collation_connection
1364
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
1366
WHERE v1.id IN (SELECT id FROM t1_values
1367
WHERE select_id = 133 OR select_id IS NULL) order by id;
1368
IFNULL(my_double,'IS_NULL') my_double id
1370
-1.7976931348623e308 -1.7976931348623e308 2
1371
1.7976931348623e308 1.7976931348623e308 3
1377
CREATE VIEW v1 AS SELECT IFNULL(my_decimal,'IS_NULL'),
1378
my_decimal, id FROM t1_values;
1379
SELECT IFNULL(my_decimal,'IS_NULL'),
1380
my_decimal, id FROM t1_values
1381
WHERE select_id = 132 OR select_id IS NULL order by id;
1382
IFNULL(my_decimal,'IS_NULL') my_decimal id
1384
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
1385
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
1386
0.000000000000000000000000000000 0.000000000000000000000000000000 4
1387
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
1388
SHOW CREATE VIEW v1;
1389
View Create View character_set_client collation_connection
1390
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
1392
WHERE v1.id IN (SELECT id FROM t1_values
1393
WHERE select_id = 132 OR select_id IS NULL) order by id;
1394
IFNULL(my_decimal,'IS_NULL') my_decimal id
1396
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
1397
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
1398
0.000000000000000000000000000000 0.000000000000000000000000000000 4
1399
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
1403
CREATE VIEW v1 AS SELECT IFNULL(my_bigint,'IS_NULL'),
1404
my_bigint, id FROM t1_values;
1405
SELECT IFNULL(my_bigint,'IS_NULL'),
1406
my_bigint, id FROM t1_values
1407
WHERE select_id = 131 OR select_id IS NULL order by id;
1408
IFNULL(my_bigint,'IS_NULL') my_bigint id
1410
-9223372036854775808 -9223372036854775808 2
1411
9223372036854775807 9223372036854775807 3
1414
SHOW CREATE VIEW v1;
1415
View Create View character_set_client collation_connection
1416
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
1418
WHERE v1.id IN (SELECT id FROM t1_values
1419
WHERE select_id = 131 OR select_id IS NULL) order by id;
1420
IFNULL(my_bigint,'IS_NULL') my_bigint id
1422
-9223372036854775808 -9223372036854775808 2
1423
9223372036854775807 9223372036854775807 3
1429
CREATE VIEW v1 AS SELECT IFNULL(my_varbinary_1000,'IS_NULL'),
1430
my_varbinary_1000, id FROM t1_values;
1431
SELECT IFNULL(my_varbinary_1000,'IS_NULL'),
1432
my_varbinary_1000, id FROM t1_values
1433
WHERE select_id = 130 OR select_id IS NULL order by id;
1434
IFNULL(my_varbinary_1000,'IS_NULL') my_varbinary_1000 id
1437
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1438
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1440
SHOW CREATE VIEW v1;
1441
View Create View character_set_client collation_connection
1442
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
1444
WHERE v1.id IN (SELECT id FROM t1_values
1445
WHERE select_id = 130 OR select_id IS NULL) order by id;
1446
IFNULL(my_varbinary_1000,'IS_NULL') my_varbinary_1000 id
1449
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1450
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1455
CREATE VIEW v1 AS SELECT IFNULL(my_binary_30,'IS_NULL'),
1456
my_binary_30, id FROM t1_values;
1457
SELECT IFNULL(my_binary_30,'IS_NULL'),
1458
my_binary_30, id FROM t1_values
1459
WHERE select_id = 129 OR select_id IS NULL order by id;
1460
IFNULL(my_binary_30,'IS_NULL') my_binary_30 id
1463
<--------30 characters-------> <--------30 characters-------> 3
1464
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1466
SHOW CREATE VIEW v1;
1467
View Create View character_set_client collation_connection
1468
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
1470
WHERE v1.id IN (SELECT id FROM t1_values
1471
WHERE select_id = 129 OR select_id IS NULL) order by id;
1472
IFNULL(my_binary_30,'IS_NULL') my_binary_30 id
1475
<--------30 characters-------> <--------30 characters-------> 3
1476
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1481
CREATE VIEW v1 AS SELECT IFNULL(my_varchar_1000,'IS_NULL'),
1482
my_varchar_1000, id FROM t1_values;
1483
SELECT IFNULL(my_varchar_1000,'IS_NULL'),
1484
my_varchar_1000, id FROM t1_values
1485
WHERE select_id = 128 OR select_id IS NULL order by id;
1486
IFNULL(my_varchar_1000,'IS_NULL') my_varchar_1000 id
1489
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1490
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1492
SHOW CREATE VIEW v1;
1493
View Create View character_set_client collation_connection
1494
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
1496
WHERE v1.id IN (SELECT id FROM t1_values
1497
WHERE select_id = 128 OR select_id IS NULL) order by id;
1498
IFNULL(my_varchar_1000,'IS_NULL') my_varchar_1000 id
1501
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1502
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1507
CREATE VIEW v1 AS SELECT IFNULL(my_char_30,'IS_NULL'),
1508
my_char_30, id FROM t1_values;
1509
SELECT IFNULL(my_char_30,'IS_NULL'),
1510
my_char_30, id FROM t1_values
1511
WHERE select_id = 127 OR select_id IS NULL order by id;
1512
IFNULL(my_char_30,'IS_NULL') my_char_30 id
1515
<--------30 characters-------> <--------30 characters-------> 3
1516
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1518
SHOW CREATE VIEW v1;
1519
View Create View character_set_client collation_connection
1520
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
1522
WHERE v1.id IN (SELECT id FROM t1_values
1523
WHERE select_id = 127 OR select_id IS NULL) order by id;
1524
IFNULL(my_char_30,'IS_NULL') my_char_30 id
1527
<--------30 characters-------> <--------30 characters-------> 3
1528
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1533
CREATE VIEW v1 AS SELECT IF(my_year IS NULL, 'IS NULL',
1534
'IS NOT NULL'), my_year, id FROM t1_values;
1535
SELECT IF(my_year IS NULL, 'IS NULL',
1536
'IS NOT NULL'), my_year, id FROM t1_values
1537
WHERE select_id = 126 OR select_id IS NULL order by id;
1538
IF(my_year IS NULL, 'IS NULL',
1539
'IS NOT NULL') my_year id
1545
SHOW CREATE VIEW v1;
1546
View Create View character_set_client collation_connection
1547
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',
1548
'IS NOT NULL')`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1550
WHERE v1.id IN (SELECT id FROM t1_values
1551
WHERE select_id = 126 OR select_id IS NULL) order by id;
1552
IF(my_year IS NULL, 'IS NULL',
1553
'IS NOT NULL') my_year id
1562
CREATE VIEW v1 AS SELECT IF(my_time IS NULL, 'IS NULL',
1563
'IS NOT NULL'), my_time, id FROM t1_values;
1564
SELECT IF(my_time IS NULL, 'IS NULL',
1565
'IS NOT NULL'), my_time, id FROM t1_values
1566
WHERE select_id = 125 OR select_id IS NULL order by id;
1567
IF(my_time IS NULL, 'IS NULL',
1568
'IS NOT NULL') my_time id
1570
IS NOT NULL -838:59:59 2
1571
IS NOT NULL 838:59:59 3
1572
IS NOT NULL 13:00:00 4
1573
IS NOT NULL 10:00:00 5
1574
SHOW CREATE VIEW v1;
1575
View Create View character_set_client collation_connection
1576
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',
1577
'IS NOT NULL')`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1579
WHERE v1.id IN (SELECT id FROM t1_values
1580
WHERE select_id = 125 OR select_id IS NULL) order by id;
1581
IF(my_time IS NULL, 'IS NULL',
1582
'IS NOT NULL') my_time id
1584
IS NOT NULL -838:59:59 2
1585
IS NOT NULL 838:59:59 3
1586
IS NOT NULL 13:00:00 4
1587
IS NOT NULL 10:00:00 5
1591
CREATE VIEW v1 AS SELECT IF(my_timestamp IS NULL, 'IS NULL',
1592
'IS NOT NULL'), my_timestamp, id FROM t1_values;
1593
SELECT IF(my_timestamp IS NULL, 'IS NULL',
1594
'IS NOT NULL'), my_timestamp, id FROM t1_values
1595
WHERE select_id = 124 OR select_id IS NULL order by id;
1596
IF(my_timestamp IS NULL, 'IS NULL',
1597
'IS NOT NULL') my_timestamp id
1598
IS NOT NULL 0000-00-00 00:00:00 1
1599
IS NOT NULL 1970-01-01 03:00:01 2
1600
IS NOT NULL 2038-01-01 02:59:59 3
1601
IS NOT NULL 2004-02-29 23:59:59 4
1602
IS NOT NULL 2005-06-28 10:00:00 5
1603
SHOW CREATE VIEW v1;
1604
View Create View character_set_client collation_connection
1605
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',
1606
'IS NOT NULL')`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1608
WHERE v1.id IN (SELECT id FROM t1_values
1609
WHERE select_id = 124 OR select_id IS NULL) order by id;
1610
IF(my_timestamp IS NULL, 'IS NULL',
1611
'IS NOT NULL') my_timestamp id
1612
IS NOT NULL 0000-00-00 00:00:00 1
1613
IS NOT NULL 1970-01-01 03:00:01 2
1614
IS NOT NULL 2038-01-01 02:59:59 3
1615
IS NOT NULL 2004-02-29 23:59:59 4
1616
IS NOT NULL 2005-06-28 10:00:00 5
1620
CREATE VIEW v1 AS SELECT IF(my_date IS NULL, 'IS NULL',
1621
'IS NOT NULL'), my_date, id FROM t1_values;
1622
SELECT IF(my_date IS NULL, 'IS NULL',
1623
'IS NOT NULL'), my_date, id FROM t1_values
1624
WHERE select_id = 123 OR select_id IS NULL order by id;
1625
IF(my_date IS NULL, 'IS NULL',
1626
'IS NOT NULL') my_date id
1628
IS NOT NULL 0001-01-01 2
1629
IS NOT NULL 9999-12-31 3
1630
IS NOT NULL 2004-02-29 4
1631
IS NOT NULL 2005-06-28 5
1632
SHOW CREATE VIEW v1;
1633
View Create View character_set_client collation_connection
1634
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',
1635
'IS NOT NULL')`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1637
WHERE v1.id IN (SELECT id FROM t1_values
1638
WHERE select_id = 123 OR select_id IS NULL) order by id;
1639
IF(my_date IS NULL, 'IS NULL',
1640
'IS NOT NULL') my_date id
1642
IS NOT NULL 0001-01-01 2
1643
IS NOT NULL 9999-12-31 3
1644
IS NOT NULL 2004-02-29 4
1645
IS NOT NULL 2005-06-28 5
1649
CREATE VIEW v1 AS SELECT IF(my_datetime IS NULL, 'IS NULL',
1650
'IS NOT NULL'), my_datetime, id FROM t1_values;
1651
SELECT IF(my_datetime IS NULL, 'IS NULL',
1652
'IS NOT NULL'), my_datetime, id FROM t1_values
1653
WHERE select_id = 122 OR select_id IS NULL order by id;
1654
IF(my_datetime IS NULL, 'IS NULL',
1655
'IS NOT NULL') my_datetime id
1657
IS NOT NULL 0001-01-01 00:00:00 2
1658
IS NOT NULL 9999-12-31 23:59:59 3
1659
IS NOT NULL 2004-02-29 23:59:59 4
1660
IS NOT NULL 2005-06-28 10:00:00 5
1661
SHOW CREATE VIEW v1;
1662
View Create View character_set_client collation_connection
1663
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',
1664
'IS NOT NULL')`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1666
WHERE v1.id IN (SELECT id FROM t1_values
1667
WHERE select_id = 122 OR select_id IS NULL) order by id;
1668
IF(my_datetime IS NULL, 'IS NULL',
1669
'IS NOT NULL') my_datetime id
1671
IS NOT NULL 0001-01-01 00:00:00 2
1672
IS NOT NULL 9999-12-31 23:59:59 3
1673
IS NOT NULL 2004-02-29 23:59:59 4
1674
IS NOT NULL 2005-06-28 10:00:00 5
1678
CREATE VIEW v1 AS SELECT IF(my_double IS NULL, 'IS NULL',
1679
'IS NOT NULL'), my_double, id FROM t1_values;
1680
SELECT IF(my_double IS NULL, 'IS NULL',
1681
'IS NOT NULL'), my_double, id FROM t1_values
1682
WHERE select_id = 121 OR select_id IS NULL order by id;
1683
IF(my_double IS NULL, 'IS NULL',
1684
'IS NOT NULL') my_double id
1686
IS NOT NULL -1.7976931348623e308 2
1687
IS NOT NULL 1.7976931348623e308 3
1690
SHOW CREATE VIEW v1;
1691
View Create View character_set_client collation_connection
1692
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',
1693
'IS NOT NULL')`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1695
WHERE v1.id IN (SELECT id FROM t1_values
1696
WHERE select_id = 121 OR select_id IS NULL) order by id;
1697
IF(my_double IS NULL, 'IS NULL',
1698
'IS NOT NULL') my_double id
1700
IS NOT NULL -1.7976931348623e308 2
1701
IS NOT NULL 1.7976931348623e308 3
1707
CREATE VIEW v1 AS SELECT IF(my_decimal IS NULL, 'IS NULL',
1708
'IS NOT NULL'), my_decimal, id FROM t1_values;
1709
SELECT IF(my_decimal IS NULL, 'IS NULL',
1710
'IS NOT NULL'), my_decimal, id FROM t1_values
1711
WHERE select_id = 120 OR select_id IS NULL order by id;
1712
IF(my_decimal IS NULL, 'IS NULL',
1713
'IS NOT NULL') my_decimal id
1715
IS NOT NULL -9999999999999999999999999999999999.999999999999999999999999999999 2
1716
IS NOT NULL 9999999999999999999999999999999999.999999999999999999999999999999 3
1717
IS NOT NULL 0.000000000000000000000000000000 4
1718
IS NOT NULL -1.000000000000000000000000000000 5
1719
SHOW CREATE VIEW v1;
1720
View Create View character_set_client collation_connection
1721
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',
1722
'IS NOT NULL')`,`t1_values`.`my_decimal` AS `my_decimal`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1724
WHERE v1.id IN (SELECT id FROM t1_values
1725
WHERE select_id = 120 OR select_id IS NULL) order by id;
1726
IF(my_decimal IS NULL, 'IS NULL',
1727
'IS NOT NULL') my_decimal id
1729
IS NOT NULL -9999999999999999999999999999999999.999999999999999999999999999999 2
1730
IS NOT NULL 9999999999999999999999999999999999.999999999999999999999999999999 3
1731
IS NOT NULL 0.000000000000000000000000000000 4
1732
IS NOT NULL -1.000000000000000000000000000000 5
1736
CREATE VIEW v1 AS SELECT IF(my_bigint IS NULL, 'IS NULL',
1737
'IS NOT NULL'), my_bigint, id FROM t1_values;
1738
SELECT IF(my_bigint IS NULL, 'IS NULL',
1739
'IS NOT NULL'), my_bigint, id FROM t1_values
1740
WHERE select_id = 119 OR select_id IS NULL order by id;
1741
IF(my_bigint IS NULL, 'IS NULL',
1742
'IS NOT NULL') my_bigint id
1744
IS NOT NULL -9223372036854775808 2
1745
IS NOT NULL 9223372036854775807 3
1748
SHOW CREATE VIEW v1;
1749
View Create View character_set_client collation_connection
1750
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',
1751
'IS NOT NULL')`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1753
WHERE v1.id IN (SELECT id FROM t1_values
1754
WHERE select_id = 119 OR select_id IS NULL) order by id;
1755
IF(my_bigint IS NULL, 'IS NULL',
1756
'IS NOT NULL') my_bigint id
1758
IS NOT NULL -9223372036854775808 2
1759
IS NOT NULL 9223372036854775807 3
1765
CREATE VIEW v1 AS SELECT IF(my_varbinary_1000 IS NULL, 'IS NULL',
1766
'IS NOT NULL'), my_varbinary_1000, id FROM t1_values;
1767
SELECT IF(my_varbinary_1000 IS NULL, 'IS NULL',
1768
'IS NOT NULL'), my_varbinary_1000, id FROM t1_values
1769
WHERE select_id = 118 OR select_id IS NULL order by id;
1770
IF(my_varbinary_1000 IS NULL, 'IS NULL',
1771
'IS NOT NULL') my_varbinary_1000 id
1774
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1775
IS NOT NULL ---äÖüß@µ*$-- 4
1777
SHOW CREATE VIEW v1;
1778
View Create View character_set_client collation_connection
1779
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',
1780
'IS NOT NULL')`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1782
WHERE v1.id IN (SELECT id FROM t1_values
1783
WHERE select_id = 118 OR select_id IS NULL) order by id;
1784
IF(my_varbinary_1000 IS NULL, 'IS NULL',
1785
'IS NOT NULL') my_varbinary_1000 id
1788
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1789
IS NOT NULL ---äÖüß@µ*$-- 4
1794
CREATE VIEW v1 AS SELECT IF(my_binary_30 IS NULL, 'IS NULL',
1795
'IS NOT NULL'), my_binary_30, id FROM t1_values;
1796
SELECT IF(my_binary_30 IS NULL, 'IS NULL',
1797
'IS NOT NULL'), my_binary_30, id FROM t1_values
1798
WHERE select_id = 117 OR select_id IS NULL order by id;
1799
IF(my_binary_30 IS NULL, 'IS NULL',
1800
'IS NOT NULL') my_binary_30 id
1803
IS NOT NULL <--------30 characters-------> 3
1804
IS NOT NULL ---äÖüß@µ*$-- 4
1806
SHOW CREATE VIEW v1;
1807
View Create View character_set_client collation_connection
1808
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',
1809
'IS NOT NULL')`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1811
WHERE v1.id IN (SELECT id FROM t1_values
1812
WHERE select_id = 117 OR select_id IS NULL) order by id;
1813
IF(my_binary_30 IS NULL, 'IS NULL',
1814
'IS NOT NULL') my_binary_30 id
1817
IS NOT NULL <--------30 characters-------> 3
1818
IS NOT NULL ---äÖüß@µ*$-- 4
1823
CREATE VIEW v1 AS SELECT IF(my_varchar_1000 IS NULL, 'IS NULL',
1824
'IS NOT NULL'), my_varchar_1000, id FROM t1_values;
1825
SELECT IF(my_varchar_1000 IS NULL, 'IS NULL',
1826
'IS NOT NULL'), my_varchar_1000, id FROM t1_values
1827
WHERE select_id = 116 OR select_id IS NULL order by id;
1828
IF(my_varchar_1000 IS NULL, 'IS NULL',
1829
'IS NOT NULL') my_varchar_1000 id
1832
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1833
IS NOT NULL ---äÖüß@µ*$-- 4
1835
SHOW CREATE VIEW v1;
1836
View Create View character_set_client collation_connection
1837
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',
1838
'IS NOT NULL')`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1840
WHERE v1.id IN (SELECT id FROM t1_values
1841
WHERE select_id = 116 OR select_id IS NULL) order by id;
1842
IF(my_varchar_1000 IS NULL, 'IS NULL',
1843
'IS NOT NULL') my_varchar_1000 id
1846
IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1847
IS NOT NULL ---äÖüß@µ*$-- 4
1852
CREATE VIEW v1 AS SELECT IF(my_char_30 IS NULL, 'IS NULL',
1853
'IS NOT NULL'), my_char_30, id FROM t1_values;
1854
SELECT IF(my_char_30 IS NULL, 'IS NULL',
1855
'IS NOT NULL'), my_char_30, id FROM t1_values
1856
WHERE select_id = 115 OR select_id IS NULL order by id;
1857
IF(my_char_30 IS NULL, 'IS NULL',
1858
'IS NOT NULL') my_char_30 id
1861
IS NOT NULL <--------30 characters-------> 3
1862
IS NOT NULL ---äÖüß@µ*$-- 4
1864
SHOW CREATE VIEW v1;
1865
View Create View character_set_client collation_connection
1866
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',
1867
'IS NOT NULL')`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1869
WHERE v1.id IN (SELECT id FROM t1_values
1870
WHERE select_id = 115 OR select_id IS NULL) order by id;
1871
IF(my_char_30 IS NULL, 'IS NULL',
1872
'IS NOT NULL') my_char_30 id
1875
IS NOT NULL <--------30 characters-------> 3
1876
IS NOT NULL ---äÖüß@µ*$-- 4
1881
CREATE VIEW v1 AS SELECT IF(my_year, 'IS TRUE', 'IS NOT TRUE'),
1882
my_year, id FROM t1_values;
1883
SELECT IF(my_year, 'IS TRUE', 'IS NOT TRUE'),
1884
my_year, id FROM t1_values
1885
WHERE select_id = 114 OR select_id IS NULL order by id;
1886
IF(my_year, 'IS TRUE', 'IS NOT TRUE') my_year id
1892
SHOW CREATE VIEW v1;
1893
View Create View character_set_client collation_connection
1894
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
1896
WHERE v1.id IN (SELECT id FROM t1_values
1897
WHERE select_id = 114 OR select_id IS NULL) order by id;
1898
IF(my_year, 'IS TRUE', 'IS NOT TRUE') my_year id
1907
CREATE VIEW v1 AS SELECT IF(my_time, 'IS TRUE', 'IS NOT TRUE'),
1908
my_time, id FROM t1_values;
1909
SELECT IF(my_time, 'IS TRUE', 'IS NOT TRUE'),
1910
my_time, id FROM t1_values
1911
WHERE select_id = 113 OR select_id IS NULL order by id;
1912
IF(my_time, 'IS TRUE', 'IS NOT TRUE') my_time id
1914
IS TRUE -838:59:59 2
1918
SHOW CREATE VIEW v1;
1919
View Create View character_set_client collation_connection
1920
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
1922
WHERE v1.id IN (SELECT id FROM t1_values
1923
WHERE select_id = 113 OR select_id IS NULL) order by id;
1924
IF(my_time, 'IS TRUE', 'IS NOT TRUE') my_time id
1926
IS TRUE -838:59:59 2
1933
CREATE VIEW v1 AS SELECT IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE'),
1934
my_timestamp, id FROM t1_values;
1935
SELECT IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE'),
1936
my_timestamp, id FROM t1_values
1937
WHERE select_id = 112 OR select_id IS NULL order by id;
1938
IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE') my_timestamp id
1939
IS NOT TRUE 0000-00-00 00:00:00 1
1940
IS TRUE 1970-01-01 03:00:01 2
1941
IS TRUE 2038-01-01 02:59:59 3
1942
IS TRUE 2004-02-29 23:59:59 4
1943
IS TRUE 2005-06-28 10:00:00 5
1944
SHOW CREATE VIEW v1;
1945
View Create View character_set_client collation_connection
1946
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
1948
WHERE v1.id IN (SELECT id FROM t1_values
1949
WHERE select_id = 112 OR select_id IS NULL) order by id;
1950
IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE') my_timestamp id
1951
IS NOT TRUE 0000-00-00 00:00:00 1
1952
IS TRUE 1970-01-01 03:00:01 2
1953
IS TRUE 2038-01-01 02:59:59 3
1954
IS TRUE 2004-02-29 23:59:59 4
1955
IS TRUE 2005-06-28 10:00:00 5
1959
CREATE VIEW v1 AS SELECT IF(my_date, 'IS TRUE', 'IS NOT TRUE'),
1960
my_date, id FROM t1_values;
1961
SELECT IF(my_date, 'IS TRUE', 'IS NOT TRUE'),
1962
my_date, id FROM t1_values
1963
WHERE select_id = 111 OR select_id IS NULL order by id;
1964
IF(my_date, 'IS TRUE', 'IS NOT TRUE') my_date id
1966
IS TRUE 0001-01-01 2
1967
IS TRUE 9999-12-31 3
1968
IS TRUE 2004-02-29 4
1969
IS TRUE 2005-06-28 5
1970
SHOW CREATE VIEW v1;
1971
View Create View character_set_client collation_connection
1972
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
1974
WHERE v1.id IN (SELECT id FROM t1_values
1975
WHERE select_id = 111 OR select_id IS NULL) order by id;
1976
IF(my_date, 'IS TRUE', 'IS NOT TRUE') my_date id
1978
IS TRUE 0001-01-01 2
1979
IS TRUE 9999-12-31 3
1980
IS TRUE 2004-02-29 4
1981
IS TRUE 2005-06-28 5
1985
CREATE VIEW v1 AS SELECT IF(my_datetime, 'IS TRUE', 'IS NOT TRUE'),
1986
my_datetime, id FROM t1_values;
1987
SELECT IF(my_datetime, 'IS TRUE', 'IS NOT TRUE'),
1988
my_datetime, id FROM t1_values
1989
WHERE select_id = 110 OR select_id IS NULL order by id;
1990
IF(my_datetime, 'IS TRUE', 'IS NOT TRUE') my_datetime id
1992
IS TRUE 0001-01-01 00:00:00 2
1993
IS TRUE 9999-12-31 23:59:59 3
1994
IS TRUE 2004-02-29 23:59:59 4
1995
IS TRUE 2005-06-28 10:00:00 5
1996
SHOW CREATE VIEW v1;
1997
View Create View character_set_client collation_connection
1998
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
2000
WHERE v1.id IN (SELECT id FROM t1_values
2001
WHERE select_id = 110 OR select_id IS NULL) order by id;
2002
IF(my_datetime, 'IS TRUE', 'IS NOT TRUE') my_datetime id
2004
IS TRUE 0001-01-01 00:00:00 2
2005
IS TRUE 9999-12-31 23:59:59 3
2006
IS TRUE 2004-02-29 23:59:59 4
2007
IS TRUE 2005-06-28 10:00:00 5
2011
CREATE VIEW v1 AS SELECT IF(my_double, 'IS TRUE', 'IS NOT TRUE'),
2012
my_double, id FROM t1_values;
2013
SELECT IF(my_double, 'IS TRUE', 'IS NOT TRUE'),
2014
my_double, id FROM t1_values
2015
WHERE select_id = 109 OR select_id IS NULL order by id;
2016
IF(my_double, 'IS TRUE', 'IS NOT TRUE') my_double id
2018
IS TRUE -1.7976931348623e308 2
2019
IS TRUE 1.7976931348623e308 3
2022
SHOW CREATE VIEW v1;
2023
View Create View character_set_client collation_connection
2024
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
2026
WHERE v1.id IN (SELECT id FROM t1_values
2027
WHERE select_id = 109 OR select_id IS NULL) order by id;
2028
IF(my_double, 'IS TRUE', 'IS NOT TRUE') my_double id
2030
IS TRUE -1.7976931348623e308 2
2031
IS TRUE 1.7976931348623e308 3
2037
CREATE VIEW v1 AS SELECT IF(my_decimal, 'IS TRUE', 'IS NOT TRUE'),
2038
my_decimal, id FROM t1_values;
2039
SELECT IF(my_decimal, 'IS TRUE', 'IS NOT TRUE'),
2040
my_decimal, id FROM t1_values
2041
WHERE select_id = 108 OR select_id IS NULL order by id;
2042
IF(my_decimal, 'IS TRUE', 'IS NOT TRUE') my_decimal id
2044
IS TRUE -9999999999999999999999999999999999.999999999999999999999999999999 2
2045
IS TRUE 9999999999999999999999999999999999.999999999999999999999999999999 3
2046
IS NOT TRUE 0.000000000000000000000000000000 4
2047
IS TRUE -1.000000000000000000000000000000 5
2048
SHOW CREATE VIEW v1;
2049
View Create View character_set_client collation_connection
2050
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
2052
WHERE v1.id IN (SELECT id FROM t1_values
2053
WHERE select_id = 108 OR select_id IS NULL) order by id;
2054
IF(my_decimal, 'IS TRUE', 'IS NOT TRUE') my_decimal id
2056
IS TRUE -9999999999999999999999999999999999.999999999999999999999999999999 2
2057
IS TRUE 9999999999999999999999999999999999.999999999999999999999999999999 3
2058
IS NOT TRUE 0.000000000000000000000000000000 4
2059
IS TRUE -1.000000000000000000000000000000 5
2063
CREATE VIEW v1 AS SELECT IF(my_bigint, 'IS TRUE', 'IS NOT TRUE'),
2064
my_bigint, id FROM t1_values;
2065
SELECT IF(my_bigint, 'IS TRUE', 'IS NOT TRUE'),
2066
my_bigint, id FROM t1_values
2067
WHERE select_id = 107 OR select_id IS NULL order by id;
2068
IF(my_bigint, 'IS TRUE', 'IS NOT TRUE') my_bigint id
2070
IS TRUE -9223372036854775808 2
2071
IS TRUE 9223372036854775807 3
2074
SHOW CREATE VIEW v1;
2075
View Create View character_set_client collation_connection
2076
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
2078
WHERE v1.id IN (SELECT id FROM t1_values
2079
WHERE select_id = 107 OR select_id IS NULL) order by id;
2080
IF(my_bigint, 'IS TRUE', 'IS NOT TRUE') my_bigint id
2082
IS TRUE -9223372036854775808 2
2083
IS TRUE 9223372036854775807 3
2089
CREATE VIEW v1 AS SELECT IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE'),
2090
my_varbinary_1000, id FROM t1_values;
2091
SELECT IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE'),
2092
my_varbinary_1000, id FROM t1_values
2093
WHERE select_id = 106 OR select_id IS NULL order by id;
2094
IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE') my_varbinary_1000 id
2097
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2098
IS NOT TRUE ---äÖüß@µ*$-- 4
2101
Warning 1292 Truncated incorrect DOUBLE value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2102
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2103
SHOW CREATE VIEW v1;
2104
View Create View character_set_client collation_connection
2105
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
2107
WHERE v1.id IN (SELECT id FROM t1_values
2108
WHERE select_id = 106 OR select_id IS NULL) order by id;
2109
IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE') my_varbinary_1000 id
2112
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2113
IS NOT TRUE ---äÖüß@µ*$-- 4
2116
Warning 1292 Truncated incorrect DOUBLE value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2117
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2121
CREATE VIEW v1 AS SELECT IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE'),
2122
my_binary_30, id FROM t1_values;
2123
SELECT IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE'),
2124
my_binary_30, id FROM t1_values
2125
WHERE select_id = 105 OR select_id IS NULL order by id;
2126
IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE') my_binary_30 id
2129
IS NOT TRUE <--------30 characters-------> 3
2130
IS NOT TRUE ---äÖüß@µ*$-- 4
2133
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'
2134
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2135
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'
2136
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'
2137
SHOW CREATE VIEW v1;
2138
View Create View character_set_client collation_connection
2139
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
2141
WHERE v1.id IN (SELECT id FROM t1_values
2142
WHERE select_id = 105 OR select_id IS NULL) order by id;
2143
IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE') my_binary_30 id
2146
IS NOT TRUE <--------30 characters-------> 3
2147
IS NOT TRUE ---äÖüß@µ*$-- 4
2150
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'
2151
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2152
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'
2153
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'
2157
CREATE VIEW v1 AS SELECT IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE'),
2158
my_varchar_1000, id FROM t1_values;
2159
SELECT IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE'),
2160
my_varchar_1000, id FROM t1_values
2161
WHERE select_id = 104 OR select_id IS NULL order by id;
2162
IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE') my_varchar_1000 id
2165
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2166
IS NOT TRUE ---äÖüß@µ*$-- 4
2169
Warning 1292 Truncated incorrect DOUBLE value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2170
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2171
SHOW CREATE VIEW v1;
2172
View Create View character_set_client collation_connection
2173
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
2175
WHERE v1.id IN (SELECT id FROM t1_values
2176
WHERE select_id = 104 OR select_id IS NULL) order by id;
2177
IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE') my_varchar_1000 id
2180
IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2181
IS NOT TRUE ---äÖüß@µ*$-- 4
2184
Warning 1292 Truncated incorrect DOUBLE value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2185
Warning 1292 Truncated incorrect DOUBLE value: ' ---����@�*$-- '
2189
CREATE VIEW v1 AS SELECT IF(my_char_30, 'IS TRUE', 'IS NOT TRUE'),
2190
my_char_30, id FROM t1_values;
2191
SELECT IF(my_char_30, 'IS TRUE', 'IS NOT TRUE'),
2192
my_char_30, id FROM t1_values
2193
WHERE select_id = 103 OR select_id IS NULL order by id;
2194
IF(my_char_30, 'IS TRUE', 'IS NOT TRUE') my_char_30 id
2197
IS NOT TRUE <--------30 characters-------> 3
2198
IS NOT TRUE ---äÖüß@µ*$-- 4
2201
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2202
Warning 1292 Truncated incorrect DOUBLE value: ' ---äÖüß@µ*$-- '
2203
SHOW CREATE VIEW v1;
2204
View Create View character_set_client collation_connection
2205
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
2207
WHERE v1.id IN (SELECT id FROM t1_values
2208
WHERE select_id = 103 OR select_id IS NULL) order by id;
2209
IF(my_char_30, 'IS TRUE', 'IS NOT TRUE') my_char_30 id
2212
IS NOT TRUE <--------30 characters-------> 3
2213
IS NOT TRUE ---äÖüß@µ*$-- 4
2216
Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2217
Warning 1292 Truncated incorrect DOUBLE value: ' ---äÖüß@µ*$-- '
2221
CREATE VIEW v1 AS SELECT CONVERT(my_varbinary_1000 USING koi8r),
2222
my_varbinary_1000, id FROM t1_values;
2223
SELECT CONVERT(my_varbinary_1000 USING koi8r),
2224
my_varbinary_1000, id FROM t1_values
2225
WHERE select_id = 102 OR select_id IS NULL order by id;
2226
CONVERT(my_varbinary_1000 USING koi8r) my_varbinary_1000 id
2229
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2230
---???????�@??*$-- ---äÖüß@µ*$-- 4
2232
SHOW CREATE VIEW v1;
2233
View Create View character_set_client collation_connection
2234
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
2236
WHERE v1.id IN (SELECT id FROM t1_values
2237
WHERE select_id = 102 OR select_id IS NULL) order by id;
2238
CONVERT(my_varbinary_1000 USING koi8r) my_varbinary_1000 id
2241
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2242
---???????�@??*$-- ---äÖüß@µ*$-- 4
2247
CREATE VIEW v1 AS SELECT CONVERT(my_binary_30 USING koi8r),
2248
my_binary_30, id FROM t1_values;
2249
SELECT CONVERT(my_binary_30 USING koi8r),
2250
my_binary_30, id FROM t1_values
2251
WHERE select_id = 101 OR select_id IS NULL order by id;
2252
CONVERT(my_binary_30 USING koi8r) my_binary_30 id
2255
<--------30 characters-------> <--------30 characters-------> 3
2256
---???????�@??*$-- ---äÖüß@µ*$-- 4
2258
SHOW CREATE VIEW v1;
2259
View Create View character_set_client collation_connection
2260
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
2262
WHERE v1.id IN (SELECT id FROM t1_values
2263
WHERE select_id = 101 OR select_id IS NULL) order by id;
2264
CONVERT(my_binary_30 USING koi8r) my_binary_30 id
2267
<--------30 characters-------> <--------30 characters-------> 3
2268
---???????�@??*$-- ---äÖüß@µ*$-- 4
2273
CREATE VIEW v1 AS SELECT CONVERT(my_varchar_1000 USING koi8r),
2274
my_varchar_1000, id FROM t1_values;
2275
SELECT CONVERT(my_varchar_1000 USING koi8r),
2276
my_varchar_1000, id FROM t1_values
2277
WHERE select_id = 100 OR select_id IS NULL order by id;
2278
CONVERT(my_varchar_1000 USING koi8r) my_varchar_1000 id
2281
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2282
---????????@??*$-- ---äÖüß@µ*$-- 4
2284
SHOW CREATE VIEW v1;
2285
View Create View character_set_client collation_connection
2286
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
2288
WHERE v1.id IN (SELECT id FROM t1_values
2289
WHERE select_id = 100 OR select_id IS NULL) order by id;
2290
CONVERT(my_varchar_1000 USING koi8r) my_varchar_1000 id
2293
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2294
---????????@??*$-- ---äÖüß@µ*$-- 4
2299
CREATE VIEW v1 AS SELECT CONVERT(my_char_30 USING koi8r),
2300
my_char_30, id FROM t1_values;
2301
SELECT CONVERT(my_char_30 USING koi8r),
2302
my_char_30, id FROM t1_values
2303
WHERE select_id = 99 OR select_id IS NULL order by id;
2304
CONVERT(my_char_30 USING koi8r) my_char_30 id
2307
<--------30 characters-------> <--------30 characters-------> 3
2308
---????????@??*$-- ---äÖüß@µ*$-- 4
2310
SHOW CREATE VIEW v1;
2311
View Create View character_set_client collation_connection
2312
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
2314
WHERE v1.id IN (SELECT id FROM t1_values
2315
WHERE select_id = 99 OR select_id IS NULL) order by id;
2316
CONVERT(my_char_30 USING koi8r) my_char_30 id
2319
<--------30 characters-------> <--------30 characters-------> 3
2320
---????????@??*$-- ---äÖüß@µ*$-- 4
2325
CREATE VIEW v1 AS SELECT CONVERT(my_varbinary_1000 USING utf8),
2326
my_varbinary_1000, id FROM t1_values;
2327
SELECT CONVERT(my_varbinary_1000 USING utf8),
2328
my_varbinary_1000, id FROM t1_values
2329
WHERE select_id = 98 OR select_id IS NULL order by id;
2330
CONVERT(my_varbinary_1000 USING utf8) my_varbinary_1000 id
2333
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2334
---����@�*$-- ---äÖüß@µ*$-- 4
2336
SHOW CREATE VIEW v1;
2337
View Create View character_set_client collation_connection
2338
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
2340
WHERE v1.id IN (SELECT id FROM t1_values
2341
WHERE select_id = 98 OR select_id IS NULL) order by id;
2342
CONVERT(my_varbinary_1000 USING utf8) my_varbinary_1000 id
2345
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2346
---����@�*$-- ---äÖüß@µ*$-- 4
2351
CREATE VIEW v1 AS SELECT CONVERT(my_binary_30 USING utf8),
2352
my_binary_30, id FROM t1_values;
2353
SELECT CONVERT(my_binary_30 USING utf8),
2354
my_binary_30, id FROM t1_values
2355
WHERE select_id = 97 OR select_id IS NULL order by id;
2356
CONVERT(my_binary_30 USING utf8) my_binary_30 id
2359
<--------30 characters-------> <--------30 characters-------> 3
2360
---����@�*$-- ---äÖüß@µ*$-- 4
2362
SHOW CREATE VIEW v1;
2363
View Create View character_set_client collation_connection
2364
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
2366
WHERE v1.id IN (SELECT id FROM t1_values
2367
WHERE select_id = 97 OR select_id IS NULL) order by id;
2368
CONVERT(my_binary_30 USING utf8) my_binary_30 id
2371
<--------30 characters-------> <--------30 characters-------> 3
2372
---����@�*$-- ---äÖüß@µ*$-- 4
2377
CREATE VIEW v1 AS SELECT CONVERT(my_varchar_1000 USING utf8),
2378
my_varchar_1000, id FROM t1_values;
2379
SELECT CONVERT(my_varchar_1000 USING utf8),
2380
my_varchar_1000, id FROM t1_values
2381
WHERE select_id = 96 OR select_id IS NULL order by id;
2382
CONVERT(my_varchar_1000 USING utf8) my_varchar_1000 id
2385
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2386
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2388
SHOW CREATE VIEW v1;
2389
View Create View character_set_client collation_connection
2390
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
2392
WHERE v1.id IN (SELECT id FROM t1_values
2393
WHERE select_id = 96 OR select_id IS NULL) order by id;
2394
CONVERT(my_varchar_1000 USING utf8) my_varchar_1000 id
2397
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2398
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2403
CREATE VIEW v1 AS SELECT CONVERT(my_char_30 USING utf8),
2404
my_char_30, id FROM t1_values;
2405
SELECT CONVERT(my_char_30 USING utf8),
2406
my_char_30, id FROM t1_values
2407
WHERE select_id = 95 OR select_id IS NULL order by id;
2408
CONVERT(my_char_30 USING utf8) my_char_30 id
2411
<--------30 characters-------> <--------30 characters-------> 3
2412
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2414
SHOW CREATE VIEW v1;
2415
View Create View character_set_client collation_connection
2416
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
2418
WHERE v1.id IN (SELECT id FROM t1_values
2419
WHERE select_id = 95 OR select_id IS NULL) order by id;
2420
CONVERT(my_char_30 USING utf8) my_char_30 id
2423
<--------30 characters-------> <--------30 characters-------> 3
2424
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2429
CREATE VIEW v1 AS SELECT CAST(my_year AS UNSIGNED INTEGER),
2430
my_year, id FROM t1_values;
2431
SELECT CAST(my_year AS UNSIGNED INTEGER),
2432
my_year, id FROM t1_values
2433
WHERE select_id = 94 OR select_id IS NULL order by id;
2434
CAST(my_year AS UNSIGNED INTEGER) my_year id
2440
SHOW CREATE VIEW v1;
2441
View Create View character_set_client collation_connection
2442
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
2444
WHERE v1.id IN (SELECT id FROM t1_values
2445
WHERE select_id = 94 OR select_id IS NULL) order by id;
2446
CAST(my_year AS UNSIGNED INTEGER) my_year id
2455
CREATE VIEW v1 AS SELECT CAST(my_time AS UNSIGNED INTEGER),
2456
my_time, id FROM t1_values;
2457
SELECT CAST(my_time AS UNSIGNED INTEGER),
2458
my_time, id FROM t1_values
2459
WHERE select_id = 93 OR select_id IS NULL order by id;
2460
CAST(my_time AS UNSIGNED INTEGER) my_time id
2462
18446744073701165657 -838:59:59 2
2466
SHOW CREATE VIEW v1;
2467
View Create View character_set_client collation_connection
2468
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
2470
WHERE v1.id IN (SELECT id FROM t1_values
2471
WHERE select_id = 93 OR select_id IS NULL) order by id;
2472
CAST(my_time AS UNSIGNED INTEGER) my_time id
2474
18446744073701165657 -838:59:59 2
2481
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS UNSIGNED INTEGER),
2482
my_timestamp, id FROM t1_values;
2483
SELECT CAST(my_timestamp AS UNSIGNED INTEGER),
2484
my_timestamp, id FROM t1_values
2485
WHERE select_id = 92 OR select_id IS NULL order by id;
2486
CAST(my_timestamp AS UNSIGNED INTEGER) my_timestamp id
2487
0 0000-00-00 00:00:00 1
2488
19700101030001 1970-01-01 03:00:01 2
2489
20380101025959 2038-01-01 02:59:59 3
2490
20040229235959 2004-02-29 23:59:59 4
2491
20050628100000 2005-06-28 10:00:00 5
2492
SHOW CREATE VIEW v1;
2493
View Create View character_set_client collation_connection
2494
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
2496
WHERE v1.id IN (SELECT id FROM t1_values
2497
WHERE select_id = 92 OR select_id IS NULL) order by id;
2498
CAST(my_timestamp AS UNSIGNED INTEGER) my_timestamp id
2499
0 0000-00-00 00:00:00 1
2500
19700101030001 1970-01-01 03:00:01 2
2501
20380101025959 2038-01-01 02:59:59 3
2502
20040229235959 2004-02-29 23:59:59 4
2503
20050628100000 2005-06-28 10:00:00 5
2507
CREATE VIEW v1 AS SELECT CAST(my_date AS UNSIGNED INTEGER),
2508
my_date, id FROM t1_values;
2509
SELECT CAST(my_date AS UNSIGNED INTEGER),
2510
my_date, id FROM t1_values
2511
WHERE select_id = 91 OR select_id IS NULL order by id;
2512
CAST(my_date AS UNSIGNED INTEGER) my_date id
2515
99991231 9999-12-31 3
2516
20040229 2004-02-29 4
2517
20050628 2005-06-28 5
2518
SHOW CREATE VIEW v1;
2519
View Create View character_set_client collation_connection
2520
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
2522
WHERE v1.id IN (SELECT id FROM t1_values
2523
WHERE select_id = 91 OR select_id IS NULL) order by id;
2524
CAST(my_date AS UNSIGNED INTEGER) my_date id
2527
99991231 9999-12-31 3
2528
20040229 2004-02-29 4
2529
20050628 2005-06-28 5
2533
CREATE VIEW v1 AS SELECT CAST(my_datetime AS UNSIGNED INTEGER),
2534
my_datetime, id FROM t1_values;
2535
SELECT CAST(my_datetime AS UNSIGNED INTEGER),
2536
my_datetime, id FROM t1_values
2537
WHERE select_id = 90 OR select_id IS NULL order by id;
2538
CAST(my_datetime AS UNSIGNED INTEGER) my_datetime id
2540
10101000000 0001-01-01 00:00:00 2
2541
99991231235959 9999-12-31 23:59:59 3
2542
20040229235959 2004-02-29 23:59:59 4
2543
20050628100000 2005-06-28 10:00:00 5
2544
SHOW CREATE VIEW v1;
2545
View Create View character_set_client collation_connection
2546
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
2548
WHERE v1.id IN (SELECT id FROM t1_values
2549
WHERE select_id = 90 OR select_id IS NULL) order by id;
2550
CAST(my_datetime AS UNSIGNED INTEGER) my_datetime id
2552
10101000000 0001-01-01 00:00:00 2
2553
99991231235959 9999-12-31 23:59:59 3
2554
20040229235959 2004-02-29 23:59:59 4
2555
20050628100000 2005-06-28 10:00:00 5
2559
CREATE VIEW v1 AS SELECT CAST(my_double AS UNSIGNED INTEGER),
2560
my_double, id FROM t1_values;
2561
SELECT CAST(my_double AS UNSIGNED INTEGER),
2562
my_double, id FROM t1_values
2563
WHERE select_id = 89 OR select_id IS NULL order by id;
2564
CAST(my_double AS UNSIGNED INTEGER) my_double id
2566
9223372036854775808 -1.7976931348623e308 2
2567
9223372036854775807 1.7976931348623e308 3
2569
18446744073709551615 -1 5
2571
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2572
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2573
SHOW CREATE VIEW v1;
2574
View Create View character_set_client collation_connection
2575
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
2577
WHERE v1.id IN (SELECT id FROM t1_values
2578
WHERE select_id = 89 OR select_id IS NULL) order by id;
2579
CAST(my_double AS UNSIGNED INTEGER) my_double id
2581
9223372036854775808 -1.7976931348623e308 2
2582
9223372036854775807 1.7976931348623e308 3
2584
18446744073709551615 -1 5
2586
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2587
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2591
CREATE VIEW v1 AS SELECT CAST(my_decimal AS UNSIGNED INTEGER),
2592
my_decimal, id FROM t1_values;
2593
SELECT CAST(my_decimal AS UNSIGNED INTEGER),
2594
my_decimal, id FROM t1_values
2595
WHERE select_id = 88 OR select_id IS NULL order by id;
2596
CAST(my_decimal AS UNSIGNED INTEGER) my_decimal id
2598
0 -9999999999999999999999999999999999.999999999999999999999999999999 2
2599
18446744073709551615 9999999999999999999999999999999999.999999999999999999999999999999 3
2600
0 0.000000000000000000000000000000 4
2601
0 -1.000000000000000000000000000000 5
2603
Warning 1292 Truncated incorrect DECIMAL value: ''
2604
Warning 1292 Truncated incorrect DECIMAL value: ''
2605
Warning 1292 Truncated incorrect DECIMAL value: ''
2606
SHOW CREATE VIEW v1;
2607
View Create View character_set_client collation_connection
2608
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
2610
WHERE v1.id IN (SELECT id FROM t1_values
2611
WHERE select_id = 88 OR select_id IS NULL) order by id;
2612
CAST(my_decimal AS UNSIGNED INTEGER) my_decimal id
2614
0 -9999999999999999999999999999999999.999999999999999999999999999999 2
2615
18446744073709551615 9999999999999999999999999999999999.999999999999999999999999999999 3
2616
0 0.000000000000000000000000000000 4
2617
0 -1.000000000000000000000000000000 5
2619
Warning 1292 Truncated incorrect DECIMAL value: ''
2620
Warning 1292 Truncated incorrect DECIMAL value: ''
2621
Warning 1292 Truncated incorrect DECIMAL value: ''
2625
CREATE VIEW v1 AS SELECT CAST(my_bigint AS UNSIGNED INTEGER),
2626
my_bigint, id FROM t1_values;
2627
SELECT CAST(my_bigint AS UNSIGNED INTEGER),
2628
my_bigint, id FROM t1_values
2629
WHERE select_id = 87 OR select_id IS NULL order by id;
2630
CAST(my_bigint AS UNSIGNED INTEGER) my_bigint id
2632
9223372036854775808 -9223372036854775808 2
2633
9223372036854775807 9223372036854775807 3
2635
18446744073709551615 -1 5
2636
SHOW CREATE VIEW v1;
2637
View Create View character_set_client collation_connection
2638
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
2640
WHERE v1.id IN (SELECT id FROM t1_values
2641
WHERE select_id = 87 OR select_id IS NULL) order by id;
2642
CAST(my_bigint AS UNSIGNED INTEGER) my_bigint id
2644
9223372036854775808 -9223372036854775808 2
2645
9223372036854775807 9223372036854775807 3
2647
18446744073709551615 -1 5
2651
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS UNSIGNED INTEGER),
2652
my_varbinary_1000, id FROM t1_values;
2653
SELECT CAST(my_varbinary_1000 AS UNSIGNED INTEGER),
2654
my_varbinary_1000, id FROM t1_values
2655
WHERE select_id = 86 OR select_id IS NULL order by id;
2656
CAST(my_varbinary_1000 AS UNSIGNED INTEGER) my_varbinary_1000 id
2659
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2661
18446744073709551615 -1 5
2663
Warning 1292 Truncated incorrect INTEGER value: ''
2664
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2665
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2666
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2667
SHOW CREATE VIEW v1;
2668
View Create View character_set_client collation_connection
2669
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
2671
WHERE v1.id IN (SELECT id FROM t1_values
2672
WHERE select_id = 86 OR select_id IS NULL) order by id;
2673
CAST(my_varbinary_1000 AS UNSIGNED INTEGER) my_varbinary_1000 id
2676
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2678
18446744073709551615 -1 5
2680
Warning 1292 Truncated incorrect INTEGER value: ''
2681
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2682
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2683
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2687
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS UNSIGNED INTEGER),
2688
my_binary_30, id FROM t1_values;
2689
SELECT CAST(my_binary_30 AS UNSIGNED INTEGER),
2690
my_binary_30, id FROM t1_values
2691
WHERE select_id = 85 OR select_id IS NULL order by id;
2692
CAST(my_binary_30 AS UNSIGNED INTEGER) my_binary_30 id
2695
0 <--------30 characters-------> 3
2697
18446744073709551615 -1 5
2699
Warning 1292 Truncated incorrect INTEGER value: ''
2700
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2701
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2702
Warning 1292 Truncated incorrect INTEGER value: '-1'
2703
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2704
SHOW CREATE VIEW v1;
2705
View Create View character_set_client collation_connection
2706
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
2708
WHERE v1.id IN (SELECT id FROM t1_values
2709
WHERE select_id = 85 OR select_id IS NULL) order by id;
2710
CAST(my_binary_30 AS UNSIGNED INTEGER) my_binary_30 id
2713
0 <--------30 characters-------> 3
2715
18446744073709551615 -1 5
2717
Warning 1292 Truncated incorrect INTEGER value: ''
2718
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2719
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2720
Warning 1292 Truncated incorrect INTEGER value: '-1'
2721
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2725
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS UNSIGNED INTEGER),
2726
my_varchar_1000, id FROM t1_values;
2727
SELECT CAST(my_varchar_1000 AS UNSIGNED INTEGER),
2728
my_varchar_1000, id FROM t1_values
2729
WHERE select_id = 84 OR select_id IS NULL order by id;
2730
CAST(my_varchar_1000 AS UNSIGNED INTEGER) my_varchar_1000 id
2733
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2735
18446744073709551615 -1 5
2737
Warning 1292 Truncated incorrect INTEGER value: ''
2738
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2739
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2740
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2741
SHOW CREATE VIEW v1;
2742
View Create View character_set_client collation_connection
2743
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
2745
WHERE v1.id IN (SELECT id FROM t1_values
2746
WHERE select_id = 84 OR select_id IS NULL) order by id;
2747
CAST(my_varchar_1000 AS UNSIGNED INTEGER) my_varchar_1000 id
2750
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2752
18446744073709551615 -1 5
2754
Warning 1292 Truncated incorrect INTEGER value: ''
2755
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2756
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
2757
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2761
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS UNSIGNED INTEGER),
2762
my_char_30, id FROM t1_values;
2763
SELECT CAST(my_char_30 AS UNSIGNED INTEGER),
2764
my_char_30, id FROM t1_values
2765
WHERE select_id = 83 OR select_id IS NULL order by id;
2766
CAST(my_char_30 AS UNSIGNED INTEGER) my_char_30 id
2769
0 <--------30 characters-------> 3
2771
18446744073709551615 -1 5
2773
Warning 1292 Truncated incorrect INTEGER value: ''
2774
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2775
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$--'
2776
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2777
SHOW CREATE VIEW v1;
2778
View Create View character_set_client collation_connection
2779
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
2781
WHERE v1.id IN (SELECT id FROM t1_values
2782
WHERE select_id = 83 OR select_id IS NULL) order by id;
2783
CAST(my_char_30 AS UNSIGNED INTEGER) my_char_30 id
2786
0 <--------30 characters-------> 3
2788
18446744073709551615 -1 5
2790
Warning 1292 Truncated incorrect INTEGER value: ''
2791
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2792
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$--'
2793
Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2797
CREATE VIEW v1 AS SELECT CAST(my_year AS SIGNED INTEGER),
2798
my_year, id FROM t1_values;
2799
SELECT CAST(my_year AS SIGNED INTEGER),
2800
my_year, id FROM t1_values
2801
WHERE select_id = 82 OR select_id IS NULL order by id;
2802
CAST(my_year AS SIGNED INTEGER) my_year id
2808
SHOW CREATE VIEW v1;
2809
View Create View character_set_client collation_connection
2810
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
2812
WHERE v1.id IN (SELECT id FROM t1_values
2813
WHERE select_id = 82 OR select_id IS NULL) order by id;
2814
CAST(my_year AS SIGNED INTEGER) my_year id
2823
CREATE VIEW v1 AS SELECT CAST(my_time AS SIGNED INTEGER),
2824
my_time, id FROM t1_values;
2825
SELECT CAST(my_time AS SIGNED INTEGER),
2826
my_time, id FROM t1_values
2827
WHERE select_id = 81 OR select_id IS NULL order by id;
2828
CAST(my_time AS SIGNED INTEGER) my_time id
2830
-8385959 -838:59:59 2
2834
SHOW CREATE VIEW v1;
2835
View Create View character_set_client collation_connection
2836
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
2838
WHERE v1.id IN (SELECT id FROM t1_values
2839
WHERE select_id = 81 OR select_id IS NULL) order by id;
2840
CAST(my_time AS SIGNED INTEGER) my_time id
2842
-8385959 -838:59:59 2
2849
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS SIGNED INTEGER),
2850
my_timestamp, id FROM t1_values;
2851
SELECT CAST(my_timestamp AS SIGNED INTEGER),
2852
my_timestamp, id FROM t1_values
2853
WHERE select_id = 80 OR select_id IS NULL order by id;
2854
CAST(my_timestamp AS SIGNED INTEGER) my_timestamp id
2855
0 0000-00-00 00:00:00 1
2856
19700101030001 1970-01-01 03:00:01 2
2857
20380101025959 2038-01-01 02:59:59 3
2858
20040229235959 2004-02-29 23:59:59 4
2859
20050628100000 2005-06-28 10:00:00 5
2860
SHOW CREATE VIEW v1;
2861
View Create View character_set_client collation_connection
2862
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
2864
WHERE v1.id IN (SELECT id FROM t1_values
2865
WHERE select_id = 80 OR select_id IS NULL) order by id;
2866
CAST(my_timestamp AS SIGNED INTEGER) my_timestamp id
2867
0 0000-00-00 00:00:00 1
2868
19700101030001 1970-01-01 03:00:01 2
2869
20380101025959 2038-01-01 02:59:59 3
2870
20040229235959 2004-02-29 23:59:59 4
2871
20050628100000 2005-06-28 10:00:00 5
2875
CREATE VIEW v1 AS SELECT CAST(my_date AS SIGNED INTEGER),
2876
my_date, id FROM t1_values;
2877
SELECT CAST(my_date AS SIGNED INTEGER),
2878
my_date, id FROM t1_values
2879
WHERE select_id = 79 OR select_id IS NULL order by id;
2880
CAST(my_date AS SIGNED INTEGER) my_date id
2883
99991231 9999-12-31 3
2884
20040229 2004-02-29 4
2885
20050628 2005-06-28 5
2886
SHOW CREATE VIEW v1;
2887
View Create View character_set_client collation_connection
2888
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
2890
WHERE v1.id IN (SELECT id FROM t1_values
2891
WHERE select_id = 79 OR select_id IS NULL) order by id;
2892
CAST(my_date AS SIGNED INTEGER) my_date id
2895
99991231 9999-12-31 3
2896
20040229 2004-02-29 4
2897
20050628 2005-06-28 5
2901
CREATE VIEW v1 AS SELECT CAST(my_datetime AS SIGNED INTEGER),
2902
my_datetime, id FROM t1_values;
2903
SELECT CAST(my_datetime AS SIGNED INTEGER),
2904
my_datetime, id FROM t1_values
2905
WHERE select_id = 78 OR select_id IS NULL order by id;
2906
CAST(my_datetime AS SIGNED INTEGER) my_datetime id
2908
10101000000 0001-01-01 00:00:00 2
2909
99991231235959 9999-12-31 23:59:59 3
2910
20040229235959 2004-02-29 23:59:59 4
2911
20050628100000 2005-06-28 10:00:00 5
2912
SHOW CREATE VIEW v1;
2913
View Create View character_set_client collation_connection
2914
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
2916
WHERE v1.id IN (SELECT id FROM t1_values
2917
WHERE select_id = 78 OR select_id IS NULL) order by id;
2918
CAST(my_datetime AS SIGNED INTEGER) my_datetime id
2920
10101000000 0001-01-01 00:00:00 2
2921
99991231235959 9999-12-31 23:59:59 3
2922
20040229235959 2004-02-29 23:59:59 4
2923
20050628100000 2005-06-28 10:00:00 5
2927
CREATE VIEW v1 AS SELECT CAST(my_double AS SIGNED INTEGER),
2928
my_double, id FROM t1_values;
2929
SELECT CAST(my_double AS SIGNED INTEGER),
2930
my_double, id FROM t1_values
2931
WHERE select_id = 77 OR select_id IS NULL order by id;
2932
CAST(my_double AS SIGNED INTEGER) my_double id
2934
-9223372036854775808 -1.7976931348623e308 2
2935
9223372036854775807 1.7976931348623e308 3
2939
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2940
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2941
SHOW CREATE VIEW v1;
2942
View Create View character_set_client collation_connection
2943
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
2945
WHERE v1.id IN (SELECT id FROM t1_values
2946
WHERE select_id = 77 OR select_id IS NULL) order by id;
2947
CAST(my_double AS SIGNED INTEGER) my_double id
2949
-9223372036854775808 -1.7976931348623e308 2
2950
9223372036854775807 1.7976931348623e308 3
2954
Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e308'
2955
Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e308'
2959
CREATE VIEW v1 AS SELECT CAST(my_decimal AS SIGNED INTEGER),
2960
my_decimal, id FROM t1_values;
2961
SELECT CAST(my_decimal AS SIGNED INTEGER),
2962
my_decimal, id FROM t1_values
2963
WHERE select_id = 76 OR select_id IS NULL order by id;
2964
CAST(my_decimal AS SIGNED INTEGER) my_decimal id
2966
-9223372036854775808 -9999999999999999999999999999999999.999999999999999999999999999999 2
2967
9223372036854775807 9999999999999999999999999999999999.999999999999999999999999999999 3
2968
0 0.000000000000000000000000000000 4
2969
-1 -1.000000000000000000000000000000 5
2971
Warning 1292 Truncated incorrect DECIMAL value: ''
2972
Warning 1292 Truncated incorrect DECIMAL value: ''
2973
SHOW CREATE VIEW v1;
2974
View Create View character_set_client collation_connection
2975
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
2977
WHERE v1.id IN (SELECT id FROM t1_values
2978
WHERE select_id = 76 OR select_id IS NULL) order by id;
2979
CAST(my_decimal AS SIGNED INTEGER) my_decimal id
2981
-9223372036854775808 -9999999999999999999999999999999999.999999999999999999999999999999 2
2982
9223372036854775807 9999999999999999999999999999999999.999999999999999999999999999999 3
2983
0 0.000000000000000000000000000000 4
2984
-1 -1.000000000000000000000000000000 5
2986
Warning 1292 Truncated incorrect DECIMAL value: ''
2987
Warning 1292 Truncated incorrect DECIMAL value: ''
2991
CREATE VIEW v1 AS SELECT CAST(my_bigint AS SIGNED INTEGER),
2992
my_bigint, id FROM t1_values;
2993
SELECT CAST(my_bigint AS SIGNED INTEGER),
2994
my_bigint, id FROM t1_values
2995
WHERE select_id = 75 OR select_id IS NULL order by id;
2996
CAST(my_bigint AS SIGNED INTEGER) my_bigint id
2998
-9223372036854775808 -9223372036854775808 2
2999
9223372036854775807 9223372036854775807 3
3002
SHOW CREATE VIEW v1;
3003
View Create View character_set_client collation_connection
3004
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
3006
WHERE v1.id IN (SELECT id FROM t1_values
3007
WHERE select_id = 75 OR select_id IS NULL) order by id;
3008
CAST(my_bigint AS SIGNED INTEGER) my_bigint id
3010
-9223372036854775808 -9223372036854775808 2
3011
9223372036854775807 9223372036854775807 3
3017
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS SIGNED INTEGER),
3018
my_varbinary_1000, id FROM t1_values;
3019
SELECT CAST(my_varbinary_1000 AS SIGNED INTEGER),
3020
my_varbinary_1000, id FROM t1_values
3021
WHERE select_id = 74 OR select_id IS NULL order by id;
3022
CAST(my_varbinary_1000 AS SIGNED INTEGER) my_varbinary_1000 id
3025
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3029
Warning 1292 Truncated incorrect INTEGER value: ''
3030
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3031
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3032
SHOW CREATE VIEW v1;
3033
View Create View character_set_client collation_connection
3034
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
3036
WHERE v1.id IN (SELECT id FROM t1_values
3037
WHERE select_id = 74 OR select_id IS NULL) order by id;
3038
CAST(my_varbinary_1000 AS SIGNED INTEGER) my_varbinary_1000 id
3041
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3045
Warning 1292 Truncated incorrect INTEGER value: ''
3046
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3047
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3051
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS SIGNED INTEGER),
3052
my_binary_30, id FROM t1_values;
3053
SELECT CAST(my_binary_30 AS SIGNED INTEGER),
3054
my_binary_30, id FROM t1_values
3055
WHERE select_id = 73 OR select_id IS NULL order by id;
3056
CAST(my_binary_30 AS SIGNED INTEGER) my_binary_30 id
3059
0 <--------30 characters-------> 3
3063
Warning 1292 Truncated incorrect INTEGER value: ''
3064
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3065
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3066
Warning 1292 Truncated incorrect INTEGER value: '-1'
3067
SHOW CREATE VIEW v1;
3068
View Create View character_set_client collation_connection
3069
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
3071
WHERE v1.id IN (SELECT id FROM t1_values
3072
WHERE select_id = 73 OR select_id IS NULL) order by id;
3073
CAST(my_binary_30 AS SIGNED INTEGER) my_binary_30 id
3076
0 <--------30 characters-------> 3
3080
Warning 1292 Truncated incorrect INTEGER value: ''
3081
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3082
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3083
Warning 1292 Truncated incorrect INTEGER value: '-1'
3087
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS SIGNED INTEGER),
3088
my_varchar_1000, id FROM t1_values;
3089
SELECT CAST(my_varchar_1000 AS SIGNED INTEGER),
3090
my_varchar_1000, id FROM t1_values
3091
WHERE select_id = 72 OR select_id IS NULL order by id;
3092
CAST(my_varchar_1000 AS SIGNED INTEGER) my_varchar_1000 id
3095
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3099
Warning 1292 Truncated incorrect INTEGER value: ''
3100
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3101
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3102
SHOW CREATE VIEW v1;
3103
View Create View character_set_client collation_connection
3104
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
3106
WHERE v1.id IN (SELECT id FROM t1_values
3107
WHERE select_id = 72 OR select_id IS NULL) order by id;
3108
CAST(my_varchar_1000 AS SIGNED INTEGER) my_varchar_1000 id
3111
0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3115
Warning 1292 Truncated incorrect INTEGER value: ''
3116
Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3117
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$-- '
3121
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS SIGNED INTEGER),
3122
my_char_30, id FROM t1_values;
3123
SELECT CAST(my_char_30 AS SIGNED INTEGER),
3124
my_char_30, id FROM t1_values
3125
WHERE select_id = 71 OR select_id IS NULL order by id;
3126
CAST(my_char_30 AS SIGNED INTEGER) my_char_30 id
3129
0 <--------30 characters-------> 3
3133
Warning 1292 Truncated incorrect INTEGER value: ''
3134
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3135
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$--'
3136
SHOW CREATE VIEW v1;
3137
View Create View character_set_client collation_connection
3138
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
3140
WHERE v1.id IN (SELECT id FROM t1_values
3141
WHERE select_id = 71 OR select_id IS NULL) order by id;
3142
CAST(my_char_30 AS SIGNED INTEGER) my_char_30 id
3145
0 <--------30 characters-------> 3
3149
Warning 1292 Truncated incorrect INTEGER value: ''
3150
Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3151
Warning 1292 Truncated incorrect INTEGER value: ' ---����@�*$--'
3155
CREATE VIEW v1 AS SELECT CAST(my_year AS DECIMAL(37,2)),
3156
my_year, id FROM t1_values;
3157
SELECT CAST(my_year AS DECIMAL(37,2)),
3158
my_year, id FROM t1_values
3159
WHERE select_id = 70 OR select_id IS NULL order by id;
3160
CAST(my_year AS DECIMAL(37,2)) my_year id
3166
SHOW CREATE VIEW v1;
3167
View Create View character_set_client collation_connection
3168
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
3170
WHERE v1.id IN (SELECT id FROM t1_values
3171
WHERE select_id = 70 OR select_id IS NULL) order by id;
3172
CAST(my_year AS DECIMAL(37,2)) my_year id
3181
CREATE VIEW v1 AS SELECT CAST(my_time AS DECIMAL(37,2)),
3182
my_time, id FROM t1_values;
3183
SELECT CAST(my_time AS DECIMAL(37,2)),
3184
my_time, id FROM t1_values
3185
WHERE select_id = 69 OR select_id IS NULL order by id;
3186
CAST(my_time AS DECIMAL(37,2)) my_time id
3188
-8385959.00 -838:59:59 2
3189
8385959.00 838:59:59 3
3190
130000.00 13:00:00 4
3191
100000.00 10:00:00 5
3192
SHOW CREATE VIEW v1;
3193
View Create View character_set_client collation_connection
3194
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
3196
WHERE v1.id IN (SELECT id FROM t1_values
3197
WHERE select_id = 69 OR select_id IS NULL) order by id;
3198
CAST(my_time AS DECIMAL(37,2)) my_time id
3200
-8385959.00 -838:59:59 2
3201
8385959.00 838:59:59 3
3202
130000.00 13:00:00 4
3203
100000.00 10:00:00 5
3207
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DECIMAL(37,2)),
3208
my_timestamp, id FROM t1_values;
3209
SELECT CAST(my_timestamp AS DECIMAL(37,2)),
3210
my_timestamp, id FROM t1_values
3211
WHERE select_id = 68 OR select_id IS NULL order by id;
3212
CAST(my_timestamp AS DECIMAL(37,2)) my_timestamp id
3213
0.00 0000-00-00 00:00:00 1
3214
19700101030001.00 1970-01-01 03:00:01 2
3215
20380101025959.00 2038-01-01 02:59:59 3
3216
20040229235959.00 2004-02-29 23:59:59 4
3217
20050628100000.00 2005-06-28 10:00:00 5
3218
SHOW CREATE VIEW v1;
3219
View Create View character_set_client collation_connection
3220
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
3222
WHERE v1.id IN (SELECT id FROM t1_values
3223
WHERE select_id = 68 OR select_id IS NULL) order by id;
3224
CAST(my_timestamp AS DECIMAL(37,2)) my_timestamp id
3225
0.00 0000-00-00 00:00:00 1
3226
19700101030001.00 1970-01-01 03:00:01 2
3227
20380101025959.00 2038-01-01 02:59:59 3
3228
20040229235959.00 2004-02-29 23:59:59 4
3229
20050628100000.00 2005-06-28 10:00:00 5
3233
CREATE VIEW v1 AS SELECT CAST(my_date AS DECIMAL(37,2)),
3234
my_date, id FROM t1_values;
3235
SELECT CAST(my_date AS DECIMAL(37,2)),
3236
my_date, id FROM t1_values
3237
WHERE select_id = 67 OR select_id IS NULL order by id;
3238
CAST(my_date AS DECIMAL(37,2)) my_date id
3240
10101.00 0001-01-01 2
3241
99991231.00 9999-12-31 3
3242
20040229.00 2004-02-29 4
3243
20050628.00 2005-06-28 5
3244
SHOW CREATE VIEW v1;
3245
View Create View character_set_client collation_connection
3246
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
3248
WHERE v1.id IN (SELECT id FROM t1_values
3249
WHERE select_id = 67 OR select_id IS NULL) order by id;
3250
CAST(my_date AS DECIMAL(37,2)) my_date id
3252
10101.00 0001-01-01 2
3253
99991231.00 9999-12-31 3
3254
20040229.00 2004-02-29 4
3255
20050628.00 2005-06-28 5
3259
CREATE VIEW v1 AS SELECT CAST(my_datetime AS DECIMAL(37,2)),
3260
my_datetime, id FROM t1_values;
3261
SELECT CAST(my_datetime AS DECIMAL(37,2)),
3262
my_datetime, id FROM t1_values
3263
WHERE select_id = 66 OR select_id IS NULL order by id;
3264
CAST(my_datetime AS DECIMAL(37,2)) my_datetime id
3266
10101000000.00 0001-01-01 00:00:00 2
3267
99991231235959.00 9999-12-31 23:59:59 3
3268
20040229235959.00 2004-02-29 23:59:59 4
3269
20050628100000.00 2005-06-28 10:00:00 5
3270
SHOW CREATE VIEW v1;
3271
View Create View character_set_client collation_connection
3272
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
3274
WHERE v1.id IN (SELECT id FROM t1_values
3275
WHERE select_id = 66 OR select_id IS NULL) order by id;
3276
CAST(my_datetime AS DECIMAL(37,2)) my_datetime id
3278
10101000000.00 0001-01-01 00:00:00 2
3279
99991231235959.00 9999-12-31 23:59:59 3
3280
20040229235959.00 2004-02-29 23:59:59 4
3281
20050628100000.00 2005-06-28 10:00:00 5
3285
CREATE VIEW v1 AS SELECT CAST(my_double AS DECIMAL(37,2)),
3286
my_double, id FROM t1_values;
3287
SELECT CAST(my_double AS DECIMAL(37,2)),
3288
my_double, id FROM t1_values
3289
WHERE select_id = 65 OR select_id IS NULL order by id;
3290
CAST(my_double AS DECIMAL(37,2)) my_double id
3292
-99999999999999999999999999999999999.99 -1.7976931348623e308 2
3293
99999999999999999999999999999999999.99 1.7976931348623e308 3
3296
-3333.33 -3333.3333 30
3298
Warning 1292 Truncated incorrect DECIMAL value: ''
3299
Warning 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3300
Warning 1292 Truncated incorrect DECIMAL value: ''
3301
Warning 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3302
SHOW CREATE VIEW v1;
3303
View Create View character_set_client collation_connection
3304
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
3306
WHERE v1.id IN (SELECT id FROM t1_values
3307
WHERE select_id = 65 OR select_id IS NULL) order by id;
3308
CAST(my_double AS DECIMAL(37,2)) my_double id
3310
-99999999999999999999999999999999999.99 -1.7976931348623e308 2
3311
99999999999999999999999999999999999.99 1.7976931348623e308 3
3314
-3333.33 -3333.3333 30
3316
Warning 1292 Truncated incorrect DECIMAL value: ''
3317
Warning 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3318
Warning 1292 Truncated incorrect DECIMAL value: ''
3319
Warning 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3323
CREATE VIEW v1 AS SELECT CAST(my_decimal AS DECIMAL(37,2)),
3324
my_decimal, id FROM t1_values;
3325
SELECT CAST(my_decimal AS DECIMAL(37,2)),
3326
my_decimal, id FROM t1_values
3327
WHERE select_id = 64 OR select_id IS NULL order by id;
3328
CAST(my_decimal AS DECIMAL(37,2)) my_decimal id
3330
-10000000000000000000000000000000000.00 -9999999999999999999999999999999999.999999999999999999999999999999 2
3331
10000000000000000000000000000000000.00 9999999999999999999999999999999999.999999999999999999999999999999 3
3332
0.00 0.000000000000000000000000000000 4
3333
-1.00 -1.000000000000000000000000000000 5
3334
SHOW CREATE VIEW v1;
3335
View Create View character_set_client collation_connection
3336
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
3338
WHERE v1.id IN (SELECT id FROM t1_values
3339
WHERE select_id = 64 OR select_id IS NULL) order by id;
3340
CAST(my_decimal AS DECIMAL(37,2)) my_decimal id
3342
-10000000000000000000000000000000000.00 -9999999999999999999999999999999999.999999999999999999999999999999 2
3343
10000000000000000000000000000000000.00 9999999999999999999999999999999999.999999999999999999999999999999 3
3344
0.00 0.000000000000000000000000000000 4
3345
-1.00 -1.000000000000000000000000000000 5
3349
CREATE VIEW v1 AS SELECT CAST(my_bigint AS DECIMAL(37,2)),
3350
my_bigint, id FROM t1_values;
3351
SELECT CAST(my_bigint AS DECIMAL(37,2)),
3352
my_bigint, id FROM t1_values
3353
WHERE select_id = 63 OR select_id IS NULL order by id;
3354
CAST(my_bigint AS DECIMAL(37,2)) my_bigint id
3356
-9223372036854775808.00 -9223372036854775808 2
3357
9223372036854775807.00 9223372036854775807 3
3360
SHOW CREATE VIEW v1;
3361
View Create View character_set_client collation_connection
3362
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
3364
WHERE v1.id IN (SELECT id FROM t1_values
3365
WHERE select_id = 63 OR select_id IS NULL) order by id;
3366
CAST(my_bigint AS DECIMAL(37,2)) my_bigint id
3368
-9223372036854775808.00 -9223372036854775808 2
3369
9223372036854775807.00 9223372036854775807 3
3375
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DECIMAL(37,2)),
3376
my_varbinary_1000, id FROM t1_values;
3377
SELECT CAST(my_varbinary_1000 AS DECIMAL(37,2)),
3378
my_varbinary_1000, id FROM t1_values
3379
WHERE select_id = 62 OR select_id IS NULL order by id;
3380
CAST(my_varbinary_1000 AS DECIMAL(37,2)) my_varbinary_1000 id
3383
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3384
0.00 ---äÖüß@µ*$-- 4
3386
-3333.33 -3333.3333 29
3388
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3389
Warning 1292 Truncated incorrect DECIMAL value: ''
3390
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3391
Warning 1292 Truncated incorrect DECIMAL value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3392
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3393
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3394
SHOW CREATE VIEW v1;
3395
View Create View character_set_client collation_connection
3396
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
3398
WHERE v1.id IN (SELECT id FROM t1_values
3399
WHERE select_id = 62 OR select_id IS NULL) order by id;
3400
CAST(my_varbinary_1000 AS DECIMAL(37,2)) my_varbinary_1000 id
3403
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3404
0.00 ---äÖüß@µ*$-- 4
3406
-3333.33 -3333.3333 29
3408
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3409
Warning 1292 Truncated incorrect DECIMAL value: ''
3410
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3411
Warning 1292 Truncated incorrect DECIMAL value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3412
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3413
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3417
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DECIMAL(37,2)),
3418
my_binary_30, id FROM t1_values;
3419
SELECT CAST(my_binary_30 AS DECIMAL(37,2)),
3420
my_binary_30, id FROM t1_values
3421
WHERE select_id = 61 OR select_id IS NULL order by id;
3422
CAST(my_binary_30 AS DECIMAL(37,2)) my_binary_30 id
3425
0.00 <--------30 characters-------> 3
3426
0.00 ---äÖüß@µ*$-- 4
3428
-3333.33 -3333.3333 28
3430
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3431
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'
3432
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3433
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3434
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3435
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'
3436
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'
3437
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'
3438
SHOW CREATE VIEW v1;
3439
View Create View character_set_client collation_connection
3440
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
3442
WHERE v1.id IN (SELECT id FROM t1_values
3443
WHERE select_id = 61 OR select_id IS NULL) order by id;
3444
CAST(my_binary_30 AS DECIMAL(37,2)) my_binary_30 id
3447
0.00 <--------30 characters-------> 3
3448
0.00 ---äÖüß@µ*$-- 4
3450
-3333.33 -3333.3333 28
3452
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3453
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'
3454
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3455
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3456
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3457
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'
3458
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'
3459
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'
3463
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DECIMAL(37,2)),
3464
my_varchar_1000, id FROM t1_values;
3465
SELECT CAST(my_varchar_1000 AS DECIMAL(37,2)),
3466
my_varchar_1000, id FROM t1_values
3467
WHERE select_id = 60 OR select_id IS NULL order by id;
3468
CAST(my_varchar_1000 AS DECIMAL(37,2)) my_varchar_1000 id
3471
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3472
0.00 ---äÖüß@µ*$-- 4
3474
-3333.33 -3333.3333 27
3476
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3477
Warning 1292 Truncated incorrect DECIMAL value: ''
3478
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3479
Warning 1292 Truncated incorrect DECIMAL value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3480
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3481
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3482
SHOW CREATE VIEW v1;
3483
View Create View character_set_client collation_connection
3484
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
3486
WHERE v1.id IN (SELECT id FROM t1_values
3487
WHERE select_id = 60 OR select_id IS NULL) order by id;
3488
CAST(my_varchar_1000 AS DECIMAL(37,2)) my_varchar_1000 id
3491
0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3492
0.00 ---äÖüß@µ*$-- 4
3494
-3333.33 -3333.3333 27
3496
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3497
Warning 1292 Truncated incorrect DECIMAL value: ''
3498
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3499
Warning 1292 Truncated incorrect DECIMAL value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3500
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3501
Warning 1292 Truncated incorrect DECIMAL value: ' ---����@�*$-- '
3505
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DECIMAL(37,2)),
3506
my_char_30, id FROM t1_values;
3507
SELECT CAST(my_char_30 AS DECIMAL(37,2)),
3508
my_char_30, id FROM t1_values
3509
WHERE select_id = 59 OR select_id IS NULL order by id;
3510
CAST(my_char_30 AS DECIMAL(37,2)) my_char_30 id
3513
0.00 <--------30 characters-------> 3
3514
0.00 ---äÖüß@µ*$-- 4
3516
-3333.33 -3333.3333 26
3518
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3519
Warning 1292 Truncated incorrect DECIMAL value: ' '
3520
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3521
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3522
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3523
Warning 1292 Truncated incorrect DECIMAL value: ' ---äÖüß@µ*$-- '
3524
SHOW CREATE VIEW v1;
3525
View Create View character_set_client collation_connection
3526
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
3528
WHERE v1.id IN (SELECT id FROM t1_values
3529
WHERE select_id = 59 OR select_id IS NULL) order by id;
3530
CAST(my_char_30 AS DECIMAL(37,2)) my_char_30 id
3533
0.00 <--------30 characters-------> 3
3534
0.00 ---äÖüß@µ*$-- 4
3536
-3333.33 -3333.3333 26
3538
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3539
Warning 1292 Truncated incorrect DECIMAL value: ' '
3540
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3541
Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3542
Warning 1366 Incorrect decimal value: '' for column '' at row -1
3543
Warning 1292 Truncated incorrect DECIMAL value: ' ---äÖüß@µ*$-- '
3547
CREATE VIEW v1 AS SELECT CAST(my_year AS TIME),
3548
my_year, id FROM t1_values;
3549
SELECT CAST(my_year AS TIME),
3550
my_year, id FROM t1_values
3551
WHERE select_id = 58 OR select_id IS NULL order by id;
3552
CAST(my_year AS TIME) my_year id
3558
SHOW CREATE VIEW v1;
3559
View Create View character_set_client collation_connection
3560
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
3562
WHERE v1.id IN (SELECT id FROM t1_values
3563
WHERE select_id = 58 OR select_id IS NULL) order by id;
3564
CAST(my_year AS TIME) my_year id
3573
CREATE VIEW v1 AS SELECT CAST(my_time AS TIME),
3574
my_time, id FROM t1_values;
3575
SELECT CAST(my_time AS TIME),
3576
my_time, id FROM t1_values
3577
WHERE select_id = 57 OR select_id IS NULL order by id;
3578
CAST(my_time AS TIME) my_time id
3580
-838:59:59 -838:59:59 2
3581
838:59:59 838:59:59 3
3584
SHOW CREATE VIEW v1;
3585
View Create View character_set_client collation_connection
3586
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
3588
WHERE v1.id IN (SELECT id FROM t1_values
3589
WHERE select_id = 57 OR select_id IS NULL) order by id;
3590
CAST(my_time AS TIME) my_time id
3592
-838:59:59 -838:59:59 2
3593
838:59:59 838:59:59 3
3599
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS TIME),
3600
my_timestamp, id FROM t1_values;
3601
SELECT CAST(my_timestamp AS TIME),
3602
my_timestamp, id FROM t1_values
3603
WHERE select_id = 56 OR select_id IS NULL order by id;
3604
CAST(my_timestamp AS TIME) my_timestamp id
3605
00:00:00 0000-00-00 00:00:00 1
3606
03:00:01 1970-01-01 03:00:01 2
3607
02:59:59 2038-01-01 02:59:59 3
3608
23:59:59 2004-02-29 23:59:59 4
3609
10:00:00 2005-06-28 10:00:00 5
3610
SHOW CREATE VIEW v1;
3611
View Create View character_set_client collation_connection
3612
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
3614
WHERE v1.id IN (SELECT id FROM t1_values
3615
WHERE select_id = 56 OR select_id IS NULL) order by id;
3616
CAST(my_timestamp AS TIME) my_timestamp id
3617
00:00:00 0000-00-00 00:00:00 1
3618
03:00:01 1970-01-01 03:00:01 2
3619
02:59:59 2038-01-01 02:59:59 3
3620
23:59:59 2004-02-29 23:59:59 4
3621
10:00:00 2005-06-28 10:00:00 5
3625
CREATE VIEW v1 AS SELECT CAST(my_date AS TIME),
3626
my_date, id FROM t1_values;
3627
SELECT CAST(my_date AS TIME),
3628
my_date, id FROM t1_values
3629
WHERE select_id = 55 OR select_id IS NULL order by id;
3630
CAST(my_date AS TIME) my_date id
3632
00:00:00 0001-01-01 2
3633
00:00:00 9999-12-31 3
3634
00:00:00 2004-02-29 4
3635
00:00:00 2005-06-28 5
3636
SHOW CREATE VIEW v1;
3637
View Create View character_set_client collation_connection
3638
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
3640
WHERE v1.id IN (SELECT id FROM t1_values
3641
WHERE select_id = 55 OR select_id IS NULL) order by id;
3642
CAST(my_date AS TIME) my_date id
3644
00:00:00 0001-01-01 2
3645
00:00:00 9999-12-31 3
3646
00:00:00 2004-02-29 4
3647
00:00:00 2005-06-28 5
3651
CREATE VIEW v1 AS SELECT CAST(my_datetime AS TIME),
3652
my_datetime, id FROM t1_values;
3653
SELECT CAST(my_datetime AS TIME),
3654
my_datetime, id FROM t1_values
3655
WHERE select_id = 54 OR select_id IS NULL order by id;
3656
CAST(my_datetime AS TIME) my_datetime id
3658
00:00:00 0001-01-01 00:00:00 2
3659
23:59:59 9999-12-31 23:59:59 3
3660
23:59:59 2004-02-29 23:59:59 4
3661
10:00:00 2005-06-28 10:00:00 5
3662
SHOW CREATE VIEW v1;
3663
View Create View character_set_client collation_connection
3664
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_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
3666
WHERE v1.id IN (SELECT id FROM t1_values
3667
WHERE select_id = 54 OR select_id IS NULL) order by id;
3668
CAST(my_datetime AS TIME) my_datetime id
3670
00:00:00 0001-01-01 00:00:00 2
3671
23:59:59 9999-12-31 23:59:59 3
3672
23:59:59 2004-02-29 23:59:59 4
3673
10:00:00 2005-06-28 10:00:00 5
3677
CREATE VIEW v1 AS SELECT CAST(my_double AS TIME),
3678
my_double, id FROM t1_values;
3679
SELECT CAST(my_double AS TIME),
3680
my_double, id FROM t1_values
3681
WHERE select_id = 53 OR select_id IS NULL order by id;
3682
CAST(my_double AS TIME) my_double id
3684
NULL -1.7976931348623e308 2
3685
NULL 1.7976931348623e308 3
3690
Warning 1292 Truncated incorrect time value: '-1.7976931348623e308'
3691
Warning 1292 Truncated incorrect time value: '1.7976931348623e308'
3692
SHOW CREATE VIEW v1;
3693
View Create View character_set_client collation_connection
3694
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
3696
WHERE v1.id IN (SELECT id FROM t1_values
3697
WHERE select_id = 53 OR select_id IS NULL) order by id;
3698
CAST(my_double AS TIME) my_double id
3700
NULL -1.7976931348623e308 2
3701
NULL 1.7976931348623e308 3
3706
Warning 1292 Truncated incorrect time value: '-1.7976931348623e308'
3707
Warning 1292 Truncated incorrect time value: '1.7976931348623e308'
3711
CREATE VIEW v1 AS SELECT CAST(my_bigint AS TIME),
3712
my_bigint, id FROM t1_values;
3713
SELECT CAST(my_bigint AS TIME),
3714
my_bigint, id FROM t1_values
3715
WHERE select_id = 52 OR select_id IS NULL order by id;
3716
CAST(my_bigint AS TIME) my_bigint id
3718
NULL -9223372036854775808 2
3719
NULL 9223372036854775807 3
3724
Warning 1292 Truncated incorrect time value: '-9223372036854775808'
3725
Warning 1292 Truncated incorrect time value: '9223372036854775807'
3726
SHOW CREATE VIEW v1;
3727
View Create View character_set_client collation_connection
3728
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
3730
WHERE v1.id IN (SELECT id FROM t1_values
3731
WHERE select_id = 52 OR select_id IS NULL) order by id;
3732
CAST(my_bigint AS TIME) my_bigint id
3734
NULL -9223372036854775808 2
3735
NULL 9223372036854775807 3
3740
Warning 1292 Truncated incorrect time value: '-9223372036854775808'
3741
Warning 1292 Truncated incorrect time value: '9223372036854775807'
3745
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS TIME),
3746
my_varbinary_1000, id FROM t1_values;
3747
SELECT CAST(my_varbinary_1000 AS TIME),
3748
my_varbinary_1000, id FROM t1_values
3749
WHERE select_id = 51 OR select_id IS NULL order by id;
3750
CAST(my_varbinary_1000 AS TIME) my_varbinary_1000 id
3753
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3754
-00:00:00 ---äÖüß@µ*$-- 4
3758
Warning 1292 Truncated incorrect time value: ''
3759
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3760
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3761
SHOW CREATE VIEW v1;
3762
View Create View character_set_client collation_connection
3763
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
3765
WHERE v1.id IN (SELECT id FROM t1_values
3766
WHERE select_id = 51 OR select_id IS NULL) order by id;
3767
CAST(my_varbinary_1000 AS TIME) my_varbinary_1000 id
3770
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3771
-00:00:00 ---äÖüß@µ*$-- 4
3775
Warning 1292 Truncated incorrect time value: ''
3776
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3777
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3781
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS TIME),
3782
my_binary_30, id FROM t1_values;
3783
SELECT CAST(my_binary_30 AS TIME),
3784
my_binary_30, id FROM t1_values
3785
WHERE select_id = 50 OR select_id IS NULL order by id;
3786
CAST(my_binary_30 AS TIME) my_binary_30 id
3789
00:00:00 <--------30 characters-------> 3
3790
-00:00:00 ---äÖüß@µ*$-- 4
3794
Warning 1292 Truncated incorrect time value: ''
3795
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3796
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3797
Warning 1292 Truncated incorrect time value: '-1'
3798
Warning 1292 Truncated incorrect time value: '1 17:58'
3799
SHOW CREATE VIEW v1;
3800
View Create View character_set_client collation_connection
3801
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
3803
WHERE v1.id IN (SELECT id FROM t1_values
3804
WHERE select_id = 50 OR select_id IS NULL) order by id;
3805
CAST(my_binary_30 AS TIME) my_binary_30 id
3808
00:00:00 <--------30 characters-------> 3
3809
-00:00:00 ---äÖüß@µ*$-- 4
3813
Warning 1292 Truncated incorrect time value: ''
3814
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3815
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3816
Warning 1292 Truncated incorrect time value: '-1'
3817
Warning 1292 Truncated incorrect time value: '1 17:58'
3821
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS TIME),
3822
my_varchar_1000, id FROM t1_values;
3823
SELECT CAST(my_varchar_1000 AS TIME),
3824
my_varchar_1000, id FROM t1_values
3825
WHERE select_id = 49 OR select_id IS NULL order by id;
3826
CAST(my_varchar_1000 AS TIME) my_varchar_1000 id
3829
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3830
-00:00:00 ---äÖüß@µ*$-- 4
3834
Warning 1292 Truncated incorrect time value: ''
3835
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3836
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3837
SHOW CREATE VIEW v1;
3838
View Create View character_set_client collation_connection
3839
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
3841
WHERE v1.id IN (SELECT id FROM t1_values
3842
WHERE select_id = 49 OR select_id IS NULL) order by id;
3843
CAST(my_varchar_1000 AS TIME) my_varchar_1000 id
3846
00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3847
-00:00:00 ---äÖüß@µ*$-- 4
3851
Warning 1292 Truncated incorrect time value: ''
3852
Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3853
Warning 1292 Truncated incorrect time value: ' ---����@�*$-- '
3857
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS TIME),
3858
my_char_30, id FROM t1_values;
3859
SELECT CAST(my_char_30 AS TIME),
3860
my_char_30, id FROM t1_values
3861
WHERE select_id = 48 OR select_id IS NULL order by id;
3862
CAST(my_char_30 AS TIME) my_char_30 id
3865
00:00:00 <--------30 characters-------> 3
3866
-00:00:00 ---äÖüß@µ*$-- 4
3870
Warning 1292 Truncated incorrect time value: ''
3871
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3872
Warning 1292 Truncated incorrect time value: ' ---����@�*$--'
3873
SHOW CREATE VIEW v1;
3874
View Create View character_set_client collation_connection
3875
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
3877
WHERE v1.id IN (SELECT id FROM t1_values
3878
WHERE select_id = 48 OR select_id IS NULL) order by id;
3879
CAST(my_char_30 AS TIME) my_char_30 id
3882
00:00:00 <--------30 characters-------> 3
3883
-00:00:00 ---äÖüß@µ*$-- 4
3887
Warning 1292 Truncated incorrect time value: ''
3888
Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3889
Warning 1292 Truncated incorrect time value: ' ---����@�*$--'
3893
CREATE VIEW v1 AS SELECT CAST(my_year AS DATETIME),
3894
my_year, id FROM t1_values;
3895
SELECT CAST(my_year AS DATETIME),
3896
my_year, id FROM t1_values
3897
WHERE select_id = 47 OR select_id IS NULL order by id;
3898
CAST(my_year AS DATETIME) my_year id
3905
Warning 1292 Incorrect datetime value: '1901'
3906
Warning 1292 Incorrect datetime value: '2155'
3907
Warning 1292 Incorrect datetime value: '2000'
3908
Warning 1292 Incorrect datetime value: '2005'
3909
SHOW CREATE VIEW v1;
3910
View Create View character_set_client collation_connection
3911
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
3913
WHERE v1.id IN (SELECT id FROM t1_values
3914
WHERE select_id = 47 OR select_id IS NULL) order by id;
3915
CAST(my_year AS DATETIME) my_year id
3922
Warning 1292 Incorrect datetime value: '1901'
3923
Warning 1292 Incorrect datetime value: '2155'
3924
Warning 1292 Incorrect datetime value: '2000'
3925
Warning 1292 Incorrect datetime value: '2005'
3929
CREATE VIEW v1 AS SELECT CAST(my_time AS DATETIME),
3930
my_time, id FROM t1_values;
3931
SELECT CAST(my_time AS DATETIME),
3932
my_time, id FROM t1_values
3933
WHERE select_id = 46 OR select_id IS NULL order by id;
3934
CAST(my_time AS DATETIME) my_time id
3936
0000-00-00 00:00:00 -838:59:59 2
3937
0000-00-00 00:00:00 838:59:59 3
3938
0000-00-00 13:00:00 13:00:00 4
3939
0000-00-00 10:00:00 10:00:00 5
3941
Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3942
Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3943
SHOW CREATE VIEW v1;
3944
View Create View character_set_client collation_connection
3945
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
3947
WHERE v1.id IN (SELECT id FROM t1_values
3948
WHERE select_id = 46 OR select_id IS NULL) order by id;
3949
CAST(my_time AS DATETIME) my_time id
3951
0000-00-00 00:00:00 -838:59:59 2
3952
0000-00-00 00:00:00 838:59:59 3
3953
0000-00-00 13:00:00 13:00:00 4
3954
0000-00-00 10:00:00 10:00:00 5
3956
Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3957
Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3961
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DATETIME),
3962
my_timestamp, id FROM t1_values;
3963
SELECT CAST(my_timestamp AS DATETIME),
3964
my_timestamp, id FROM t1_values
3965
WHERE select_id = 45 OR select_id IS NULL order by id;
3966
CAST(my_timestamp AS DATETIME) my_timestamp id
3967
0000-00-00 00:00:00 0000-00-00 00:00:00 1
3968
1970-01-01 03:00:01 1970-01-01 03:00:01 2
3969
2038-01-01 02:59:59 2038-01-01 02:59:59 3
3970
2004-02-29 23:59:59 2004-02-29 23:59:59 4
3971
2005-06-28 10:00:00 2005-06-28 10:00:00 5
3972
SHOW CREATE VIEW v1;
3973
View Create View character_set_client collation_connection
3974
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
3976
WHERE v1.id IN (SELECT id FROM t1_values
3977
WHERE select_id = 45 OR select_id IS NULL) order by id;
3978
CAST(my_timestamp AS DATETIME) my_timestamp id
3979
0000-00-00 00:00:00 0000-00-00 00:00:00 1
3980
1970-01-01 03:00:01 1970-01-01 03:00:01 2
3981
2038-01-01 02:59:59 2038-01-01 02:59:59 3
3982
2004-02-29 23:59:59 2004-02-29 23:59:59 4
3983
2005-06-28 10:00:00 2005-06-28 10:00:00 5
3987
CREATE VIEW v1 AS SELECT CAST(my_date AS DATETIME),
3988
my_date, id FROM t1_values;
3989
SELECT CAST(my_date AS DATETIME),
3990
my_date, id FROM t1_values
3991
WHERE select_id = 44 OR select_id IS NULL order by id;
3992
CAST(my_date AS DATETIME) my_date id
3994
0001-01-01 00:00:00 0001-01-01 2
3995
9999-12-31 00:00:00 9999-12-31 3
3996
2004-02-29 00:00:00 2004-02-29 4
3997
2005-06-28 00:00:00 2005-06-28 5
3998
SHOW CREATE VIEW v1;
3999
View Create View character_set_client collation_connection
4000
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
4002
WHERE v1.id IN (SELECT id FROM t1_values
4003
WHERE select_id = 44 OR select_id IS NULL) order by id;
4004
CAST(my_date AS DATETIME) my_date id
4006
0001-01-01 00:00:00 0001-01-01 2
4007
9999-12-31 00:00:00 9999-12-31 3
4008
2004-02-29 00:00:00 2004-02-29 4
4009
2005-06-28 00:00:00 2005-06-28 5
4013
CREATE VIEW v1 AS SELECT CAST(my_datetime AS DATETIME),
4014
my_datetime, id FROM t1_values;
4015
SELECT CAST(my_datetime AS DATETIME),
4016
my_datetime, id FROM t1_values
4017
WHERE select_id = 43 OR select_id IS NULL order by id;
4018
CAST(my_datetime AS DATETIME) my_datetime id
4020
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4021
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4022
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4023
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4024
SHOW CREATE VIEW v1;
4025
View Create View character_set_client collation_connection
4026
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
4028
WHERE v1.id IN (SELECT id FROM t1_values
4029
WHERE select_id = 43 OR select_id IS NULL) order by id;
4030
CAST(my_datetime AS DATETIME) my_datetime id
4032
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4033
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4034
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4035
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4039
CREATE VIEW v1 AS SELECT CAST(my_double AS DATETIME),
4040
my_double, id FROM t1_values;
4041
SELECT CAST(my_double AS DATETIME),
4042
my_double, id FROM t1_values
4043
WHERE select_id = 42 OR select_id IS NULL order by id;
4044
CAST(my_double AS DATETIME) my_double id
4046
NULL -1.7976931348623e308 2
4047
NULL 1.7976931348623e308 3
4050
NULL 200506271758 19
4052
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4053
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4054
Warning 1292 Incorrect datetime value: '0'
4055
Warning 1292 Incorrect datetime value: '-1'
4056
Warning 1292 Incorrect datetime value: '200506271758'
4057
SHOW CREATE VIEW v1;
4058
View Create View character_set_client collation_connection
4059
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
4061
WHERE v1.id IN (SELECT id FROM t1_values
4062
WHERE select_id = 42 OR select_id IS NULL) order by id;
4063
CAST(my_double AS DATETIME) my_double id
4065
NULL -1.7976931348623e308 2
4066
NULL 1.7976931348623e308 3
4069
NULL 200506271758 19
4071
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4072
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4073
Warning 1292 Incorrect datetime value: '0'
4074
Warning 1292 Incorrect datetime value: '-1'
4075
Warning 1292 Incorrect datetime value: '200506271758'
4079
CREATE VIEW v1 AS SELECT CAST(my_bigint AS DATETIME),
4080
my_bigint, id FROM t1_values;
4081
SELECT CAST(my_bigint AS DATETIME),
4082
my_bigint, id FROM t1_values
4083
WHERE select_id = 41 OR select_id IS NULL order by id;
4084
CAST(my_bigint AS DATETIME) my_bigint id
4086
NULL -9223372036854775808 2
4087
NULL 9223372036854775807 3
4090
NULL 200506271758 18
4092
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4093
Warning 1292 Incorrect datetime value: '9223372036854775807'
4094
Warning 1292 Incorrect datetime value: '0'
4095
Warning 1292 Incorrect datetime value: '-1'
4096
Warning 1292 Incorrect datetime value: '200506271758'
4097
SHOW CREATE VIEW v1;
4098
View Create View character_set_client collation_connection
4099
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
4101
WHERE v1.id IN (SELECT id FROM t1_values
4102
WHERE select_id = 41 OR select_id IS NULL) order by id;
4103
CAST(my_bigint AS DATETIME) my_bigint id
4105
NULL -9223372036854775808 2
4106
NULL 9223372036854775807 3
4109
NULL 200506271758 18
4111
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4112
Warning 1292 Incorrect datetime value: '9223372036854775807'
4113
Warning 1292 Incorrect datetime value: '0'
4114
Warning 1292 Incorrect datetime value: '-1'
4115
Warning 1292 Incorrect datetime value: '200506271758'
4119
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DATETIME),
4120
my_varbinary_1000, id FROM t1_values;
4121
SELECT CAST(my_varbinary_1000 AS DATETIME),
4122
my_varbinary_1000, id FROM t1_values
4123
WHERE select_id = 40 OR select_id IS NULL order by id;
4124
CAST(my_varbinary_1000 AS DATETIME) my_varbinary_1000 id
4127
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4128
NULL ---äÖüß@µ*$-- 4
4130
2005-06-27 17:58:00 2005-06-27 17:58 17
4132
Warning 1292 Incorrect datetime value: ''
4133
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4134
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4135
Warning 1292 Incorrect datetime value: '-1'
4136
SHOW CREATE VIEW v1;
4137
View Create View character_set_client collation_connection
4138
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
4140
WHERE v1.id IN (SELECT id FROM t1_values
4141
WHERE select_id = 40 OR select_id IS NULL) order by id;
4142
CAST(my_varbinary_1000 AS DATETIME) my_varbinary_1000 id
4145
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4146
NULL ---äÖüß@µ*$-- 4
4148
2005-06-27 17:58:00 2005-06-27 17:58 17
4150
Warning 1292 Incorrect datetime value: ''
4151
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4152
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4153
Warning 1292 Incorrect datetime value: '-1'
4157
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DATETIME),
4158
my_binary_30, id FROM t1_values;
4159
SELECT CAST(my_binary_30 AS DATETIME),
4160
my_binary_30, id FROM t1_values
4161
WHERE select_id = 39 OR select_id IS NULL order by id;
4162
CAST(my_binary_30 AS DATETIME) my_binary_30 id
4165
NULL <--------30 characters-------> 3
4166
NULL ---äÖüß@µ*$-- 4
4168
2005-06-27 17:58:00 2005-06-27 17:58 16
4170
Warning 1292 Incorrect datetime value: ''
4171
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4172
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4173
Warning 1292 Incorrect datetime value: '-1'
4174
Warning 1292 Truncated incorrect datetime value: '2005-06-27 17:58'
4175
SHOW CREATE VIEW v1;
4176
View Create View character_set_client collation_connection
4177
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
4179
WHERE v1.id IN (SELECT id FROM t1_values
4180
WHERE select_id = 39 OR select_id IS NULL) order by id;
4181
CAST(my_binary_30 AS DATETIME) my_binary_30 id
4184
NULL <--------30 characters-------> 3
4185
NULL ---äÖüß@µ*$-- 4
4187
2005-06-27 17:58:00 2005-06-27 17:58 16
4189
Warning 1292 Incorrect datetime value: ''
4190
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4191
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4192
Warning 1292 Incorrect datetime value: '-1'
4193
Warning 1292 Truncated incorrect datetime value: '2005-06-27 17:58'
4197
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DATETIME),
4198
my_varchar_1000, id FROM t1_values;
4199
SELECT CAST(my_varchar_1000 AS DATETIME),
4200
my_varchar_1000, id FROM t1_values
4201
WHERE select_id = 38 OR select_id IS NULL order by id;
4202
CAST(my_varchar_1000 AS DATETIME) my_varchar_1000 id
4205
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4206
NULL ---äÖüß@µ*$-- 4
4208
2005-06-27 17:58:00 2005-06-27 17:58 15
4210
Warning 1292 Incorrect datetime value: ''
4211
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4212
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4213
Warning 1292 Incorrect datetime value: '-1'
4214
SHOW CREATE VIEW v1;
4215
View Create View character_set_client collation_connection
4216
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
4218
WHERE v1.id IN (SELECT id FROM t1_values
4219
WHERE select_id = 38 OR select_id IS NULL) order by id;
4220
CAST(my_varchar_1000 AS DATETIME) my_varchar_1000 id
4223
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4224
NULL ---äÖüß@µ*$-- 4
4226
2005-06-27 17:58:00 2005-06-27 17:58 15
4228
Warning 1292 Incorrect datetime value: ''
4229
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4230
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4231
Warning 1292 Incorrect datetime value: '-1'
4235
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DATETIME),
4236
my_char_30, id FROM t1_values;
4237
SELECT CAST(my_char_30 AS DATETIME),
4238
my_char_30, id FROM t1_values
4239
WHERE select_id = 37 OR select_id IS NULL order by id;
4240
CAST(my_char_30 AS DATETIME) my_char_30 id
4243
NULL <--------30 characters-------> 3
4244
NULL ---äÖüß@µ*$-- 4
4246
2005-06-27 17:58:00 2005-06-27 17:58 14
4248
Warning 1292 Incorrect datetime value: ''
4249
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4250
Warning 1292 Incorrect datetime value: ' ---����@�*$--'
4251
Warning 1292 Incorrect datetime value: '-1'
4252
SHOW CREATE VIEW v1;
4253
View Create View character_set_client collation_connection
4254
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
4256
WHERE v1.id IN (SELECT id FROM t1_values
4257
WHERE select_id = 37 OR select_id IS NULL) order by id;
4258
CAST(my_char_30 AS DATETIME) my_char_30 id
4261
NULL <--------30 characters-------> 3
4262
NULL ---äÖüß@µ*$-- 4
4264
2005-06-27 17:58:00 2005-06-27 17:58 14
4266
Warning 1292 Incorrect datetime value: ''
4267
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4268
Warning 1292 Incorrect datetime value: ' ---����@�*$--'
4269
Warning 1292 Incorrect datetime value: '-1'
4273
CREATE VIEW v1 AS SELECT CAST(my_year AS DATE),
4274
my_year, id FROM t1_values;
4275
SELECT CAST(my_year AS DATE),
4276
my_year, id FROM t1_values
4277
WHERE select_id = 36 OR select_id IS NULL order by id;
4278
CAST(my_year AS DATE) my_year id
4285
Warning 1292 Incorrect datetime value: '1901'
4286
Warning 1292 Incorrect datetime value: '2155'
4287
Warning 1292 Incorrect datetime value: '2000'
4288
Warning 1292 Incorrect datetime value: '2005'
4289
SHOW CREATE VIEW v1;
4290
View Create View character_set_client collation_connection
4291
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
4293
WHERE v1.id IN (SELECT id FROM t1_values
4294
WHERE select_id = 36 OR select_id IS NULL) order by id;
4295
CAST(my_year AS DATE) my_year id
4302
Warning 1292 Incorrect datetime value: '1901'
4303
Warning 1292 Incorrect datetime value: '2155'
4304
Warning 1292 Incorrect datetime value: '2000'
4305
Warning 1292 Incorrect datetime value: '2005'
4309
CREATE VIEW v1 AS SELECT CAST(my_time AS DATE),
4310
my_time, id FROM t1_values;
4311
SELECT CAST(my_time AS DATE),
4312
my_time, id FROM t1_values
4313
WHERE select_id = 35 OR select_id IS NULL order by id;
4314
CAST(my_time AS DATE) my_time id
4316
0000-00-00 -838:59:59 2
4317
0000-00-00 838:59:59 3
4318
0000-00-00 13:00:00 4
4319
0000-00-00 10:00:00 5
4320
SHOW CREATE VIEW v1;
4321
View Create View character_set_client collation_connection
4322
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
4324
WHERE v1.id IN (SELECT id FROM t1_values
4325
WHERE select_id = 35 OR select_id IS NULL) order by id;
4326
CAST(my_time AS DATE) my_time id
4328
0000-00-00 -838:59:59 2
4329
0000-00-00 838:59:59 3
4330
0000-00-00 13:00:00 4
4331
0000-00-00 10:00:00 5
4335
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DATE),
4336
my_timestamp, id FROM t1_values;
4337
SELECT CAST(my_timestamp AS DATE),
4338
my_timestamp, id FROM t1_values
4339
WHERE select_id = 34 OR select_id IS NULL order by id;
4340
CAST(my_timestamp AS DATE) my_timestamp id
4341
0000-00-00 0000-00-00 00:00:00 1
4342
1970-01-01 1970-01-01 03:00:01 2
4343
2038-01-01 2038-01-01 02:59:59 3
4344
2004-02-29 2004-02-29 23:59:59 4
4345
2005-06-28 2005-06-28 10:00:00 5
4346
SHOW CREATE VIEW v1;
4347
View Create View character_set_client collation_connection
4348
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
4350
WHERE v1.id IN (SELECT id FROM t1_values
4351
WHERE select_id = 34 OR select_id IS NULL) order by id;
4352
CAST(my_timestamp AS DATE) my_timestamp id
4353
0000-00-00 0000-00-00 00:00:00 1
4354
1970-01-01 1970-01-01 03:00:01 2
4355
2038-01-01 2038-01-01 02:59:59 3
4356
2004-02-29 2004-02-29 23:59:59 4
4357
2005-06-28 2005-06-28 10:00:00 5
4361
CREATE VIEW v1 AS SELECT CAST(my_date AS DATE),
4362
my_date, id FROM t1_values;
4363
SELECT CAST(my_date AS DATE),
4364
my_date, id FROM t1_values
4365
WHERE select_id = 33 OR select_id IS NULL order by id;
4366
CAST(my_date AS DATE) my_date id
4368
0001-01-01 0001-01-01 2
4369
9999-12-31 9999-12-31 3
4370
2004-02-29 2004-02-29 4
4371
2005-06-28 2005-06-28 5
4372
SHOW CREATE VIEW v1;
4373
View Create View character_set_client collation_connection
4374
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
4376
WHERE v1.id IN (SELECT id FROM t1_values
4377
WHERE select_id = 33 OR select_id IS NULL) order by id;
4378
CAST(my_date AS DATE) my_date id
4380
0001-01-01 0001-01-01 2
4381
9999-12-31 9999-12-31 3
4382
2004-02-29 2004-02-29 4
4383
2005-06-28 2005-06-28 5
4387
CREATE VIEW v1 AS SELECT CAST(my_datetime AS DATE),
4388
my_datetime, id FROM t1_values;
4389
SELECT CAST(my_datetime AS DATE),
4390
my_datetime, id FROM t1_values
4391
WHERE select_id = 32 OR select_id IS NULL order by id;
4392
CAST(my_datetime AS DATE) my_datetime id
4394
0001-01-01 0001-01-01 00:00:00 2
4395
9999-12-31 9999-12-31 23:59:59 3
4396
2004-02-29 2004-02-29 23:59:59 4
4397
2005-06-28 2005-06-28 10:00:00 5
4398
SHOW CREATE VIEW v1;
4399
View Create View character_set_client collation_connection
4400
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
4402
WHERE v1.id IN (SELECT id FROM t1_values
4403
WHERE select_id = 32 OR select_id IS NULL) order by id;
4404
CAST(my_datetime AS DATE) my_datetime id
4406
0001-01-01 0001-01-01 00:00:00 2
4407
9999-12-31 9999-12-31 23:59:59 3
4408
2004-02-29 2004-02-29 23:59:59 4
4409
2005-06-28 2005-06-28 10:00:00 5
4413
CREATE VIEW v1 AS SELECT CAST(my_double AS DATE),
4414
my_double, id FROM t1_values;
4415
SELECT CAST(my_double AS DATE),
4416
my_double, id FROM t1_values
4417
WHERE select_id = 31 OR select_id IS NULL order by id;
4418
CAST(my_double AS DATE) my_double id
4420
NULL -1.7976931348623e308 2
4421
NULL 1.7976931348623e308 3
4424
2005-06-27 20050627 13
4426
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4427
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4428
Warning 1292 Incorrect datetime value: '0'
4429
Warning 1292 Incorrect datetime value: '-1'
4430
SHOW CREATE VIEW v1;
4431
View Create View character_set_client collation_connection
4432
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
4434
WHERE v1.id IN (SELECT id FROM t1_values
4435
WHERE select_id = 31 OR select_id IS NULL) order by id;
4436
CAST(my_double AS DATE) my_double id
4438
NULL -1.7976931348623e308 2
4439
NULL 1.7976931348623e308 3
4442
2005-06-27 20050627 13
4444
Warning 1292 Incorrect datetime value: '-1.7976931348623e308'
4445
Warning 1292 Incorrect datetime value: '1.7976931348623e308'
4446
Warning 1292 Incorrect datetime value: '0'
4447
Warning 1292 Incorrect datetime value: '-1'
4451
CREATE VIEW v1 AS SELECT CAST(my_bigint AS DATE),
4452
my_bigint, id FROM t1_values;
4453
SELECT CAST(my_bigint AS DATE),
4454
my_bigint, id FROM t1_values
4455
WHERE select_id = 30 OR select_id IS NULL order by id;
4456
CAST(my_bigint AS DATE) my_bigint id
4458
NULL -9223372036854775808 2
4459
NULL 9223372036854775807 3
4462
2005-06-27 20050627 12
4464
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4465
Warning 1292 Incorrect datetime value: '9223372036854775807'
4466
Warning 1292 Incorrect datetime value: '0'
4467
Warning 1292 Incorrect datetime value: '-1'
4468
SHOW CREATE VIEW v1;
4469
View Create View character_set_client collation_connection
4470
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
4472
WHERE v1.id IN (SELECT id FROM t1_values
4473
WHERE select_id = 30 OR select_id IS NULL) order by id;
4474
CAST(my_bigint AS DATE) my_bigint id
4476
NULL -9223372036854775808 2
4477
NULL 9223372036854775807 3
4480
2005-06-27 20050627 12
4482
Warning 1292 Incorrect datetime value: '-9223372036854775808'
4483
Warning 1292 Incorrect datetime value: '9223372036854775807'
4484
Warning 1292 Incorrect datetime value: '0'
4485
Warning 1292 Incorrect datetime value: '-1'
4489
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DATE),
4490
my_varbinary_1000, id FROM t1_values;
4491
SELECT CAST(my_varbinary_1000 AS DATE),
4492
my_varbinary_1000, id FROM t1_values
4493
WHERE select_id = 29 OR select_id IS NULL order by id;
4494
CAST(my_varbinary_1000 AS DATE) my_varbinary_1000 id
4497
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4498
NULL ---äÖüß@µ*$-- 4
4500
2005-06-27 2005-06-27 11
4502
Warning 1292 Incorrect datetime value: ''
4503
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4504
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4505
Warning 1292 Incorrect datetime value: '-1'
4506
SHOW CREATE VIEW v1;
4507
View Create View character_set_client collation_connection
4508
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
4510
WHERE v1.id IN (SELECT id FROM t1_values
4511
WHERE select_id = 29 OR select_id IS NULL) order by id;
4512
CAST(my_varbinary_1000 AS DATE) my_varbinary_1000 id
4515
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4516
NULL ---äÖüß@µ*$-- 4
4518
2005-06-27 2005-06-27 11
4520
Warning 1292 Incorrect datetime value: ''
4521
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4522
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4523
Warning 1292 Incorrect datetime value: '-1'
4527
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DATE),
4528
my_binary_30, id FROM t1_values;
4529
SELECT CAST(my_binary_30 AS DATE),
4530
my_binary_30, id FROM t1_values
4531
WHERE select_id = 28 OR select_id IS NULL order by id;
4532
CAST(my_binary_30 AS DATE) my_binary_30 id
4535
NULL <--------30 characters-------> 3
4536
NULL ---äÖüß@µ*$-- 4
4538
2005-06-27 2005-06-27 10
4540
Warning 1292 Incorrect datetime value: ''
4541
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4542
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4543
Warning 1292 Incorrect datetime value: '-1'
4544
Warning 1292 Truncated incorrect date value: '2005-06-27'
4545
SHOW CREATE VIEW v1;
4546
View Create View character_set_client collation_connection
4547
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
4549
WHERE v1.id IN (SELECT id FROM t1_values
4550
WHERE select_id = 28 OR select_id IS NULL) order by id;
4551
CAST(my_binary_30 AS DATE) my_binary_30 id
4554
NULL <--------30 characters-------> 3
4555
NULL ---äÖüß@µ*$-- 4
4557
2005-06-27 2005-06-27 10
4559
Warning 1292 Incorrect datetime value: ''
4560
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4561
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4562
Warning 1292 Incorrect datetime value: '-1'
4563
Warning 1292 Truncated incorrect date value: '2005-06-27'
4567
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DATE),
4568
my_varchar_1000, id FROM t1_values;
4569
SELECT CAST(my_varchar_1000 AS DATE),
4570
my_varchar_1000, id FROM t1_values
4571
WHERE select_id = 27 OR select_id IS NULL order by id;
4572
CAST(my_varchar_1000 AS DATE) my_varchar_1000 id
4575
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4576
NULL ---äÖüß@µ*$-- 4
4578
2005-06-27 2005-06-27 9
4580
Warning 1292 Incorrect datetime value: ''
4581
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4582
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4583
Warning 1292 Incorrect datetime value: '-1'
4584
SHOW CREATE VIEW v1;
4585
View Create View character_set_client collation_connection
4586
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
4588
WHERE v1.id IN (SELECT id FROM t1_values
4589
WHERE select_id = 27 OR select_id IS NULL) order by id;
4590
CAST(my_varchar_1000 AS DATE) my_varchar_1000 id
4593
NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4594
NULL ---äÖüß@µ*$-- 4
4596
2005-06-27 2005-06-27 9
4598
Warning 1292 Incorrect datetime value: ''
4599
Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4600
Warning 1292 Incorrect datetime value: ' ---����@�*$-- '
4601
Warning 1292 Incorrect datetime value: '-1'
4605
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DATE),
4606
my_char_30, id FROM t1_values;
4607
SELECT CAST(my_char_30 AS DATE),
4608
my_char_30, id FROM t1_values
4609
WHERE select_id = 26 OR select_id IS NULL order by id;
4610
CAST(my_char_30 AS DATE) my_char_30 id
4613
NULL <--------30 characters-------> 3
4614
NULL ---äÖüß@µ*$-- 4
4616
2005-06-27 2005-06-27 8
4618
Warning 1292 Incorrect datetime value: ''
4619
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4620
Warning 1292 Incorrect datetime value: ' ---����@�*$--'
4621
Warning 1292 Incorrect datetime value: '-1'
4622
SHOW CREATE VIEW v1;
4623
View Create View character_set_client collation_connection
4624
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
4626
WHERE v1.id IN (SELECT id FROM t1_values
4627
WHERE select_id = 26 OR select_id IS NULL) order by id;
4628
CAST(my_char_30 AS DATE) my_char_30 id
4631
NULL <--------30 characters-------> 3
4632
NULL ---äÖüß@µ*$-- 4
4634
2005-06-27 2005-06-27 8
4636
Warning 1292 Incorrect datetime value: ''
4637
Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4638
Warning 1292 Incorrect datetime value: ' ---����@�*$--'
4639
Warning 1292 Incorrect datetime value: '-1'
4643
CREATE VIEW v1 AS SELECT CAST(my_year AS CHAR),
4644
my_year, id FROM t1_values;
4645
SELECT CAST(my_year AS CHAR),
4646
my_year, id FROM t1_values
4647
WHERE select_id = 25 OR select_id IS NULL order by id;
4648
CAST(my_year AS CHAR) my_year id
4654
SHOW CREATE VIEW v1;
4655
View Create View character_set_client collation_connection
4656
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
4658
WHERE v1.id IN (SELECT id FROM t1_values
4659
WHERE select_id = 25 OR select_id IS NULL) order by id;
4660
CAST(my_year AS CHAR) my_year id
4669
CREATE VIEW v1 AS SELECT CAST(my_time AS CHAR),
4670
my_time, id FROM t1_values;
4671
SELECT CAST(my_time AS CHAR),
4672
my_time, id FROM t1_values
4673
WHERE select_id = 24 OR select_id IS NULL order by id;
4674
CAST(my_time AS CHAR) my_time id
4676
-838:59:59 -838:59:59 2
4677
838:59:59 838:59:59 3
4680
SHOW CREATE VIEW v1;
4681
View Create View character_set_client collation_connection
4682
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
4684
WHERE v1.id IN (SELECT id FROM t1_values
4685
WHERE select_id = 24 OR select_id IS NULL) order by id;
4686
CAST(my_time AS CHAR) my_time id
4688
-838:59:59 -838:59:59 2
4689
838:59:59 838:59:59 3
4695
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS CHAR),
4696
my_timestamp, id FROM t1_values;
4697
SELECT CAST(my_timestamp AS CHAR),
4698
my_timestamp, id FROM t1_values
4699
WHERE select_id = 23 OR select_id IS NULL order by id;
4700
CAST(my_timestamp AS CHAR) my_timestamp id
4701
0000-00-00 00:00:00 0000-00-00 00:00:00 1
4702
1970-01-01 03:00:01 1970-01-01 03:00:01 2
4703
2038-01-01 02:59:59 2038-01-01 02:59:59 3
4704
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4705
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4706
SHOW CREATE VIEW v1;
4707
View Create View character_set_client collation_connection
4708
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
4710
WHERE v1.id IN (SELECT id FROM t1_values
4711
WHERE select_id = 23 OR select_id IS NULL) order by id;
4712
CAST(my_timestamp AS CHAR) my_timestamp id
4713
0000-00-00 00:00:00 0000-00-00 00:00:00 1
4714
1970-01-01 03:00:01 1970-01-01 03:00:01 2
4715
2038-01-01 02:59:59 2038-01-01 02:59:59 3
4716
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4717
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4721
CREATE VIEW v1 AS SELECT CAST(my_date AS CHAR),
4722
my_date, id FROM t1_values;
4723
SELECT CAST(my_date AS CHAR),
4724
my_date, id FROM t1_values
4725
WHERE select_id = 22 OR select_id IS NULL order by id;
4726
CAST(my_date AS CHAR) my_date id
4728
0001-01-01 0001-01-01 2
4729
9999-12-31 9999-12-31 3
4730
2004-02-29 2004-02-29 4
4731
2005-06-28 2005-06-28 5
4732
SHOW CREATE VIEW v1;
4733
View Create View character_set_client collation_connection
4734
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
4736
WHERE v1.id IN (SELECT id FROM t1_values
4737
WHERE select_id = 22 OR select_id IS NULL) order by id;
4738
CAST(my_date AS CHAR) my_date id
4740
0001-01-01 0001-01-01 2
4741
9999-12-31 9999-12-31 3
4742
2004-02-29 2004-02-29 4
4743
2005-06-28 2005-06-28 5
4747
CREATE VIEW v1 AS SELECT CAST(my_datetime AS CHAR),
4748
my_datetime, id FROM t1_values;
4749
SELECT CAST(my_datetime AS CHAR),
4750
my_datetime, id FROM t1_values
4751
WHERE select_id = 21 OR select_id IS NULL order by id;
4752
CAST(my_datetime AS CHAR) my_datetime id
4754
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4755
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4756
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4757
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4758
SHOW CREATE VIEW v1;
4759
View Create View character_set_client collation_connection
4760
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
4762
WHERE v1.id IN (SELECT id FROM t1_values
4763
WHERE select_id = 21 OR select_id IS NULL) order by id;
4764
CAST(my_datetime AS CHAR) my_datetime id
4766
0001-01-01 00:00:00 0001-01-01 00:00:00 2
4767
9999-12-31 23:59:59 9999-12-31 23:59:59 3
4768
2004-02-29 23:59:59 2004-02-29 23:59:59 4
4769
2005-06-28 10:00:00 2005-06-28 10:00:00 5
4773
CREATE VIEW v1 AS SELECT CAST(my_double AS CHAR),
4774
my_double, id FROM t1_values;
4775
SELECT CAST(my_double AS CHAR),
4776
my_double, id FROM t1_values
4777
WHERE select_id = 20 OR select_id IS NULL order by id;
4778
CAST(my_double AS CHAR) my_double id
4780
-1.7976931348623e308 -1.7976931348623e308 2
4781
1.7976931348623e308 1.7976931348623e308 3
4784
SHOW CREATE VIEW v1;
4785
View Create View character_set_client collation_connection
4786
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
4788
WHERE v1.id IN (SELECT id FROM t1_values
4789
WHERE select_id = 20 OR select_id IS NULL) order by id;
4790
CAST(my_double AS CHAR) my_double id
4792
-1.7976931348623e308 -1.7976931348623e308 2
4793
1.7976931348623e308 1.7976931348623e308 3
4799
CREATE VIEW v1 AS SELECT CAST(my_decimal AS CHAR),
4800
my_decimal, id FROM t1_values;
4801
SELECT CAST(my_decimal AS CHAR),
4802
my_decimal, id FROM t1_values
4803
WHERE select_id = 19 OR select_id IS NULL order by id;
4804
CAST(my_decimal AS CHAR) my_decimal id
4806
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
4807
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
4808
0.000000000000000000000000000000 0.000000000000000000000000000000 4
4809
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
4810
SHOW CREATE VIEW v1;
4811
View Create View character_set_client collation_connection
4812
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
4814
WHERE v1.id IN (SELECT id FROM t1_values
4815
WHERE select_id = 19 OR select_id IS NULL) order by id;
4816
CAST(my_decimal AS CHAR) my_decimal id
4818
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
4819
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
4820
0.000000000000000000000000000000 0.000000000000000000000000000000 4
4821
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
4825
CREATE VIEW v1 AS SELECT CAST(my_bigint AS CHAR),
4826
my_bigint, id FROM t1_values;
4827
SELECT CAST(my_bigint AS CHAR),
4828
my_bigint, id FROM t1_values
4829
WHERE select_id = 18 OR select_id IS NULL order by id;
4830
CAST(my_bigint AS CHAR) my_bigint id
4832
-9223372036854775808 -9223372036854775808 2
4833
9223372036854775807 9223372036854775807 3
4836
SHOW CREATE VIEW v1;
4837
View Create View character_set_client collation_connection
4838
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
4840
WHERE v1.id IN (SELECT id FROM t1_values
4841
WHERE select_id = 18 OR select_id IS NULL) order by id;
4842
CAST(my_bigint AS CHAR) my_bigint id
4844
-9223372036854775808 -9223372036854775808 2
4845
9223372036854775807 9223372036854775807 3
4851
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS CHAR),
4852
my_varbinary_1000, id FROM t1_values;
4853
SELECT CAST(my_varbinary_1000 AS CHAR),
4854
my_varbinary_1000, id FROM t1_values
4855
WHERE select_id = 17 OR select_id IS NULL order by id;
4856
CAST(my_varbinary_1000 AS CHAR) my_varbinary_1000 id
4859
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4860
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4862
SHOW CREATE VIEW v1;
4863
View Create View character_set_client collation_connection
4864
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
4866
WHERE v1.id IN (SELECT id FROM t1_values
4867
WHERE select_id = 17 OR select_id IS NULL) order by id;
4868
CAST(my_varbinary_1000 AS CHAR) my_varbinary_1000 id
4871
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4872
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4877
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS CHAR),
4878
my_binary_30, id FROM t1_values;
4879
SELECT CAST(my_binary_30 AS CHAR),
4880
my_binary_30, id FROM t1_values
4881
WHERE select_id = 16 OR select_id IS NULL order by id;
4882
CAST(my_binary_30 AS CHAR) my_binary_30 id
4885
<--------30 characters-------> <--------30 characters-------> 3
4886
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4888
SHOW CREATE VIEW v1;
4889
View Create View character_set_client collation_connection
4890
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
4892
WHERE v1.id IN (SELECT id FROM t1_values
4893
WHERE select_id = 16 OR select_id IS NULL) order by id;
4894
CAST(my_binary_30 AS CHAR) my_binary_30 id
4897
<--------30 characters-------> <--------30 characters-------> 3
4898
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4903
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS CHAR),
4904
my_varchar_1000, id FROM t1_values;
4905
SELECT CAST(my_varchar_1000 AS CHAR),
4906
my_varchar_1000, id FROM t1_values
4907
WHERE select_id = 15 OR select_id IS NULL order by id;
4908
CAST(my_varchar_1000 AS CHAR) my_varchar_1000 id
4911
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4912
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4914
SHOW CREATE VIEW v1;
4915
View Create View character_set_client collation_connection
4916
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
4918
WHERE v1.id IN (SELECT id FROM t1_values
4919
WHERE select_id = 15 OR select_id IS NULL) order by id;
4920
CAST(my_varchar_1000 AS CHAR) my_varchar_1000 id
4923
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4924
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4929
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS CHAR),
4930
my_char_30, id FROM t1_values;
4931
SELECT CAST(my_char_30 AS CHAR),
4932
my_char_30, id FROM t1_values
4933
WHERE select_id = 14 OR select_id IS NULL order by id;
4934
CAST(my_char_30 AS CHAR) my_char_30 id
4937
<--------30 characters-------> <--------30 characters-------> 3
4938
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4940
SHOW CREATE VIEW v1;
4941
View Create View character_set_client collation_connection
4942
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
4944
WHERE v1.id IN (SELECT id FROM t1_values
4945
WHERE select_id = 14 OR select_id IS NULL) order by id;
4946
CAST(my_char_30 AS CHAR) my_char_30 id
4949
<--------30 characters-------> <--------30 characters-------> 3
4950
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4955
CREATE VIEW v1 AS SELECT CAST(my_year AS BINARY),
4956
my_year, id FROM t1_values;
4957
SELECT CAST(my_year AS BINARY),
4958
my_year, id FROM t1_values
4959
WHERE select_id = 13 OR select_id IS NULL order by id;
4960
CAST(my_year AS BINARY) my_year id
4966
SHOW CREATE VIEW v1;
4967
View Create View character_set_client collation_connection
4968
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
4970
WHERE v1.id IN (SELECT id FROM t1_values
4971
WHERE select_id = 13 OR select_id IS NULL) order by id;
4972
CAST(my_year AS BINARY) my_year id
4981
CREATE VIEW v1 AS SELECT CAST(my_time AS BINARY),
4982
my_time, id FROM t1_values;
4983
SELECT CAST(my_time AS BINARY),
4984
my_time, id FROM t1_values
4985
WHERE select_id = 12 OR select_id IS NULL order by id;
4986
CAST(my_time AS BINARY) my_time id
4988
-838:59:59 -838:59:59 2
4989
838:59:59 838:59:59 3
4992
SHOW CREATE VIEW v1;
4993
View Create View character_set_client collation_connection
4994
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
4996
WHERE v1.id IN (SELECT id FROM t1_values
4997
WHERE select_id = 12 OR select_id IS NULL) order by id;
4998
CAST(my_time AS BINARY) my_time id
5000
-838:59:59 -838:59:59 2
5001
838:59:59 838:59:59 3
5007
CREATE VIEW v1 AS SELECT CAST(my_timestamp AS BINARY),
5008
my_timestamp, id FROM t1_values;
5009
SELECT CAST(my_timestamp AS BINARY),
5010
my_timestamp, id FROM t1_values
5011
WHERE select_id = 11 OR select_id IS NULL order by id;
5012
CAST(my_timestamp AS BINARY) my_timestamp id
5013
0000-00-00 00:00:00 0000-00-00 00:00:00 1
5014
1970-01-01 03:00:01 1970-01-01 03:00:01 2
5015
2038-01-01 02:59:59 2038-01-01 02:59:59 3
5016
2004-02-29 23:59:59 2004-02-29 23:59:59 4
5017
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5018
SHOW CREATE VIEW v1;
5019
View Create View character_set_client collation_connection
5020
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
5022
WHERE v1.id IN (SELECT id FROM t1_values
5023
WHERE select_id = 11 OR select_id IS NULL) order by id;
5024
CAST(my_timestamp AS BINARY) my_timestamp id
5025
0000-00-00 00:00:00 0000-00-00 00:00:00 1
5026
1970-01-01 03:00:01 1970-01-01 03:00:01 2
5027
2038-01-01 02:59:59 2038-01-01 02:59:59 3
5028
2004-02-29 23:59:59 2004-02-29 23:59:59 4
5029
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5033
CREATE VIEW v1 AS SELECT CAST(my_date AS BINARY),
5034
my_date, id FROM t1_values;
5035
SELECT CAST(my_date AS BINARY),
5036
my_date, id FROM t1_values
5037
WHERE select_id = 10 OR select_id IS NULL order by id;
5038
CAST(my_date AS BINARY) my_date id
5040
0001-01-01 0001-01-01 2
5041
9999-12-31 9999-12-31 3
5042
2004-02-29 2004-02-29 4
5043
2005-06-28 2005-06-28 5
5044
SHOW CREATE VIEW v1;
5045
View Create View character_set_client collation_connection
5046
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
5048
WHERE v1.id IN (SELECT id FROM t1_values
5049
WHERE select_id = 10 OR select_id IS NULL) order by id;
5050
CAST(my_date AS BINARY) my_date id
5052
0001-01-01 0001-01-01 2
5053
9999-12-31 9999-12-31 3
5054
2004-02-29 2004-02-29 4
5055
2005-06-28 2005-06-28 5
5059
CREATE VIEW v1 AS SELECT CAST(my_datetime AS BINARY),
5060
my_datetime, id FROM t1_values;
5061
SELECT CAST(my_datetime AS BINARY),
5062
my_datetime, id FROM t1_values
5063
WHERE select_id = 9 OR select_id IS NULL order by id;
5064
CAST(my_datetime AS BINARY) my_datetime id
5066
0001-01-01 00:00:00 0001-01-01 00:00:00 2
5067
9999-12-31 23:59:59 9999-12-31 23:59:59 3
5068
2004-02-29 23:59:59 2004-02-29 23:59:59 4
5069
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5070
SHOW CREATE VIEW v1;
5071
View Create View character_set_client collation_connection
5072
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
5074
WHERE v1.id IN (SELECT id FROM t1_values
5075
WHERE select_id = 9 OR select_id IS NULL) order by id;
5076
CAST(my_datetime AS BINARY) my_datetime id
5078
0001-01-01 00:00:00 0001-01-01 00:00:00 2
5079
9999-12-31 23:59:59 9999-12-31 23:59:59 3
5080
2004-02-29 23:59:59 2004-02-29 23:59:59 4
5081
2005-06-28 10:00:00 2005-06-28 10:00:00 5
5085
CREATE VIEW v1 AS SELECT CAST(my_double AS BINARY),
5086
my_double, id FROM t1_values;
5087
SELECT CAST(my_double AS BINARY),
5088
my_double, id FROM t1_values
5089
WHERE select_id = 8 OR select_id IS NULL order by id;
5090
CAST(my_double AS BINARY) my_double id
5092
-1.7976931348623e308 -1.7976931348623e308 2
5093
1.7976931348623e308 1.7976931348623e308 3
5096
SHOW CREATE VIEW v1;
5097
View Create View character_set_client collation_connection
5098
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
5100
WHERE v1.id IN (SELECT id FROM t1_values
5101
WHERE select_id = 8 OR select_id IS NULL) order by id;
5102
CAST(my_double AS BINARY) my_double id
5104
-1.7976931348623e308 -1.7976931348623e308 2
5105
1.7976931348623e308 1.7976931348623e308 3
5111
CREATE VIEW v1 AS SELECT CAST(my_decimal AS BINARY),
5112
my_decimal, id FROM t1_values;
5113
SELECT CAST(my_decimal AS BINARY),
5114
my_decimal, id FROM t1_values
5115
WHERE select_id = 7 OR select_id IS NULL order by id;
5116
CAST(my_decimal AS BINARY) my_decimal id
5118
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
5119
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
5120
0.000000000000000000000000000000 0.000000000000000000000000000000 4
5121
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
5122
SHOW CREATE VIEW v1;
5123
View Create View character_set_client collation_connection
5124
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
5126
WHERE v1.id IN (SELECT id FROM t1_values
5127
WHERE select_id = 7 OR select_id IS NULL) order by id;
5128
CAST(my_decimal AS BINARY) my_decimal id
5130
-9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
5131
9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
5132
0.000000000000000000000000000000 0.000000000000000000000000000000 4
5133
-1.000000000000000000000000000000 -1.000000000000000000000000000000 5
5137
CREATE VIEW v1 AS SELECT CAST(my_bigint AS BINARY),
5138
my_bigint, id FROM t1_values;
5139
SELECT CAST(my_bigint AS BINARY),
5140
my_bigint, id FROM t1_values
5141
WHERE select_id = 6 OR select_id IS NULL order by id;
5142
CAST(my_bigint AS BINARY) my_bigint id
5144
-9223372036854775808 -9223372036854775808 2
5145
9223372036854775807 9223372036854775807 3
5148
SHOW CREATE VIEW v1;
5149
View Create View character_set_client collation_connection
5150
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
5152
WHERE v1.id IN (SELECT id FROM t1_values
5153
WHERE select_id = 6 OR select_id IS NULL) order by id;
5154
CAST(my_bigint AS BINARY) my_bigint id
5156
-9223372036854775808 -9223372036854775808 2
5157
9223372036854775807 9223372036854775807 3
5163
CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS BINARY),
5164
my_varbinary_1000, id FROM t1_values;
5165
SELECT CAST(my_varbinary_1000 AS BINARY),
5166
my_varbinary_1000, id FROM t1_values
5167
WHERE select_id = 5 OR select_id IS NULL order by id;
5168
CAST(my_varbinary_1000 AS BINARY) my_varbinary_1000 id
5171
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5172
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5174
SHOW CREATE VIEW v1;
5175
View Create View character_set_client collation_connection
5176
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
5178
WHERE v1.id IN (SELECT id FROM t1_values
5179
WHERE select_id = 5 OR select_id IS NULL) order by id;
5180
CAST(my_varbinary_1000 AS BINARY) my_varbinary_1000 id
5183
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5184
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5189
CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS BINARY),
5190
my_binary_30, id FROM t1_values;
5191
SELECT CAST(my_binary_30 AS BINARY),
5192
my_binary_30, id FROM t1_values
5193
WHERE select_id = 4 OR select_id IS NULL order by id;
5194
CAST(my_binary_30 AS BINARY) my_binary_30 id
5197
<--------30 characters-------> <--------30 characters-------> 3
5198
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5200
SHOW CREATE VIEW v1;
5201
View Create View character_set_client collation_connection
5202
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
5204
WHERE v1.id IN (SELECT id FROM t1_values
5205
WHERE select_id = 4 OR select_id IS NULL) order by id;
5206
CAST(my_binary_30 AS BINARY) my_binary_30 id
5209
<--------30 characters-------> <--------30 characters-------> 3
5210
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5215
CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS BINARY),
5216
my_varchar_1000, id FROM t1_values;
5217
SELECT CAST(my_varchar_1000 AS BINARY),
5218
my_varchar_1000, id FROM t1_values
5219
WHERE select_id = 3 OR select_id IS NULL order by id;
5220
CAST(my_varchar_1000 AS BINARY) my_varchar_1000 id
5223
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5224
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5226
SHOW CREATE VIEW v1;
5227
View Create View character_set_client collation_connection
5228
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
5230
WHERE v1.id IN (SELECT id FROM t1_values
5231
WHERE select_id = 3 OR select_id IS NULL) order by id;
5232
CAST(my_varchar_1000 AS BINARY) my_varchar_1000 id
5235
<---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5236
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5241
CREATE VIEW v1 AS SELECT CAST(my_char_30 AS BINARY),
5242
my_char_30, id FROM t1_values;
5243
SELECT CAST(my_char_30 AS BINARY),
5244
my_char_30, id FROM t1_values
5245
WHERE select_id = 2 OR select_id IS NULL order by id;
5246
CAST(my_char_30 AS BINARY) my_char_30 id
5249
<--------30 characters-------> <--------30 characters-------> 3
5250
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5252
SHOW CREATE VIEW v1;
5253
View Create View character_set_client collation_connection
5254
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
5256
WHERE v1.id IN (SELECT id FROM t1_values
5257
WHERE select_id = 2 OR select_id IS NULL) order by id;
5258
CAST(my_char_30 AS BINARY) my_char_30 id
5261
<--------30 characters-------> <--------30 characters-------> 3
5262
---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5267
CREATE VIEW v1 AS SELECT sqrt(my_bigint), my_bigint, id FROM t1_values;
5268
SELECT sqrt(my_bigint), my_bigint, id FROM t1_values
5269
WHERE select_id = 1 OR select_id IS NULL order by id;
5270
sqrt(my_bigint) my_bigint id
5272
NULL -9223372036854775808 2
5273
3037000499.97605 9223372036854775807 3
5278
SHOW CREATE VIEW v1;
5279
View Create View character_set_client collation_connection
5280
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
5282
WHERE v1.id IN (SELECT id FROM t1_values
5283
WHERE select_id = 1 OR select_id IS NULL) order by id;
5284
sqrt(my_bigint) my_bigint id
5286
NULL -9223372036854775808 2
5287
3037000499.97605 9223372036854775807 3
5295
DROP TABLE t1_selects, t1_modes, t1_values;
added
removed
mysql-test/suite/funcs_1/r/memory_func_view.result
