|
1
by brian
clean slate |
1 |
drop table if exists t1; |
2 |
create table t1 (`a` blob); |
|
3 |
insert into t1 values("hello world"),("Hello mars"),(NULL); |
|
4 |
select load_file(concat(@tmpdir,"/outfile-test.1")); |
|
5 |
load_file(concat(@tmpdir,"/outfile-test.1")) |
|
|
1813.2.12
by Monty Taylor
Made load_file work properly with throwing errors and opening files. |
6 |
hello world |
7 |
Hello mars |
|
8 |
\N |
|
9 |
||
|
1
by brian
clean slate |
10 |
select load_file(concat(@tmpdir,"/outfile-test.2")); |
11 |
load_file(concat(@tmpdir,"/outfile-test.2")) |
|
|
1813.2.12
by Monty Taylor
Made load_file work properly with throwing errors and opening files. |
12 |
hello world |
|
1
by brian
clean slate |
13 |
select load_file(concat(@tmpdir,"/outfile-test.3")); |
14 |
load_file(concat(@tmpdir,"/outfile-test.3")) |
|
|
1786.3.2
by Monty Taylor
Cleaned up the initial pass at this. It's not perfect, but it does work. |
15 |
NULL
|
|
1878.7.1
by patrick crews
Updated tests to use variable vardir rather than a hard-coded one |
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 |
|
|
1878.8.5
by patrick crews
Tweak func_str and outfile to deal with the limitations of only 128 chars available for filename + path in error messages |
19 |
select load_file(DRIZZLETEST_BAD_FILE); |
20 |
ERROR HY000: The file 'DRIZZLETEST_BAD_FILE' must be in the schema directory or be readable by all |
|
|
1
by brian
clean slate |
21 |
drop table t1; |
22 |
select load_file(concat(@tmpdir,"/outfile-test.4")); |
|
23 |
load_file(concat(@tmpdir,"/outfile-test.4")) |
|
|
1813.2.12
by Monty Taylor
Made load_file work properly with throwing errors and opening files. |
24 |
1
|
25 |
||
|
1
by brian
clean slate |
26 |
CREATE TABLE t1 (a INT); |
|
1878.7.1
by patrick crews
Updated tests to use variable vardir rather than a hard-coded one |
27 |
EXPLAIN SELECT * INTO OUTFILE 'DRIZZLETEST_VARDIR/tmp/t1.txt' |
28 |
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n' |
|
|
1
by brian
clean slate |
29 |
FROM t1; |
30 |
id select_type table type possible_keys key key_len ref rows Extra |
|
|
673.3.7
by Stewart Smith
fix outfile test |
31 |
1 SIMPLE t1 ALL NULL NULL NULL NULL 1 |
|
1
by brian
clean slate |
32 |
DROP TABLE t1; |
33 |
use test; |
|
34 |
create table t1(a int); |
|
|
319.1.1
by Grant Limberg
renamed all instances of MYSQL_ to DRIZZLE_ |
35 |
select * into outfile "DRIZZLE_TEST_DIR/outfile-test1" from t1; |
|
673.3.7
by Stewart Smith
fix outfile test |
36 |
ERROR HY000: The Drizzle server is running with the --secure-file-priv option so it cannot execute this statement |
|
1
by brian
clean slate |
37 |
drop table t1; |