240
240
SET NAMES default;
241
241
DROP TABLE t1, t2;
243
# Bug #53088: mysqldump with -T & --default-character-set set
244
# truncates text/blob to 766 chars
246
# Also see mysqldump.test
248
CREATE TABLE t1 (a BLOB) CHARSET latin1;
249
CREATE TABLE t2 LIKE t1;
250
INSERT INTO t1 VALUES (REPEAT('.', 800));
251
SELECT * INTO OUTFILE 'MYSQLTEST_VARDIR/tmp/bug53088.txt' CHARACTER SET latin1 FROM t1;
252
# should be greater than 800
253
SELECT LENGTH(LOAD_FILE('MYSQLTEST_VARDIR/tmp/bug53088.txt'));
254
LENGTH(LOAD_FILE('MYSQLTEST_VARDIR/tmp/bug53088.txt'))
256
LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/bug53088.txt' INTO TABLE t2;
258
SELECT LENGTH(a) FROM t2;
242
262
# End of 5.1 tests.