From a175314c3e5827eb193872241446f2f8f5c9d33c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:07:14 +0200 Subject: Adding upstream version 1:10.5.12. Signed-off-by: Daniel Baumann --- mysql-test/suite/engines/funcs/t/ld_simple.test | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 mysql-test/suite/engines/funcs/t/ld_simple.test (limited to 'mysql-test/suite/engines/funcs/t/ld_simple.test') diff --git a/mysql-test/suite/engines/funcs/t/ld_simple.test b/mysql-test/suite/engines/funcs/t/ld_simple.test new file mode 100644 index 00000000..1e150f8d --- /dev/null +++ b/mysql-test/suite/engines/funcs/t/ld_simple.test @@ -0,0 +1,13 @@ +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings +CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 VARCHAR(10), c3 DATETIME); +LOAD DATA LOCAL INFILE 'suite/engines/funcs/t/load_simple.inc' INTO TABLE t1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'; +SELECT * INTO OUTFILE '../../tmp/t1.dat' FROM t1; +SELECT * FROM t1 ORDER BY c1; +TRUNCATE TABLE t1; +LOAD DATA INFILE '../../tmp/t1.dat' INTO TABLE t1; +SELECT * FROM t1 ORDER BY c1; +remove_file $MYSQLTEST_VARDIR/tmp/t1.dat; +DROP TABLE t1; + -- cgit v1.2.3