--disable_warnings
drop table if exists t1,t2;
--enable_warnings

CREATE TABLE t1 (c1 INT, c2 INT);

CREATE TABLE t2 (id INT, c2 INT);

INSERT INTO t1 (c1, c2) VALUES (10, 9);
SELECT * FROM t1;

--exec rm -f $MYSQL_TEST_DIR/var/tmp/t1
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
eval SELECT * INTO OUTFILE '$MYSQL_TEST_DIR/var/tmp/t1' FIELDS ENCLOSED BY '0' FROM t1;
--exec cat $MYSQL_TEST_DIR/var/tmp/t1
--exec echo EOF

--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
eval LOAD DATA INFILE '$MYSQL_TEST_DIR/var/tmp/t1' INTO TABLE t2 FIELDS ENCLOSED BY '0';
SELECT * FROM t2;

--exec rm $MYSQL_TEST_DIR/var/tmp/t1
DROP TABLE t1,t2;