13
13
select load_file(concat(@tmpdir,"/outfile-test.3"));
14
14
load_file(concat(@tmpdir,"/outfile-test.3"))
16
ERROR HY000: File '../../tmp/outfile-test.1' already exists
17
ERROR HY000: File '../../tmp/outfile-test.2' already exists
18
ERROR HY000: File '../../tmp/outfile-test.3' already exists
16
ERROR HY000: File 'DRIZZLETEST_VARDIR/tmp/outfile-test.1' already exists
17
ERROR HY000: File 'DRIZZLETEST_VARDIR/tmp/outfile-test.2' already exists
18
ERROR HY000: File 'DRIZZLETEST_VARDIR/tmp/outfile-test.3' already exists
19
19
select load_file(concat(@tmpdir,"/outfile-test.not-exist"));
20
ERROR HY000: The file '../../tmp/outfile-test.not-exist' must be in the schema directory or be readable by all
20
ERROR HY000: The file 'DRIZZLETEST_VARDIR/tmp/outfile-test.not-exist' must be in the schema directory or be readable by all
22
22
select load_file(concat(@tmpdir,"/outfile-test.4"));
23
23
load_file(concat(@tmpdir,"/outfile-test.4"))
26
26
CREATE TABLE t1 (a INT);
29
INTO OUTFILE '../../tmp/t1.txt'
30
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
27
EXPLAIN SELECT * INTO OUTFILE 'DRIZZLETEST_VARDIR/tmp/t1.txt'
28
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
32
30
id select_type table type possible_keys key key_len ref rows Extra
33
31
1 SIMPLE t1 ALL NULL NULL NULL NULL 1