Bug #51399 Test "information_schema_chmod" fails on i5/os because "chmod" doesn't help

• Submitted: 22 Feb 2010 19:09
• Reporter: Joerg Bruehe
• Status: Verified
• Category: Tests: Server
• Severity: S3 (Non-critical)
• Version: 5.1 + 5.5
• OS: IBM i
• CPU Architecture: Any

[22 Feb 2010 19:09] Joerg Bruehe

Description:
Test "information_schema_chmod" fails on i5/os because the concept of making directories unreadable (by using "chmod") doesn't help there:

=====
main.information_schema_chmod            [ retry-fail ]
        Test ended at YYYY-MM-DD HH:MM:SS

CURRENT_TEST: main.information_schema_chmod
*** /PATH/mysql-test/r/information_schema_chmod.result
--- /PATH/mysql-test/r/information_schema_chmod.reject
***************
*** 2,5
--- 2,6
  create table mysqltest.t1(a int);
  select table_schema from information_schema.tables where table_schema='mysqltest';
  table_schema
+ mysqltest
  drop database mysqltest;

mysqltest: Result length mismatch
=====

Looking at the test, you see:
=====
...
#
# Bug #15851 Unlistable directories yield no info from information_schema
#
create database mysqltest;
create table mysqltest.t1(a int);
let $MYSQLD_DATADIR= `select @@datadir`;
chmod 0000 $MYSQLD_DATADIR/mysqltest;
select table_schema from information_schema.tables where table_schema='mysqltest';
chmod 0777 $MYSQLD_DATADIR/mysqltest;
drop database mysqltest;
=====

Obviously, this "chmod 0000" doesn't have the same effect on i5/os as it has on a decent Unix system.
(Or, the recognition of the server running as "root" user is broken.)

How to repeat:
Run the test suite.

Suggested fix:
Exclude the test on i5/os, as is done on Windows already.