← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/outfile.result

  • Committer: patrick crews
  • Date: 2010-10-26 01:31:08 UTC
  • mfrom: (1878.7.1 drizzle)
  • mto: (1902.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1903.
  • Revision ID: gleebix@gmail.com-20101026013108-t2c3nokk4k8a7sxk
https://launchpad.net/bugs/666548
Updated tests to use variable vardir rather than a hard-coded one

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
 
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
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
 
20
ERROR HY000: The file 'DRIZZLETEST_VARDIR/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 
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