bzr push into mysql-5.1-bugteam branch (azundris:2681 to 2682) Bug#37114

[Tatiana A. Nurnberg]

 2682 Tatiana A. Nurnberg	2008-09-18
      Bug#37114: sql_mode NO_BACKSLASH_ESCAPES does not work properly with LOAD DATA     
Bug#37114: sql_mode NO_BACKSLASH_ESCAPES does not work properly with LOAD DATA INFILE
      
      tweaked test to make embedded server happy
modified:
  mysql-test/r/loaddata.result
  mysql-test/t/loaddata.test

 2681 Tatiana A. Nurnberg	2008-09-17 [merge]
      auto-merge
modified:
  sql/stacktrace.c

=== modified file 'mysql-test/r/loaddata.result'
--- a/mysql-test/r/loaddata.result	2008-09-17 06:34:00 +0000
+++ b/mysql-test/r/loaddata.result	2008-09-18 09:24:50 +0000
@@ -334,9 +334,11 @@ SET SESSION character_set_server=latin1;
 SET SESSION character_set_connection=latin1;
 SET @OLD_SQL_MODE=@@SESSION.SQL_MODE;
 test LOAD DATA INFILE
+SET sql_mode = '';
+SELECT '1 \\aa\n' INTO DUMPFILE 'MYSQLTEST_VARDIR/tmp/bug37114.txt';
 CREATE TABLE t1 (id INT, val1 CHAR(3)) ENGINE=MyISAM;
 SET sql_mode = 'NO_BACKSLASH_ESCAPES';
-LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/bug37114.txt' REPLACE INTO TABLE t1 FIELDS
TERMINATED BY ' ';
+LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/bug37114.txt' REPLACE INTO TABLE t1 FIELDS
TERMINATED BY ' ';
 SELECT * FROM t1;
 id	val1
 1	\aa

=== modified file 'mysql-test/t/loaddata.test'
--- a/mysql-test/t/loaddata.test	2008-09-17 06:34:00 +0000
+++ b/mysql-test/t/loaddata.test	2008-09-18 09:24:50 +0000
@@ -357,16 +357,17 @@ SET @OLD_SQL_MODE=@@SESSION.SQL_MODE;
 --let $file=$MYSQLTEST_VARDIR/tmp/bug37114.txt
 --let $file2=$MYSQLTEST_VARDIR/tmp/bug37114_out.txt
 
---write_file $file
-1 \aa
-EOF
+SET sql_mode = '';
+
+--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
+--eval SELECT '1 \\\\aa\n' INTO DUMPFILE '$file'
 
 CREATE TABLE t1 (id INT, val1 CHAR(3)) ENGINE=MyISAM;
 
 SET sql_mode = 'NO_BACKSLASH_ESCAPES';
 
 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
---eval LOAD DATA LOCAL INFILE '$file' REPLACE INTO TABLE t1 FIELDS TERMINATED BY ' '
+--eval LOAD DATA INFILE '$file' REPLACE INTO TABLE t1 FIELDS TERMINATED BY ' '
 SELECT * FROM t1;
 
 # show we can write this with OUTFILE, forcing the parameters for now