From 9ea8ce72ff73614191ab770812087e5f9629ac85 Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 7 Oct 2005 14:16:44 +0500 Subject: Fix for bug#13202 SELECT * INTO OUTFILE ... FROM information_schema.schemata now fails allow select into outfile from I_S tables it is enough to add FILE_ACL for I_S tables only to 'check_table_access' function as we use 'any_db' for 'check_access' function in places where FILE_ACL is required mysql-test/t/outfile.test: Fix for bug#13202 SELECT * INTO OUTFILE ... FROM information_schema.schemata now fails test case --- mysql-test/t/outfile.test | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) (limited to 'mysql-test/t') diff --git a/mysql-test/t/outfile.test b/mysql-test/t/outfile.test index a74bebe1460..37e96d9d38d 100644 --- a/mysql-test/t/outfile.test +++ b/mysql-test/t/outfile.test @@ -65,3 +65,21 @@ EXPLAIN DROP TABLE t1; # End of 4.1 tests + +# +# Bug#13202 SELECT * INTO OUTFILE ... FROM information_schema.schemata now fails +# +disable_query_log; +eval SELECT * INTO OUTFILE "$MYSQL_TEST_DIR/var/tmp/outfile-test.4" +FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' +FROM information_schema.schemata LIMIT 0, 5; +# enable_query_log; +--exec rm $MYSQL_TEST_DIR/var/tmp/outfile-test.4 + +use information_schema; +# disable_query_log; +eval SELECT * INTO OUTFILE "$MYSQL_TEST_DIR/var/tmp/outfile-test.4" +FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' +FROM schemata LIMIT 0, 5; +enable_query_log; +--exec rm $MYSQL_TEST_DIR/var/tmp/outfile-test.4 -- cgit v1.2.1