580
580
connection default;
585
--echo # Bug #51876 : crash/memory underrun when loading data with ucs2
586
--echo # and reverse() function
589
--echo # Problem # 1 (original report): wrong parsing of ucs2 data
590
SELECT '00' UNION SELECT '10' INTO OUTFILE 'tmpp.txt';
591
CREATE TABLE t1(a INT);
592
LOAD DATA INFILE 'tmpp.txt' INTO TABLE t1 CHARACTER SET ucs2
593
(@b) SET a=REVERSE(@b);
594
--echo # should return 2 zeroes (as the value is truncated)
598
let $MYSQLD_DATADIR= `select @@datadir`;
599
remove_file $MYSQLD_DATADIR/test/tmpp.txt;
602
--echo # Problem # 2 : if you write and read ucs2 data to a file they're lost
603
SELECT '00' UNION SELECT '10' INTO OUTFILE 'tmpp2.txt' CHARACTER SET ucs2;
604
CREATE TABLE t1(a INT);
605
LOAD DATA INFILE 'tmpp2.txt' INTO TABLE t1 CHARACTER SET ucs2
606
(@b) SET a=REVERSE(@b);
607
--echo # should return 0 and 1 (10 reversed)
611
let $MYSQLD_DATADIR= `select @@datadir`;
612
remove_file $MYSQLD_DATADIR/test/tmpp2.txt;
615
--echo # Bug#11765139 58069: LOAD DATA INFILE: VALGRIND REPORTS INVALID MEMORY READS AND WRITES WITH U
618
CREATE TABLE t1(f1 INT);
619
EVAL SELECT 0xE1BB30 INTO OUTFILE 't1.dat';
621
LOAD DATA INFILE 't1.dat' IGNORE INTO TABLE t1 CHARACTER SET utf8;
625
let $MYSQLD_DATADIR= `select @@datadir`;
626
remove_file $MYSQLD_DATADIR/test/t1.dat;
629
--echo # Bug#11765141 - 58072: LOAD DATA INFILE: LEAKS IO CACHE MEMORY
630
--echo # WHEN ERROR OCCURS
633
--let $file=$MYSQLTEST_VARDIR/tmp/bug11735141.txt
634
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
635
--eval SELECT '1\n' INTO DUMPFILE '$file'
637
create table t1(a point);
638
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
639
--error ER_CANT_CREATE_GEOMETRY_OBJECT
640
--eval LOAD DATA INFILE '$file' INTO TABLE t1
583
643
--echo End of 5.1 tests
added
removed
mysql-test/t/loaddata.test
