57
57
my_decimal = -9999999999999999999999999999999999.999999999999999999999999999999 ,
58
58
my_double = -1.7976931348623E+308;
59
59
INSERT INTO t1_values SET
60
my_char_30 = '<--------30 characters------->',
60
my_char_30 = '<--------30 characters------->',
61
61
my_varchar_1000 = CONCAT('<---------1000 characters',
62
62
RPAD('',965,'-'),'--------->'),
63
my_binary_30 = '<--------30 characters------->',
63
my_binary_30 = '<--------30 characters------->',
64
64
my_varbinary_1000 = CONCAT('<---------1000 characters',
65
65
RPAD('',965,'-'),'--------->'),
66
66
my_datetime = '9999-12-31 23:59:59',
72
72
my_decimal = +9999999999999999999999999999999999.999999999999999999999999999999 ,
73
73
my_double = 1.7976931348623E+308;
74
74
INSERT INTO t1_values SET
75
my_char_30 = ' ---äÖüß@µ*$-- ',
76
my_varchar_1000 = ' ---äÖüß@µ*$-- ',
77
my_binary_30 = ' ---äÖüß@µ*$-- ',
78
my_varbinary_1000 = ' ---äÖüß@µ*$-- ',
75
my_char_30 = ' ---äÖüß@µ*$-- ',
76
my_varchar_1000 = ' ---äÖüß@µ*$-- ',
77
my_binary_30 = ' ---äÖüß@µ*$-- ',
78
my_varbinary_1000 = ' ---äÖüß@µ*$-- ',
79
79
my_datetime = '2004-02-29 23:59:59',
80
80
my_date = '2004-02-29',
81
81
my_timestamp = '2004-02-29 23:59:59',
82
82
my_time = '13:00:00',
87
87
INSERT INTO t1_values SET
89
my_varchar_1000 = '-1',
91
my_varbinary_1000 = '-1',
89
my_varchar_1000 = '-1',
91
my_varbinary_1000 = '-1',
92
92
my_datetime = '2005-06-28 10:00:00',
93
93
my_date = '2005-06-28',
94
94
my_timestamp = '2005-06-28 10:00:00',
174
174
some statements disabled because of
175
175
Bug#5913 Traditional mode: BIGINT range not correctly delimited
176
176
--------------------------------------------------------------------------------
177
SET @my_select = 'SELECT CONVERT(my_char_30 USING utf8),
177
SET @my_select = 'SELECT CONVERT(my_char_30 USING utf8),
178
178
my_char_30, id FROM t1_values';
179
SET @my_select = 'SELECT CONVERT(my_varchar_1000 USING utf8),
179
SET @my_select = 'SELECT CONVERT(my_varchar_1000 USING utf8),
180
180
my_varchar_1000, id FROM t1_values';
181
SET @my_select = 'SELECT CONVERT(my_binary_30 USING utf8),
181
SET @my_select = 'SELECT CONVERT(my_binary_30 USING utf8),
182
182
my_binary_30, id FROM t1_values';
183
SET @my_select = 'SELECT CONVERT(my_varbinary_1000 USING utf8),
183
SET @my_select = 'SELECT CONVERT(my_varbinary_1000 USING utf8),
184
184
my_varbinary_1000, id FROM t1_values';
185
SET @my_select = 'SELECT CONVERT(my_char_30 USING koi8r),
185
SET @my_select = 'SELECT CONVERT(my_char_30 USING koi8r),
186
186
my_char_30, id FROM t1_values';
187
SET @my_select = 'SELECT CONVERT(my_varchar_1000 USING koi8r),
187
SET @my_select = 'SELECT CONVERT(my_varchar_1000 USING koi8r),
188
188
my_varchar_1000, id FROM t1_values';
189
SET @my_select = 'SELECT CONVERT(my_binary_30 USING koi8r),
189
SET @my_select = 'SELECT CONVERT(my_binary_30 USING koi8r),
190
190
my_binary_30, id FROM t1_values';
191
SET @my_select = 'SELECT CONVERT(my_varbinary_1000 USING koi8r),
191
SET @my_select = 'SELECT CONVERT(my_varbinary_1000 USING koi8r),
192
192
my_varbinary_1000, id FROM t1_values';
193
193
SET @my_select = 'SELECT BIT_LENGTH(my_char_30),
194
194
my_char_30, id FROM t1_values';
202
202
my_char_30, id FROM t1_values';
203
203
SET @my_select = 'SELECT LCASE(my_varchar_1000),
204
204
my_varchar_1000, id FROM t1_values';
206
206
'SELECT LEFT(my_char_30, 2), my_char_30, id FROM t1_values';
208
208
'SELECT LEFT(my_varchar_1000, 2), my_varchar_1000, id FROM t1_values';
210
210
'SELECT LEFT(my_binary_30, 2), my_binary_30, id FROM t1_values';
212
212
'SELECT LEFT(my_varbinary_1000, 2), my_varbinary_1000, id FROM t1_values';
214
214
'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_bigint), my_bigint, id FROM t1_values';
216
216
'SELECT LEFT(''AaBbCcDdEeFfGgHhIiJjÄäÜüÖö'', my_decimal), my_decimal, id FROM t1_values';
224
224
my_binary_30, id FROM t1_values';
225
225
SET @my_select = 'SELECT LENGTH(my_varbinary_1000),
226
226
my_varbinary_1000, id FROM t1_values';
227
SELECT 'äÄ@' INTO OUTFILE '../tmp/func_view.dat';
229
'SELECT LOAD_FILE(''../tmp/func_view.dat''), id FROM t1_values';
228
'SELECT LOAD_FILE(''<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/load_file.txt'')
230
231
SET @my_select = 'SELECT LOCATE(''char'', my_char_30),
231
232
my_char_30, id FROM t1_values';
232
233
SET @my_select = 'SELECT LOCATE(''char'', my_varchar_1000),
835
CREATE VIEW v1 AS SELECT LOAD_FILE('../tmp/func_view.dat'), id FROM t1_values;
836
SELECT LOAD_FILE('../tmp/func_view.dat'), id FROM t1_values
836
CREATE VIEW v1 AS SELECT LOAD_FILE('<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/load_file.txt')
839
SELECT LOAD_FILE('<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/load_file.txt')
837
842
WHERE select_id = 156 OR select_id IS NULL order by id;
838
LOAD_FILE('../tmp/func_view.dat') id
844
Here is content from load_file
846
Here is content from load_file
848
Here is content from load_file
850
Here is content from load_file
852
Here is content from load_file
849
854
SHOW CREATE VIEW v1;
850
855
View Create View character_set_client collation_connection
851
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select load_file('../tmp/func_view.dat') AS `LOAD_FILE('../tmp/func_view.dat')`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
856
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select load_file('<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/load_file.txt') AS `my_col`,`t1_values`.`id` AS `id` from `t1_values` latin1 latin1_swedish_ci
852
857
SELECT v1.* FROM v1
853
858
WHERE v1.id IN (SELECT id FROM t1_values
854
859
WHERE select_id = 156 OR select_id IS NULL) order by id;
855
LOAD_FILE('../tmp/func_view.dat') id
861
Here is content from load_file
863
Here is content from load_file
865
Here is content from load_file
867
Here is content from load_file
869
Here is content from load_file
962
967
0.000000000000000000000000000000 4
963
968
-1.000000000000000000000000000000 5
965
Error 1292 Truncated incorrect DECIMAL value: ''
966
Error 1292 Truncated incorrect DECIMAL value: ''
970
Warning 1292 Truncated incorrect DECIMAL value: ''
971
Warning 1292 Truncated incorrect DECIMAL value: ''
967
972
SHOW CREATE VIEW v1;
968
973
View Create View character_set_client collation_connection
969
974
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
977
982
0.000000000000000000000000000000 4
978
983
-1.000000000000000000000000000000 5
980
Error 1292 Truncated incorrect DECIMAL value: ''
981
Error 1292 Truncated incorrect DECIMAL value: ''
985
Warning 1292 Truncated incorrect DECIMAL value: ''
986
Warning 1292 Truncated incorrect DECIMAL value: ''