← 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-01 13:06:31 UTC
  • mfrom: (1802.2.2 drizzle-bug-651948)
  • mto: This revision was merged to the branch mainline in revision 1805.
  • Revision ID: lbieber@orisndriz08-20101001130631-xubscnhmj7r5dn6g
Merge Andrew - Fix bug 651948 - Index lengths not retrieved using drizzledump

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
 
hello world
7
 
Hello mars
8
 
\N
9
 
 
 
6
NULL
10
7
select load_file(concat(@tmpdir,"/outfile-test.2"));
11
8
load_file(concat(@tmpdir,"/outfile-test.2"))
12
 
hello world
 
9
NULL
13
10
select load_file(concat(@tmpdir,"/outfile-test.3"));
14
11
load_file(concat(@tmpdir,"/outfile-test.3"))
15
12
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
 
13
ERROR HY000: File '../../tmp/outfile-test.1' already exists
 
14
ERROR HY000: File '../../tmp/outfile-test.2' already exists
 
15
ERROR HY000: File '../../tmp/outfile-test.3' already exists
 
16
select load_file(concat(@tmpdir,"/outfile-test.not-exist"));
 
17
load_file(concat(@tmpdir,"/outfile-test.not-exist"))
 
18
NULL
21
19
drop table t1;
22
20
select load_file(concat(@tmpdir,"/outfile-test.4"));
23
21
load_file(concat(@tmpdir,"/outfile-test.4"))
24
 
1
25
 
 
 
22
NULL
26
23
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'
 
24
EXPLAIN 
 
25
SELECT *
 
26
INTO OUTFILE '../../tmp/t1.txt'
 
27
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
29
28
  FROM t1;
30
29
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
31
30
1       SIMPLE  t1      ALL     NULL    NULL    NULL    NULL    1