diff options
| author | unknown <gluh@eagle.intranet.mysql.r18.ru> | 2005-10-07 14:16:44 +0500 |
|---|---|---|
| committer | unknown <gluh@eagle.intranet.mysql.r18.ru> | 2005-10-07 14:16:44 +0500 |
| commit | 9ea8ce72ff73614191ab770812087e5f9629ac85 (patch) | |
| tree | a805b676320dd81004ea2eae71ee99289c9c5360 /mysql-test/t/outfile.test | |
| parent | a9363ce9c3d7569ea00384a71829a21ecebadff0 (diff) | |
| download | mariadb-git-9ea8ce72ff73614191ab770812087e5f9629ac85.tar.gz | |
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
Diffstat (limited to 'mysql-test/t/outfile.test')
| -rw-r--r-- | mysql-test/t/outfile.test | 18 |
1 files changed, 18 insertions, 0 deletions
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 |