← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/outfile.test

  • Committer: Brian Aker
  • Date: 2008-10-06 06:47:29 UTC
  • Revision ID: brian@tangent.org-20081006064729-2i9mhjkzyvow9xsm
Remove uint.

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