1
2#
3# Due to "Bug#18474  Unlistable directories yield no info from
4# information_schema, part2" this test can't be run on Window with our
5# current test framework. When "chmod -r" is done within cygwin the
6# MySQL Server can still read the directory.
7# Manual testing shows the functionalty to skip unlistable directories
8# works on windows
9#
10--source include/not_windows.inc
11
12# This test uses chmod, can't be run with root permissions
13-- source include/not_as_root.inc
14
15
16#
17# Bug #15851 Unlistable directories yield no info from information_schema
18#
19create database mysqltest;
20create table mysqltest.t1(a int);
21let $MYSQLD_DATADIR= `select @@datadir`;
22chmod 0000 $MYSQLD_DATADIR/mysqltest;
23select table_schema from information_schema.tables where table_schema='mysqltest';
24chmod 0777 $MYSQLD_DATADIR/mysqltest;
25drop database mysqltest;
26