Bug #51399 Test "information_schema_chmod" fails on i5/os because "chmod" doesn't help
Submitted: 22 Feb 2010 19:09
Reporter: Joerg Bruehe Email Updates:
Status: Verified Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.1 + 5.5 OS:IBM i
Assigned to: CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[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.