diff options
| author | Tatiana A. Nurnberg <azundris@mysql.com> | 2008-09-18 11:24:50 +0200 |
|---|---|---|
| committer | Tatiana A. Nurnberg <azundris@mysql.com> | 2008-09-18 11:24:50 +0200 |
| commit | 654db75dfbedf64435fb7fdb00500396e0ee92f1 (patch) | |
| tree | 7e273a4e2ed59d674de4be48bff8156d250360fa /mysql-test/r | |
| parent | 8d10051b9a8bb7753cf24b210c9cd69580539ac4 (diff) | |
| download | mariadb-git-654db75dfbedf64435fb7fdb00500396e0ee92f1.tar.gz | |
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
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/loaddata.result | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/r/loaddata.result b/mysql-test/r/loaddata.result index 2aef2ade625..6e879114119 100644 --- a/mysql-test/r/loaddata.result +++ b/mysql-test/r/loaddata.result @@ -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 |