1 DROP TABLE IF EXISTS t1_selects, t1_modes, t1_values;
2 DROP VIEW IF EXISTS v1;
5 id BIGINT AUTO_INCREMENT,
8 ) ENGINE = <engine_to_be_tested>;
9 ALTER TABLE t1_values ADD my_char_30 CHAR(30);
10 ALTER TABLE t1_values ADD my_varchar_1000 VARCHAR(1000);
11 ALTER TABLE t1_values ADD my_binary_30 BINARY(30);
12 ALTER TABLE t1_values ADD my_varbinary_1000 VARBINARY(1000);
13 ALTER TABLE t1_values ADD my_datetime DATETIME;
14 ALTER TABLE t1_values ADD my_date DATE;
15 ALTER TABLE t1_values ADD ts_dummy TIMESTAMP;
16 ALTER TABLE t1_values ADD my_timestamp TIMESTAMP;
17 ALTER TABLE t1_values ADD my_time TIME;
18 ALTER TABLE t1_values ADD my_year YEAR;
19 ALTER TABLE t1_values ADD my_bigint BIGINT;
20 ALTER TABLE t1_values ADD my_double DOUBLE;
21 ALTER TABLE t1_values ADD my_decimal DECIMAL(64,30);
22 SET sql_mode = 'traditional';
23 INSERT INTO t1_values SET id = 0;
24 INSERT INTO t1_values SET
28 my_varbinary_1000 = '',
29 my_datetime = '0001-01-01 00:00:00',
30 my_date = '0001-01-01',
31 my_timestamp = '1970-01-01 03:00:01',
32 my_time = '-838:59:59',
34 my_bigint = -9223372036854775808,
35 my_decimal = -9999999999999999999999999999999999.999999999999999999999999999999 ,
36 my_double = -1.7976931348623E+308;
37 INSERT INTO t1_values SET
38 my_char_30 = '<--------30 characters------->',
39 my_varchar_1000 = CONCAT('<---------1000 characters',
40 RPAD('',965,'-'),'--------->'),
41 my_binary_30 = '<--------30 characters------->',
42 my_varbinary_1000 = CONCAT('<---------1000 characters',
43 RPAD('',965,'-'),'--------->'),
44 my_datetime = '9999-12-31 23:59:59',
45 my_date = '9999-12-31',
46 my_timestamp = '2038-01-01 02:59:59',
47 my_time = '838:59:59',
49 my_bigint = 9223372036854775807,
50 my_decimal = +9999999999999999999999999999999999.999999999999999999999999999999 ,
51 my_double = 1.7976931348623E+308;
52 INSERT INTO t1_values SET
53 my_char_30 = ' ---äÖüß@µ*$-- ',
54 my_varchar_1000 = ' ---äÖüß@µ*$-- ',
55 my_binary_30 = ' ---äÖüß@µ*$-- ',
56 my_varbinary_1000 = ' ---äÖüß@µ*$-- ',
57 my_datetime = '2004-02-29 23:59:59',
58 my_date = '2004-02-29',
59 my_timestamp = '2004-02-29 23:59:59',
65 INSERT INTO t1_values SET
67 my_varchar_1000 = '-1',
69 my_varbinary_1000 = '-1',
70 my_datetime = '2005-06-28 10:00:00',
71 my_date = '2005-06-28',
72 my_timestamp = '2005-06-28 10:00:00',
76 my_decimal = -1.000000000000000000000000000000,
78 PREPARE ins_sel_with_result FROM "INSERT INTO t1_selects SET my_select = @my_select,
79 disable_result = 'No'" ;
80 PREPARE ins_sel_no_result FROM "INSERT INTO t1_selects SET my_select = @my_select,
81 disable_result = 'Yes'" ;
82 SET sql_mode = 'traditional';
83 SET @my_select = 'SELECT sqrt(my_bigint), my_bigint, id FROM t1_values';
84 INSERT INTO t1_values SET select_id = @select_id,
86 INSERT INTO t1_values SET select_id = @select_id,
88 ##### 1.1.1. CAST --> BINARY
89 ##### 1.1.2. CAST --> CHAR
90 ##### 1.1.3. CAST --> DATE
91 INSERT INTO t1_values SET select_id = @select_id,
92 my_char_30 = '2005-06-27';
93 INSERT INTO t1_values SET select_id = @select_id,
94 my_varchar_1000 = '2005-06-27';
95 INSERT INTO t1_values SET select_id = @select_id,
96 my_binary_30 = '2005-06-27';
97 INSERT INTO t1_values SET select_id = @select_id,
98 my_varbinary_1000 = '2005-06-27';
99 INSERT INTO t1_values SET select_id = @select_id,
100 my_bigint = 20050627;
101 INSERT INTO t1_values SET select_id = @select_id,
102 my_double = +20.050627E+6;
103 ##### 1.1.4. CAST --> DATETIME
104 INSERT INTO t1_values SET select_id = @select_id,
105 my_char_30 = '2005-06-27 17:58';
106 INSERT INTO t1_values SET select_id = @select_id,
107 my_varchar_1000 = '2005-06-27 17:58';
108 INSERT INTO t1_values SET select_id = @select_id,
109 my_binary_30 = '2005-06-27 17:58';
110 INSERT INTO t1_values SET select_id = @select_id,
111 my_varbinary_1000 = '2005-06-27 17:58';
112 INSERT INTO t1_values SET select_id = @select_id,
113 my_bigint = 200506271758;
114 INSERT INTO t1_values SET select_id = @select_id,
115 my_double = +0.0200506271758E+13;
116 ##### 1.1.5. CAST --> TIME
117 INSERT INTO t1_values SET select_id = @select_id,
118 my_char_30 = '1 17:58';
119 INSERT INTO t1_values SET select_id = @select_id,
120 my_varchar_1000 = '1 17:58';
121 INSERT INTO t1_values SET select_id = @select_id,
122 my_binary_30 = '1 17:58';
123 INSERT INTO t1_values SET select_id = @select_id,
124 my_varbinary_1000 = '1 17:58';
125 INSERT INTO t1_values SET select_id = @select_id,
127 INSERT INTO t1_values SET select_id = @select_id,
128 my_double = +1.758E+3;
129 ##### 1.1.6. CAST --> DECIMAL
130 INSERT INTO t1_values SET select_id = @select_id,
131 my_char_30 = '-3333.3333';
132 INSERT INTO t1_values SET select_id = @select_id,
133 my_varchar_1000 = '-3333.3333';
134 INSERT INTO t1_values SET select_id = @select_id,
135 my_binary_30 = '-3333.3333';
136 INSERT INTO t1_values SET select_id = @select_id,
137 my_varbinary_1000 = '-3333.3333';
138 INSERT INTO t1_values SET select_id = @select_id,
139 my_double = -0.33333333E+4;
140 ##### 1.1.7. CAST --> SIGNED INTEGER
142 "Attention: CAST --> SIGNED INTEGER
143 Bug#5913 Traditional mode: BIGINT range not correctly delimited
144 Status: To be fixed later"
145 --------------------------------------------------------------------------------
146 ##### 1.1.8. CAST --> UNSIGNED INTEGER
148 "Attention: CAST --> UNSIGNED INTEGER
149 The file with expected results suffers from Bug 5913"
150 --------------------------------------------------------------------------------
152 some statements disabled because of
153 Bug#5913 Traditional mode: BIGINT range not correctly delimited
154 --------------------------------------------------------------------------------
155 SET @my_select = 'SELECT CONVERT(my_char_30 USING utf8),
156 my_char_30, id FROM t1_values';
157 SET @my_select = 'SELECT CONVERT(my_varchar_1000 USING utf8),
158 my_varchar_1000, id FROM t1_values';
159 SET @my_select = 'SELECT CONVERT(my_binary_30 USING utf8),
160 my_binary_30, id FROM t1_values';
161 SET @my_select = 'SELECT CONVERT(my_varbinary_1000 USING utf8),
162 my_varbinary_1000, id FROM t1_values';
163 SET @my_select = 'SELECT CONVERT(my_char_30 USING koi8r),
164 my_char_30, id FROM t1_values';
165 SET @my_select = 'SELECT CONVERT(my_varchar_1000 USING koi8r),
166 my_varchar_1000, id FROM t1_values';
167 SET @my_select = 'SELECT CONVERT(my_binary_30 USING koi8r),
168 my_binary_30, id FROM t1_values';
169 SET @my_select = 'SELECT CONVERT(my_varbinary_1000 USING koi8r),
170 my_varbinary_1000, id FROM t1_values';
171 SET @my_select = 'SELECT BIT_LENGTH(my_char_30),
172 my_char_30, id FROM t1_values';
173 SET @my_select = 'SELECT BIT_LENGTH(my_varchar_1000),
174 my_varchar_1000, id FROM t1_values';
175 SET @my_select = 'SELECT BIT_LENGTH(my_binary_30),
176 my_binary_30, id FROM t1_values';
177 SET @my_select = 'SELECT BIT_LENGTH(my_varbinary_1000),
178 my_varbinary_1000, id FROM t1_values';
179 SET @my_select = 'SELECT INSTR(my_char_30, ''char''),
180 my_char_30, id FROM t1_values';
181 SET @my_select = 'SELECT LCASE(my_varchar_1000),
182 my_varchar_1000, id FROM t1_values';
184 'SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values';
186 'SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values';
188 'SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values';
190 'SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values';
192 'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_bigint), my_bigint, id FROM t1_values';
194 'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_decimal), my_decimal, id FROM t1_values';
196 'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_double), my_double, id FROM t1_values';
197 SET @my_select = 'SELECT LENGTH(my_char_30),
198 my_char_30, id FROM t1_values';
199 SET @my_select = 'SELECT LENGTH(my_varchar_1000),
200 my_varchar_1000, id FROM t1_values';
201 SET @my_select = 'SELECT LENGTH(my_binary_30),
202 my_binary_30, id FROM t1_values';
203 SET @my_select = 'SELECT LENGTH(my_varbinary_1000),
204 my_varbinary_1000, id FROM t1_values';
206 'SELECT LOAD_FILE(''<MYSQLTEST_VARDIR>/std_data/funcs_1/load_file.txt'')
209 SET @my_select = 'SELECT LOCATE(''char'', my_char_30),
210 my_char_30, id FROM t1_values';
211 SET @my_select = 'SELECT LOCATE(''char'', my_varchar_1000),
212 my_varchar_1000, id FROM t1_values';
213 SET @my_select = 'SELECT LOCATE(''char'', my_binary_30),
214 my_binary_30, id FROM t1_values';
215 SET @my_select = 'SELECT LOCATE(''char'', my_varbinary_1000),
216 my_varbinary_1000, id FROM t1_values';
217 SET @my_select = 'SELECT LOCATE(my_char_30, my_char_30 ),
218 my_char_30, id FROM t1_values';
219 SET @my_select = 'SELECT LOCATE(my_char_30, my_varchar_1000 ),
220 my_char_30, my_varchar_1000 id FROM t1_values';
221 SET @my_select = 'SELECT LOCATE(my_char_30, my_binary_30 ),
222 my_char_30, my_binary_30 id FROM t1_values';
223 SET @my_select = 'SELECT LOCATE(my_char_30, my_varbinary_1000 ),
224 my_char_30, my_varbinary_1000 id FROM t1_values';
225 SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
226 my_varchar_1000, id FROM t1_values';
227 SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_char_30 ),
228 my_varchar_1000, my_char_30 id FROM t1_values';
229 SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_binary_30 ),
230 my_varchar_1000, my_binary_30 id FROM t1_values';
231 SET @my_select = 'SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
232 my_varchar_1000, my_varbinary_1000 id FROM t1_values';
233 SET @my_select = 'SELECT LOCATE(my_binary_30, my_binary_30 ),
234 my_binary_30, id FROM t1_values';
235 SET @my_select = 'SELECT LOCATE(my_binary_30, my_char_30 ),
236 my_binary_30, my_char_30 id FROM t1_values';
237 SET @my_select = 'SELECT LOCATE(my_binary_30, my_varchar_1000 ),
238 my_binary_30, my_varchar_1000 id FROM t1_values';
239 SET @my_select = 'SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
240 my_binary_30, my_varbinary_1000 id FROM t1_values';
241 SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
242 my_varbinary_1000, id FROM t1_values';
243 SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_char_30 ),
244 my_varbinary_1000, my_char_30 id FROM t1_values';
245 SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
246 my_varbinary_1000, my_varchar_1000 id FROM t1_values';
247 SET @my_select = 'SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
248 my_varbinary_1000, my_binary_30 id FROM t1_values';
249 SET @my_select = 'SELECT LOCATE(''-'', my_char_30, 3),
250 my_char_30, id FROM t1_values';
251 SET @my_select = 'SELECT LOCATE(''-'', my_varchar_1000, 3),
252 my_varchar_1000, id FROM t1_values';
253 SET @my_select = 'SELECT LOCATE(''-'', my_binary_30, 3),
254 my_binary_30, id FROM t1_values';
255 SET @my_select = 'SELECT LOCATE(''-'', my_varbinary_1000, 3),
256 my_varbinary_1000, id FROM t1_values';
257 SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_bigint),
258 my_bigint, id FROM t1_values';
259 SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_double),
260 my_double, id FROM t1_values';
261 SET @my_select = 'SELECT LOCATE(''-'', '' - -ABC'', my_decimal),
262 my_decimal, id FROM t1_values';
263 SET @my_select = 'SELECT LOWER(my_char_30),
264 my_char_30, id FROM t1_values';
265 SET @my_select = 'SELECT LOWER(my_varchar_1000),
266 my_varchar_1000, id FROM t1_values';
267 SET @my_select = 'SELECT LOWER(my_binary_30),
268 my_binary_30, id FROM t1_values';
269 SET @my_select = 'SELECT LOWER(my_varbinary_1000),
270 my_varbinary_1000, id FROM t1_values';
271 SET @my_select = 'SELECT LTRIM(my_char_30),
272 my_char_30, id FROM t1_values';
273 SET @my_select = 'SELECT LTRIM(my_varchar_1000),
274 my_varchar_1000, id FROM t1_values';
275 SET @my_select = 'SELECT LTRIM(my_binary_30),
276 my_binary_30, id FROM t1_values';
277 SET @my_select = 'SELECT LTRIM(my_varbinary_1000),
278 my_varbinary_1000, id FROM t1_values';
280 'SELECT CONCAT(''A'',my_char_30), my_char_30, id FROM t1_values';
281 SET @my_select = 'SELECT my_char_30, id FROM t1_values';
282 INSERT INTO t1_values SET select_id = @select_id,
283 my_char_30 = 'Viana do Castelo';
286 "# The basic preparations end and the main test starts here"
287 --------------------------------------------------------------------------------
288 CREATE VIEW v1 AS SELECT my_char_30, id FROM t1_values;
289 SELECT my_char_30, id FROM t1_values
290 WHERE select_id = 193 OR select_id IS NULL order by id;
292 View Create View character_set_client collation_connection
293 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
295 WHERE v1.id IN (SELECT id FROM t1_values
296 WHERE select_id = 193 OR select_id IS NULL) order by id;
300 CREATE VIEW v1 AS SELECT CONCAT('A',my_char_30), my_char_30, id FROM t1_values;
301 SELECT CONCAT('A',my_char_30), my_char_30, id FROM t1_values
302 WHERE select_id = 192 OR select_id IS NULL order by id;
303 CONCAT('A',my_char_30) my_char_30 id
306 A<--------30 characters-------> <--------30 characters-------> 3
307 A ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
310 View Create View character_set_client collation_connection
311 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
313 WHERE v1.id IN (SELECT id FROM t1_values
314 WHERE select_id = 192 OR select_id IS NULL) order by id;
315 CONCAT('A',my_char_30) my_char_30 id
318 A<--------30 characters-------> <--------30 characters-------> 3
319 A ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
324 CREATE VIEW v1 AS SELECT LTRIM(my_varbinary_1000),
325 my_varbinary_1000, id FROM t1_values;
326 SELECT LTRIM(my_varbinary_1000),
327 my_varbinary_1000, id FROM t1_values
328 WHERE select_id = 191 OR select_id IS NULL order by id;
330 View Create View character_set_client collation_connection
331 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
333 WHERE v1.id IN (SELECT id FROM t1_values
334 WHERE select_id = 191 OR select_id IS NULL) order by id;
338 CREATE VIEW v1 AS SELECT LTRIM(my_binary_30),
339 my_binary_30, id FROM t1_values;
340 SELECT LTRIM(my_binary_30),
341 my_binary_30, id FROM t1_values
342 WHERE select_id = 190 OR select_id IS NULL order by id;
344 View Create View character_set_client collation_connection
345 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
347 WHERE v1.id IN (SELECT id FROM t1_values
348 WHERE select_id = 190 OR select_id IS NULL) order by id;
352 CREATE VIEW v1 AS SELECT LTRIM(my_varchar_1000),
353 my_varchar_1000, id FROM t1_values;
354 SELECT LTRIM(my_varchar_1000),
355 my_varchar_1000, id FROM t1_values
356 WHERE select_id = 189 OR select_id IS NULL order by id;
358 View Create View character_set_client collation_connection
359 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
361 WHERE v1.id IN (SELECT id FROM t1_values
362 WHERE select_id = 189 OR select_id IS NULL) order by id;
366 CREATE VIEW v1 AS SELECT LTRIM(my_char_30),
367 my_char_30, id FROM t1_values;
368 SELECT LTRIM(my_char_30),
369 my_char_30, id FROM t1_values
370 WHERE select_id = 188 OR select_id IS NULL order by id;
372 View Create View character_set_client collation_connection
373 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
375 WHERE v1.id IN (SELECT id FROM t1_values
376 WHERE select_id = 188 OR select_id IS NULL) order by id;
380 CREATE VIEW v1 AS SELECT LOWER(my_varbinary_1000),
381 my_varbinary_1000, id FROM t1_values;
382 SELECT LOWER(my_varbinary_1000),
383 my_varbinary_1000, id FROM t1_values
384 WHERE select_id = 187 OR select_id IS NULL order by id;
386 View Create View character_set_client collation_connection
387 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
389 WHERE v1.id IN (SELECT id FROM t1_values
390 WHERE select_id = 187 OR select_id IS NULL) order by id;
394 CREATE VIEW v1 AS SELECT LOWER(my_binary_30),
395 my_binary_30, id FROM t1_values;
396 SELECT LOWER(my_binary_30),
397 my_binary_30, id FROM t1_values
398 WHERE select_id = 186 OR select_id IS NULL order by id;
400 View Create View character_set_client collation_connection
401 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
403 WHERE v1.id IN (SELECT id FROM t1_values
404 WHERE select_id = 186 OR select_id IS NULL) order by id;
408 CREATE VIEW v1 AS SELECT LOWER(my_varchar_1000),
409 my_varchar_1000, id FROM t1_values;
410 SELECT LOWER(my_varchar_1000),
411 my_varchar_1000, id FROM t1_values
412 WHERE select_id = 185 OR select_id IS NULL order by id;
414 View Create View character_set_client collation_connection
415 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
417 WHERE v1.id IN (SELECT id FROM t1_values
418 WHERE select_id = 185 OR select_id IS NULL) order by id;
422 CREATE VIEW v1 AS SELECT LOWER(my_char_30),
423 my_char_30, id FROM t1_values;
424 SELECT LOWER(my_char_30),
425 my_char_30, id FROM t1_values
426 WHERE select_id = 184 OR select_id IS NULL order by id;
428 View Create View character_set_client collation_connection
429 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
431 WHERE v1.id IN (SELECT id FROM t1_values
432 WHERE select_id = 184 OR select_id IS NULL) order by id;
436 CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_decimal),
437 my_decimal, id FROM t1_values;
438 SELECT LOCATE('-', ' - -ABC', my_decimal),
439 my_decimal, id FROM t1_values
440 WHERE select_id = 183 OR select_id IS NULL order by id;
442 View Create View character_set_client collation_connection
443 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
445 WHERE v1.id IN (SELECT id FROM t1_values
446 WHERE select_id = 183 OR select_id IS NULL) order by id;
450 CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_double),
451 my_double, id FROM t1_values;
452 SELECT LOCATE('-', ' - -ABC', my_double),
453 my_double, id FROM t1_values
454 WHERE select_id = 182 OR select_id IS NULL order by id;
456 View Create View character_set_client collation_connection
457 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
459 WHERE v1.id IN (SELECT id FROM t1_values
460 WHERE select_id = 182 OR select_id IS NULL) order by id;
464 CREATE VIEW v1 AS SELECT LOCATE('-', ' - -ABC', my_bigint),
465 my_bigint, id FROM t1_values;
466 SELECT LOCATE('-', ' - -ABC', my_bigint),
467 my_bigint, id FROM t1_values
468 WHERE select_id = 181 OR select_id IS NULL order by id;
470 View Create View character_set_client collation_connection
471 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
473 WHERE v1.id IN (SELECT id FROM t1_values
474 WHERE select_id = 181 OR select_id IS NULL) order by id;
478 CREATE VIEW v1 AS SELECT LOCATE('-', my_varbinary_1000, 3),
479 my_varbinary_1000, id FROM t1_values;
480 SELECT LOCATE('-', my_varbinary_1000, 3),
481 my_varbinary_1000, id FROM t1_values
482 WHERE select_id = 180 OR select_id IS NULL order by id;
484 View Create View character_set_client collation_connection
485 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
487 WHERE v1.id IN (SELECT id FROM t1_values
488 WHERE select_id = 180 OR select_id IS NULL) order by id;
492 CREATE VIEW v1 AS SELECT LOCATE('-', my_binary_30, 3),
493 my_binary_30, id FROM t1_values;
494 SELECT LOCATE('-', my_binary_30, 3),
495 my_binary_30, id FROM t1_values
496 WHERE select_id = 179 OR select_id IS NULL order by id;
498 View Create View character_set_client collation_connection
499 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
501 WHERE v1.id IN (SELECT id FROM t1_values
502 WHERE select_id = 179 OR select_id IS NULL) order by id;
506 CREATE VIEW v1 AS SELECT LOCATE('-', my_varchar_1000, 3),
507 my_varchar_1000, id FROM t1_values;
508 SELECT LOCATE('-', my_varchar_1000, 3),
509 my_varchar_1000, id FROM t1_values
510 WHERE select_id = 178 OR select_id IS NULL order by id;
512 View Create View character_set_client collation_connection
513 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
515 WHERE v1.id IN (SELECT id FROM t1_values
516 WHERE select_id = 178 OR select_id IS NULL) order by id;
520 CREATE VIEW v1 AS SELECT LOCATE('-', my_char_30, 3),
521 my_char_30, id FROM t1_values;
522 SELECT LOCATE('-', my_char_30, 3),
523 my_char_30, id FROM t1_values
524 WHERE select_id = 177 OR select_id IS NULL order by id;
526 View Create View character_set_client collation_connection
527 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
529 WHERE v1.id IN (SELECT id FROM t1_values
530 WHERE select_id = 177 OR select_id IS NULL) order by id;
534 CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
535 my_varbinary_1000, my_binary_30 id FROM t1_values;
536 SELECT LOCATE(my_varbinary_1000, my_binary_30 ),
537 my_varbinary_1000, my_binary_30 id FROM t1_values
538 WHERE select_id = 176 OR select_id IS NULL order by id;
540 View Create View character_set_client collation_connection
541 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
543 WHERE v1.id IN (SELECT id FROM t1_values
544 WHERE select_id = 176 OR select_id IS NULL) order by id;
548 CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
549 my_varbinary_1000, my_varchar_1000 id FROM t1_values;
550 SELECT LOCATE(my_varbinary_1000, my_varchar_1000 ),
551 my_varbinary_1000, my_varchar_1000 id FROM t1_values
552 WHERE select_id = 175 OR select_id IS NULL order by id;
554 View Create View character_set_client collation_connection
555 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
557 WHERE v1.id IN (SELECT id FROM t1_values
558 WHERE select_id = 175 OR select_id IS NULL) order by id;
562 CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_char_30 ),
563 my_varbinary_1000, my_char_30 id FROM t1_values;
564 SELECT LOCATE(my_varbinary_1000, my_char_30 ),
565 my_varbinary_1000, my_char_30 id FROM t1_values
566 WHERE select_id = 174 OR select_id IS NULL order by id;
568 View Create View character_set_client collation_connection
569 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
571 WHERE v1.id IN (SELECT id FROM t1_values
572 WHERE select_id = 174 OR select_id IS NULL) order by id;
576 CREATE VIEW v1 AS SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
577 my_varbinary_1000, id FROM t1_values;
578 SELECT LOCATE(my_varbinary_1000, my_varbinary_1000 ),
579 my_varbinary_1000, id FROM t1_values
580 WHERE select_id = 173 OR select_id IS NULL order by id;
582 View Create View character_set_client collation_connection
583 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
585 WHERE v1.id IN (SELECT id FROM t1_values
586 WHERE select_id = 173 OR select_id IS NULL) order by id;
590 CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
591 my_binary_30, my_varbinary_1000 id FROM t1_values;
592 SELECT LOCATE(my_binary_30, my_varbinary_1000 ),
593 my_binary_30, my_varbinary_1000 id FROM t1_values
594 WHERE select_id = 172 OR select_id IS NULL order by id;
596 View Create View character_set_client collation_connection
597 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
599 WHERE v1.id IN (SELECT id FROM t1_values
600 WHERE select_id = 172 OR select_id IS NULL) order by id;
604 CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_varchar_1000 ),
605 my_binary_30, my_varchar_1000 id FROM t1_values;
606 SELECT LOCATE(my_binary_30, my_varchar_1000 ),
607 my_binary_30, my_varchar_1000 id FROM t1_values
608 WHERE select_id = 171 OR select_id IS NULL order by id;
610 View Create View character_set_client collation_connection
611 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
613 WHERE v1.id IN (SELECT id FROM t1_values
614 WHERE select_id = 171 OR select_id IS NULL) order by id;
618 CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_char_30 ),
619 my_binary_30, my_char_30 id FROM t1_values;
620 SELECT LOCATE(my_binary_30, my_char_30 ),
621 my_binary_30, my_char_30 id FROM t1_values
622 WHERE select_id = 170 OR select_id IS NULL order by id;
624 View Create View character_set_client collation_connection
625 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
627 WHERE v1.id IN (SELECT id FROM t1_values
628 WHERE select_id = 170 OR select_id IS NULL) order by id;
632 CREATE VIEW v1 AS SELECT LOCATE(my_binary_30, my_binary_30 ),
633 my_binary_30, id FROM t1_values;
634 SELECT LOCATE(my_binary_30, my_binary_30 ),
635 my_binary_30, id FROM t1_values
636 WHERE select_id = 169 OR select_id IS NULL order by id;
638 View Create View character_set_client collation_connection
639 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
641 WHERE v1.id IN (SELECT id FROM t1_values
642 WHERE select_id = 169 OR select_id IS NULL) order by id;
646 CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
647 my_varchar_1000, my_varbinary_1000 id FROM t1_values;
648 SELECT LOCATE(my_varchar_1000, my_varbinary_1000 ),
649 my_varchar_1000, my_varbinary_1000 id FROM t1_values
650 WHERE select_id = 168 OR select_id IS NULL order by id;
652 View Create View character_set_client collation_connection
653 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
655 WHERE v1.id IN (SELECT id FROM t1_values
656 WHERE select_id = 168 OR select_id IS NULL) order by id;
660 CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_binary_30 ),
661 my_varchar_1000, my_binary_30 id FROM t1_values;
662 SELECT LOCATE(my_varchar_1000, my_binary_30 ),
663 my_varchar_1000, my_binary_30 id FROM t1_values
664 WHERE select_id = 167 OR select_id IS NULL order by id;
666 View Create View character_set_client collation_connection
667 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
669 WHERE v1.id IN (SELECT id FROM t1_values
670 WHERE select_id = 167 OR select_id IS NULL) order by id;
674 CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_char_30 ),
675 my_varchar_1000, my_char_30 id FROM t1_values;
676 SELECT LOCATE(my_varchar_1000, my_char_30 ),
677 my_varchar_1000, my_char_30 id FROM t1_values
678 WHERE select_id = 166 OR select_id IS NULL order by id;
680 View Create View character_set_client collation_connection
681 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
683 WHERE v1.id IN (SELECT id FROM t1_values
684 WHERE select_id = 166 OR select_id IS NULL) order by id;
688 CREATE VIEW v1 AS SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
689 my_varchar_1000, id FROM t1_values;
690 SELECT LOCATE(my_varchar_1000, my_varchar_1000 ),
691 my_varchar_1000, id FROM t1_values
692 WHERE select_id = 165 OR select_id IS NULL order by id;
694 View Create View character_set_client collation_connection
695 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
697 WHERE v1.id IN (SELECT id FROM t1_values
698 WHERE select_id = 165 OR select_id IS NULL) order by id;
702 CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_varbinary_1000 ),
703 my_char_30, my_varbinary_1000 id FROM t1_values;
704 SELECT LOCATE(my_char_30, my_varbinary_1000 ),
705 my_char_30, my_varbinary_1000 id FROM t1_values
706 WHERE select_id = 164 OR select_id IS NULL order by id;
708 View Create View character_set_client collation_connection
709 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
711 WHERE v1.id IN (SELECT id FROM t1_values
712 WHERE select_id = 164 OR select_id IS NULL) order by id;
716 CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_binary_30 ),
717 my_char_30, my_binary_30 id FROM t1_values;
718 SELECT LOCATE(my_char_30, my_binary_30 ),
719 my_char_30, my_binary_30 id FROM t1_values
720 WHERE select_id = 163 OR select_id IS NULL order by id;
722 View Create View character_set_client collation_connection
723 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
725 WHERE v1.id IN (SELECT id FROM t1_values
726 WHERE select_id = 163 OR select_id IS NULL) order by id;
730 CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_varchar_1000 ),
731 my_char_30, my_varchar_1000 id FROM t1_values;
732 SELECT LOCATE(my_char_30, my_varchar_1000 ),
733 my_char_30, my_varchar_1000 id FROM t1_values
734 WHERE select_id = 162 OR select_id IS NULL order by id;
736 View Create View character_set_client collation_connection
737 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
739 WHERE v1.id IN (SELECT id FROM t1_values
740 WHERE select_id = 162 OR select_id IS NULL) order by id;
744 CREATE VIEW v1 AS SELECT LOCATE(my_char_30, my_char_30 ),
745 my_char_30, id FROM t1_values;
746 SELECT LOCATE(my_char_30, my_char_30 ),
747 my_char_30, id FROM t1_values
748 WHERE select_id = 161 OR select_id IS NULL order by id;
750 View Create View character_set_client collation_connection
751 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
753 WHERE v1.id IN (SELECT id FROM t1_values
754 WHERE select_id = 161 OR select_id IS NULL) order by id;
758 CREATE VIEW v1 AS SELECT LOCATE('char', my_varbinary_1000),
759 my_varbinary_1000, id FROM t1_values;
760 SELECT LOCATE('char', my_varbinary_1000),
761 my_varbinary_1000, id FROM t1_values
762 WHERE select_id = 160 OR select_id IS NULL order by id;
764 View Create View character_set_client collation_connection
765 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
767 WHERE v1.id IN (SELECT id FROM t1_values
768 WHERE select_id = 160 OR select_id IS NULL) order by id;
772 CREATE VIEW v1 AS SELECT LOCATE('char', my_binary_30),
773 my_binary_30, id FROM t1_values;
774 SELECT LOCATE('char', my_binary_30),
775 my_binary_30, id FROM t1_values
776 WHERE select_id = 159 OR select_id IS NULL order by id;
778 View Create View character_set_client collation_connection
779 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
781 WHERE v1.id IN (SELECT id FROM t1_values
782 WHERE select_id = 159 OR select_id IS NULL) order by id;
786 CREATE VIEW v1 AS SELECT LOCATE('char', my_varchar_1000),
787 my_varchar_1000, id FROM t1_values;
788 SELECT LOCATE('char', my_varchar_1000),
789 my_varchar_1000, id FROM t1_values
790 WHERE select_id = 158 OR select_id IS NULL order by id;
792 View Create View character_set_client collation_connection
793 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
795 WHERE v1.id IN (SELECT id FROM t1_values
796 WHERE select_id = 158 OR select_id IS NULL) order by id;
800 CREATE VIEW v1 AS SELECT LOCATE('char', my_char_30),
801 my_char_30, id FROM t1_values;
802 SELECT LOCATE('char', my_char_30),
803 my_char_30, id FROM t1_values
804 WHERE select_id = 157 OR select_id IS NULL order by id;
806 View Create View character_set_client collation_connection
807 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
809 WHERE v1.id IN (SELECT id FROM t1_values
810 WHERE select_id = 157 OR select_id IS NULL) order by id;
814 CREATE VIEW v1 AS SELECT LOAD_FILE('<MYSQLTEST_VARDIR>/std_data/funcs_1/load_file.txt')
817 SELECT LOAD_FILE('<MYSQLTEST_VARDIR>/std_data/funcs_1/load_file.txt')
820 WHERE select_id = 156 OR select_id IS NULL order by id;
822 Here is content from load_file
824 Here is content from load_file
826 Here is content from load_file
828 Here is content from load_file
830 Here is content from load_file
833 View Create View character_set_client collation_connection
834 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
836 WHERE v1.id IN (SELECT id FROM t1_values
837 WHERE select_id = 156 OR select_id IS NULL) order by id;
839 Here is content from load_file
841 Here is content from load_file
843 Here is content from load_file
845 Here is content from load_file
847 Here is content from load_file
852 CREATE VIEW v1 AS SELECT LENGTH(my_varbinary_1000),
853 my_varbinary_1000, id FROM t1_values;
854 SELECT LENGTH(my_varbinary_1000),
855 my_varbinary_1000, id FROM t1_values
856 WHERE select_id = 155 OR select_id IS NULL order by id;
858 View Create View character_set_client collation_connection
859 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
861 WHERE v1.id IN (SELECT id FROM t1_values
862 WHERE select_id = 155 OR select_id IS NULL) order by id;
866 CREATE VIEW v1 AS SELECT LENGTH(my_binary_30),
867 my_binary_30, id FROM t1_values;
868 SELECT LENGTH(my_binary_30),
869 my_binary_30, id FROM t1_values
870 WHERE select_id = 154 OR select_id IS NULL order by id;
872 View Create View character_set_client collation_connection
873 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
875 WHERE v1.id IN (SELECT id FROM t1_values
876 WHERE select_id = 154 OR select_id IS NULL) order by id;
880 CREATE VIEW v1 AS SELECT LENGTH(my_varchar_1000),
881 my_varchar_1000, id FROM t1_values;
882 SELECT LENGTH(my_varchar_1000),
883 my_varchar_1000, id FROM t1_values
884 WHERE select_id = 153 OR select_id IS NULL order by id;
886 View Create View character_set_client collation_connection
887 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
889 WHERE v1.id IN (SELECT id FROM t1_values
890 WHERE select_id = 153 OR select_id IS NULL) order by id;
894 CREATE VIEW v1 AS SELECT LENGTH(my_char_30),
895 my_char_30, id FROM t1_values;
896 SELECT LENGTH(my_char_30),
897 my_char_30, id FROM t1_values
898 WHERE select_id = 152 OR select_id IS NULL order by id;
900 View Create View character_set_client collation_connection
901 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
903 WHERE v1.id IN (SELECT id FROM t1_values
904 WHERE select_id = 152 OR select_id IS NULL) order by id;
908 CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double), my_double, id FROM t1_values;
909 SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double), my_double, id FROM t1_values
910 WHERE select_id = 151 OR select_id IS NULL order by id;
911 LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double) my_double id
913 -1.7976931348623e+308 2
914 AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 1.7976931348623e+308 3
918 Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e+308'
919 Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e+308'
921 View Create View character_set_client collation_connection
922 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
924 WHERE v1.id IN (SELECT id FROM t1_values
925 WHERE select_id = 151 OR select_id IS NULL) order by id;
926 LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_double) my_double id
928 -1.7976931348623e+308 2
929 AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 1.7976931348623e+308 3
933 Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e+308'
934 Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e+308'
938 CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal), my_decimal, id FROM t1_values;
939 SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal), my_decimal, id FROM t1_values
940 WHERE select_id = 150 OR select_id IS NULL order by id;
941 LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal) my_decimal id
943 -9999999999999999999999999999999999.999999999999999999999999999999 2
944 AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9999999999999999999999999999999999.999999999999999999999999999999 3
945 0.000000000000000000000000000000 4
946 -1.000000000000000000000000000000 5
948 Error 1292 Truncated incorrect DECIMAL value: ''
949 Error 1292 Truncated incorrect DECIMAL value: ''
951 View Create View character_set_client collation_connection
952 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
954 WHERE v1.id IN (SELECT id FROM t1_values
955 WHERE select_id = 150 OR select_id IS NULL) order by id;
956 LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_decimal) my_decimal id
958 -9999999999999999999999999999999999.999999999999999999999999999999 2
959 AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9999999999999999999999999999999999.999999999999999999999999999999 3
960 0.000000000000000000000000000000 4
961 -1.000000000000000000000000000000 5
963 Error 1292 Truncated incorrect DECIMAL value: ''
964 Error 1292 Truncated incorrect DECIMAL value: ''
968 CREATE VIEW v1 AS SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint), my_bigint, id FROM t1_values;
969 SELECT LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint), my_bigint, id FROM t1_values
970 WHERE select_id = 149 OR select_id IS NULL order by id;
971 LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint) my_bigint id
973 -9223372036854775808 2
974 AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9223372036854775807 3
978 View Create View character_set_client collation_connection
979 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
981 WHERE v1.id IN (SELECT id FROM t1_values
982 WHERE select_id = 149 OR select_id IS NULL) order by id;
983 LEFT('AaBbCcDdEeFfGgHhIiJjÄäÜüÖö', my_bigint) my_bigint id
985 -9223372036854775808 2
986 AaBbCcDdEeFfGgHhIiJjÄäÜüÖö 9223372036854775807 3
992 CREATE VIEW v1 AS SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values;
993 SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values
994 WHERE select_id = 148 OR select_id IS NULL order by id;
995 LEFT(my_varbinary_1000, 2) my_varbinary_1000 id
998 <- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1001 SHOW CREATE VIEW v1;
1002 View Create View character_set_client collation_connection
1003 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
1005 WHERE v1.id IN (SELECT id FROM t1_values
1006 WHERE select_id = 148 OR select_id IS NULL) order by id;
1007 LEFT(my_varbinary_1000, 2) my_varbinary_1000 id
1010 <- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1016 CREATE VIEW v1 AS SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values;
1017 SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values
1018 WHERE select_id = 147 OR select_id IS NULL order by id;
1019 LEFT(my_binary_30, 2) my_binary_30 id
1022 <- <--------30 characters-------> 3
1025 SHOW CREATE VIEW v1;
1026 View Create View character_set_client collation_connection
1027 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
1029 WHERE v1.id IN (SELECT id FROM t1_values
1030 WHERE select_id = 147 OR select_id IS NULL) order by id;
1031 LEFT(my_binary_30, 2) my_binary_30 id
1033 \0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
1034 <- <--------30 characters-------> 3
1035 - ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
1036 -1 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
1040 CREATE VIEW v1 AS SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values;
1041 SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values
1042 WHERE select_id = 146 OR select_id IS NULL order by id;
1043 LEFT(my_varchar_1000, 2) my_varchar_1000 id
1046 <- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1049 SHOW CREATE VIEW v1;
1050 View Create View character_set_client collation_connection
1051 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
1053 WHERE v1.id IN (SELECT id FROM t1_values
1054 WHERE select_id = 146 OR select_id IS NULL) order by id;
1055 LEFT(my_varchar_1000, 2) my_varchar_1000 id
1058 <- <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1064 CREATE VIEW v1 AS SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values;
1065 SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values
1066 WHERE select_id = 145 OR select_id IS NULL order by id;
1067 LEFT(my_char_30, 2) my_char_30 id
1070 <- <--------30 characters-------> 3
1073 SHOW CREATE VIEW v1;
1074 View Create View character_set_client collation_connection
1075 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
1077 WHERE v1.id IN (SELECT id FROM t1_values
1078 WHERE select_id = 145 OR select_id IS NULL) order by id;
1079 LEFT(my_char_30, 2) my_char_30 id
1082 <- <--------30 characters-------> 3
1088 CREATE VIEW v1 AS SELECT LCASE(my_varchar_1000),
1089 my_varchar_1000, id FROM t1_values;
1090 SELECT LCASE(my_varchar_1000),
1091 my_varchar_1000, id FROM t1_values
1092 WHERE select_id = 144 OR select_id IS NULL order by id;
1093 SHOW CREATE VIEW v1;
1094 View Create View character_set_client collation_connection
1095 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
1097 WHERE v1.id IN (SELECT id FROM t1_values
1098 WHERE select_id = 144 OR select_id IS NULL) order by id;
1102 CREATE VIEW v1 AS SELECT INSTR(my_char_30, 'char'),
1103 my_char_30, id FROM t1_values;
1104 SELECT INSTR(my_char_30, 'char'),
1105 my_char_30, id FROM t1_values
1106 WHERE select_id = 143 OR select_id IS NULL order by id;
1107 SHOW CREATE VIEW v1;
1108 View Create View character_set_client collation_connection
1109 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
1111 WHERE v1.id IN (SELECT id FROM t1_values
1112 WHERE select_id = 143 OR select_id IS NULL) order by id;
1116 CREATE VIEW v1 AS SELECT BIT_LENGTH(my_varbinary_1000),
1117 my_varbinary_1000, id FROM t1_values;
1118 SELECT BIT_LENGTH(my_varbinary_1000),
1119 my_varbinary_1000, id FROM t1_values
1120 WHERE select_id = 142 OR select_id IS NULL order by id;
1121 BIT_LENGTH(my_varbinary_1000) my_varbinary_1000 id
1124 8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1127 SHOW CREATE VIEW v1;
1128 View Create View character_set_client collation_connection
1129 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
1131 WHERE v1.id IN (SELECT id FROM t1_values
1132 WHERE select_id = 142 OR select_id IS NULL) order by id;
1133 BIT_LENGTH(my_varbinary_1000) my_varbinary_1000 id
1136 8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1142 CREATE VIEW v1 AS SELECT BIT_LENGTH(my_binary_30),
1143 my_binary_30, id FROM t1_values;
1144 SELECT BIT_LENGTH(my_binary_30),
1145 my_binary_30, id FROM t1_values
1146 WHERE select_id = 141 OR select_id IS NULL order by id;
1147 BIT_LENGTH(my_binary_30) my_binary_30 id
1150 240 <--------30 characters-------> 3
1153 SHOW CREATE VIEW v1;
1154 View Create View character_set_client collation_connection
1155 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
1157 WHERE v1.id IN (SELECT id FROM t1_values
1158 WHERE select_id = 141 OR select_id IS NULL) order by id;
1159 BIT_LENGTH(my_binary_30) my_binary_30 id
1161 240
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
1162 240 <--------30 characters-------> 3
1163 240 ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
1164 240 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
1168 CREATE VIEW v1 AS SELECT BIT_LENGTH(my_varchar_1000),
1169 my_varchar_1000, id FROM t1_values;
1170 SELECT BIT_LENGTH(my_varchar_1000),
1171 my_varchar_1000, id FROM t1_values
1172 WHERE select_id = 140 OR select_id IS NULL order by id;
1173 BIT_LENGTH(my_varchar_1000) my_varchar_1000 id
1176 8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1179 SHOW CREATE VIEW v1;
1180 View Create View character_set_client collation_connection
1181 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
1183 WHERE v1.id IN (SELECT id FROM t1_values
1184 WHERE select_id = 140 OR select_id IS NULL) order by id;
1185 BIT_LENGTH(my_varchar_1000) my_varchar_1000 id
1188 8000 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1194 CREATE VIEW v1 AS SELECT BIT_LENGTH(my_char_30),
1195 my_char_30, id FROM t1_values;
1196 SELECT BIT_LENGTH(my_char_30),
1197 my_char_30, id FROM t1_values
1198 WHERE select_id = 139 OR select_id IS NULL order by id;
1199 BIT_LENGTH(my_char_30) my_char_30 id
1202 240 <--------30 characters-------> 3
1205 SHOW CREATE VIEW v1;
1206 View Create View character_set_client collation_connection
1207 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
1209 WHERE v1.id IN (SELECT id FROM t1_values
1210 WHERE select_id = 139 OR select_id IS NULL) order by id;
1211 BIT_LENGTH(my_char_30) my_char_30 id
1214 240 <--------30 characters-------> 3
1220 CREATE VIEW v1 AS SELECT IFNULL(my_year,'IS_NULL'),
1221 my_year, id FROM t1_values;
1222 SELECT IFNULL(my_year,'IS_NULL'),
1223 my_year, id FROM t1_values
1224 WHERE select_id = 138 OR select_id IS NULL order by id;
1225 IFNULL(my_year,'IS_NULL') my_year id
1231 SHOW CREATE VIEW v1;
1232 View Create View character_set_client collation_connection
1233 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
1235 WHERE v1.id IN (SELECT id FROM t1_values
1236 WHERE select_id = 138 OR select_id IS NULL) order by id;
1237 IFNULL(my_year,'IS_NULL') my_year id
1246 CREATE VIEW v1 AS SELECT IFNULL(my_time,'IS_NULL'),
1247 my_time, id FROM t1_values;
1248 SELECT IFNULL(my_time,'IS_NULL'),
1249 my_time, id FROM t1_values
1250 WHERE select_id = 137 OR select_id IS NULL order by id;
1251 IFNULL(my_time,'IS_NULL') my_time id
1253 -838:59:59 -838:59:59 2
1254 838:59:59 838:59:59 3
1257 SHOW CREATE VIEW v1;
1258 View Create View character_set_client collation_connection
1259 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
1261 WHERE v1.id IN (SELECT id FROM t1_values
1262 WHERE select_id = 137 OR select_id IS NULL) order by id;
1263 IFNULL(my_time,'IS_NULL') my_time id
1265 -838:59:59 -838:59:59 2
1266 838:59:59 838:59:59 3
1272 CREATE VIEW v1 AS SELECT IFNULL(my_timestamp,'IS_NULL'),
1273 my_timestamp, id FROM t1_values;
1274 SELECT IFNULL(my_timestamp,'IS_NULL'),
1275 my_timestamp, id FROM t1_values
1276 WHERE select_id = 136 OR select_id IS NULL order by id;
1277 IFNULL(my_timestamp,'IS_NULL') my_timestamp id
1278 0000-00-00 00:00:00 0000-00-00 00:00:00 1
1279 1970-01-01 03:00:01 1970-01-01 03:00:01 2
1280 2038-01-01 02:59:59 2038-01-01 02:59:59 3
1281 2004-02-29 23:59:59 2004-02-29 23:59:59 4
1282 2005-06-28 10:00:00 2005-06-28 10:00:00 5
1283 SHOW CREATE VIEW v1;
1284 View Create View character_set_client collation_connection
1285 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
1287 WHERE v1.id IN (SELECT id FROM t1_values
1288 WHERE select_id = 136 OR select_id IS NULL) order by id;
1289 IFNULL(my_timestamp,'IS_NULL') my_timestamp id
1290 0000-00-00 00:00:00 0000-00-00 00:00:00 1
1291 1970-01-01 03:00:01 1970-01-01 03:00:01 2
1292 2038-01-01 02:59:59 2038-01-01 02:59:59 3
1293 2004-02-29 23:59:59 2004-02-29 23:59:59 4
1294 2005-06-28 10:00:00 2005-06-28 10:00:00 5
1298 CREATE VIEW v1 AS SELECT IFNULL(my_date,'IS_NULL'),
1299 my_date, id FROM t1_values;
1300 SELECT IFNULL(my_date,'IS_NULL'),
1301 my_date, id FROM t1_values
1302 WHERE select_id = 135 OR select_id IS NULL order by id;
1303 IFNULL(my_date,'IS_NULL') my_date id
1305 0001-01-01 0001-01-01 2
1306 9999-12-31 9999-12-31 3
1307 2004-02-29 2004-02-29 4
1308 2005-06-28 2005-06-28 5
1309 SHOW CREATE VIEW v1;
1310 View Create View character_set_client collation_connection
1311 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
1313 WHERE v1.id IN (SELECT id FROM t1_values
1314 WHERE select_id = 135 OR select_id IS NULL) order by id;
1315 IFNULL(my_date,'IS_NULL') my_date id
1317 0001-01-01 0001-01-01 2
1318 9999-12-31 9999-12-31 3
1319 2004-02-29 2004-02-29 4
1320 2005-06-28 2005-06-28 5
1324 CREATE VIEW v1 AS SELECT IFNULL(my_datetime,'IS_NULL'),
1325 my_datetime, id FROM t1_values;
1326 SELECT IFNULL(my_datetime,'IS_NULL'),
1327 my_datetime, id FROM t1_values
1328 WHERE select_id = 134 OR select_id IS NULL order by id;
1329 IFNULL(my_datetime,'IS_NULL') my_datetime id
1331 0001-01-01 00:00:00 0001-01-01 00:00:00 2
1332 9999-12-31 23:59:59 9999-12-31 23:59:59 3
1333 2004-02-29 23:59:59 2004-02-29 23:59:59 4
1334 2005-06-28 10:00:00 2005-06-28 10:00:00 5
1335 SHOW CREATE VIEW v1;
1336 View Create View character_set_client collation_connection
1337 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
1339 WHERE v1.id IN (SELECT id FROM t1_values
1340 WHERE select_id = 134 OR select_id IS NULL) order by id;
1341 IFNULL(my_datetime,'IS_NULL') my_datetime id
1343 0001-01-01 00:00:00 0001-01-01 00:00:00 2
1344 9999-12-31 23:59:59 9999-12-31 23:59:59 3
1345 2004-02-29 23:59:59 2004-02-29 23:59:59 4
1346 2005-06-28 10:00:00 2005-06-28 10:00:00 5
1350 CREATE VIEW v1 AS SELECT IFNULL(my_double,'IS_NULL'),
1351 my_double, id FROM t1_values;
1352 SELECT IFNULL(my_double,'IS_NULL'),
1353 my_double, id FROM t1_values
1354 WHERE select_id = 133 OR select_id IS NULL order by id;
1355 IFNULL(my_double,'IS_NULL') my_double id
1357 -1.7976931348623e+308 -1.7976931348623e+308 2
1358 1.7976931348623e+308 1.7976931348623e+308 3
1361 SHOW CREATE VIEW v1;
1362 View Create View character_set_client collation_connection
1363 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
1365 WHERE v1.id IN (SELECT id FROM t1_values
1366 WHERE select_id = 133 OR select_id IS NULL) order by id;
1367 IFNULL(my_double,'IS_NULL') my_double id
1369 -1.7976931348623e+308 -1.7976931348623e+308 2
1370 1.7976931348623e+308 1.7976931348623e+308 3
1376 CREATE VIEW v1 AS SELECT IFNULL(my_decimal,'IS_NULL'),
1377 my_decimal, id FROM t1_values;
1378 SELECT IFNULL(my_decimal,'IS_NULL'),
1379 my_decimal, id FROM t1_values
1380 WHERE select_id = 132 OR select_id IS NULL order by id;
1381 IFNULL(my_decimal,'IS_NULL') my_decimal id
1383 -9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
1384 9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
1385 0.000000000000000000000000000000 0.000000000000000000000000000000 4
1386 -1.000000000000000000000000000000 -1.000000000000000000000000000000 5
1387 SHOW CREATE VIEW v1;
1388 View Create View character_set_client collation_connection
1389 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
1391 WHERE v1.id IN (SELECT id FROM t1_values
1392 WHERE select_id = 132 OR select_id IS NULL) order by id;
1393 IFNULL(my_decimal,'IS_NULL') my_decimal id
1395 -9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
1396 9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
1397 0.000000000000000000000000000000 0.000000000000000000000000000000 4
1398 -1.000000000000000000000000000000 -1.000000000000000000000000000000 5
1402 CREATE VIEW v1 AS SELECT IFNULL(my_bigint,'IS_NULL'),
1403 my_bigint, id FROM t1_values;
1404 SELECT IFNULL(my_bigint,'IS_NULL'),
1405 my_bigint, id FROM t1_values
1406 WHERE select_id = 131 OR select_id IS NULL order by id;
1407 IFNULL(my_bigint,'IS_NULL') my_bigint id
1409 -9223372036854775808 -9223372036854775808 2
1410 9223372036854775807 9223372036854775807 3
1413 SHOW CREATE VIEW v1;
1414 View Create View character_set_client collation_connection
1415 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
1417 WHERE v1.id IN (SELECT id FROM t1_values
1418 WHERE select_id = 131 OR select_id IS NULL) order by id;
1419 IFNULL(my_bigint,'IS_NULL') my_bigint id
1421 -9223372036854775808 -9223372036854775808 2
1422 9223372036854775807 9223372036854775807 3
1428 CREATE VIEW v1 AS SELECT IFNULL(my_varbinary_1000,'IS_NULL'),
1429 my_varbinary_1000, id FROM t1_values;
1430 SELECT IFNULL(my_varbinary_1000,'IS_NULL'),
1431 my_varbinary_1000, id FROM t1_values
1432 WHERE select_id = 130 OR select_id IS NULL order by id;
1433 IFNULL(my_varbinary_1000,'IS_NULL') my_varbinary_1000 id
1436 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1437 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1439 SHOW CREATE VIEW v1;
1440 View Create View character_set_client collation_connection
1441 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
1443 WHERE v1.id IN (SELECT id FROM t1_values
1444 WHERE select_id = 130 OR select_id IS NULL) order by id;
1445 IFNULL(my_varbinary_1000,'IS_NULL') my_varbinary_1000 id
1448 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1449 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1454 CREATE VIEW v1 AS SELECT IFNULL(my_binary_30,'IS_NULL'),
1455 my_binary_30, id FROM t1_values;
1456 SELECT IFNULL(my_binary_30,'IS_NULL'),
1457 my_binary_30, id FROM t1_values
1458 WHERE select_id = 129 OR select_id IS NULL order by id;
1459 IFNULL(my_binary_30,'IS_NULL') my_binary_30 id
1462 <--------30 characters-------> <--------30 characters-------> 3
1463 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1465 SHOW CREATE VIEW v1;
1466 View Create View character_set_client collation_connection
1467 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
1469 WHERE v1.id IN (SELECT id FROM t1_values
1470 WHERE select_id = 129 OR select_id IS NULL) order by id;
1471 IFNULL(my_binary_30,'IS_NULL') my_binary_30 id
1473 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
1474 <--------30 characters-------> <--------30 characters-------> 3
1475 ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
1476 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
1480 CREATE VIEW v1 AS SELECT IFNULL(my_varchar_1000,'IS_NULL'),
1481 my_varchar_1000, id FROM t1_values;
1482 SELECT IFNULL(my_varchar_1000,'IS_NULL'),
1483 my_varchar_1000, id FROM t1_values
1484 WHERE select_id = 128 OR select_id IS NULL order by id;
1485 IFNULL(my_varchar_1000,'IS_NULL') my_varchar_1000 id
1488 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1489 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1491 SHOW CREATE VIEW v1;
1492 View Create View character_set_client collation_connection
1493 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
1495 WHERE v1.id IN (SELECT id FROM t1_values
1496 WHERE select_id = 128 OR select_id IS NULL) order by id;
1497 IFNULL(my_varchar_1000,'IS_NULL') my_varchar_1000 id
1500 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1501 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1506 CREATE VIEW v1 AS SELECT IFNULL(my_char_30,'IS_NULL'),
1507 my_char_30, id FROM t1_values;
1508 SELECT IFNULL(my_char_30,'IS_NULL'),
1509 my_char_30, id FROM t1_values
1510 WHERE select_id = 127 OR select_id IS NULL order by id;
1511 IFNULL(my_char_30,'IS_NULL') my_char_30 id
1514 <--------30 characters-------> <--------30 characters-------> 3
1515 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1517 SHOW CREATE VIEW v1;
1518 View Create View character_set_client collation_connection
1519 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
1521 WHERE v1.id IN (SELECT id FROM t1_values
1522 WHERE select_id = 127 OR select_id IS NULL) order by id;
1523 IFNULL(my_char_30,'IS_NULL') my_char_30 id
1526 <--------30 characters-------> <--------30 characters-------> 3
1527 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
1532 CREATE VIEW v1 AS SELECT IF(my_year IS NULL, 'IS NULL',
1533 'IS NOT NULL'), my_year, id FROM t1_values;
1534 SELECT IF(my_year IS NULL, 'IS NULL',
1535 'IS NOT NULL'), my_year, id FROM t1_values
1536 WHERE select_id = 126 OR select_id IS NULL order by id;
1537 IF(my_year IS NULL, 'IS NULL',
1538 'IS NOT NULL') my_year id
1544 SHOW CREATE VIEW v1;
1545 View Create View character_set_client collation_connection
1546 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',
1547 'IS NOT NULL')`,`t1_values`.`my_year` AS `my_year`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1549 WHERE v1.id IN (SELECT id FROM t1_values
1550 WHERE select_id = 126 OR select_id IS NULL) order by id;
1551 IF(my_year IS NULL, 'IS NULL',
1552 'IS NOT NULL') my_year id
1561 CREATE VIEW v1 AS SELECT IF(my_time IS NULL, 'IS NULL',
1562 'IS NOT NULL'), my_time, id FROM t1_values;
1563 SELECT IF(my_time IS NULL, 'IS NULL',
1564 'IS NOT NULL'), my_time, id FROM t1_values
1565 WHERE select_id = 125 OR select_id IS NULL order by id;
1566 IF(my_time IS NULL, 'IS NULL',
1567 'IS NOT NULL') my_time id
1569 IS NOT NULL -838:59:59 2
1570 IS NOT NULL 838:59:59 3
1571 IS NOT NULL 13:00:00 4
1572 IS NOT NULL 10:00:00 5
1573 SHOW CREATE VIEW v1;
1574 View Create View character_set_client collation_connection
1575 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',
1576 'IS NOT NULL')`,`t1_values`.`my_time` AS `my_time`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1578 WHERE v1.id IN (SELECT id FROM t1_values
1579 WHERE select_id = 125 OR select_id IS NULL) order by id;
1580 IF(my_time IS NULL, 'IS NULL',
1581 'IS NOT NULL') my_time id
1583 IS NOT NULL -838:59:59 2
1584 IS NOT NULL 838:59:59 3
1585 IS NOT NULL 13:00:00 4
1586 IS NOT NULL 10:00:00 5
1590 CREATE VIEW v1 AS SELECT IF(my_timestamp IS NULL, 'IS NULL',
1591 'IS NOT NULL'), my_timestamp, id FROM t1_values;
1592 SELECT IF(my_timestamp IS NULL, 'IS NULL',
1593 'IS NOT NULL'), my_timestamp, id FROM t1_values
1594 WHERE select_id = 124 OR select_id IS NULL order by id;
1595 IF(my_timestamp IS NULL, 'IS NULL',
1596 'IS NOT NULL') my_timestamp id
1597 IS NOT NULL 0000-00-00 00:00:00 1
1598 IS NOT NULL 1970-01-01 03:00:01 2
1599 IS NOT NULL 2038-01-01 02:59:59 3
1600 IS NOT NULL 2004-02-29 23:59:59 4
1601 IS NOT NULL 2005-06-28 10:00:00 5
1602 SHOW CREATE VIEW v1;
1603 View Create View character_set_client collation_connection
1604 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',
1605 'IS NOT NULL')`,`t1_values`.`my_timestamp` AS `my_timestamp`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1607 WHERE v1.id IN (SELECT id FROM t1_values
1608 WHERE select_id = 124 OR select_id IS NULL) order by id;
1609 IF(my_timestamp IS NULL, 'IS NULL',
1610 'IS NOT NULL') my_timestamp id
1611 IS NOT NULL 0000-00-00 00:00:00 1
1612 IS NOT NULL 1970-01-01 03:00:01 2
1613 IS NOT NULL 2038-01-01 02:59:59 3
1614 IS NOT NULL 2004-02-29 23:59:59 4
1615 IS NOT NULL 2005-06-28 10:00:00 5
1619 CREATE VIEW v1 AS SELECT IF(my_date IS NULL, 'IS NULL',
1620 'IS NOT NULL'), my_date, id FROM t1_values;
1621 SELECT IF(my_date IS NULL, 'IS NULL',
1622 'IS NOT NULL'), my_date, id FROM t1_values
1623 WHERE select_id = 123 OR select_id IS NULL order by id;
1624 IF(my_date IS NULL, 'IS NULL',
1625 'IS NOT NULL') my_date id
1627 IS NOT NULL 0001-01-01 2
1628 IS NOT NULL 9999-12-31 3
1629 IS NOT NULL 2004-02-29 4
1630 IS NOT NULL 2005-06-28 5
1631 SHOW CREATE VIEW v1;
1632 View Create View character_set_client collation_connection
1633 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',
1634 'IS NOT NULL')`,`t1_values`.`my_date` AS `my_date`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1636 WHERE v1.id IN (SELECT id FROM t1_values
1637 WHERE select_id = 123 OR select_id IS NULL) order by id;
1638 IF(my_date IS NULL, 'IS NULL',
1639 'IS NOT NULL') my_date id
1641 IS NOT NULL 0001-01-01 2
1642 IS NOT NULL 9999-12-31 3
1643 IS NOT NULL 2004-02-29 4
1644 IS NOT NULL 2005-06-28 5
1648 CREATE VIEW v1 AS SELECT IF(my_datetime IS NULL, 'IS NULL',
1649 'IS NOT NULL'), my_datetime, id FROM t1_values;
1650 SELECT IF(my_datetime IS NULL, 'IS NULL',
1651 'IS NOT NULL'), my_datetime, id FROM t1_values
1652 WHERE select_id = 122 OR select_id IS NULL order by id;
1653 IF(my_datetime IS NULL, 'IS NULL',
1654 'IS NOT NULL') my_datetime id
1656 IS NOT NULL 0001-01-01 00:00:00 2
1657 IS NOT NULL 9999-12-31 23:59:59 3
1658 IS NOT NULL 2004-02-29 23:59:59 4
1659 IS NOT NULL 2005-06-28 10:00:00 5
1660 SHOW CREATE VIEW v1;
1661 View Create View character_set_client collation_connection
1662 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',
1663 'IS NOT NULL')`,`t1_values`.`my_datetime` AS `my_datetime`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1665 WHERE v1.id IN (SELECT id FROM t1_values
1666 WHERE select_id = 122 OR select_id IS NULL) order by id;
1667 IF(my_datetime IS NULL, 'IS NULL',
1668 'IS NOT NULL') my_datetime id
1670 IS NOT NULL 0001-01-01 00:00:00 2
1671 IS NOT NULL 9999-12-31 23:59:59 3
1672 IS NOT NULL 2004-02-29 23:59:59 4
1673 IS NOT NULL 2005-06-28 10:00:00 5
1677 CREATE VIEW v1 AS SELECT IF(my_double IS NULL, 'IS NULL',
1678 'IS NOT NULL'), my_double, id FROM t1_values;
1679 SELECT IF(my_double IS NULL, 'IS NULL',
1680 'IS NOT NULL'), my_double, id FROM t1_values
1681 WHERE select_id = 121 OR select_id IS NULL order by id;
1682 IF(my_double IS NULL, 'IS NULL',
1683 'IS NOT NULL') my_double id
1685 IS NOT NULL -1.7976931348623e+308 2
1686 IS NOT NULL 1.7976931348623e+308 3
1689 SHOW CREATE VIEW v1;
1690 View Create View character_set_client collation_connection
1691 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',
1692 'IS NOT NULL')`,`t1_values`.`my_double` AS `my_double`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1694 WHERE v1.id IN (SELECT id FROM t1_values
1695 WHERE select_id = 121 OR select_id IS NULL) order by id;
1696 IF(my_double IS NULL, 'IS NULL',
1697 'IS NOT NULL') my_double id
1699 IS NOT NULL -1.7976931348623e+308 2
1700 IS NOT NULL 1.7976931348623e+308 3
1706 CREATE VIEW v1 AS SELECT IF(my_decimal IS NULL, 'IS NULL',
1707 'IS NOT NULL'), my_decimal, id FROM t1_values;
1708 SELECT IF(my_decimal IS NULL, 'IS NULL',
1709 'IS NOT NULL'), my_decimal, id FROM t1_values
1710 WHERE select_id = 120 OR select_id IS NULL order by id;
1711 IF(my_decimal IS NULL, 'IS NULL',
1712 'IS NOT NULL') my_decimal id
1714 IS NOT NULL -9999999999999999999999999999999999.999999999999999999999999999999 2
1715 IS NOT NULL 9999999999999999999999999999999999.999999999999999999999999999999 3
1716 IS NOT NULL 0.000000000000000000000000000000 4
1717 IS NOT NULL -1.000000000000000000000000000000 5
1718 SHOW CREATE VIEW v1;
1719 View Create View character_set_client collation_connection
1720 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',
1721 'IS NOT NULL')`,`t1_values`.`my_decimal` AS `my_decimal`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1723 WHERE v1.id IN (SELECT id FROM t1_values
1724 WHERE select_id = 120 OR select_id IS NULL) order by id;
1725 IF(my_decimal IS NULL, 'IS NULL',
1726 'IS NOT NULL') my_decimal id
1728 IS NOT NULL -9999999999999999999999999999999999.999999999999999999999999999999 2
1729 IS NOT NULL 9999999999999999999999999999999999.999999999999999999999999999999 3
1730 IS NOT NULL 0.000000000000000000000000000000 4
1731 IS NOT NULL -1.000000000000000000000000000000 5
1735 CREATE VIEW v1 AS SELECT IF(my_bigint IS NULL, 'IS NULL',
1736 'IS NOT NULL'), my_bigint, id FROM t1_values;
1737 SELECT IF(my_bigint IS NULL, 'IS NULL',
1738 'IS NOT NULL'), my_bigint, id FROM t1_values
1739 WHERE select_id = 119 OR select_id IS NULL order by id;
1740 IF(my_bigint IS NULL, 'IS NULL',
1741 'IS NOT NULL') my_bigint id
1743 IS NOT NULL -9223372036854775808 2
1744 IS NOT NULL 9223372036854775807 3
1747 SHOW CREATE VIEW v1;
1748 View Create View character_set_client collation_connection
1749 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',
1750 'IS NOT NULL')`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1752 WHERE v1.id IN (SELECT id FROM t1_values
1753 WHERE select_id = 119 OR select_id IS NULL) order by id;
1754 IF(my_bigint IS NULL, 'IS NULL',
1755 'IS NOT NULL') my_bigint id
1757 IS NOT NULL -9223372036854775808 2
1758 IS NOT NULL 9223372036854775807 3
1764 CREATE VIEW v1 AS SELECT IF(my_varbinary_1000 IS NULL, 'IS NULL',
1765 'IS NOT NULL'), my_varbinary_1000, id FROM t1_values;
1766 SELECT IF(my_varbinary_1000 IS NULL, 'IS NULL',
1767 'IS NOT NULL'), my_varbinary_1000, id FROM t1_values
1768 WHERE select_id = 118 OR select_id IS NULL order by id;
1769 IF(my_varbinary_1000 IS NULL, 'IS NULL',
1770 'IS NOT NULL') my_varbinary_1000 id
1773 IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1774 IS NOT NULL ---äÖüß@µ*$-- 4
1776 SHOW CREATE VIEW v1;
1777 View Create View character_set_client collation_connection
1778 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',
1779 'IS NOT NULL')`,`t1_values`.`my_varbinary_1000` AS `my_varbinary_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1781 WHERE v1.id IN (SELECT id FROM t1_values
1782 WHERE select_id = 118 OR select_id IS NULL) order by id;
1783 IF(my_varbinary_1000 IS NULL, 'IS NULL',
1784 'IS NOT NULL') my_varbinary_1000 id
1787 IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1788 IS NOT NULL ---äÖüß@µ*$-- 4
1793 CREATE VIEW v1 AS SELECT IF(my_binary_30 IS NULL, 'IS NULL',
1794 'IS NOT NULL'), my_binary_30, id FROM t1_values;
1795 SELECT IF(my_binary_30 IS NULL, 'IS NULL',
1796 'IS NOT NULL'), my_binary_30, id FROM t1_values
1797 WHERE select_id = 117 OR select_id IS NULL order by id;
1798 IF(my_binary_30 IS NULL, 'IS NULL',
1799 'IS NOT NULL') my_binary_30 id
1802 IS NOT NULL <--------30 characters-------> 3
1803 IS NOT NULL ---äÖüß@µ*$-- 4
1805 SHOW CREATE VIEW v1;
1806 View Create View character_set_client collation_connection
1807 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',
1808 'IS NOT NULL')`,`t1_values`.`my_binary_30` AS `my_binary_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1810 WHERE v1.id IN (SELECT id FROM t1_values
1811 WHERE select_id = 117 OR select_id IS NULL) order by id;
1812 IF(my_binary_30 IS NULL, 'IS NULL',
1813 'IS NOT NULL') my_binary_30 id
1815 IS NOT NULL
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
1816 IS NOT NULL <--------30 characters-------> 3
1817 IS NOT NULL ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
1818 IS NOT NULL -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
1822 CREATE VIEW v1 AS SELECT IF(my_varchar_1000 IS NULL, 'IS NULL',
1823 'IS NOT NULL'), my_varchar_1000, id FROM t1_values;
1824 SELECT IF(my_varchar_1000 IS NULL, 'IS NULL',
1825 'IS NOT NULL'), my_varchar_1000, id FROM t1_values
1826 WHERE select_id = 116 OR select_id IS NULL order by id;
1827 IF(my_varchar_1000 IS NULL, 'IS NULL',
1828 'IS NOT NULL') my_varchar_1000 id
1831 IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1832 IS NOT NULL ---äÖüß@µ*$-- 4
1834 SHOW CREATE VIEW v1;
1835 View Create View character_set_client collation_connection
1836 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',
1837 'IS NOT NULL')`,`t1_values`.`my_varchar_1000` AS `my_varchar_1000`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1839 WHERE v1.id IN (SELECT id FROM t1_values
1840 WHERE select_id = 116 OR select_id IS NULL) order by id;
1841 IF(my_varchar_1000 IS NULL, 'IS NULL',
1842 'IS NOT NULL') my_varchar_1000 id
1845 IS NOT NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
1846 IS NOT NULL ---äÖüß@µ*$-- 4
1851 CREATE VIEW v1 AS SELECT IF(my_char_30 IS NULL, 'IS NULL',
1852 'IS NOT NULL'), my_char_30, id FROM t1_values;
1853 SELECT IF(my_char_30 IS NULL, 'IS NULL',
1854 'IS NOT NULL'), my_char_30, id FROM t1_values
1855 WHERE select_id = 115 OR select_id IS NULL order by id;
1856 IF(my_char_30 IS NULL, 'IS NULL',
1857 'IS NOT NULL') my_char_30 id
1860 IS NOT NULL <--------30 characters-------> 3
1861 IS NOT NULL ---äÖüß@µ*$-- 4
1863 SHOW CREATE VIEW v1;
1864 View Create View character_set_client collation_connection
1865 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',
1866 'IS NOT NULL')`,`t1_values`.`my_char_30` AS `my_char_30`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
1868 WHERE v1.id IN (SELECT id FROM t1_values
1869 WHERE select_id = 115 OR select_id IS NULL) order by id;
1870 IF(my_char_30 IS NULL, 'IS NULL',
1871 'IS NOT NULL') my_char_30 id
1874 IS NOT NULL <--------30 characters-------> 3
1875 IS NOT NULL ---äÖüß@µ*$-- 4
1880 CREATE VIEW v1 AS SELECT IF(my_year, 'IS TRUE', 'IS NOT TRUE'),
1881 my_year, id FROM t1_values;
1882 SELECT IF(my_year, 'IS TRUE', 'IS NOT TRUE'),
1883 my_year, id FROM t1_values
1884 WHERE select_id = 114 OR select_id IS NULL order by id;
1885 IF(my_year, 'IS TRUE', 'IS NOT TRUE') my_year id
1891 SHOW CREATE VIEW v1;
1892 View Create View character_set_client collation_connection
1893 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
1895 WHERE v1.id IN (SELECT id FROM t1_values
1896 WHERE select_id = 114 OR select_id IS NULL) order by id;
1897 IF(my_year, 'IS TRUE', 'IS NOT TRUE') my_year id
1906 CREATE VIEW v1 AS SELECT IF(my_time, 'IS TRUE', 'IS NOT TRUE'),
1907 my_time, id FROM t1_values;
1908 SELECT IF(my_time, 'IS TRUE', 'IS NOT TRUE'),
1909 my_time, id FROM t1_values
1910 WHERE select_id = 113 OR select_id IS NULL order by id;
1911 IF(my_time, 'IS TRUE', 'IS NOT TRUE') my_time id
1913 IS TRUE -838:59:59 2
1917 SHOW CREATE VIEW v1;
1918 View Create View character_set_client collation_connection
1919 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
1921 WHERE v1.id IN (SELECT id FROM t1_values
1922 WHERE select_id = 113 OR select_id IS NULL) order by id;
1923 IF(my_time, 'IS TRUE', 'IS NOT TRUE') my_time id
1925 IS TRUE -838:59:59 2
1932 CREATE VIEW v1 AS SELECT IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE'),
1933 my_timestamp, id FROM t1_values;
1934 SELECT IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE'),
1935 my_timestamp, id FROM t1_values
1936 WHERE select_id = 112 OR select_id IS NULL order by id;
1937 IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE') my_timestamp id
1938 IS NOT TRUE 0000-00-00 00:00:00 1
1939 IS TRUE 1970-01-01 03:00:01 2
1940 IS TRUE 2038-01-01 02:59:59 3
1941 IS TRUE 2004-02-29 23:59:59 4
1942 IS TRUE 2005-06-28 10:00:00 5
1943 SHOW CREATE VIEW v1;
1944 View Create View character_set_client collation_connection
1945 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
1947 WHERE v1.id IN (SELECT id FROM t1_values
1948 WHERE select_id = 112 OR select_id IS NULL) order by id;
1949 IF(my_timestamp, 'IS TRUE', 'IS NOT TRUE') my_timestamp id
1950 IS NOT TRUE 0000-00-00 00:00:00 1
1951 IS TRUE 1970-01-01 03:00:01 2
1952 IS TRUE 2038-01-01 02:59:59 3
1953 IS TRUE 2004-02-29 23:59:59 4
1954 IS TRUE 2005-06-28 10:00:00 5
1958 CREATE VIEW v1 AS SELECT IF(my_date, 'IS TRUE', 'IS NOT TRUE'),
1959 my_date, id FROM t1_values;
1960 SELECT IF(my_date, 'IS TRUE', 'IS NOT TRUE'),
1961 my_date, id FROM t1_values
1962 WHERE select_id = 111 OR select_id IS NULL order by id;
1963 IF(my_date, 'IS TRUE', 'IS NOT TRUE') my_date id
1965 IS TRUE 0001-01-01 2
1966 IS TRUE 9999-12-31 3
1967 IS TRUE 2004-02-29 4
1968 IS TRUE 2005-06-28 5
1969 SHOW CREATE VIEW v1;
1970 View Create View character_set_client collation_connection
1971 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
1973 WHERE v1.id IN (SELECT id FROM t1_values
1974 WHERE select_id = 111 OR select_id IS NULL) order by id;
1975 IF(my_date, 'IS TRUE', 'IS NOT TRUE') my_date id
1977 IS TRUE 0001-01-01 2
1978 IS TRUE 9999-12-31 3
1979 IS TRUE 2004-02-29 4
1980 IS TRUE 2005-06-28 5
1984 CREATE VIEW v1 AS SELECT IF(my_datetime, 'IS TRUE', 'IS NOT TRUE'),
1985 my_datetime, id FROM t1_values;
1986 SELECT IF(my_datetime, 'IS TRUE', 'IS NOT TRUE'),
1987 my_datetime, id FROM t1_values
1988 WHERE select_id = 110 OR select_id IS NULL order by id;
1989 IF(my_datetime, 'IS TRUE', 'IS NOT TRUE') my_datetime id
1991 IS TRUE 0001-01-01 00:00:00 2
1992 IS TRUE 9999-12-31 23:59:59 3
1993 IS TRUE 2004-02-29 23:59:59 4
1994 IS TRUE 2005-06-28 10:00:00 5
1995 SHOW CREATE VIEW v1;
1996 View Create View character_set_client collation_connection
1997 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
1999 WHERE v1.id IN (SELECT id FROM t1_values
2000 WHERE select_id = 110 OR select_id IS NULL) order by id;
2001 IF(my_datetime, 'IS TRUE', 'IS NOT TRUE') my_datetime id
2003 IS TRUE 0001-01-01 00:00:00 2
2004 IS TRUE 9999-12-31 23:59:59 3
2005 IS TRUE 2004-02-29 23:59:59 4
2006 IS TRUE 2005-06-28 10:00:00 5
2010 CREATE VIEW v1 AS SELECT IF(my_double, 'IS TRUE', 'IS NOT TRUE'),
2011 my_double, id FROM t1_values;
2012 SELECT IF(my_double, 'IS TRUE', 'IS NOT TRUE'),
2013 my_double, id FROM t1_values
2014 WHERE select_id = 109 OR select_id IS NULL order by id;
2015 IF(my_double, 'IS TRUE', 'IS NOT TRUE') my_double id
2017 IS TRUE -1.7976931348623e+308 2
2018 IS TRUE 1.7976931348623e+308 3
2021 SHOW CREATE VIEW v1;
2022 View Create View character_set_client collation_connection
2023 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
2025 WHERE v1.id IN (SELECT id FROM t1_values
2026 WHERE select_id = 109 OR select_id IS NULL) order by id;
2027 IF(my_double, 'IS TRUE', 'IS NOT TRUE') my_double id
2029 IS TRUE -1.7976931348623e+308 2
2030 IS TRUE 1.7976931348623e+308 3
2036 CREATE VIEW v1 AS SELECT IF(my_decimal, 'IS TRUE', 'IS NOT TRUE'),
2037 my_decimal, id FROM t1_values;
2038 SELECT IF(my_decimal, 'IS TRUE', 'IS NOT TRUE'),
2039 my_decimal, id FROM t1_values
2040 WHERE select_id = 108 OR select_id IS NULL order by id;
2041 IF(my_decimal, 'IS TRUE', 'IS NOT TRUE') my_decimal id
2043 IS TRUE -9999999999999999999999999999999999.999999999999999999999999999999 2
2044 IS TRUE 9999999999999999999999999999999999.999999999999999999999999999999 3
2045 IS NOT TRUE 0.000000000000000000000000000000 4
2046 IS TRUE -1.000000000000000000000000000000 5
2047 SHOW CREATE VIEW v1;
2048 View Create View character_set_client collation_connection
2049 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
2051 WHERE v1.id IN (SELECT id FROM t1_values
2052 WHERE select_id = 108 OR select_id IS NULL) order by id;
2053 IF(my_decimal, 'IS TRUE', 'IS NOT TRUE') my_decimal id
2055 IS TRUE -9999999999999999999999999999999999.999999999999999999999999999999 2
2056 IS TRUE 9999999999999999999999999999999999.999999999999999999999999999999 3
2057 IS NOT TRUE 0.000000000000000000000000000000 4
2058 IS TRUE -1.000000000000000000000000000000 5
2062 CREATE VIEW v1 AS SELECT IF(my_bigint, 'IS TRUE', 'IS NOT TRUE'),
2063 my_bigint, id FROM t1_values;
2064 SELECT IF(my_bigint, 'IS TRUE', 'IS NOT TRUE'),
2065 my_bigint, id FROM t1_values
2066 WHERE select_id = 107 OR select_id IS NULL order by id;
2067 IF(my_bigint, 'IS TRUE', 'IS NOT TRUE') my_bigint id
2069 IS TRUE -9223372036854775808 2
2070 IS TRUE 9223372036854775807 3
2073 SHOW CREATE VIEW v1;
2074 View Create View character_set_client collation_connection
2075 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
2077 WHERE v1.id IN (SELECT id FROM t1_values
2078 WHERE select_id = 107 OR select_id IS NULL) order by id;
2079 IF(my_bigint, 'IS TRUE', 'IS NOT TRUE') my_bigint id
2081 IS TRUE -9223372036854775808 2
2082 IS TRUE 9223372036854775807 3
2088 CREATE VIEW v1 AS SELECT IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE'),
2089 my_varbinary_1000, id FROM t1_values;
2090 SELECT IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE'),
2091 my_varbinary_1000, id FROM t1_values
2092 WHERE select_id = 106 OR select_id IS NULL order by id;
2093 IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE') my_varbinary_1000 id
2096 IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2097 IS NOT TRUE ---äÖüß@µ*$-- 4
2099 SHOW CREATE VIEW v1;
2100 View Create View character_set_client collation_connection
2101 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
2103 WHERE v1.id IN (SELECT id FROM t1_values
2104 WHERE select_id = 106 OR select_id IS NULL) order by id;
2105 IF(my_varbinary_1000, 'IS TRUE', 'IS NOT TRUE') my_varbinary_1000 id
2108 IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2109 IS NOT TRUE ---äÖüß@µ*$-- 4
2114 CREATE VIEW v1 AS SELECT IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE'),
2115 my_binary_30, id FROM t1_values;
2116 SELECT IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE'),
2117 my_binary_30, id FROM t1_values
2118 WHERE select_id = 105 OR select_id IS NULL order by id;
2119 IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE') my_binary_30 id
2122 IS NOT TRUE <--------30 characters-------> 3
2123 IS NOT TRUE ---äÖüß@µ*$-- 4
2126 Warning 1292 Truncated incorrect DOUBLE value: ''
2127 Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2128 Warning 1292 Truncated incorrect DOUBLE value: ' ---äÖüß@µ*$-- '
2129 Warning 1292 Truncated incorrect DOUBLE value: '-1'
2130 SHOW CREATE VIEW v1;
2131 View Create View character_set_client collation_connection
2132 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
2134 WHERE v1.id IN (SELECT id FROM t1_values
2135 WHERE select_id = 105 OR select_id IS NULL) order by id;
2136 IF(my_binary_30, 'IS TRUE', 'IS NOT TRUE') my_binary_30 id
2138 IS NOT TRUE
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
2139 IS NOT TRUE <--------30 characters-------> 3
2140 IS NOT TRUE ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
2141 IS TRUE -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
2143 Warning 1292 Truncated incorrect DOUBLE value: ''
2144 Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2145 Warning 1292 Truncated incorrect DOUBLE value: ' ---äÖüß@µ*$-- '
2146 Warning 1292 Truncated incorrect DOUBLE value: '-1'
2150 CREATE VIEW v1 AS SELECT IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE'),
2151 my_varchar_1000, id FROM t1_values;
2152 SELECT IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE'),
2153 my_varchar_1000, id FROM t1_values
2154 WHERE select_id = 104 OR select_id IS NULL order by id;
2155 IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE') my_varchar_1000 id
2158 IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2159 IS NOT TRUE ---äÖüß@µ*$-- 4
2161 SHOW CREATE VIEW v1;
2162 View Create View character_set_client collation_connection
2163 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
2165 WHERE v1.id IN (SELECT id FROM t1_values
2166 WHERE select_id = 104 OR select_id IS NULL) order by id;
2167 IF(my_varchar_1000, 'IS TRUE', 'IS NOT TRUE') my_varchar_1000 id
2170 IS NOT TRUE <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2171 IS NOT TRUE ---äÖüß@µ*$-- 4
2176 CREATE VIEW v1 AS SELECT IF(my_char_30, 'IS TRUE', 'IS NOT TRUE'),
2177 my_char_30, id FROM t1_values;
2178 SELECT IF(my_char_30, 'IS TRUE', 'IS NOT TRUE'),
2179 my_char_30, id FROM t1_values
2180 WHERE select_id = 103 OR select_id IS NULL order by id;
2181 IF(my_char_30, 'IS TRUE', 'IS NOT TRUE') my_char_30 id
2184 IS NOT TRUE <--------30 characters-------> 3
2185 IS NOT TRUE ---äÖüß@µ*$-- 4
2188 Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2189 Warning 1292 Truncated incorrect DOUBLE value: ' ---äÖüß@µ*$-- '
2190 SHOW CREATE VIEW v1;
2191 View Create View character_set_client collation_connection
2192 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
2194 WHERE v1.id IN (SELECT id FROM t1_values
2195 WHERE select_id = 103 OR select_id IS NULL) order by id;
2196 IF(my_char_30, 'IS TRUE', 'IS NOT TRUE') my_char_30 id
2199 IS NOT TRUE <--------30 characters-------> 3
2200 IS NOT TRUE ---äÖüß@µ*$-- 4
2203 Warning 1292 Truncated incorrect DOUBLE value: '<--------30 characters------->'
2204 Warning 1292 Truncated incorrect DOUBLE value: ' ---äÖüß@µ*$-- '
2208 CREATE VIEW v1 AS SELECT CONVERT(my_varbinary_1000 USING koi8r),
2209 my_varbinary_1000, id FROM t1_values;
2210 SELECT CONVERT(my_varbinary_1000 USING koi8r),
2211 my_varbinary_1000, id FROM t1_values
2212 WHERE select_id = 102 OR select_id IS NULL order by id;
2213 CONVERT(my_varbinary_1000 USING koi8r) my_varbinary_1000 id
2216 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2217 ---???????÷@??*$-- ---äÖüß@µ*$-- 4
2219 SHOW CREATE VIEW v1;
2220 View Create View character_set_client collation_connection
2221 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
2223 WHERE v1.id IN (SELECT id FROM t1_values
2224 WHERE select_id = 102 OR select_id IS NULL) order by id;
2225 CONVERT(my_varbinary_1000 USING koi8r) my_varbinary_1000 id
2228 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2229 ---???????÷@??*$-- ---äÖüß@µ*$-- 4
2234 CREATE VIEW v1 AS SELECT CONVERT(my_binary_30 USING koi8r),
2235 my_binary_30, id FROM t1_values;
2236 SELECT CONVERT(my_binary_30 USING koi8r),
2237 my_binary_30, id FROM t1_values
2238 WHERE select_id = 101 OR select_id IS NULL order by id;
2239 CONVERT(my_binary_30 USING koi8r) my_binary_30 id
2242 <--------30 characters-------> <--------30 characters-------> 3
2243 ---???????÷@??*$-- ---äÖüß@µ*$-- 4
2245 SHOW CREATE VIEW v1;
2246 View Create View character_set_client collation_connection
2247 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
2249 WHERE v1.id IN (SELECT id FROM t1_values
2250 WHERE select_id = 101 OR select_id IS NULL) order by id;
2251 CONVERT(my_binary_30 USING koi8r) my_binary_30 id
2253 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
2254 <--------30 characters-------> <--------30 characters-------> 3
2255 ---???????÷@??*$--
\0\0\0\0\0\0\0\0\0\0 ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
2256 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
2260 CREATE VIEW v1 AS SELECT CONVERT(my_varchar_1000 USING koi8r),
2261 my_varchar_1000, id FROM t1_values;
2262 SELECT CONVERT(my_varchar_1000 USING koi8r),
2263 my_varchar_1000, id FROM t1_values
2264 WHERE select_id = 100 OR select_id IS NULL order by id;
2265 CONVERT(my_varchar_1000 USING koi8r) my_varchar_1000 id
2268 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2269 ---????????@??*$-- ---äÖüß@µ*$-- 4
2271 SHOW CREATE VIEW v1;
2272 View Create View character_set_client collation_connection
2273 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
2275 WHERE v1.id IN (SELECT id FROM t1_values
2276 WHERE select_id = 100 OR select_id IS NULL) order by id;
2277 CONVERT(my_varchar_1000 USING koi8r) my_varchar_1000 id
2280 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2281 ---????????@??*$-- ---äÖüß@µ*$-- 4
2286 CREATE VIEW v1 AS SELECT CONVERT(my_char_30 USING koi8r),
2287 my_char_30, id FROM t1_values;
2288 SELECT CONVERT(my_char_30 USING koi8r),
2289 my_char_30, id FROM t1_values
2290 WHERE select_id = 99 OR select_id IS NULL order by id;
2291 CONVERT(my_char_30 USING koi8r) my_char_30 id
2294 <--------30 characters-------> <--------30 characters-------> 3
2295 ---????????@??*$-- ---äÖüß@µ*$-- 4
2297 SHOW CREATE VIEW v1;
2298 View Create View character_set_client collation_connection
2299 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
2301 WHERE v1.id IN (SELECT id FROM t1_values
2302 WHERE select_id = 99 OR select_id IS NULL) order by id;
2303 CONVERT(my_char_30 USING koi8r) my_char_30 id
2306 <--------30 characters-------> <--------30 characters-------> 3
2307 ---????????@??*$-- ---äÖüß@µ*$-- 4
2312 CREATE VIEW v1 AS SELECT CONVERT(my_varbinary_1000 USING utf8),
2313 my_varbinary_1000, id FROM t1_values;
2314 SELECT CONVERT(my_varbinary_1000 USING utf8),
2315 my_varbinary_1000, id FROM t1_values
2316 WHERE select_id = 98 OR select_id IS NULL order by id;
2317 CONVERT(my_varbinary_1000 USING utf8) my_varbinary_1000 id
2320 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2321 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2323 SHOW CREATE VIEW v1;
2324 View Create View character_set_client collation_connection
2325 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
2327 WHERE v1.id IN (SELECT id FROM t1_values
2328 WHERE select_id = 98 OR select_id IS NULL) order by id;
2329 CONVERT(my_varbinary_1000 USING utf8) my_varbinary_1000 id
2332 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2333 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2338 CREATE VIEW v1 AS SELECT CONVERT(my_binary_30 USING utf8),
2339 my_binary_30, id FROM t1_values;
2340 SELECT CONVERT(my_binary_30 USING utf8),
2341 my_binary_30, id FROM t1_values
2342 WHERE select_id = 97 OR select_id IS NULL order by id;
2343 CONVERT(my_binary_30 USING utf8) my_binary_30 id
2346 <--------30 characters-------> <--------30 characters-------> 3
2347 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2349 SHOW CREATE VIEW v1;
2350 View Create View character_set_client collation_connection
2351 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
2353 WHERE v1.id IN (SELECT id FROM t1_values
2354 WHERE select_id = 97 OR select_id IS NULL) order by id;
2355 CONVERT(my_binary_30 USING utf8) my_binary_30 id
2357 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
2358 <--------30 characters-------> <--------30 characters-------> 3
2359 ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
2360 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
2364 CREATE VIEW v1 AS SELECT CONVERT(my_varchar_1000 USING utf8),
2365 my_varchar_1000, id FROM t1_values;
2366 SELECT CONVERT(my_varchar_1000 USING utf8),
2367 my_varchar_1000, id FROM t1_values
2368 WHERE select_id = 96 OR select_id IS NULL order by id;
2369 CONVERT(my_varchar_1000 USING utf8) my_varchar_1000 id
2372 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2373 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2375 SHOW CREATE VIEW v1;
2376 View Create View character_set_client collation_connection
2377 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
2379 WHERE v1.id IN (SELECT id FROM t1_values
2380 WHERE select_id = 96 OR select_id IS NULL) order by id;
2381 CONVERT(my_varchar_1000 USING utf8) my_varchar_1000 id
2384 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2385 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2390 CREATE VIEW v1 AS SELECT CONVERT(my_char_30 USING utf8),
2391 my_char_30, id FROM t1_values;
2392 SELECT CONVERT(my_char_30 USING utf8),
2393 my_char_30, id FROM t1_values
2394 WHERE select_id = 95 OR select_id IS NULL order by id;
2395 CONVERT(my_char_30 USING utf8) my_char_30 id
2398 <--------30 characters-------> <--------30 characters-------> 3
2399 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2401 SHOW CREATE VIEW v1;
2402 View Create View character_set_client collation_connection
2403 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
2405 WHERE v1.id IN (SELECT id FROM t1_values
2406 WHERE select_id = 95 OR select_id IS NULL) order by id;
2407 CONVERT(my_char_30 USING utf8) my_char_30 id
2410 <--------30 characters-------> <--------30 characters-------> 3
2411 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
2416 CREATE VIEW v1 AS SELECT CAST(my_year AS UNSIGNED INTEGER),
2417 my_year, id FROM t1_values;
2418 SELECT CAST(my_year AS UNSIGNED INTEGER),
2419 my_year, id FROM t1_values
2420 WHERE select_id = 94 OR select_id IS NULL order by id;
2421 CAST(my_year AS UNSIGNED INTEGER) my_year id
2427 SHOW CREATE VIEW v1;
2428 View Create View character_set_client collation_connection
2429 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
2431 WHERE v1.id IN (SELECT id FROM t1_values
2432 WHERE select_id = 94 OR select_id IS NULL) order by id;
2433 CAST(my_year AS UNSIGNED INTEGER) my_year id
2442 CREATE VIEW v1 AS SELECT CAST(my_time AS UNSIGNED INTEGER),
2443 my_time, id FROM t1_values;
2444 SELECT CAST(my_time AS UNSIGNED INTEGER),
2445 my_time, id FROM t1_values
2446 WHERE select_id = 93 OR select_id IS NULL order by id;
2447 CAST(my_time AS UNSIGNED INTEGER) my_time id
2449 18446744073701165657 -838:59:59 2
2453 SHOW CREATE VIEW v1;
2454 View Create View character_set_client collation_connection
2455 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
2457 WHERE v1.id IN (SELECT id FROM t1_values
2458 WHERE select_id = 93 OR select_id IS NULL) order by id;
2459 CAST(my_time AS UNSIGNED INTEGER) my_time id
2461 18446744073701165657 -838:59:59 2
2468 CREATE VIEW v1 AS SELECT CAST(my_timestamp AS UNSIGNED INTEGER),
2469 my_timestamp, id FROM t1_values;
2470 SELECT CAST(my_timestamp AS UNSIGNED INTEGER),
2471 my_timestamp, id FROM t1_values
2472 WHERE select_id = 92 OR select_id IS NULL order by id;
2473 CAST(my_timestamp AS UNSIGNED INTEGER) my_timestamp id
2474 0 0000-00-00 00:00:00 1
2475 19700101030001 1970-01-01 03:00:01 2
2476 20380101025959 2038-01-01 02:59:59 3
2477 20040229235959 2004-02-29 23:59:59 4
2478 20050628100000 2005-06-28 10:00:00 5
2479 SHOW CREATE VIEW v1;
2480 View Create View character_set_client collation_connection
2481 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
2483 WHERE v1.id IN (SELECT id FROM t1_values
2484 WHERE select_id = 92 OR select_id IS NULL) order by id;
2485 CAST(my_timestamp AS UNSIGNED INTEGER) my_timestamp id
2486 0 0000-00-00 00:00:00 1
2487 19700101030001 1970-01-01 03:00:01 2
2488 20380101025959 2038-01-01 02:59:59 3
2489 20040229235959 2004-02-29 23:59:59 4
2490 20050628100000 2005-06-28 10:00:00 5
2494 CREATE VIEW v1 AS SELECT CAST(my_date AS UNSIGNED INTEGER),
2495 my_date, id FROM t1_values;
2496 SELECT CAST(my_date AS UNSIGNED INTEGER),
2497 my_date, id FROM t1_values
2498 WHERE select_id = 91 OR select_id IS NULL order by id;
2499 CAST(my_date AS UNSIGNED INTEGER) my_date id
2502 99991231 9999-12-31 3
2503 20040229 2004-02-29 4
2504 20050628 2005-06-28 5
2505 SHOW CREATE VIEW v1;
2506 View Create View character_set_client collation_connection
2507 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
2509 WHERE v1.id IN (SELECT id FROM t1_values
2510 WHERE select_id = 91 OR select_id IS NULL) order by id;
2511 CAST(my_date AS UNSIGNED INTEGER) my_date id
2514 99991231 9999-12-31 3
2515 20040229 2004-02-29 4
2516 20050628 2005-06-28 5
2520 CREATE VIEW v1 AS SELECT CAST(my_datetime AS UNSIGNED INTEGER),
2521 my_datetime, id FROM t1_values;
2522 SELECT CAST(my_datetime AS UNSIGNED INTEGER),
2523 my_datetime, id FROM t1_values
2524 WHERE select_id = 90 OR select_id IS NULL order by id;
2525 CAST(my_datetime AS UNSIGNED INTEGER) my_datetime id
2527 10101000000 0001-01-01 00:00:00 2
2528 99991231235959 9999-12-31 23:59:59 3
2529 20040229235959 2004-02-29 23:59:59 4
2530 20050628100000 2005-06-28 10:00:00 5
2531 SHOW CREATE VIEW v1;
2532 View Create View character_set_client collation_connection
2533 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
2535 WHERE v1.id IN (SELECT id FROM t1_values
2536 WHERE select_id = 90 OR select_id IS NULL) order by id;
2537 CAST(my_datetime AS UNSIGNED INTEGER) my_datetime id
2539 10101000000 0001-01-01 00:00:00 2
2540 99991231235959 9999-12-31 23:59:59 3
2541 20040229235959 2004-02-29 23:59:59 4
2542 20050628100000 2005-06-28 10:00:00 5
2546 CREATE VIEW v1 AS SELECT CAST(my_double AS UNSIGNED INTEGER),
2547 my_double, id FROM t1_values;
2548 SELECT CAST(my_double AS UNSIGNED INTEGER),
2549 my_double, id FROM t1_values
2550 WHERE select_id = 89 OR select_id IS NULL order by id;
2551 CAST(my_double AS UNSIGNED INTEGER) my_double id
2553 9223372036854775808 -1.7976931348623e+308 2
2554 9223372036854775807 1.7976931348623e+308 3
2556 18446744073709551615 -1 5
2558 Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e+308'
2559 Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e+308'
2560 SHOW CREATE VIEW v1;
2561 View Create View character_set_client collation_connection
2562 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
2564 WHERE v1.id IN (SELECT id FROM t1_values
2565 WHERE select_id = 89 OR select_id IS NULL) order by id;
2566 CAST(my_double AS UNSIGNED INTEGER) my_double id
2568 9223372036854775808 -1.7976931348623e+308 2
2569 9223372036854775807 1.7976931348623e+308 3
2571 18446744073709551615 -1 5
2573 Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e+308'
2574 Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e+308'
2578 CREATE VIEW v1 AS SELECT CAST(my_decimal AS UNSIGNED INTEGER),
2579 my_decimal, id FROM t1_values;
2580 SELECT CAST(my_decimal AS UNSIGNED INTEGER),
2581 my_decimal, id FROM t1_values
2582 WHERE select_id = 88 OR select_id IS NULL order by id;
2583 CAST(my_decimal AS UNSIGNED INTEGER) my_decimal id
2585 0 -9999999999999999999999999999999999.999999999999999999999999999999 2
2586 18446744073709551615 9999999999999999999999999999999999.999999999999999999999999999999 3
2587 0 0.000000000000000000000000000000 4
2588 0 -1.000000000000000000000000000000 5
2590 Error 1292 Truncated incorrect DECIMAL value: ''
2591 Error 1292 Truncated incorrect DECIMAL value: ''
2592 Error 1292 Truncated incorrect DECIMAL value: ''
2593 SHOW CREATE VIEW v1;
2594 View Create View character_set_client collation_connection
2595 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
2597 WHERE v1.id IN (SELECT id FROM t1_values
2598 WHERE select_id = 88 OR select_id IS NULL) order by id;
2599 CAST(my_decimal AS UNSIGNED INTEGER) my_decimal id
2601 0 -9999999999999999999999999999999999.999999999999999999999999999999 2
2602 18446744073709551615 9999999999999999999999999999999999.999999999999999999999999999999 3
2603 0 0.000000000000000000000000000000 4
2604 0 -1.000000000000000000000000000000 5
2606 Error 1292 Truncated incorrect DECIMAL value: ''
2607 Error 1292 Truncated incorrect DECIMAL value: ''
2608 Error 1292 Truncated incorrect DECIMAL value: ''
2612 CREATE VIEW v1 AS SELECT CAST(my_bigint AS UNSIGNED INTEGER),
2613 my_bigint, id FROM t1_values;
2614 SELECT CAST(my_bigint AS UNSIGNED INTEGER),
2615 my_bigint, id FROM t1_values
2616 WHERE select_id = 87 OR select_id IS NULL order by id;
2617 CAST(my_bigint AS UNSIGNED INTEGER) my_bigint id
2619 9223372036854775808 -9223372036854775808 2
2620 9223372036854775807 9223372036854775807 3
2622 18446744073709551615 -1 5
2623 SHOW CREATE VIEW v1;
2624 View Create View character_set_client collation_connection
2625 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
2627 WHERE v1.id IN (SELECT id FROM t1_values
2628 WHERE select_id = 87 OR select_id IS NULL) order by id;
2629 CAST(my_bigint AS UNSIGNED INTEGER) my_bigint id
2631 9223372036854775808 -9223372036854775808 2
2632 9223372036854775807 9223372036854775807 3
2634 18446744073709551615 -1 5
2638 CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS UNSIGNED INTEGER),
2639 my_varbinary_1000, id FROM t1_values;
2640 SELECT CAST(my_varbinary_1000 AS UNSIGNED INTEGER),
2641 my_varbinary_1000, id FROM t1_values
2642 WHERE select_id = 86 OR select_id IS NULL order by id;
2643 CAST(my_varbinary_1000 AS UNSIGNED INTEGER) my_varbinary_1000 id
2646 0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2648 18446744073709551615 -1 5
2650 Warning 1292 Truncated incorrect INTEGER value: ''
2651 Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2652 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
2653 Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2654 SHOW CREATE VIEW v1;
2655 View Create View character_set_client collation_connection
2656 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
2658 WHERE v1.id IN (SELECT id FROM t1_values
2659 WHERE select_id = 86 OR select_id IS NULL) order by id;
2660 CAST(my_varbinary_1000 AS UNSIGNED INTEGER) my_varbinary_1000 id
2663 0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2665 18446744073709551615 -1 5
2667 Warning 1292 Truncated incorrect INTEGER value: ''
2668 Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2669 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
2670 Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2674 CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS UNSIGNED INTEGER),
2675 my_binary_30, id FROM t1_values;
2676 SELECT CAST(my_binary_30 AS UNSIGNED INTEGER),
2677 my_binary_30, id FROM t1_values
2678 WHERE select_id = 85 OR select_id IS NULL order by id;
2679 CAST(my_binary_30 AS UNSIGNED INTEGER) my_binary_30 id
2682 0 <--------30 characters-------> 3
2684 18446744073709551615 -1 5
2686 Warning 1292 Truncated incorrect INTEGER value: ''
2687 Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2688 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
2689 Warning 1292 Truncated incorrect INTEGER value: '-1'
2690 Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2691 SHOW CREATE VIEW v1;
2692 View Create View character_set_client collation_connection
2693 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
2695 WHERE v1.id IN (SELECT id FROM t1_values
2696 WHERE select_id = 85 OR select_id IS NULL) order by id;
2697 CAST(my_binary_30 AS UNSIGNED INTEGER) my_binary_30 id
2699 0
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
2700 0 <--------30 characters-------> 3
2701 0 ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
2702 18446744073709551615 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
2704 Warning 1292 Truncated incorrect INTEGER value: ''
2705 Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2706 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
2707 Warning 1292 Truncated incorrect INTEGER value: '-1'
2708 Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2712 CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS UNSIGNED INTEGER),
2713 my_varchar_1000, id FROM t1_values;
2714 SELECT CAST(my_varchar_1000 AS UNSIGNED INTEGER),
2715 my_varchar_1000, id FROM t1_values
2716 WHERE select_id = 84 OR select_id IS NULL order by id;
2717 CAST(my_varchar_1000 AS UNSIGNED INTEGER) my_varchar_1000 id
2720 0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2722 18446744073709551615 -1 5
2724 Warning 1292 Truncated incorrect INTEGER value: ''
2725 Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2726 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
2727 Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2728 SHOW CREATE VIEW v1;
2729 View Create View character_set_client collation_connection
2730 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
2732 WHERE v1.id IN (SELECT id FROM t1_values
2733 WHERE select_id = 84 OR select_id IS NULL) order by id;
2734 CAST(my_varchar_1000 AS UNSIGNED INTEGER) my_varchar_1000 id
2737 0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
2739 18446744073709551615 -1 5
2741 Warning 1292 Truncated incorrect INTEGER value: ''
2742 Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
2743 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
2744 Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2748 CREATE VIEW v1 AS SELECT CAST(my_char_30 AS UNSIGNED INTEGER),
2749 my_char_30, id FROM t1_values;
2750 SELECT CAST(my_char_30 AS UNSIGNED INTEGER),
2751 my_char_30, id FROM t1_values
2752 WHERE select_id = 83 OR select_id IS NULL order by id;
2753 CAST(my_char_30 AS UNSIGNED INTEGER) my_char_30 id
2756 0 <--------30 characters-------> 3
2758 18446744073709551615 -1 5
2760 Warning 1292 Truncated incorrect INTEGER value: ''
2761 Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2762 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$--'
2763 Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2764 SHOW CREATE VIEW v1;
2765 View Create View character_set_client collation_connection
2766 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
2768 WHERE v1.id IN (SELECT id FROM t1_values
2769 WHERE select_id = 83 OR select_id IS NULL) order by id;
2770 CAST(my_char_30 AS UNSIGNED INTEGER) my_char_30 id
2773 0 <--------30 characters-------> 3
2775 18446744073709551615 -1 5
2777 Warning 1292 Truncated incorrect INTEGER value: ''
2778 Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
2779 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$--'
2780 Warning 1105 Cast to unsigned converted negative integer to it's positive complement
2784 CREATE VIEW v1 AS SELECT CAST(my_year AS SIGNED INTEGER),
2785 my_year, id FROM t1_values;
2786 SELECT CAST(my_year AS SIGNED INTEGER),
2787 my_year, id FROM t1_values
2788 WHERE select_id = 82 OR select_id IS NULL order by id;
2789 CAST(my_year AS SIGNED INTEGER) my_year id
2795 SHOW CREATE VIEW v1;
2796 View Create View character_set_client collation_connection
2797 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
2799 WHERE v1.id IN (SELECT id FROM t1_values
2800 WHERE select_id = 82 OR select_id IS NULL) order by id;
2801 CAST(my_year AS SIGNED INTEGER) my_year id
2810 CREATE VIEW v1 AS SELECT CAST(my_time AS SIGNED INTEGER),
2811 my_time, id FROM t1_values;
2812 SELECT CAST(my_time AS SIGNED INTEGER),
2813 my_time, id FROM t1_values
2814 WHERE select_id = 81 OR select_id IS NULL order by id;
2815 CAST(my_time AS SIGNED INTEGER) my_time id
2817 -8385959 -838:59:59 2
2821 SHOW CREATE VIEW v1;
2822 View Create View character_set_client collation_connection
2823 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
2825 WHERE v1.id IN (SELECT id FROM t1_values
2826 WHERE select_id = 81 OR select_id IS NULL) order by id;
2827 CAST(my_time AS SIGNED INTEGER) my_time id
2829 -8385959 -838:59:59 2
2836 CREATE VIEW v1 AS SELECT CAST(my_timestamp AS SIGNED INTEGER),
2837 my_timestamp, id FROM t1_values;
2838 SELECT CAST(my_timestamp AS SIGNED INTEGER),
2839 my_timestamp, id FROM t1_values
2840 WHERE select_id = 80 OR select_id IS NULL order by id;
2841 CAST(my_timestamp AS SIGNED INTEGER) my_timestamp id
2842 0 0000-00-00 00:00:00 1
2843 19700101030001 1970-01-01 03:00:01 2
2844 20380101025959 2038-01-01 02:59:59 3
2845 20040229235959 2004-02-29 23:59:59 4
2846 20050628100000 2005-06-28 10:00:00 5
2847 SHOW CREATE VIEW v1;
2848 View Create View character_set_client collation_connection
2849 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
2851 WHERE v1.id IN (SELECT id FROM t1_values
2852 WHERE select_id = 80 OR select_id IS NULL) order by id;
2853 CAST(my_timestamp AS SIGNED INTEGER) my_timestamp id
2854 0 0000-00-00 00:00:00 1
2855 19700101030001 1970-01-01 03:00:01 2
2856 20380101025959 2038-01-01 02:59:59 3
2857 20040229235959 2004-02-29 23:59:59 4
2858 20050628100000 2005-06-28 10:00:00 5
2862 CREATE VIEW v1 AS SELECT CAST(my_date AS SIGNED INTEGER),
2863 my_date, id FROM t1_values;
2864 SELECT CAST(my_date AS SIGNED INTEGER),
2865 my_date, id FROM t1_values
2866 WHERE select_id = 79 OR select_id IS NULL order by id;
2867 CAST(my_date AS SIGNED INTEGER) my_date id
2870 99991231 9999-12-31 3
2871 20040229 2004-02-29 4
2872 20050628 2005-06-28 5
2873 SHOW CREATE VIEW v1;
2874 View Create View character_set_client collation_connection
2875 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
2877 WHERE v1.id IN (SELECT id FROM t1_values
2878 WHERE select_id = 79 OR select_id IS NULL) order by id;
2879 CAST(my_date AS SIGNED INTEGER) my_date id
2882 99991231 9999-12-31 3
2883 20040229 2004-02-29 4
2884 20050628 2005-06-28 5
2888 CREATE VIEW v1 AS SELECT CAST(my_datetime AS SIGNED INTEGER),
2889 my_datetime, id FROM t1_values;
2890 SELECT CAST(my_datetime AS SIGNED INTEGER),
2891 my_datetime, id FROM t1_values
2892 WHERE select_id = 78 OR select_id IS NULL order by id;
2893 CAST(my_datetime AS SIGNED INTEGER) my_datetime id
2895 10101000000 0001-01-01 00:00:00 2
2896 99991231235959 9999-12-31 23:59:59 3
2897 20040229235959 2004-02-29 23:59:59 4
2898 20050628100000 2005-06-28 10:00:00 5
2899 SHOW CREATE VIEW v1;
2900 View Create View character_set_client collation_connection
2901 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
2903 WHERE v1.id IN (SELECT id FROM t1_values
2904 WHERE select_id = 78 OR select_id IS NULL) order by id;
2905 CAST(my_datetime AS SIGNED INTEGER) my_datetime id
2907 10101000000 0001-01-01 00:00:00 2
2908 99991231235959 9999-12-31 23:59:59 3
2909 20040229235959 2004-02-29 23:59:59 4
2910 20050628100000 2005-06-28 10:00:00 5
2914 CREATE VIEW v1 AS SELECT CAST(my_double AS SIGNED INTEGER),
2915 my_double, id FROM t1_values;
2916 SELECT CAST(my_double AS SIGNED INTEGER),
2917 my_double, id FROM t1_values
2918 WHERE select_id = 77 OR select_id IS NULL order by id;
2919 CAST(my_double AS SIGNED INTEGER) my_double id
2921 -9223372036854775808 -1.7976931348623e+308 2
2922 9223372036854775807 1.7976931348623e+308 3
2926 Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e+308'
2927 Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e+308'
2928 SHOW CREATE VIEW v1;
2929 View Create View character_set_client collation_connection
2930 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
2932 WHERE v1.id IN (SELECT id FROM t1_values
2933 WHERE select_id = 77 OR select_id IS NULL) order by id;
2934 CAST(my_double AS SIGNED INTEGER) my_double id
2936 -9223372036854775808 -1.7976931348623e+308 2
2937 9223372036854775807 1.7976931348623e+308 3
2941 Warning 1292 Truncated incorrect INTEGER value: '-1.7976931348623e+308'
2942 Warning 1292 Truncated incorrect INTEGER value: '1.7976931348623e+308'
2946 CREATE VIEW v1 AS SELECT CAST(my_decimal AS SIGNED INTEGER),
2947 my_decimal, id FROM t1_values;
2948 SELECT CAST(my_decimal AS SIGNED INTEGER),
2949 my_decimal, id FROM t1_values
2950 WHERE select_id = 76 OR select_id IS NULL order by id;
2951 CAST(my_decimal AS SIGNED INTEGER) my_decimal id
2953 -9223372036854775808 -9999999999999999999999999999999999.999999999999999999999999999999 2
2954 9223372036854775807 9999999999999999999999999999999999.999999999999999999999999999999 3
2955 0 0.000000000000000000000000000000 4
2956 -1 -1.000000000000000000000000000000 5
2958 Error 1292 Truncated incorrect DECIMAL value: ''
2959 Error 1292 Truncated incorrect DECIMAL value: ''
2960 SHOW CREATE VIEW v1;
2961 View Create View character_set_client collation_connection
2962 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
2964 WHERE v1.id IN (SELECT id FROM t1_values
2965 WHERE select_id = 76 OR select_id IS NULL) order by id;
2966 CAST(my_decimal AS SIGNED INTEGER) my_decimal id
2968 -9223372036854775808 -9999999999999999999999999999999999.999999999999999999999999999999 2
2969 9223372036854775807 9999999999999999999999999999999999.999999999999999999999999999999 3
2970 0 0.000000000000000000000000000000 4
2971 -1 -1.000000000000000000000000000000 5
2973 Error 1292 Truncated incorrect DECIMAL value: ''
2974 Error 1292 Truncated incorrect DECIMAL value: ''
2978 CREATE VIEW v1 AS SELECT CAST(my_bigint AS SIGNED INTEGER),
2979 my_bigint, id FROM t1_values;
2980 SELECT CAST(my_bigint AS SIGNED INTEGER),
2981 my_bigint, id FROM t1_values
2982 WHERE select_id = 75 OR select_id IS NULL order by id;
2983 CAST(my_bigint AS SIGNED INTEGER) my_bigint id
2985 -9223372036854775808 -9223372036854775808 2
2986 9223372036854775807 9223372036854775807 3
2989 SHOW CREATE VIEW v1;
2990 View Create View character_set_client collation_connection
2991 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
2993 WHERE v1.id IN (SELECT id FROM t1_values
2994 WHERE select_id = 75 OR select_id IS NULL) order by id;
2995 CAST(my_bigint AS SIGNED INTEGER) my_bigint id
2997 -9223372036854775808 -9223372036854775808 2
2998 9223372036854775807 9223372036854775807 3
3004 CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS SIGNED INTEGER),
3005 my_varbinary_1000, id FROM t1_values;
3006 SELECT CAST(my_varbinary_1000 AS SIGNED INTEGER),
3007 my_varbinary_1000, id FROM t1_values
3008 WHERE select_id = 74 OR select_id IS NULL order by id;
3009 CAST(my_varbinary_1000 AS SIGNED INTEGER) my_varbinary_1000 id
3012 0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3016 Warning 1292 Truncated incorrect INTEGER value: ''
3017 Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3018 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
3019 SHOW CREATE VIEW v1;
3020 View Create View character_set_client collation_connection
3021 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
3023 WHERE v1.id IN (SELECT id FROM t1_values
3024 WHERE select_id = 74 OR select_id IS NULL) order by id;
3025 CAST(my_varbinary_1000 AS SIGNED INTEGER) my_varbinary_1000 id
3028 0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3032 Warning 1292 Truncated incorrect INTEGER value: ''
3033 Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3034 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
3038 CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS SIGNED INTEGER),
3039 my_binary_30, id FROM t1_values;
3040 SELECT CAST(my_binary_30 AS SIGNED INTEGER),
3041 my_binary_30, id FROM t1_values
3042 WHERE select_id = 73 OR select_id IS NULL order by id;
3043 CAST(my_binary_30 AS SIGNED INTEGER) my_binary_30 id
3046 0 <--------30 characters-------> 3
3050 Warning 1292 Truncated incorrect INTEGER value: ''
3051 Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3052 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
3053 Warning 1292 Truncated incorrect INTEGER value: '-1'
3054 SHOW CREATE VIEW v1;
3055 View Create View character_set_client collation_connection
3056 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
3058 WHERE v1.id IN (SELECT id FROM t1_values
3059 WHERE select_id = 73 OR select_id IS NULL) order by id;
3060 CAST(my_binary_30 AS SIGNED INTEGER) my_binary_30 id
3062 0
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
3063 0 <--------30 characters-------> 3
3064 0 ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
3065 -1 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
3067 Warning 1292 Truncated incorrect INTEGER value: ''
3068 Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3069 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
3070 Warning 1292 Truncated incorrect INTEGER value: '-1'
3074 CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS SIGNED INTEGER),
3075 my_varchar_1000, id FROM t1_values;
3076 SELECT CAST(my_varchar_1000 AS SIGNED INTEGER),
3077 my_varchar_1000, id FROM t1_values
3078 WHERE select_id = 72 OR select_id IS NULL order by id;
3079 CAST(my_varchar_1000 AS SIGNED INTEGER) my_varchar_1000 id
3082 0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3086 Warning 1292 Truncated incorrect INTEGER value: ''
3087 Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3088 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
3089 SHOW CREATE VIEW v1;
3090 View Create View character_set_client collation_connection
3091 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
3093 WHERE v1.id IN (SELECT id FROM t1_values
3094 WHERE select_id = 72 OR select_id IS NULL) order by id;
3095 CAST(my_varchar_1000 AS SIGNED INTEGER) my_varchar_1000 id
3098 0 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3102 Warning 1292 Truncated incorrect INTEGER value: ''
3103 Warning 1292 Truncated incorrect INTEGER value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3104 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$-- '
3108 CREATE VIEW v1 AS SELECT CAST(my_char_30 AS SIGNED INTEGER),
3109 my_char_30, id FROM t1_values;
3110 SELECT CAST(my_char_30 AS SIGNED INTEGER),
3111 my_char_30, id FROM t1_values
3112 WHERE select_id = 71 OR select_id IS NULL order by id;
3113 CAST(my_char_30 AS SIGNED INTEGER) my_char_30 id
3116 0 <--------30 characters-------> 3
3120 Warning 1292 Truncated incorrect INTEGER value: ''
3121 Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3122 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$--'
3123 SHOW CREATE VIEW v1;
3124 View Create View character_set_client collation_connection
3125 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
3127 WHERE v1.id IN (SELECT id FROM t1_values
3128 WHERE select_id = 71 OR select_id IS NULL) order by id;
3129 CAST(my_char_30 AS SIGNED INTEGER) my_char_30 id
3132 0 <--------30 characters-------> 3
3136 Warning 1292 Truncated incorrect INTEGER value: ''
3137 Warning 1292 Truncated incorrect INTEGER value: '<--------30 characters------->'
3138 Warning 1292 Truncated incorrect INTEGER value: ' ---äÖüß@µ*$--'
3142 CREATE VIEW v1 AS SELECT CAST(my_year AS DECIMAL(37,2)),
3143 my_year, id FROM t1_values;
3144 SELECT CAST(my_year AS DECIMAL(37,2)),
3145 my_year, id FROM t1_values
3146 WHERE select_id = 70 OR select_id IS NULL order by id;
3147 CAST(my_year AS DECIMAL(37,2)) my_year id
3153 SHOW CREATE VIEW v1;
3154 View Create View character_set_client collation_connection
3155 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
3157 WHERE v1.id IN (SELECT id FROM t1_values
3158 WHERE select_id = 70 OR select_id IS NULL) order by id;
3159 CAST(my_year AS DECIMAL(37,2)) my_year id
3168 CREATE VIEW v1 AS SELECT CAST(my_time AS DECIMAL(37,2)),
3169 my_time, id FROM t1_values;
3170 SELECT CAST(my_time AS DECIMAL(37,2)),
3171 my_time, id FROM t1_values
3172 WHERE select_id = 69 OR select_id IS NULL order by id;
3173 CAST(my_time AS DECIMAL(37,2)) my_time id
3175 -8385959.00 -838:59:59 2
3176 8385959.00 838:59:59 3
3177 130000.00 13:00:00 4
3178 100000.00 10:00:00 5
3179 SHOW CREATE VIEW v1;
3180 View Create View character_set_client collation_connection
3181 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
3183 WHERE v1.id IN (SELECT id FROM t1_values
3184 WHERE select_id = 69 OR select_id IS NULL) order by id;
3185 CAST(my_time AS DECIMAL(37,2)) my_time id
3187 -8385959.00 -838:59:59 2
3188 8385959.00 838:59:59 3
3189 130000.00 13:00:00 4
3190 100000.00 10:00:00 5
3194 CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DECIMAL(37,2)),
3195 my_timestamp, id FROM t1_values;
3196 SELECT CAST(my_timestamp AS DECIMAL(37,2)),
3197 my_timestamp, id FROM t1_values
3198 WHERE select_id = 68 OR select_id IS NULL order by id;
3199 CAST(my_timestamp AS DECIMAL(37,2)) my_timestamp id
3200 0.00 0000-00-00 00:00:00 1
3201 19700101030001.00 1970-01-01 03:00:01 2
3202 20380101025959.00 2038-01-01 02:59:59 3
3203 20040229235959.00 2004-02-29 23:59:59 4
3204 20050628100000.00 2005-06-28 10:00:00 5
3205 SHOW CREATE VIEW v1;
3206 View Create View character_set_client collation_connection
3207 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
3209 WHERE v1.id IN (SELECT id FROM t1_values
3210 WHERE select_id = 68 OR select_id IS NULL) order by id;
3211 CAST(my_timestamp AS DECIMAL(37,2)) my_timestamp id
3212 0.00 0000-00-00 00:00:00 1
3213 19700101030001.00 1970-01-01 03:00:01 2
3214 20380101025959.00 2038-01-01 02:59:59 3
3215 20040229235959.00 2004-02-29 23:59:59 4
3216 20050628100000.00 2005-06-28 10:00:00 5
3220 CREATE VIEW v1 AS SELECT CAST(my_date AS DECIMAL(37,2)),
3221 my_date, id FROM t1_values;
3222 SELECT CAST(my_date AS DECIMAL(37,2)),
3223 my_date, id FROM t1_values
3224 WHERE select_id = 67 OR select_id IS NULL order by id;
3225 CAST(my_date AS DECIMAL(37,2)) my_date id
3227 10101.00 0001-01-01 2
3228 99991231.00 9999-12-31 3
3229 20040229.00 2004-02-29 4
3230 20050628.00 2005-06-28 5
3231 SHOW CREATE VIEW v1;
3232 View Create View character_set_client collation_connection
3233 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
3235 WHERE v1.id IN (SELECT id FROM t1_values
3236 WHERE select_id = 67 OR select_id IS NULL) order by id;
3237 CAST(my_date AS DECIMAL(37,2)) my_date id
3239 10101.00 0001-01-01 2
3240 99991231.00 9999-12-31 3
3241 20040229.00 2004-02-29 4
3242 20050628.00 2005-06-28 5
3246 CREATE VIEW v1 AS SELECT CAST(my_datetime AS DECIMAL(37,2)),
3247 my_datetime, id FROM t1_values;
3248 SELECT CAST(my_datetime AS DECIMAL(37,2)),
3249 my_datetime, id FROM t1_values
3250 WHERE select_id = 66 OR select_id IS NULL order by id;
3251 CAST(my_datetime AS DECIMAL(37,2)) my_datetime id
3253 10101000000.00 0001-01-01 00:00:00 2
3254 99991231235959.00 9999-12-31 23:59:59 3
3255 20040229235959.00 2004-02-29 23:59:59 4
3256 20050628100000.00 2005-06-28 10:00:00 5
3257 SHOW CREATE VIEW v1;
3258 View Create View character_set_client collation_connection
3259 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
3261 WHERE v1.id IN (SELECT id FROM t1_values
3262 WHERE select_id = 66 OR select_id IS NULL) order by id;
3263 CAST(my_datetime AS DECIMAL(37,2)) my_datetime id
3265 10101000000.00 0001-01-01 00:00:00 2
3266 99991231235959.00 9999-12-31 23:59:59 3
3267 20040229235959.00 2004-02-29 23:59:59 4
3268 20050628100000.00 2005-06-28 10:00:00 5
3272 CREATE VIEW v1 AS SELECT CAST(my_double AS DECIMAL(37,2)),
3273 my_double, id FROM t1_values;
3274 SELECT CAST(my_double AS DECIMAL(37,2)),
3275 my_double, id FROM t1_values
3276 WHERE select_id = 65 OR select_id IS NULL order by id;
3277 CAST(my_double AS DECIMAL(37,2)) my_double id
3279 -99999999999999999999999999999999999.99 -1.7976931348623e+308 2
3280 99999999999999999999999999999999999.99 1.7976931348623e+308 3
3283 -3333.33 -3333.3333 30
3285 Error 1292 Truncated incorrect DECIMAL value: ''
3286 Error 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3287 Error 1292 Truncated incorrect DECIMAL value: ''
3288 Error 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3289 SHOW CREATE VIEW v1;
3290 View Create View character_set_client collation_connection
3291 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
3293 WHERE v1.id IN (SELECT id FROM t1_values
3294 WHERE select_id = 65 OR select_id IS NULL) order by id;
3295 CAST(my_double AS DECIMAL(37,2)) my_double id
3297 -99999999999999999999999999999999999.99 -1.7976931348623e+308 2
3298 99999999999999999999999999999999999.99 1.7976931348623e+308 3
3301 -3333.33 -3333.3333 30
3303 Error 1292 Truncated incorrect DECIMAL value: ''
3304 Error 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3305 Error 1292 Truncated incorrect DECIMAL value: ''
3306 Error 1264 Out of range value for column 'CAST(my_double AS DECIMAL(37,2))' at row 1
3310 CREATE VIEW v1 AS SELECT CAST(my_decimal AS DECIMAL(37,2)),
3311 my_decimal, id FROM t1_values;
3312 SELECT CAST(my_decimal AS DECIMAL(37,2)),
3313 my_decimal, id FROM t1_values
3314 WHERE select_id = 64 OR select_id IS NULL order by id;
3315 CAST(my_decimal AS DECIMAL(37,2)) my_decimal id
3317 -10000000000000000000000000000000000.00 -9999999999999999999999999999999999.999999999999999999999999999999 2
3318 10000000000000000000000000000000000.00 9999999999999999999999999999999999.999999999999999999999999999999 3
3319 0.00 0.000000000000000000000000000000 4
3320 -1.00 -1.000000000000000000000000000000 5
3321 SHOW CREATE VIEW v1;
3322 View Create View character_set_client collation_connection
3323 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
3325 WHERE v1.id IN (SELECT id FROM t1_values
3326 WHERE select_id = 64 OR select_id IS NULL) order by id;
3327 CAST(my_decimal AS DECIMAL(37,2)) my_decimal id
3329 -10000000000000000000000000000000000.00 -9999999999999999999999999999999999.999999999999999999999999999999 2
3330 10000000000000000000000000000000000.00 9999999999999999999999999999999999.999999999999999999999999999999 3
3331 0.00 0.000000000000000000000000000000 4
3332 -1.00 -1.000000000000000000000000000000 5
3336 CREATE VIEW v1 AS SELECT CAST(my_bigint AS DECIMAL(37,2)),
3337 my_bigint, id FROM t1_values;
3338 SELECT CAST(my_bigint AS DECIMAL(37,2)),
3339 my_bigint, id FROM t1_values
3340 WHERE select_id = 63 OR select_id IS NULL order by id;
3341 CAST(my_bigint AS DECIMAL(37,2)) my_bigint id
3343 -9223372036854775808.00 -9223372036854775808 2
3344 9223372036854775807.00 9223372036854775807 3
3347 SHOW CREATE VIEW v1;
3348 View Create View character_set_client collation_connection
3349 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
3351 WHERE v1.id IN (SELECT id FROM t1_values
3352 WHERE select_id = 63 OR select_id IS NULL) order by id;
3353 CAST(my_bigint AS DECIMAL(37,2)) my_bigint id
3355 -9223372036854775808.00 -9223372036854775808 2
3356 9223372036854775807.00 9223372036854775807 3
3362 CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DECIMAL(37,2)),
3363 my_varbinary_1000, id FROM t1_values;
3364 SELECT CAST(my_varbinary_1000 AS DECIMAL(37,2)),
3365 my_varbinary_1000, id FROM t1_values
3366 WHERE select_id = 62 OR select_id IS NULL order by id;
3367 CAST(my_varbinary_1000 AS DECIMAL(37,2)) my_varbinary_1000 id
3370 0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3371 0.00 ---äÖüß@µ*$-- 4
3373 -3333.33 -3333.3333 29
3375 Error 1366 Incorrect decimal value: '' for column '' at row -1
3376 Error 1366 Incorrect decimal value: '' for column '' at row -1
3377 Error 1366 Incorrect decimal value: '' for column '' at row -1
3378 SHOW CREATE VIEW v1;
3379 View Create View character_set_client collation_connection
3380 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
3382 WHERE v1.id IN (SELECT id FROM t1_values
3383 WHERE select_id = 62 OR select_id IS NULL) order by id;
3384 CAST(my_varbinary_1000 AS DECIMAL(37,2)) my_varbinary_1000 id
3387 0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3388 0.00 ---äÖüß@µ*$-- 4
3390 -3333.33 -3333.3333 29
3392 Error 1366 Incorrect decimal value: '' for column '' at row -1
3393 Error 1366 Incorrect decimal value: '' for column '' at row -1
3394 Error 1366 Incorrect decimal value: '' for column '' at row -1
3398 CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DECIMAL(37,2)),
3399 my_binary_30, id FROM t1_values;
3400 SELECT CAST(my_binary_30 AS DECIMAL(37,2)),
3401 my_binary_30, id FROM t1_values
3402 WHERE select_id = 61 OR select_id IS NULL order by id;
3403 CAST(my_binary_30 AS DECIMAL(37,2)) my_binary_30 id
3406 0.00 <--------30 characters-------> 3
3407 0.00 ---äÖüß@µ*$-- 4
3409 -3333.33 -3333.3333 28
3411 Error 1366 Incorrect decimal value: '' for column '' at row -1
3412 Warning 1292 Truncated incorrect DECIMAL value: ''
3413 Error 1366 Incorrect decimal value: '' for column '' at row -1
3414 Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3415 Error 1366 Incorrect decimal value: '' for column '' at row -1
3416 Warning 1292 Truncated incorrect DECIMAL value: ' ---äÖüß@µ*$-- '
3417 Warning 1292 Truncated incorrect DECIMAL value: '-1'
3418 Warning 1292 Truncated incorrect DECIMAL value: '-3333.3333'
3419 SHOW CREATE VIEW v1;
3420 View Create View character_set_client collation_connection
3421 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
3423 WHERE v1.id IN (SELECT id FROM t1_values
3424 WHERE select_id = 61 OR select_id IS NULL) order by id;
3425 CAST(my_binary_30 AS DECIMAL(37,2)) my_binary_30 id
3427 0.00
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
3428 0.00 <--------30 characters-------> 3
3429 0.00 ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
3430 -1.00 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
3431 -3333.33 -3333.3333
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 28
3433 Error 1366 Incorrect decimal value: '' for column '' at row -1
3434 Warning 1292 Truncated incorrect DECIMAL value: ''
3435 Error 1366 Incorrect decimal value: '' for column '' at row -1
3436 Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3437 Error 1366 Incorrect decimal value: '' for column '' at row -1
3438 Warning 1292 Truncated incorrect DECIMAL value: ' ---äÖüß@µ*$-- '
3439 Warning 1292 Truncated incorrect DECIMAL value: '-1'
3440 Warning 1292 Truncated incorrect DECIMAL value: '-3333.3333'
3444 CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DECIMAL(37,2)),
3445 my_varchar_1000, id FROM t1_values;
3446 SELECT CAST(my_varchar_1000 AS DECIMAL(37,2)),
3447 my_varchar_1000, id FROM t1_values
3448 WHERE select_id = 60 OR select_id IS NULL order by id;
3449 CAST(my_varchar_1000 AS DECIMAL(37,2)) my_varchar_1000 id
3452 0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3453 0.00 ---äÖüß@µ*$-- 4
3455 -3333.33 -3333.3333 27
3457 Error 1366 Incorrect decimal value: '' for column '' at row -1
3458 Error 1366 Incorrect decimal value: '' for column '' at row -1
3459 Error 1366 Incorrect decimal value: '' for column '' at row -1
3460 SHOW CREATE VIEW v1;
3461 View Create View character_set_client collation_connection
3462 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
3464 WHERE v1.id IN (SELECT id FROM t1_values
3465 WHERE select_id = 60 OR select_id IS NULL) order by id;
3466 CAST(my_varchar_1000 AS DECIMAL(37,2)) my_varchar_1000 id
3469 0.00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3470 0.00 ---äÖüß@µ*$-- 4
3472 -3333.33 -3333.3333 27
3474 Error 1366 Incorrect decimal value: '' for column '' at row -1
3475 Error 1366 Incorrect decimal value: '' for column '' at row -1
3476 Error 1366 Incorrect decimal value: '' for column '' at row -1
3480 CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DECIMAL(37,2)),
3481 my_char_30, id FROM t1_values;
3482 SELECT CAST(my_char_30 AS DECIMAL(37,2)),
3483 my_char_30, id FROM t1_values
3484 WHERE select_id = 59 OR select_id IS NULL order by id;
3485 CAST(my_char_30 AS DECIMAL(37,2)) my_char_30 id
3488 0.00 <--------30 characters-------> 3
3489 0.00 ---äÖüß@µ*$-- 4
3491 -3333.33 -3333.3333 26
3493 Error 1366 Incorrect decimal value: '' for column '' at row -1
3494 Warning 1292 Truncated incorrect DECIMAL value: ' '
3495 Error 1366 Incorrect decimal value: '' for column '' at row -1
3496 Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3497 Error 1366 Incorrect decimal value: '' for column '' at row -1
3498 Warning 1292 Truncated incorrect DECIMAL value: ' ---äÖüß@µ*$-- '
3499 SHOW CREATE VIEW v1;
3500 View Create View character_set_client collation_connection
3501 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
3503 WHERE v1.id IN (SELECT id FROM t1_values
3504 WHERE select_id = 59 OR select_id IS NULL) order by id;
3505 CAST(my_char_30 AS DECIMAL(37,2)) my_char_30 id
3508 0.00 <--------30 characters-------> 3
3509 0.00 ---äÖüß@µ*$-- 4
3511 -3333.33 -3333.3333 26
3513 Error 1366 Incorrect decimal value: '' for column '' at row -1
3514 Warning 1292 Truncated incorrect DECIMAL value: ' '
3515 Error 1366 Incorrect decimal value: '' for column '' at row -1
3516 Warning 1292 Truncated incorrect DECIMAL value: '<--------30 characters------->'
3517 Error 1366 Incorrect decimal value: '' for column '' at row -1
3518 Warning 1292 Truncated incorrect DECIMAL value: ' ---äÖüß@µ*$-- '
3522 CREATE VIEW v1 AS SELECT CAST(my_year AS TIME),
3523 my_year, id FROM t1_values;
3524 SELECT CAST(my_year AS TIME),
3525 my_year, id FROM t1_values
3526 WHERE select_id = 58 OR select_id IS NULL order by id;
3527 CAST(my_year AS TIME) my_year id
3533 SHOW CREATE VIEW v1;
3534 View Create View character_set_client collation_connection
3535 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
3537 WHERE v1.id IN (SELECT id FROM t1_values
3538 WHERE select_id = 58 OR select_id IS NULL) order by id;
3539 CAST(my_year AS TIME) my_year id
3548 CREATE VIEW v1 AS SELECT CAST(my_time AS TIME),
3549 my_time, id FROM t1_values;
3550 SELECT CAST(my_time AS TIME),
3551 my_time, id FROM t1_values
3552 WHERE select_id = 57 OR select_id IS NULL order by id;
3553 CAST(my_time AS TIME) my_time id
3555 -838:59:59 -838:59:59 2
3556 838:59:59 838:59:59 3
3559 SHOW CREATE VIEW v1;
3560 View Create View character_set_client collation_connection
3561 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_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
3563 WHERE v1.id IN (SELECT id FROM t1_values
3564 WHERE select_id = 57 OR select_id IS NULL) order by id;
3565 CAST(my_time AS TIME) my_time id
3567 -838:59:59 -838:59:59 2
3568 838:59:59 838:59:59 3
3574 CREATE VIEW v1 AS SELECT CAST(my_timestamp AS TIME),
3575 my_timestamp, id FROM t1_values;
3576 SELECT CAST(my_timestamp AS TIME),
3577 my_timestamp, id FROM t1_values
3578 WHERE select_id = 56 OR select_id IS NULL order by id;
3579 CAST(my_timestamp AS TIME) my_timestamp id
3580 00:00:00 0000-00-00 00:00:00 1
3581 03:00:01 1970-01-01 03:00:01 2
3582 02:59:59 2038-01-01 02:59:59 3
3583 23:59:59 2004-02-29 23:59:59 4
3584 10:00:00 2005-06-28 10:00:00 5
3585 SHOW CREATE VIEW v1;
3586 View Create View character_set_client collation_connection
3587 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_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
3589 WHERE v1.id IN (SELECT id FROM t1_values
3590 WHERE select_id = 56 OR select_id IS NULL) order by id;
3591 CAST(my_timestamp AS TIME) my_timestamp id
3592 00:00:00 0000-00-00 00:00:00 1
3593 03:00:01 1970-01-01 03:00:01 2
3594 02:59:59 2038-01-01 02:59:59 3
3595 23:59:59 2004-02-29 23:59:59 4
3596 10:00:00 2005-06-28 10:00:00 5
3600 CREATE VIEW v1 AS SELECT CAST(my_date AS TIME),
3601 my_date, id FROM t1_values;
3602 SELECT CAST(my_date AS TIME),
3603 my_date, id FROM t1_values
3604 WHERE select_id = 55 OR select_id IS NULL order by id;
3605 CAST(my_date AS TIME) my_date id
3607 00:00:00 0001-01-01 2
3608 00:00:00 9999-12-31 3
3609 00:00:00 2004-02-29 4
3610 00:00:00 2005-06-28 5
3611 SHOW CREATE VIEW v1;
3612 View Create View character_set_client collation_connection
3613 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_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
3615 WHERE v1.id IN (SELECT id FROM t1_values
3616 WHERE select_id = 55 OR select_id IS NULL) order by id;
3617 CAST(my_date AS TIME) my_date id
3619 00:00:00 0001-01-01 2
3620 00:00:00 9999-12-31 3
3621 00:00:00 2004-02-29 4
3622 00:00:00 2005-06-28 5
3626 CREATE VIEW v1 AS SELECT CAST(my_datetime AS TIME),
3627 my_datetime, id FROM t1_values;
3628 SELECT CAST(my_datetime AS TIME),
3629 my_datetime, id FROM t1_values
3630 WHERE select_id = 54 OR select_id IS NULL order by id;
3631 CAST(my_datetime AS TIME) my_datetime id
3633 00:00:00 0001-01-01 00:00:00 2
3634 23:59:59 9999-12-31 23:59:59 3
3635 23:59:59 2004-02-29 23:59:59 4
3636 10:00:00 2005-06-28 10:00:00 5
3637 SHOW CREATE VIEW v1;
3638 View Create View character_set_client collation_connection
3639 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(`t1_values`.`my_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
3641 WHERE v1.id IN (SELECT id FROM t1_values
3642 WHERE select_id = 54 OR select_id IS NULL) order by id;
3643 CAST(my_datetime AS TIME) my_datetime id
3645 00:00:00 0001-01-01 00:00:00 2
3646 23:59:59 9999-12-31 23:59:59 3
3647 23:59:59 2004-02-29 23:59:59 4
3648 10:00:00 2005-06-28 10:00:00 5
3652 CREATE VIEW v1 AS SELECT CAST(my_double AS TIME),
3653 my_double, id FROM t1_values;
3654 SELECT CAST(my_double AS TIME),
3655 my_double, id FROM t1_values
3656 WHERE select_id = 53 OR select_id IS NULL order by id;
3657 CAST(my_double AS TIME) my_double id
3659 NULL -1.7976931348623e+308 2
3660 NULL 1.7976931348623e+308 3
3665 Warning 1292 Truncated incorrect time value: '-1.7976931348623e+308'
3666 Warning 1292 Truncated incorrect time value: '1.7976931348623e+308'
3667 SHOW CREATE VIEW v1;
3668 View Create View character_set_client collation_connection
3669 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
3671 WHERE v1.id IN (SELECT id FROM t1_values
3672 WHERE select_id = 53 OR select_id IS NULL) order by id;
3673 CAST(my_double AS TIME) my_double id
3675 NULL -1.7976931348623e+308 2
3676 NULL 1.7976931348623e+308 3
3681 Warning 1292 Truncated incorrect time value: '-1.7976931348623e+308'
3682 Warning 1292 Truncated incorrect time value: '1.7976931348623e+308'
3686 CREATE VIEW v1 AS SELECT CAST(my_bigint AS TIME),
3687 my_bigint, id FROM t1_values;
3688 SELECT CAST(my_bigint AS TIME),
3689 my_bigint, id FROM t1_values
3690 WHERE select_id = 52 OR select_id IS NULL order by id;
3691 CAST(my_bigint AS TIME) my_bigint id
3693 NULL -9223372036854775808 2
3694 NULL 9223372036854775807 3
3699 Warning 1292 Truncated incorrect time value: '-9223372036854775808'
3700 Warning 1292 Truncated incorrect time value: '9223372036854775807'
3701 SHOW CREATE VIEW v1;
3702 View Create View character_set_client collation_connection
3703 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
3705 WHERE v1.id IN (SELECT id FROM t1_values
3706 WHERE select_id = 52 OR select_id IS NULL) order by id;
3707 CAST(my_bigint AS TIME) my_bigint id
3709 NULL -9223372036854775808 2
3710 NULL 9223372036854775807 3
3715 Warning 1292 Truncated incorrect time value: '-9223372036854775808'
3716 Warning 1292 Truncated incorrect time value: '9223372036854775807'
3720 CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS TIME),
3721 my_varbinary_1000, id FROM t1_values;
3722 SELECT CAST(my_varbinary_1000 AS TIME),
3723 my_varbinary_1000, id FROM t1_values
3724 WHERE select_id = 51 OR select_id IS NULL order by id;
3725 CAST(my_varbinary_1000 AS TIME) my_varbinary_1000 id
3728 00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3729 -00:00:00 ---äÖüß@µ*$-- 4
3733 Warning 1292 Truncated incorrect time value: ''
3734 Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3735 Warning 1292 Truncated incorrect time value: ' ---äÖüß@µ*$-- '
3736 SHOW CREATE VIEW v1;
3737 View Create View character_set_client collation_connection
3738 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
3740 WHERE v1.id IN (SELECT id FROM t1_values
3741 WHERE select_id = 51 OR select_id IS NULL) order by id;
3742 CAST(my_varbinary_1000 AS TIME) my_varbinary_1000 id
3745 00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3746 -00:00:00 ---äÖüß@µ*$-- 4
3750 Warning 1292 Truncated incorrect time value: ''
3751 Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3752 Warning 1292 Truncated incorrect time value: ' ---äÖüß@µ*$-- '
3756 CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS TIME),
3757 my_binary_30, id FROM t1_values;
3758 SELECT CAST(my_binary_30 AS TIME),
3759 my_binary_30, id FROM t1_values
3760 WHERE select_id = 50 OR select_id IS NULL order by id;
3761 CAST(my_binary_30 AS TIME) my_binary_30 id
3764 00:00:00 <--------30 characters-------> 3
3765 -00:00:00 ---äÖüß@µ*$-- 4
3769 Warning 1292 Truncated incorrect time value: ''
3770 Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3771 Warning 1292 Truncated incorrect time value: ' ---äÖüß@µ*$-- '
3772 Warning 1292 Truncated incorrect time value: '-1'
3773 Warning 1292 Truncated incorrect time value: '1 17:58'
3774 SHOW CREATE VIEW v1;
3775 View Create View character_set_client collation_connection
3776 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
3778 WHERE v1.id IN (SELECT id FROM t1_values
3779 WHERE select_id = 50 OR select_id IS NULL) order by id;
3780 CAST(my_binary_30 AS TIME) my_binary_30 id
3782 00:00:00
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
3783 00:00:00 <--------30 characters-------> 3
3784 -00:00:00 ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
3785 NULL -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
3786 41:58:00 1 17:58
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 22
3788 Warning 1292 Truncated incorrect time value: ''
3789 Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3790 Warning 1292 Truncated incorrect time value: ' ---äÖüß@µ*$-- '
3791 Warning 1292 Truncated incorrect time value: '-1'
3792 Warning 1292 Truncated incorrect time value: '1 17:58'
3796 CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS TIME),
3797 my_varchar_1000, id FROM t1_values;
3798 SELECT CAST(my_varchar_1000 AS TIME),
3799 my_varchar_1000, id FROM t1_values
3800 WHERE select_id = 49 OR select_id IS NULL order by id;
3801 CAST(my_varchar_1000 AS TIME) my_varchar_1000 id
3804 00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3805 -00:00:00 ---äÖüß@µ*$-- 4
3809 Warning 1292 Truncated incorrect time value: ''
3810 Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3811 Warning 1292 Truncated incorrect time value: ' ---äÖüß@µ*$-- '
3812 SHOW CREATE VIEW v1;
3813 View Create View character_set_client collation_connection
3814 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
3816 WHERE v1.id IN (SELECT id FROM t1_values
3817 WHERE select_id = 49 OR select_id IS NULL) order by id;
3818 CAST(my_varchar_1000 AS TIME) my_varchar_1000 id
3821 00:00:00 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
3822 -00:00:00 ---äÖüß@µ*$-- 4
3826 Warning 1292 Truncated incorrect time value: ''
3827 Warning 1292 Truncated incorrect time value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
3828 Warning 1292 Truncated incorrect time value: ' ---äÖüß@µ*$-- '
3832 CREATE VIEW v1 AS SELECT CAST(my_char_30 AS TIME),
3833 my_char_30, id FROM t1_values;
3834 SELECT CAST(my_char_30 AS TIME),
3835 my_char_30, id FROM t1_values
3836 WHERE select_id = 48 OR select_id IS NULL order by id;
3837 CAST(my_char_30 AS TIME) my_char_30 id
3840 00:00:00 <--------30 characters-------> 3
3841 -00:00:00 ---äÖüß@µ*$-- 4
3845 Warning 1292 Truncated incorrect time value: ''
3846 Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3847 Warning 1292 Truncated incorrect time value: ' ---äÖüß@µ*$--'
3848 SHOW CREATE VIEW v1;
3849 View Create View character_set_client collation_connection
3850 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
3852 WHERE v1.id IN (SELECT id FROM t1_values
3853 WHERE select_id = 48 OR select_id IS NULL) order by id;
3854 CAST(my_char_30 AS TIME) my_char_30 id
3857 00:00:00 <--------30 characters-------> 3
3858 -00:00:00 ---äÖüß@µ*$-- 4
3862 Warning 1292 Truncated incorrect time value: ''
3863 Warning 1292 Truncated incorrect time value: '<--------30 characters------->'
3864 Warning 1292 Truncated incorrect time value: ' ---äÖüß@µ*$--'
3868 CREATE VIEW v1 AS SELECT CAST(my_year AS DATETIME),
3869 my_year, id FROM t1_values;
3870 SELECT CAST(my_year AS DATETIME),
3871 my_year, id FROM t1_values
3872 WHERE select_id = 47 OR select_id IS NULL order by id;
3873 CAST(my_year AS DATETIME) my_year id
3880 Warning 1292 Incorrect datetime value: '1901'
3881 Warning 1292 Incorrect datetime value: '2155'
3882 Warning 1292 Incorrect datetime value: '2000'
3883 Warning 1292 Incorrect datetime value: '2005'
3884 SHOW CREATE VIEW v1;
3885 View Create View character_set_client collation_connection
3886 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
3888 WHERE v1.id IN (SELECT id FROM t1_values
3889 WHERE select_id = 47 OR select_id IS NULL) order by id;
3890 CAST(my_year AS DATETIME) my_year id
3897 Warning 1292 Incorrect datetime value: '1901'
3898 Warning 1292 Incorrect datetime value: '2155'
3899 Warning 1292 Incorrect datetime value: '2000'
3900 Warning 1292 Incorrect datetime value: '2005'
3904 CREATE VIEW v1 AS SELECT CAST(my_time AS DATETIME),
3905 my_time, id FROM t1_values;
3906 SELECT CAST(my_time AS DATETIME),
3907 my_time, id FROM t1_values
3908 WHERE select_id = 46 OR select_id IS NULL order by id;
3909 CAST(my_time AS DATETIME) my_time id
3911 0000-00-00 00:00:00 -838:59:59 2
3912 0000-00-00 00:00:00 838:59:59 3
3913 0000-00-00 13:00:00 13:00:00 4
3914 0000-00-00 10:00:00 10:00:00 5
3916 Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3917 Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3918 SHOW CREATE VIEW v1;
3919 View Create View character_set_client collation_connection
3920 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
3922 WHERE v1.id IN (SELECT id FROM t1_values
3923 WHERE select_id = 46 OR select_id IS NULL) order by id;
3924 CAST(my_time AS DATETIME) my_time id
3926 0000-00-00 00:00:00 -838:59:59 2
3927 0000-00-00 00:00:00 838:59:59 3
3928 0000-00-00 13:00:00 13:00:00 4
3929 0000-00-00 10:00:00 10:00:00 5
3931 Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3932 Warning 1292 Incorrect datetime value: '0000-00-00 838:59:59'
3936 CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DATETIME),
3937 my_timestamp, id FROM t1_values;
3938 SELECT CAST(my_timestamp AS DATETIME),
3939 my_timestamp, id FROM t1_values
3940 WHERE select_id = 45 OR select_id IS NULL order by id;
3941 CAST(my_timestamp AS DATETIME) my_timestamp id
3942 0000-00-00 00:00:00 0000-00-00 00:00:00 1
3943 1970-01-01 03:00:01 1970-01-01 03:00:01 2
3944 2038-01-01 02:59:59 2038-01-01 02:59:59 3
3945 2004-02-29 23:59:59 2004-02-29 23:59:59 4
3946 2005-06-28 10:00:00 2005-06-28 10:00:00 5
3947 SHOW CREATE VIEW v1;
3948 View Create View character_set_client collation_connection
3949 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
3951 WHERE v1.id IN (SELECT id FROM t1_values
3952 WHERE select_id = 45 OR select_id IS NULL) order by id;
3953 CAST(my_timestamp AS DATETIME) my_timestamp id
3954 0000-00-00 00:00:00 0000-00-00 00:00:00 1
3955 1970-01-01 03:00:01 1970-01-01 03:00:01 2
3956 2038-01-01 02:59:59 2038-01-01 02:59:59 3
3957 2004-02-29 23:59:59 2004-02-29 23:59:59 4
3958 2005-06-28 10:00:00 2005-06-28 10:00:00 5
3962 CREATE VIEW v1 AS SELECT CAST(my_date AS DATETIME),
3963 my_date, id FROM t1_values;
3964 SELECT CAST(my_date AS DATETIME),
3965 my_date, id FROM t1_values
3966 WHERE select_id = 44 OR select_id IS NULL order by id;
3967 CAST(my_date AS DATETIME) my_date id
3969 0001-01-01 00:00:00 0001-01-01 2
3970 9999-12-31 00:00:00 9999-12-31 3
3971 2004-02-29 00:00:00 2004-02-29 4
3972 2005-06-28 00:00:00 2005-06-28 5
3973 SHOW CREATE VIEW v1;
3974 View Create View character_set_client collation_connection
3975 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
3977 WHERE v1.id IN (SELECT id FROM t1_values
3978 WHERE select_id = 44 OR select_id IS NULL) order by id;
3979 CAST(my_date AS DATETIME) my_date id
3981 0001-01-01 00:00:00 0001-01-01 2
3982 9999-12-31 00:00:00 9999-12-31 3
3983 2004-02-29 00:00:00 2004-02-29 4
3984 2005-06-28 00:00:00 2005-06-28 5
3988 CREATE VIEW v1 AS SELECT CAST(my_datetime AS DATETIME),
3989 my_datetime, id FROM t1_values;
3990 SELECT CAST(my_datetime AS DATETIME),
3991 my_datetime, id FROM t1_values
3992 WHERE select_id = 43 OR select_id IS NULL order by id;
3993 CAST(my_datetime AS DATETIME) my_datetime id
3995 0001-01-01 00:00:00 0001-01-01 00:00:00 2
3996 9999-12-31 23:59:59 9999-12-31 23:59:59 3
3997 2004-02-29 23:59:59 2004-02-29 23:59:59 4
3998 2005-06-28 10:00:00 2005-06-28 10:00:00 5
3999 SHOW CREATE VIEW v1;
4000 View Create View character_set_client collation_connection
4001 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
4003 WHERE v1.id IN (SELECT id FROM t1_values
4004 WHERE select_id = 43 OR select_id IS NULL) order by id;
4005 CAST(my_datetime AS DATETIME) my_datetime id
4007 0001-01-01 00:00:00 0001-01-01 00:00:00 2
4008 9999-12-31 23:59:59 9999-12-31 23:59:59 3
4009 2004-02-29 23:59:59 2004-02-29 23:59:59 4
4010 2005-06-28 10:00:00 2005-06-28 10:00:00 5
4014 CREATE VIEW v1 AS SELECT CAST(my_double AS DATETIME),
4015 my_double, id FROM t1_values;
4016 SELECT CAST(my_double AS DATETIME),
4017 my_double, id FROM t1_values
4018 WHERE select_id = 42 OR select_id IS NULL order by id;
4019 CAST(my_double AS DATETIME) my_double id
4021 NULL -1.7976931348623e+308 2
4022 NULL 1.7976931348623e+308 3
4025 NULL 200506271758 19
4027 Warning 1292 Incorrect datetime value: '-1.7976931348623e+308'
4028 Warning 1292 Incorrect datetime value: '1.7976931348623e+308'
4029 Warning 1292 Incorrect datetime value: '0'
4030 Warning 1292 Incorrect datetime value: '-1'
4031 Warning 1292 Incorrect datetime value: '200506271758'
4032 SHOW CREATE VIEW v1;
4033 View Create View character_set_client collation_connection
4034 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
4036 WHERE v1.id IN (SELECT id FROM t1_values
4037 WHERE select_id = 42 OR select_id IS NULL) order by id;
4038 CAST(my_double AS DATETIME) my_double id
4040 NULL -1.7976931348623e+308 2
4041 NULL 1.7976931348623e+308 3
4044 NULL 200506271758 19
4046 Warning 1292 Incorrect datetime value: '-1.7976931348623e+308'
4047 Warning 1292 Incorrect datetime value: '1.7976931348623e+308'
4048 Warning 1292 Incorrect datetime value: '0'
4049 Warning 1292 Incorrect datetime value: '-1'
4050 Warning 1292 Incorrect datetime value: '200506271758'
4054 CREATE VIEW v1 AS SELECT CAST(my_bigint AS DATETIME),
4055 my_bigint, id FROM t1_values;
4056 SELECT CAST(my_bigint AS DATETIME),
4057 my_bigint, id FROM t1_values
4058 WHERE select_id = 41 OR select_id IS NULL order by id;
4059 CAST(my_bigint AS DATETIME) my_bigint id
4061 NULL -9223372036854775808 2
4062 NULL 9223372036854775807 3
4065 NULL 200506271758 18
4067 Warning 1292 Incorrect datetime value: '-9223372036854775808'
4068 Warning 1292 Incorrect datetime value: '9223372036854775807'
4069 Warning 1292 Incorrect datetime value: '0'
4070 Warning 1292 Incorrect datetime value: '-1'
4071 Warning 1292 Incorrect datetime value: '200506271758'
4072 SHOW CREATE VIEW v1;
4073 View Create View character_set_client collation_connection
4074 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
4076 WHERE v1.id IN (SELECT id FROM t1_values
4077 WHERE select_id = 41 OR select_id IS NULL) order by id;
4078 CAST(my_bigint AS DATETIME) my_bigint id
4080 NULL -9223372036854775808 2
4081 NULL 9223372036854775807 3
4084 NULL 200506271758 18
4086 Warning 1292 Incorrect datetime value: '-9223372036854775808'
4087 Warning 1292 Incorrect datetime value: '9223372036854775807'
4088 Warning 1292 Incorrect datetime value: '0'
4089 Warning 1292 Incorrect datetime value: '-1'
4090 Warning 1292 Incorrect datetime value: '200506271758'
4094 CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DATETIME),
4095 my_varbinary_1000, id FROM t1_values;
4096 SELECT CAST(my_varbinary_1000 AS DATETIME),
4097 my_varbinary_1000, id FROM t1_values
4098 WHERE select_id = 40 OR select_id IS NULL order by id;
4099 CAST(my_varbinary_1000 AS DATETIME) my_varbinary_1000 id
4102 NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4103 NULL ---äÖüß@µ*$-- 4
4105 2005-06-27 17:58:00 2005-06-27 17:58 17
4107 Warning 1292 Incorrect datetime value: ''
4108 Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4109 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4110 Warning 1292 Incorrect datetime value: '-1'
4111 SHOW CREATE VIEW v1;
4112 View Create View character_set_client collation_connection
4113 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
4115 WHERE v1.id IN (SELECT id FROM t1_values
4116 WHERE select_id = 40 OR select_id IS NULL) order by id;
4117 CAST(my_varbinary_1000 AS DATETIME) my_varbinary_1000 id
4120 NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4121 NULL ---äÖüß@µ*$-- 4
4123 2005-06-27 17:58:00 2005-06-27 17:58 17
4125 Warning 1292 Incorrect datetime value: ''
4126 Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4127 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4128 Warning 1292 Incorrect datetime value: '-1'
4132 CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DATETIME),
4133 my_binary_30, id FROM t1_values;
4134 SELECT CAST(my_binary_30 AS DATETIME),
4135 my_binary_30, id FROM t1_values
4136 WHERE select_id = 39 OR select_id IS NULL order by id;
4137 CAST(my_binary_30 AS DATETIME) my_binary_30 id
4140 NULL <--------30 characters-------> 3
4141 NULL ---äÖüß@µ*$-- 4
4143 2005-06-27 17:58:00 2005-06-27 17:58 16
4145 Warning 1292 Incorrect datetime value: ''
4146 Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4147 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4148 Warning 1292 Incorrect datetime value: '-1'
4149 Warning 1292 Truncated incorrect datetime value: '2005-06-27 17:58'
4150 SHOW CREATE VIEW v1;
4151 View Create View character_set_client collation_connection
4152 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
4154 WHERE v1.id IN (SELECT id FROM t1_values
4155 WHERE select_id = 39 OR select_id IS NULL) order by id;
4156 CAST(my_binary_30 AS DATETIME) my_binary_30 id
4158 NULL
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
4159 NULL <--------30 characters-------> 3
4160 NULL ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
4161 NULL -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
4162 2005-06-27 17:58:00 2005-06-27 17:58
\0\0\0\0\0\0\0\0\0\0\0\0\0\0 16
4164 Warning 1292 Incorrect datetime value: ''
4165 Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4166 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4167 Warning 1292 Incorrect datetime value: '-1'
4168 Warning 1292 Truncated incorrect datetime value: '2005-06-27 17:58'
4172 CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DATETIME),
4173 my_varchar_1000, id FROM t1_values;
4174 SELECT CAST(my_varchar_1000 AS DATETIME),
4175 my_varchar_1000, id FROM t1_values
4176 WHERE select_id = 38 OR select_id IS NULL order by id;
4177 CAST(my_varchar_1000 AS DATETIME) my_varchar_1000 id
4180 NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4181 NULL ---äÖüß@µ*$-- 4
4183 2005-06-27 17:58:00 2005-06-27 17:58 15
4185 Warning 1292 Incorrect datetime value: ''
4186 Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4187 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4188 Warning 1292 Incorrect datetime value: '-1'
4189 SHOW CREATE VIEW v1;
4190 View Create View character_set_client collation_connection
4191 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
4193 WHERE v1.id IN (SELECT id FROM t1_values
4194 WHERE select_id = 38 OR select_id IS NULL) order by id;
4195 CAST(my_varchar_1000 AS DATETIME) my_varchar_1000 id
4198 NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4199 NULL ---äÖüß@µ*$-- 4
4201 2005-06-27 17:58:00 2005-06-27 17:58 15
4203 Warning 1292 Incorrect datetime value: ''
4204 Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4205 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4206 Warning 1292 Incorrect datetime value: '-1'
4210 CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DATETIME),
4211 my_char_30, id FROM t1_values;
4212 SELECT CAST(my_char_30 AS DATETIME),
4213 my_char_30, id FROM t1_values
4214 WHERE select_id = 37 OR select_id IS NULL order by id;
4215 CAST(my_char_30 AS DATETIME) my_char_30 id
4218 NULL <--------30 characters-------> 3
4219 NULL ---äÖüß@µ*$-- 4
4221 2005-06-27 17:58:00 2005-06-27 17:58 14
4223 Warning 1292 Incorrect datetime value: ''
4224 Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4225 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$--'
4226 Warning 1292 Incorrect datetime value: '-1'
4227 SHOW CREATE VIEW v1;
4228 View Create View character_set_client collation_connection
4229 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
4231 WHERE v1.id IN (SELECT id FROM t1_values
4232 WHERE select_id = 37 OR select_id IS NULL) order by id;
4233 CAST(my_char_30 AS DATETIME) my_char_30 id
4236 NULL <--------30 characters-------> 3
4237 NULL ---äÖüß@µ*$-- 4
4239 2005-06-27 17:58:00 2005-06-27 17:58 14
4241 Warning 1292 Incorrect datetime value: ''
4242 Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4243 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$--'
4244 Warning 1292 Incorrect datetime value: '-1'
4248 CREATE VIEW v1 AS SELECT CAST(my_year AS DATE),
4249 my_year, id FROM t1_values;
4250 SELECT CAST(my_year AS DATE),
4251 my_year, id FROM t1_values
4252 WHERE select_id = 36 OR select_id IS NULL order by id;
4253 CAST(my_year AS DATE) my_year id
4260 Warning 1292 Incorrect datetime value: '1901'
4261 Warning 1292 Incorrect datetime value: '2155'
4262 Warning 1292 Incorrect datetime value: '2000'
4263 Warning 1292 Incorrect datetime value: '2005'
4264 SHOW CREATE VIEW v1;
4265 View Create View character_set_client collation_connection
4266 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
4268 WHERE v1.id IN (SELECT id FROM t1_values
4269 WHERE select_id = 36 OR select_id IS NULL) order by id;
4270 CAST(my_year AS DATE) my_year id
4277 Warning 1292 Incorrect datetime value: '1901'
4278 Warning 1292 Incorrect datetime value: '2155'
4279 Warning 1292 Incorrect datetime value: '2000'
4280 Warning 1292 Incorrect datetime value: '2005'
4284 CREATE VIEW v1 AS SELECT CAST(my_time AS DATE),
4285 my_time, id FROM t1_values;
4286 SELECT CAST(my_time AS DATE),
4287 my_time, id FROM t1_values
4288 WHERE select_id = 35 OR select_id IS NULL order by id;
4289 CAST(my_time AS DATE) my_time id
4291 0000-00-00 -838:59:59 2
4292 0000-00-00 838:59:59 3
4293 0000-00-00 13:00:00 4
4294 0000-00-00 10:00:00 5
4295 SHOW CREATE VIEW v1;
4296 View Create View character_set_client collation_connection
4297 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
4299 WHERE v1.id IN (SELECT id FROM t1_values
4300 WHERE select_id = 35 OR select_id IS NULL) order by id;
4301 CAST(my_time AS DATE) my_time id
4303 0000-00-00 -838:59:59 2
4304 0000-00-00 838:59:59 3
4305 0000-00-00 13:00:00 4
4306 0000-00-00 10:00:00 5
4310 CREATE VIEW v1 AS SELECT CAST(my_timestamp AS DATE),
4311 my_timestamp, id FROM t1_values;
4312 SELECT CAST(my_timestamp AS DATE),
4313 my_timestamp, id FROM t1_values
4314 WHERE select_id = 34 OR select_id IS NULL order by id;
4315 CAST(my_timestamp AS DATE) my_timestamp id
4316 0000-00-00 0000-00-00 00:00:00 1
4317 1970-01-01 1970-01-01 03:00:01 2
4318 2038-01-01 2038-01-01 02:59:59 3
4319 2004-02-29 2004-02-29 23:59:59 4
4320 2005-06-28 2005-06-28 10:00:00 5
4321 SHOW CREATE VIEW v1;
4322 View Create View character_set_client collation_connection
4323 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
4325 WHERE v1.id IN (SELECT id FROM t1_values
4326 WHERE select_id = 34 OR select_id IS NULL) order by id;
4327 CAST(my_timestamp AS DATE) my_timestamp id
4328 0000-00-00 0000-00-00 00:00:00 1
4329 1970-01-01 1970-01-01 03:00:01 2
4330 2038-01-01 2038-01-01 02:59:59 3
4331 2004-02-29 2004-02-29 23:59:59 4
4332 2005-06-28 2005-06-28 10:00:00 5
4336 CREATE VIEW v1 AS SELECT CAST(my_date AS DATE),
4337 my_date, id FROM t1_values;
4338 SELECT CAST(my_date AS DATE),
4339 my_date, id FROM t1_values
4340 WHERE select_id = 33 OR select_id IS NULL order by id;
4341 CAST(my_date AS DATE) my_date id
4343 0001-01-01 0001-01-01 2
4344 9999-12-31 9999-12-31 3
4345 2004-02-29 2004-02-29 4
4346 2005-06-28 2005-06-28 5
4347 SHOW CREATE VIEW v1;
4348 View Create View character_set_client collation_connection
4349 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
4351 WHERE v1.id IN (SELECT id FROM t1_values
4352 WHERE select_id = 33 OR select_id IS NULL) order by id;
4353 CAST(my_date AS DATE) my_date id
4355 0001-01-01 0001-01-01 2
4356 9999-12-31 9999-12-31 3
4357 2004-02-29 2004-02-29 4
4358 2005-06-28 2005-06-28 5
4362 CREATE VIEW v1 AS SELECT CAST(my_datetime AS DATE),
4363 my_datetime, id FROM t1_values;
4364 SELECT CAST(my_datetime AS DATE),
4365 my_datetime, id FROM t1_values
4366 WHERE select_id = 32 OR select_id IS NULL order by id;
4367 CAST(my_datetime AS DATE) my_datetime id
4369 0001-01-01 0001-01-01 00:00:00 2
4370 9999-12-31 9999-12-31 23:59:59 3
4371 2004-02-29 2004-02-29 23:59:59 4
4372 2005-06-28 2005-06-28 10:00:00 5
4373 SHOW CREATE VIEW v1;
4374 View Create View character_set_client collation_connection
4375 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
4377 WHERE v1.id IN (SELECT id FROM t1_values
4378 WHERE select_id = 32 OR select_id IS NULL) order by id;
4379 CAST(my_datetime AS DATE) my_datetime id
4381 0001-01-01 0001-01-01 00:00:00 2
4382 9999-12-31 9999-12-31 23:59:59 3
4383 2004-02-29 2004-02-29 23:59:59 4
4384 2005-06-28 2005-06-28 10:00:00 5
4388 CREATE VIEW v1 AS SELECT CAST(my_double AS DATE),
4389 my_double, id FROM t1_values;
4390 SELECT CAST(my_double AS DATE),
4391 my_double, id FROM t1_values
4392 WHERE select_id = 31 OR select_id IS NULL order by id;
4393 CAST(my_double AS DATE) my_double id
4395 NULL -1.7976931348623e+308 2
4396 NULL 1.7976931348623e+308 3
4399 2005-06-27 20050627 13
4401 Warning 1292 Incorrect datetime value: '-1.7976931348623e+308'
4402 Warning 1292 Incorrect datetime value: '1.7976931348623e+308'
4403 Warning 1292 Incorrect datetime value: '0'
4404 Warning 1292 Incorrect datetime value: '-1'
4405 SHOW CREATE VIEW v1;
4406 View Create View character_set_client collation_connection
4407 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
4409 WHERE v1.id IN (SELECT id FROM t1_values
4410 WHERE select_id = 31 OR select_id IS NULL) order by id;
4411 CAST(my_double AS DATE) my_double id
4413 NULL -1.7976931348623e+308 2
4414 NULL 1.7976931348623e+308 3
4417 2005-06-27 20050627 13
4419 Warning 1292 Incorrect datetime value: '-1.7976931348623e+308'
4420 Warning 1292 Incorrect datetime value: '1.7976931348623e+308'
4421 Warning 1292 Incorrect datetime value: '0'
4422 Warning 1292 Incorrect datetime value: '-1'
4426 CREATE VIEW v1 AS SELECT CAST(my_bigint AS DATE),
4427 my_bigint, id FROM t1_values;
4428 SELECT CAST(my_bigint AS DATE),
4429 my_bigint, id FROM t1_values
4430 WHERE select_id = 30 OR select_id IS NULL order by id;
4431 CAST(my_bigint AS DATE) my_bigint id
4433 NULL -9223372036854775808 2
4434 NULL 9223372036854775807 3
4437 2005-06-27 20050627 12
4439 Warning 1292 Incorrect datetime value: '-9223372036854775808'
4440 Warning 1292 Incorrect datetime value: '9223372036854775807'
4441 Warning 1292 Incorrect datetime value: '0'
4442 Warning 1292 Incorrect datetime value: '-1'
4443 SHOW CREATE VIEW v1;
4444 View Create View character_set_client collation_connection
4445 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
4447 WHERE v1.id IN (SELECT id FROM t1_values
4448 WHERE select_id = 30 OR select_id IS NULL) order by id;
4449 CAST(my_bigint AS DATE) my_bigint id
4451 NULL -9223372036854775808 2
4452 NULL 9223372036854775807 3
4455 2005-06-27 20050627 12
4457 Warning 1292 Incorrect datetime value: '-9223372036854775808'
4458 Warning 1292 Incorrect datetime value: '9223372036854775807'
4459 Warning 1292 Incorrect datetime value: '0'
4460 Warning 1292 Incorrect datetime value: '-1'
4464 CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS DATE),
4465 my_varbinary_1000, id FROM t1_values;
4466 SELECT CAST(my_varbinary_1000 AS DATE),
4467 my_varbinary_1000, id FROM t1_values
4468 WHERE select_id = 29 OR select_id IS NULL order by id;
4469 CAST(my_varbinary_1000 AS DATE) my_varbinary_1000 id
4472 NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4473 NULL ---äÖüß@µ*$-- 4
4475 2005-06-27 2005-06-27 11
4477 Warning 1292 Incorrect datetime value: ''
4478 Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4479 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4480 Warning 1292 Incorrect datetime value: '-1'
4481 SHOW CREATE VIEW v1;
4482 View Create View character_set_client collation_connection
4483 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
4485 WHERE v1.id IN (SELECT id FROM t1_values
4486 WHERE select_id = 29 OR select_id IS NULL) order by id;
4487 CAST(my_varbinary_1000 AS DATE) my_varbinary_1000 id
4490 NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4491 NULL ---äÖüß@µ*$-- 4
4493 2005-06-27 2005-06-27 11
4495 Warning 1292 Incorrect datetime value: ''
4496 Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4497 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4498 Warning 1292 Incorrect datetime value: '-1'
4502 CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS DATE),
4503 my_binary_30, id FROM t1_values;
4504 SELECT CAST(my_binary_30 AS DATE),
4505 my_binary_30, id FROM t1_values
4506 WHERE select_id = 28 OR select_id IS NULL order by id;
4507 CAST(my_binary_30 AS DATE) my_binary_30 id
4510 NULL <--------30 characters-------> 3
4511 NULL ---äÖüß@µ*$-- 4
4513 2005-06-27 2005-06-27 10
4515 Warning 1292 Incorrect datetime value: ''
4516 Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4517 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4518 Warning 1292 Incorrect datetime value: '-1'
4519 Warning 1292 Truncated incorrect date value: '2005-06-27'
4520 SHOW CREATE VIEW v1;
4521 View Create View character_set_client collation_connection
4522 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
4524 WHERE v1.id IN (SELECT id FROM t1_values
4525 WHERE select_id = 28 OR select_id IS NULL) order by id;
4526 CAST(my_binary_30 AS DATE) my_binary_30 id
4528 NULL
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
4529 NULL <--------30 characters-------> 3
4530 NULL ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
4531 NULL -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
4532 2005-06-27 2005-06-27
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 10
4534 Warning 1292 Incorrect datetime value: ''
4535 Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4536 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4537 Warning 1292 Incorrect datetime value: '-1'
4538 Warning 1292 Truncated incorrect date value: '2005-06-27'
4542 CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS DATE),
4543 my_varchar_1000, id FROM t1_values;
4544 SELECT CAST(my_varchar_1000 AS DATE),
4545 my_varchar_1000, id FROM t1_values
4546 WHERE select_id = 27 OR select_id IS NULL order by id;
4547 CAST(my_varchar_1000 AS DATE) my_varchar_1000 id
4550 NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4551 NULL ---äÖüß@µ*$-- 4
4553 2005-06-27 2005-06-27 9
4555 Warning 1292 Incorrect datetime value: ''
4556 Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4557 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4558 Warning 1292 Incorrect datetime value: '-1'
4559 SHOW CREATE VIEW v1;
4560 View Create View character_set_client collation_connection
4561 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
4563 WHERE v1.id IN (SELECT id FROM t1_values
4564 WHERE select_id = 27 OR select_id IS NULL) order by id;
4565 CAST(my_varchar_1000 AS DATE) my_varchar_1000 id
4568 NULL <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4569 NULL ---äÖüß@µ*$-- 4
4571 2005-06-27 2005-06-27 9
4573 Warning 1292 Incorrect datetime value: ''
4574 Warning 1292 Incorrect datetime value: '<---------1000 characters-------------------------------------------------------------------------------------------------------'
4575 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$-- '
4576 Warning 1292 Incorrect datetime value: '-1'
4580 CREATE VIEW v1 AS SELECT CAST(my_char_30 AS DATE),
4581 my_char_30, id FROM t1_values;
4582 SELECT CAST(my_char_30 AS DATE),
4583 my_char_30, id FROM t1_values
4584 WHERE select_id = 26 OR select_id IS NULL order by id;
4585 CAST(my_char_30 AS DATE) my_char_30 id
4588 NULL <--------30 characters-------> 3
4589 NULL ---äÖüß@µ*$-- 4
4591 2005-06-27 2005-06-27 8
4593 Warning 1292 Incorrect datetime value: ''
4594 Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4595 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$--'
4596 Warning 1292 Incorrect datetime value: '-1'
4597 SHOW CREATE VIEW v1;
4598 View Create View character_set_client collation_connection
4599 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
4601 WHERE v1.id IN (SELECT id FROM t1_values
4602 WHERE select_id = 26 OR select_id IS NULL) order by id;
4603 CAST(my_char_30 AS DATE) my_char_30 id
4606 NULL <--------30 characters-------> 3
4607 NULL ---äÖüß@µ*$-- 4
4609 2005-06-27 2005-06-27 8
4611 Warning 1292 Incorrect datetime value: ''
4612 Warning 1292 Incorrect datetime value: '<--------30 characters------->'
4613 Warning 1292 Incorrect datetime value: ' ---äÖüß@µ*$--'
4614 Warning 1292 Incorrect datetime value: '-1'
4618 CREATE VIEW v1 AS SELECT CAST(my_year AS CHAR),
4619 my_year, id FROM t1_values;
4620 SELECT CAST(my_year AS CHAR),
4621 my_year, id FROM t1_values
4622 WHERE select_id = 25 OR select_id IS NULL order by id;
4623 CAST(my_year AS CHAR) my_year id
4629 SHOW CREATE VIEW v1;
4630 View Create View character_set_client collation_connection
4631 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
4633 WHERE v1.id IN (SELECT id FROM t1_values
4634 WHERE select_id = 25 OR select_id IS NULL) order by id;
4635 CAST(my_year AS CHAR) my_year id
4644 CREATE VIEW v1 AS SELECT CAST(my_time AS CHAR),
4645 my_time, id FROM t1_values;
4646 SELECT CAST(my_time AS CHAR),
4647 my_time, id FROM t1_values
4648 WHERE select_id = 24 OR select_id IS NULL order by id;
4649 CAST(my_time AS CHAR) my_time id
4651 -838:59:59 -838:59:59 2
4652 838:59:59 838:59:59 3
4655 SHOW CREATE VIEW v1;
4656 View Create View character_set_client collation_connection
4657 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
4659 WHERE v1.id IN (SELECT id FROM t1_values
4660 WHERE select_id = 24 OR select_id IS NULL) order by id;
4661 CAST(my_time AS CHAR) my_time id
4663 -838:59:59 -838:59:59 2
4664 838:59:59 838:59:59 3
4670 CREATE VIEW v1 AS SELECT CAST(my_timestamp AS CHAR),
4671 my_timestamp, id FROM t1_values;
4672 SELECT CAST(my_timestamp AS CHAR),
4673 my_timestamp, id FROM t1_values
4674 WHERE select_id = 23 OR select_id IS NULL order by id;
4675 CAST(my_timestamp AS CHAR) my_timestamp id
4676 0000-00-00 00:00:00 0000-00-00 00:00:00 1
4677 1970-01-01 03:00:01 1970-01-01 03:00:01 2
4678 2038-01-01 02:59:59 2038-01-01 02:59:59 3
4679 2004-02-29 23:59:59 2004-02-29 23:59:59 4
4680 2005-06-28 10:00:00 2005-06-28 10:00:00 5
4681 SHOW CREATE VIEW v1;
4682 View Create View character_set_client collation_connection
4683 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
4685 WHERE v1.id IN (SELECT id FROM t1_values
4686 WHERE select_id = 23 OR select_id IS NULL) order by id;
4687 CAST(my_timestamp AS CHAR) my_timestamp id
4688 0000-00-00 00:00:00 0000-00-00 00:00:00 1
4689 1970-01-01 03:00:01 1970-01-01 03:00:01 2
4690 2038-01-01 02:59:59 2038-01-01 02:59:59 3
4691 2004-02-29 23:59:59 2004-02-29 23:59:59 4
4692 2005-06-28 10:00:00 2005-06-28 10:00:00 5
4696 CREATE VIEW v1 AS SELECT CAST(my_date AS CHAR),
4697 my_date, id FROM t1_values;
4698 SELECT CAST(my_date AS CHAR),
4699 my_date, id FROM t1_values
4700 WHERE select_id = 22 OR select_id IS NULL order by id;
4701 CAST(my_date AS CHAR) my_date id
4703 0001-01-01 0001-01-01 2
4704 9999-12-31 9999-12-31 3
4705 2004-02-29 2004-02-29 4
4706 2005-06-28 2005-06-28 5
4707 SHOW CREATE VIEW v1;
4708 View Create View character_set_client collation_connection
4709 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
4711 WHERE v1.id IN (SELECT id FROM t1_values
4712 WHERE select_id = 22 OR select_id IS NULL) order by id;
4713 CAST(my_date AS CHAR) my_date id
4715 0001-01-01 0001-01-01 2
4716 9999-12-31 9999-12-31 3
4717 2004-02-29 2004-02-29 4
4718 2005-06-28 2005-06-28 5
4722 CREATE VIEW v1 AS SELECT CAST(my_datetime AS CHAR),
4723 my_datetime, id FROM t1_values;
4724 SELECT CAST(my_datetime AS CHAR),
4725 my_datetime, id FROM t1_values
4726 WHERE select_id = 21 OR select_id IS NULL order by id;
4727 CAST(my_datetime AS CHAR) my_datetime id
4729 0001-01-01 00:00:00 0001-01-01 00:00:00 2
4730 9999-12-31 23:59:59 9999-12-31 23:59:59 3
4731 2004-02-29 23:59:59 2004-02-29 23:59:59 4
4732 2005-06-28 10:00:00 2005-06-28 10:00:00 5
4733 SHOW CREATE VIEW v1;
4734 View Create View character_set_client collation_connection
4735 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
4737 WHERE v1.id IN (SELECT id FROM t1_values
4738 WHERE select_id = 21 OR select_id IS NULL) order by id;
4739 CAST(my_datetime AS CHAR) my_datetime id
4741 0001-01-01 00:00:00 0001-01-01 00:00:00 2
4742 9999-12-31 23:59:59 9999-12-31 23:59:59 3
4743 2004-02-29 23:59:59 2004-02-29 23:59:59 4
4744 2005-06-28 10:00:00 2005-06-28 10:00:00 5
4748 CREATE VIEW v1 AS SELECT CAST(my_double AS CHAR),
4749 my_double, id FROM t1_values;
4750 SELECT CAST(my_double AS CHAR),
4751 my_double, id FROM t1_values
4752 WHERE select_id = 20 OR select_id IS NULL order by id;
4753 CAST(my_double AS CHAR) my_double id
4755 -1.7976931348623e+308 -1.7976931348623e+308 2
4756 1.7976931348623e+308 1.7976931348623e+308 3
4759 SHOW CREATE VIEW v1;
4760 View Create View character_set_client collation_connection
4761 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
4763 WHERE v1.id IN (SELECT id FROM t1_values
4764 WHERE select_id = 20 OR select_id IS NULL) order by id;
4765 CAST(my_double AS CHAR) my_double id
4767 -1.7976931348623e+308 -1.7976931348623e+308 2
4768 1.7976931348623e+308 1.7976931348623e+308 3
4774 CREATE VIEW v1 AS SELECT CAST(my_decimal AS CHAR),
4775 my_decimal, id FROM t1_values;
4776 SELECT CAST(my_decimal AS CHAR),
4777 my_decimal, id FROM t1_values
4778 WHERE select_id = 19 OR select_id IS NULL order by id;
4779 CAST(my_decimal AS CHAR) my_decimal id
4781 -9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
4782 9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
4783 0.000000000000000000000000000000 0.000000000000000000000000000000 4
4784 -1.000000000000000000000000000000 -1.000000000000000000000000000000 5
4785 SHOW CREATE VIEW v1;
4786 View Create View character_set_client collation_connection
4787 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
4789 WHERE v1.id IN (SELECT id FROM t1_values
4790 WHERE select_id = 19 OR select_id IS NULL) order by id;
4791 CAST(my_decimal AS CHAR) my_decimal id
4793 -9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
4794 9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
4795 0.000000000000000000000000000000 0.000000000000000000000000000000 4
4796 -1.000000000000000000000000000000 -1.000000000000000000000000000000 5
4800 CREATE VIEW v1 AS SELECT CAST(my_bigint AS CHAR),
4801 my_bigint, id FROM t1_values;
4802 SELECT CAST(my_bigint AS CHAR),
4803 my_bigint, id FROM t1_values
4804 WHERE select_id = 18 OR select_id IS NULL order by id;
4805 CAST(my_bigint AS CHAR) my_bigint id
4807 -9223372036854775808 -9223372036854775808 2
4808 9223372036854775807 9223372036854775807 3
4811 SHOW CREATE VIEW v1;
4812 View Create View character_set_client collation_connection
4813 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
4815 WHERE v1.id IN (SELECT id FROM t1_values
4816 WHERE select_id = 18 OR select_id IS NULL) order by id;
4817 CAST(my_bigint AS CHAR) my_bigint id
4819 -9223372036854775808 -9223372036854775808 2
4820 9223372036854775807 9223372036854775807 3
4826 CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS CHAR),
4827 my_varbinary_1000, id FROM t1_values;
4828 SELECT CAST(my_varbinary_1000 AS CHAR),
4829 my_varbinary_1000, id FROM t1_values
4830 WHERE select_id = 17 OR select_id IS NULL order by id;
4831 CAST(my_varbinary_1000 AS CHAR) my_varbinary_1000 id
4834 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4835 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4837 SHOW CREATE VIEW v1;
4838 View Create View character_set_client collation_connection
4839 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
4841 WHERE v1.id IN (SELECT id FROM t1_values
4842 WHERE select_id = 17 OR select_id IS NULL) order by id;
4843 CAST(my_varbinary_1000 AS CHAR) my_varbinary_1000 id
4846 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4847 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4852 CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS CHAR),
4853 my_binary_30, id FROM t1_values;
4854 SELECT CAST(my_binary_30 AS CHAR),
4855 my_binary_30, id FROM t1_values
4856 WHERE select_id = 16 OR select_id IS NULL order by id;
4857 CAST(my_binary_30 AS CHAR) my_binary_30 id
4860 <--------30 characters-------> <--------30 characters-------> 3
4861 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4863 SHOW CREATE VIEW v1;
4864 View Create View character_set_client collation_connection
4865 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
4867 WHERE v1.id IN (SELECT id FROM t1_values
4868 WHERE select_id = 16 OR select_id IS NULL) order by id;
4869 CAST(my_binary_30 AS CHAR) my_binary_30 id
4871 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
4872 <--------30 characters-------> <--------30 characters-------> 3
4873 ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
4874 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
4878 CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS CHAR),
4879 my_varchar_1000, id FROM t1_values;
4880 SELECT CAST(my_varchar_1000 AS CHAR),
4881 my_varchar_1000, id FROM t1_values
4882 WHERE select_id = 15 OR select_id IS NULL order by id;
4883 CAST(my_varchar_1000 AS CHAR) my_varchar_1000 id
4886 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4887 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4889 SHOW CREATE VIEW v1;
4890 View Create View character_set_client collation_connection
4891 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
4893 WHERE v1.id IN (SELECT id FROM t1_values
4894 WHERE select_id = 15 OR select_id IS NULL) order by id;
4895 CAST(my_varchar_1000 AS CHAR) my_varchar_1000 id
4898 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
4899 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4904 CREATE VIEW v1 AS SELECT CAST(my_char_30 AS CHAR),
4905 my_char_30, id FROM t1_values;
4906 SELECT CAST(my_char_30 AS CHAR),
4907 my_char_30, id FROM t1_values
4908 WHERE select_id = 14 OR select_id IS NULL order by id;
4909 CAST(my_char_30 AS CHAR) my_char_30 id
4912 <--------30 characters-------> <--------30 characters-------> 3
4913 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4915 SHOW CREATE VIEW v1;
4916 View Create View character_set_client collation_connection
4917 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
4919 WHERE v1.id IN (SELECT id FROM t1_values
4920 WHERE select_id = 14 OR select_id IS NULL) order by id;
4921 CAST(my_char_30 AS CHAR) my_char_30 id
4924 <--------30 characters-------> <--------30 characters-------> 3
4925 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
4930 CREATE VIEW v1 AS SELECT CAST(my_year AS BINARY),
4931 my_year, id FROM t1_values;
4932 SELECT CAST(my_year AS BINARY),
4933 my_year, id FROM t1_values
4934 WHERE select_id = 13 OR select_id IS NULL order by id;
4935 CAST(my_year AS BINARY) my_year id
4941 SHOW CREATE VIEW v1;
4942 View Create View character_set_client collation_connection
4943 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
4945 WHERE v1.id IN (SELECT id FROM t1_values
4946 WHERE select_id = 13 OR select_id IS NULL) order by id;
4947 CAST(my_year AS BINARY) my_year id
4956 CREATE VIEW v1 AS SELECT CAST(my_time AS BINARY),
4957 my_time, id FROM t1_values;
4958 SELECT CAST(my_time AS BINARY),
4959 my_time, id FROM t1_values
4960 WHERE select_id = 12 OR select_id IS NULL order by id;
4961 CAST(my_time AS BINARY) my_time id
4963 -838:59:59 -838:59:59 2
4964 838:59:59 838:59:59 3
4967 SHOW CREATE VIEW v1;
4968 View Create View character_set_client collation_connection
4969 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
4971 WHERE v1.id IN (SELECT id FROM t1_values
4972 WHERE select_id = 12 OR select_id IS NULL) order by id;
4973 CAST(my_time AS BINARY) my_time id
4975 -838:59:59 -838:59:59 2
4976 838:59:59 838:59:59 3
4982 CREATE VIEW v1 AS SELECT CAST(my_timestamp AS BINARY),
4983 my_timestamp, id FROM t1_values;
4984 SELECT CAST(my_timestamp AS BINARY),
4985 my_timestamp, id FROM t1_values
4986 WHERE select_id = 11 OR select_id IS NULL order by id;
4987 CAST(my_timestamp AS BINARY) my_timestamp id
4988 0000-00-00 00:00:00 0000-00-00 00:00:00 1
4989 1970-01-01 03:00:01 1970-01-01 03:00:01 2
4990 2038-01-01 02:59:59 2038-01-01 02:59:59 3
4991 2004-02-29 23:59:59 2004-02-29 23:59:59 4
4992 2005-06-28 10:00:00 2005-06-28 10:00:00 5
4993 SHOW CREATE VIEW v1;
4994 View Create View character_set_client collation_connection
4995 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
4997 WHERE v1.id IN (SELECT id FROM t1_values
4998 WHERE select_id = 11 OR select_id IS NULL) order by id;
4999 CAST(my_timestamp AS BINARY) my_timestamp id
5000 0000-00-00 00:00:00 0000-00-00 00:00:00 1
5001 1970-01-01 03:00:01 1970-01-01 03:00:01 2
5002 2038-01-01 02:59:59 2038-01-01 02:59:59 3
5003 2004-02-29 23:59:59 2004-02-29 23:59:59 4
5004 2005-06-28 10:00:00 2005-06-28 10:00:00 5
5008 CREATE VIEW v1 AS SELECT CAST(my_date AS BINARY),
5009 my_date, id FROM t1_values;
5010 SELECT CAST(my_date AS BINARY),
5011 my_date, id FROM t1_values
5012 WHERE select_id = 10 OR select_id IS NULL order by id;
5013 CAST(my_date AS BINARY) my_date id
5015 0001-01-01 0001-01-01 2
5016 9999-12-31 9999-12-31 3
5017 2004-02-29 2004-02-29 4
5018 2005-06-28 2005-06-28 5
5019 SHOW CREATE VIEW v1;
5020 View Create View character_set_client collation_connection
5021 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
5023 WHERE v1.id IN (SELECT id FROM t1_values
5024 WHERE select_id = 10 OR select_id IS NULL) order by id;
5025 CAST(my_date AS BINARY) my_date id
5027 0001-01-01 0001-01-01 2
5028 9999-12-31 9999-12-31 3
5029 2004-02-29 2004-02-29 4
5030 2005-06-28 2005-06-28 5
5034 CREATE VIEW v1 AS SELECT CAST(my_datetime AS BINARY),
5035 my_datetime, id FROM t1_values;
5036 SELECT CAST(my_datetime AS BINARY),
5037 my_datetime, id FROM t1_values
5038 WHERE select_id = 9 OR select_id IS NULL order by id;
5039 CAST(my_datetime AS BINARY) my_datetime id
5041 0001-01-01 00:00:00 0001-01-01 00:00:00 2
5042 9999-12-31 23:59:59 9999-12-31 23:59:59 3
5043 2004-02-29 23:59:59 2004-02-29 23:59:59 4
5044 2005-06-28 10:00:00 2005-06-28 10:00:00 5
5045 SHOW CREATE VIEW v1;
5046 View Create View character_set_client collation_connection
5047 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
5049 WHERE v1.id IN (SELECT id FROM t1_values
5050 WHERE select_id = 9 OR select_id IS NULL) order by id;
5051 CAST(my_datetime AS BINARY) my_datetime id
5053 0001-01-01 00:00:00 0001-01-01 00:00:00 2
5054 9999-12-31 23:59:59 9999-12-31 23:59:59 3
5055 2004-02-29 23:59:59 2004-02-29 23:59:59 4
5056 2005-06-28 10:00:00 2005-06-28 10:00:00 5
5060 CREATE VIEW v1 AS SELECT CAST(my_double AS BINARY),
5061 my_double, id FROM t1_values;
5062 SELECT CAST(my_double AS BINARY),
5063 my_double, id FROM t1_values
5064 WHERE select_id = 8 OR select_id IS NULL order by id;
5065 CAST(my_double AS BINARY) my_double id
5067 -1.7976931348623e+308 -1.7976931348623e+308 2
5068 1.7976931348623e+308 1.7976931348623e+308 3
5071 SHOW CREATE VIEW v1;
5072 View Create View character_set_client collation_connection
5073 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
5075 WHERE v1.id IN (SELECT id FROM t1_values
5076 WHERE select_id = 8 OR select_id IS NULL) order by id;
5077 CAST(my_double AS BINARY) my_double id
5079 -1.7976931348623e+308 -1.7976931348623e+308 2
5080 1.7976931348623e+308 1.7976931348623e+308 3
5086 CREATE VIEW v1 AS SELECT CAST(my_decimal AS BINARY),
5087 my_decimal, id FROM t1_values;
5088 SELECT CAST(my_decimal AS BINARY),
5089 my_decimal, id FROM t1_values
5090 WHERE select_id = 7 OR select_id IS NULL order by id;
5091 CAST(my_decimal AS BINARY) my_decimal id
5093 -9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
5094 9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
5095 0.000000000000000000000000000000 0.000000000000000000000000000000 4
5096 -1.000000000000000000000000000000 -1.000000000000000000000000000000 5
5097 SHOW CREATE VIEW v1;
5098 View Create View character_set_client collation_connection
5099 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
5101 WHERE v1.id IN (SELECT id FROM t1_values
5102 WHERE select_id = 7 OR select_id IS NULL) order by id;
5103 CAST(my_decimal AS BINARY) my_decimal id
5105 -9999999999999999999999999999999999.999999999999999999999999999999 -9999999999999999999999999999999999.999999999999999999999999999999 2
5106 9999999999999999999999999999999999.999999999999999999999999999999 9999999999999999999999999999999999.999999999999999999999999999999 3
5107 0.000000000000000000000000000000 0.000000000000000000000000000000 4
5108 -1.000000000000000000000000000000 -1.000000000000000000000000000000 5
5112 CREATE VIEW v1 AS SELECT CAST(my_bigint AS BINARY),
5113 my_bigint, id FROM t1_values;
5114 SELECT CAST(my_bigint AS BINARY),
5115 my_bigint, id FROM t1_values
5116 WHERE select_id = 6 OR select_id IS NULL order by id;
5117 CAST(my_bigint AS BINARY) my_bigint id
5119 -9223372036854775808 -9223372036854775808 2
5120 9223372036854775807 9223372036854775807 3
5123 SHOW CREATE VIEW v1;
5124 View Create View character_set_client collation_connection
5125 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
5127 WHERE v1.id IN (SELECT id FROM t1_values
5128 WHERE select_id = 6 OR select_id IS NULL) order by id;
5129 CAST(my_bigint AS BINARY) my_bigint id
5131 -9223372036854775808 -9223372036854775808 2
5132 9223372036854775807 9223372036854775807 3
5138 CREATE VIEW v1 AS SELECT CAST(my_varbinary_1000 AS BINARY),
5139 my_varbinary_1000, id FROM t1_values;
5140 SELECT CAST(my_varbinary_1000 AS BINARY),
5141 my_varbinary_1000, id FROM t1_values
5142 WHERE select_id = 5 OR select_id IS NULL order by id;
5143 CAST(my_varbinary_1000 AS BINARY) my_varbinary_1000 id
5146 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5147 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5149 SHOW CREATE VIEW v1;
5150 View Create View character_set_client collation_connection
5151 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
5153 WHERE v1.id IN (SELECT id FROM t1_values
5154 WHERE select_id = 5 OR select_id IS NULL) order by id;
5155 CAST(my_varbinary_1000 AS BINARY) my_varbinary_1000 id
5158 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5159 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5164 CREATE VIEW v1 AS SELECT CAST(my_binary_30 AS BINARY),
5165 my_binary_30, id FROM t1_values;
5166 SELECT CAST(my_binary_30 AS BINARY),
5167 my_binary_30, id FROM t1_values
5168 WHERE select_id = 4 OR select_id IS NULL order by id;
5169 CAST(my_binary_30 AS BINARY) my_binary_30 id
5172 <--------30 characters-------> <--------30 characters-------> 3
5173 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5175 SHOW CREATE VIEW v1;
5176 View Create View character_set_client collation_connection
5177 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
5179 WHERE v1.id IN (SELECT id FROM t1_values
5180 WHERE select_id = 4 OR select_id IS NULL) order by id;
5181 CAST(my_binary_30 AS BINARY) my_binary_30 id
5183 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 2
5184 <--------30 characters-------> <--------30 characters-------> 3
5185 ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 ---äÖüß@µ*$--
\0\0\0\0\0\0\0\0\0\0 4
5186 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 -1
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 5
5190 CREATE VIEW v1 AS SELECT CAST(my_varchar_1000 AS BINARY),
5191 my_varchar_1000, id FROM t1_values;
5192 SELECT CAST(my_varchar_1000 AS BINARY),
5193 my_varchar_1000, id FROM t1_values
5194 WHERE select_id = 3 OR select_id IS NULL order by id;
5195 CAST(my_varchar_1000 AS BINARY) my_varchar_1000 id
5198 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5199 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5201 SHOW CREATE VIEW v1;
5202 View Create View character_set_client collation_connection
5203 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
5205 WHERE v1.id IN (SELECT id FROM t1_values
5206 WHERE select_id = 3 OR select_id IS NULL) order by id;
5207 CAST(my_varchar_1000 AS BINARY) my_varchar_1000 id
5210 <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> <---------1000 characters--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3
5211 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5216 CREATE VIEW v1 AS SELECT CAST(my_char_30 AS BINARY),
5217 my_char_30, id FROM t1_values;
5218 SELECT CAST(my_char_30 AS BINARY),
5219 my_char_30, id FROM t1_values
5220 WHERE select_id = 2 OR select_id IS NULL order by id;
5221 CAST(my_char_30 AS BINARY) my_char_30 id
5224 <--------30 characters-------> <--------30 characters-------> 3
5225 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5227 SHOW CREATE VIEW v1;
5228 View Create View character_set_client collation_connection
5229 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
5231 WHERE v1.id IN (SELECT id FROM t1_values
5232 WHERE select_id = 2 OR select_id IS NULL) order by id;
5233 CAST(my_char_30 AS BINARY) my_char_30 id
5236 <--------30 characters-------> <--------30 characters-------> 3
5237 ---äÖüß@µ*$-- ---äÖüß@µ*$-- 4
5242 CREATE VIEW v1 AS SELECT sqrt(my_bigint), my_bigint, id FROM t1_values;
5243 SELECT sqrt(my_bigint), my_bigint, id FROM t1_values
5244 WHERE select_id = 1 OR select_id IS NULL order by id;
5245 sqrt(my_bigint) my_bigint id
5247 NULL -9223372036854775808 2
5248 3037000499.97605 9223372036854775807 3
5253 SHOW CREATE VIEW v1;
5254 View Create View character_set_client collation_connection
5255 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
5257 WHERE v1.id IN (SELECT id FROM t1_values
5258 WHERE select_id = 1 OR select_id IS NULL) order by id;
5259 sqrt(my_bigint) my_bigint id
5261 NULL -9223372036854775808 2
5262 3037000499.97605 9223372036854775807 3
5270 DROP TABLE t1_selects, t1_modes, t1_values;