← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/outfile.test

  • Committer: Stewart Smith
  • Date: 2008-12-16 03:40:00 UTC
  • mto: This revision was merged to the branch mainline in revision 692.
  • Revision ID: stewart@flamingspork.com-20081216034000-1wbt7khar8aqxs9q
fix outfile test

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/outfile.test
95
95
--error 1290
96
96
eval select * into outfile "$DRIZZLE_TEST_DIR/outfile-test1" from t1;
97
97
drop table t1;
98
 
 
99
 
#
100
 
# Bug#28181 Access denied to 'information_schema when
101
 
# select into out file (regression)
102
 
#
103
 
create database mysqltest;
104
 
create user user_1@localhost;
105
 
grant all on mysqltest.* to user_1@localhost;
106
 
connect (con28181_1,localhost,user_1,,mysqltest);
107
 
 
108
 
--error ER_ACCESS_DENIED_ERROR 
109
 
eval select schema_name
110
 
into outfile "../tmp/outfile-test.4"
111
 
fields terminated by ',' optionally enclosed by '"'
112
 
 lines terminated by '\n'
113
 
from information_schema.schemata
114
 
where schema_name like 'mysqltest';
115
 
 
116
 
connection default;
117
 
grant file on *.* to user_1@localhost;
118
 
 
119
 
connect (con28181_2,localhost,user_1,,mysqltest);
120
 
eval select schema_name
121
 
into outfile "../tmp/outfile-test.4"
122
 
fields terminated by ',' optionally enclosed by '"'
123
 
 lines terminated by '\n'
124
 
from information_schema.schemata
125
 
where schema_name like 'mysqltest';
126
 
 
127
 
connection default;
128
 
--exec rm $MYSQLTEST_VARDIR/tmp/outfile-test.4
129
 
use test;
130
 
revoke all privileges on *.* from user_1@localhost;
131
 
drop user user_1@localhost;
132
 
drop database mysqltest;
133