~drizzle-trunk/drizzle/development

drop table if exists t1;

create table t1 (`a` blob);

insert into t1 values("hello world"),("Hello mars"),(NULL);

select load_file(concat(@tmpdir,"/outfile-test.1"));

load_file(concat(@tmpdir,"/outfile-test.1"))

NULL

select load_file(concat(@tmpdir,"/outfile-test.2"));

load_file(concat(@tmpdir,"/outfile-test.2"))

NULL

select load_file(concat(@tmpdir,"/outfile-test.3"));

load_file(concat(@tmpdir,"/outfile-test.3"))

NULL

ERROR HY000: File '../../tmp/outfile-test.1' already exists

ERROR HY000: File '../../tmp/outfile-test.2' already exists

ERROR HY000: File '../../tmp/outfile-test.3' already exists

select load_file(concat(@tmpdir,"/outfile-test.not-exist"));

load_file(concat(@tmpdir,"/outfile-test.not-exist"))

NULL

drop table t1;

select load_file(concat(@tmpdir,"/outfile-test.4"));

load_file(concat(@tmpdir,"/outfile-test.4"))

NULL

CREATE TABLE t1 (a INT);

EXPLAIN 

SELECT *

INTO OUTFILE '../../tmp/t1.txt'

  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n'

  FROM t1;

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	1	

DROP TABLE t1;

use test;

create table t1(a int);

select * into outfile "DRIZZLE_TEST_DIR/outfile-test1" from t1;

ERROR HY000: The Drizzle server is running with the --secure-file-priv option so it cannot execute this statement

drop table t1;