← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/outfile.test

Merged up with brian.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/outfile.test
5
5
enable_query_log;
6
6
-- source include/have_outfile.inc
7
7
 
 
8
--disable_warnings
 
9
DROP SCHEMA IF EXISTS data_dictionary;
 
10
--enable_warnings
 
11
 
 
12
CREATE SCHEMA data_dictionary;
 
13
 
8
14
#
9
15
# test of into outfile|dumpfile
10
16
#
68
74
# End of 4.1 tests
69
75
 
70
76
#
71
 
# Bug#13202  SELECT * INTO OUTFILE ... FROM information_schema.schemata now fails
 
77
# Bug#13202  SELECT * INTO OUTFILE ... FROM data_dictionary.schemas now fails
72
78
#
73
79
disable_query_log;
74
80
eval SELECT * INTO OUTFILE "../tmp/outfile-test.4"
75
81
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
76
 
FROM information_schema.schemata LIMIT 0, 5;
 
82
FROM data_dictionary.schemas LIMIT 0, 5;
77
83
# enable_query_log;
78
84
--remove_file $MYSQLTEST_VARDIR/tmp/outfile-test.4
79
85
 
80
 
use information_schema;
 
86
use data_dictionary;
81
87
# disable_query_log;
82
88
eval SELECT * INTO OUTFILE "../tmp/outfile-test.4"
83
89
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
84
 
FROM schemata LIMIT 0, 5;
 
90
FROM schemas LIMIT 0, 5;
85
91
enable_query_log;
86
92
--remove_file $MYSQLTEST_VARDIR/tmp/outfile-test.4
87
93
use test;
95
101
--error 1290
96
102
eval select * into outfile "$DRIZZLE_TEST_DIR/outfile-test1" from t1;
97
103
drop table t1;
 
104
 
 
105
DROP SCHEMA data_dictionary;