~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/t/information_schema_chmod.test

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-03-17 14:56:02 UTC
  • Revision ID: james.westby@ubuntu.com-20100317145602-x7e30l1b2sb5s6w6
Tags: upstream-5.1.45
ImportĀ upstreamĀ versionĀ 5.1.45

Show diffs side-by-side

added added

removed removed

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