2
# Tests for "LOAD XML" - a contributed patch from Erik Wetterberg.
6
drop table if exists t1;
9
create table t1 (a int, b varchar(64));
12
--echo -- Load a static XML file
13
load xml infile '../std_data_ln/loadxml.dat' into table t1
14
rows identified by '<row>';
15
select * from t1 order by a;
19
--echo -- Load a static XML file with 'IGNORE num ROWS'
20
load xml infile '../std_data_ln/loadxml.dat' into table t1
21
rows identified by '<row>' ignore 4 rows;
22
select * from t1 order by a;
25
--echo -- Check 'mysqldump --xml' + 'LOAD XML' round trip
26
--exec $DRIZZLE_DUMP --xml test t1 > "$MYSQLTEST_VARDIR/loadxml-dump.xml" 2>&1
28
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
29
--eval load xml infile '$MYSQLTEST_VARDIR/loadxml-dump.xml' into table t1 rows identified by '<row>';
30
select * from t1 order by a;
32
--echo --Check that default row tag is '<row>
34
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
35
--eval load xml infile '$MYSQLTEST_VARDIR/loadxml-dump.xml' into table t1;
36
select * from t1 order by a;
38
--echo -- Check that 'xml' is not a keyword
45
--system rm $MYSQLTEST_VARDIR/loadxml-dump.xml