diff options
| author | unknown <jimw@mysql.com> | 2005-06-22 16:14:14 -0700 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-06-22 16:14:14 -0700 |
| commit | c686f699b22c8ff7f3f9f2a6f550cdcb23db4793 (patch) | |
| tree | c437713521665097653a262fd2146db1abd22f80 /mysql-test/r/loaddata.result | |
| parent | 31d07866873631f79177fb1277bacfec62062c80 (diff) | |
| download | mariadb-git-c686f699b22c8ff7f3f9f2a6f550cdcb23db4793.tar.gz | |
Fix LOAD DATA to handle having the escape and enclosed-by character
be the same. (Bug #11203)
mysql-test/r/loaddata.result:
Update results
mysql-test/t/loaddata.test:
Add new test
sql/sql_load.cc:
Handle having escape_char and enclosed_char the same when loading
data.
mysql-test/std_data/loaddata5.dat:
New BitKeeper file ``mysql-test/std_data/loaddata5.dat''
Diffstat (limited to 'mysql-test/r/loaddata.result')
| -rw-r--r-- | mysql-test/r/loaddata.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/loaddata.result b/mysql-test/r/loaddata.result index c0baabcc507..cb9849ec23d 100644 --- a/mysql-test/r/loaddata.result +++ b/mysql-test/r/loaddata.result @@ -66,3 +66,11 @@ a b 3 row 3 0 drop table t1; +create table t1 (a varchar(20), b varchar(20)); +load data infile '../../std_data/loaddata5.dat' into table t1 fields terminated by ',' enclosed by '"' escaped by '"' (a,b); +select * from t1; +a b +field1 field2 +a"b cd"ef +a"b c"d"e +drop table t1; |