diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2017-07-18 14:45:44 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2017-07-18 14:59:33 +0200 |
| commit | f6bcdb9e3c955f0a998a996edd93362deca31edf (patch) | |
| tree | aa353b2a5a73c49eb73571a12aea37fc66d72f21 /mysql-test/r/loadxml.result | |
| parent | 9a5fe1f4ea53f26690bfe2cd4f42050bfccaf4af (diff) | |
| download | mariadb-git-f6bcdb9e3c955f0a998a996edd93362deca31edf.tar.gz | |
test case for loadxml and spaces
Diffstat (limited to 'mysql-test/r/loadxml.result')
| -rw-r--r-- | mysql-test/r/loadxml.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/r/loadxml.result b/mysql-test/r/loadxml.result index 1128caf9122..250037f60b8 100644 --- a/mysql-test/r/loadxml.result +++ b/mysql-test/r/loadxml.result @@ -5,10 +5,10 @@ load xml infile '../../std_data/loadxml.dat' into table t1 rows identified by '<row>'; select * from t1 order by a; a b -1 b1 -2 b2 -3 b3 -11 b11 +1 b1 +2 b2 +3 b3 +11 b11 111 b111 112 b112 & < > " ' &unknown; -- check entities 212 b212 @@ -81,17 +81,17 @@ LOAD XML INFILE '../../std_data/loadxml.dat' INTO TABLE t1 ROWS IDENTIFIED BY '<row>' (a,@b) SET b=concat('!',@b); SELECT * FROM t1 ORDER BY a; a b -1 !b1 -11 !b11 +1 ! b1 +11 ! b11 111 !b111 112 !b112 & < > " ' &unknown; -- check entities -2 !b2 +2 ! b2 212 !b212 213 !b213 214 !b214 215 !b215 216 !&bb b; -3 !b3 +3 ! b3 DROP TABLE t1; # # Bug#16171518 LOAD XML DOES NOT HANDLE EMPTY ELEMENTS |