← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/outfile.result

  • Committer: Lee Bieber
  • Date: 2010-10-27 18:28:56 UTC
  • mfrom: (1883.1.3 build)
  • Revision ID: kalebral@gmail.com-20101027182856-q3wqtbv1t4egkjsk
Merge Andrew - fix bug 667360: --defaults-file not processed before paths read           
Merge Andrew - fix bug 656577: Importing SQL script results in silent failure    
Merge Andrew - fix bug 667053: drizzledump minor output cleanup needed

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/outfile.result
13
13
select load_file(concat(@tmpdir,"/outfile-test.3"));
14
14
load_file(concat(@tmpdir,"/outfile-test.3"))
15
15
NULL
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
 
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
 
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
 
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
21
21
drop table t1;
22
22
select load_file(concat(@tmpdir,"/outfile-test.4"));
23
23
load_file(concat(@tmpdir,"/outfile-test.4"))
24
24
1
25
25
 
26
26
CREATE TABLE t1 (a INT);
27
 
EXPLAIN SELECT * INTO OUTFILE 'DRIZZLETEST_VARDIR/tmp/t1.txt' 
28
 
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
 
27
EXPLAIN 
 
28
SELECT *
 
29
INTO OUTFILE '../../tmp/t1.txt'
 
30
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
29
31
  FROM t1;
30
32
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
31
33
1       SIMPLE  t1      ALL     NULL    NULL    NULL    NULL    1