← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/outfile.result

  • Committer: lbieber
  • Date: 2010-10-07 15:39:23 UTC
  • mfrom: (1819.1.2 build)
  • Revision ID: lbieber@orisndriz08-20101007153923-e9rwa9ha5oyhjdc2
Merge Monty - Bug 655294: load_data() function returns null if file is invalid 
Merge Monty - Bug 655342: select into outfile creates a garbage file on no results
Merge Monty - Fixes the haildb build

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/outfile.result
3
3
insert into t1 values("hello world"),("Hello mars"),(NULL);
4
4
select load_file(concat(@tmpdir,"/outfile-test.1"));
5
5
load_file(concat(@tmpdir,"/outfile-test.1"))
6
 
NULL
 
6
hello world
 
7
Hello mars
 
8
\N
 
9
 
7
10
select load_file(concat(@tmpdir,"/outfile-test.2"));
8
11
load_file(concat(@tmpdir,"/outfile-test.2"))
9
 
NULL
 
12
hello world
10
13
select load_file(concat(@tmpdir,"/outfile-test.3"));
11
14
load_file(concat(@tmpdir,"/outfile-test.3"))
12
15
NULL
14
17
ERROR HY000: File '../../tmp/outfile-test.2' already exists
15
18
ERROR HY000: File '../../tmp/outfile-test.3' already exists
16
19
select load_file(concat(@tmpdir,"/outfile-test.not-exist"));
17
 
load_file(concat(@tmpdir,"/outfile-test.not-exist"))
18
 
NULL
 
20
ERROR HY000: The file '../../tmp/outfile-test.not-exist' must be in the database directory or be readable by all
19
21
drop table t1;
20
22
select load_file(concat(@tmpdir,"/outfile-test.4"));
21
23
load_file(concat(@tmpdir,"/outfile-test.4"))
22
 
NULL
 
24
1
 
25
 
23
26
CREATE TABLE t1 (a INT);
24
27
EXPLAIN 
25
28
SELECT *