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

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.

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.