← 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-11-04 14:34:26 UTC
  • mfrom: (1902.1.3 build)
  • Revision ID: kalebral@gmail.com-20101104143426-7j06brcd847kl52n
Merge Stewart - some very simple HailDB plugin docs.
Merge Patrick - fix bug 666548: Several tests that make use of hard-coded paths for INFILE commands are failing when test-run used with --mem
Merge Stewart - fix some warnings when making docs.

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 '../../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
 
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
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 
28
 
SELECT *
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'
31
29
  FROM t1;
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