outfile.test 2.36 KB
Newer Older
1 2
disable_query_log;
-- source include/test_outfile.inc
3 4
# Server are started in "var/master-data", so "../tmp" will be "var/tmp"
eval set @tmpdir="../tmp";
5 6
enable_query_log;
-- source include/have_outfile.inc
unknown's avatar
unknown committed
7

8 9 10 11
#
# test of into outfile|dumpfile
#

12 13 14 15
--disable_warnings
drop table if exists t1;
--enable_warnings

16 17 18
create table t1 (`a` blob);
insert into t1 values("hello world"),("Hello mars"),(NULL);
disable_query_log;
19
eval select * into outfile "../tmp/outfile-test.1" from t1;
20 21 22
enable_query_log;
select load_file(concat(@tmpdir,"/outfile-test.1"));
disable_query_log;
23
eval select * into dumpfile "../tmp/outfile-test.2" from t1 limit 1;
24 25 26
enable_query_log;
select load_file(concat(@tmpdir,"/outfile-test.2"));
disable_query_log;
27
eval select * into dumpfile "../tmp/outfile-test.3" from t1 where a is null;
28 29
enable_query_log;
select load_file(concat(@tmpdir,"/outfile-test.3"));
30

31 32
# the following should give errors

33 34 35 36 37 38 39 40 41 42
disable_query_log;
--error 1086
eval select * into outfile "../tmp/outfile-test.1" from t1;

--error 1086
eval select * into dumpfile "../tmp/outfile-test.2" from t1;

--error 1086
eval select * into dumpfile "../tmp/outfile-test.3" from t1;
enable_query_log;
43
select load_file(concat(@tmpdir,"/outfile-test.not-exist"));
44 45 46
--exec rm $MYSQLTEST_VARDIR/tmp/outfile-test.1
--exec rm $MYSQLTEST_VARDIR/tmp/outfile-test.2
--exec rm $MYSQLTEST_VARDIR/tmp/outfile-test.3
47 48 49 50
drop table t1;

# Bug#8191
disable_query_log;
51
eval select 1 into outfile "../tmp/outfile-test.4";
52 53
enable_query_log;
select load_file(concat(@tmpdir,"/outfile-test.4"));
54
--exec rm $MYSQLTEST_VARDIR/tmp/outfile-test.4
55 56 57 58 59 60 61 62 63 64 65 66

#
# Bug #5382: 'explain select into outfile' crashes the server
#

CREATE TABLE t1 (a INT);
EXPLAIN 
  SELECT *
  INTO OUTFILE '/tmp/t1.txt'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
  FROM t1;
DROP TABLE t1;
67 68

# End of 4.1 tests
69 70 71 72 73

#
# Bug#13202  SELECT * INTO OUTFILE ... FROM information_schema.schemata now fails
#
disable_query_log;
74
eval SELECT * INTO OUTFILE "../tmp/outfile-test.4"
75 76 77
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
FROM information_schema.schemata LIMIT 0, 5;
# enable_query_log;
78
--exec rm $MYSQLTEST_VARDIR/tmp/outfile-test.4
79 80 81

use information_schema;
# disable_query_log;
82
eval SELECT * INTO OUTFILE "../tmp/outfile-test.4"
83 84 85
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
FROM schemata LIMIT 0, 5;
enable_query_log;
86
--exec rm $MYSQLTEST_VARDIR/tmp/outfile-test.4