MySQL Bugs: #28895: Test 'information_schema

Bug #28895	Test 'information_schema_db' fails on i5/OS 32 bit
Submitted:	5 Jun 2007 12:52	Modified:	18 Jun 2007 15:31
Reporter:	Kent Boortz	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S7 (Test Cases)
Version:	5.0, 5.1	OS:	Any
Assigned to:	Alexey Kopytov	CPU Architecture:	Any

Description:
Moving an existing AIX 5.2 32 bit binary of MySQL 5.0.42,
or building one on the i5/OS host using VisualAge 6,
results in one test failure

-------------------------------------------------------
*** r/information_schema_db.result      Mon May 14 17:10:26 2007
--- r/information_schema_db.reject      Thu May 31 18:01:28 2007
***************
*** 125,136 ****
  v6    CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v6` AS select `t1`.`f1` AS `f1` from `t1`
  show create view testdb_1.v7;
  View  Create View
! v7    CREATE ALGORITHM=UNDEFINED DEFINER=`no_such_user`@`no_such_host` SQL SECURITY DEFINER VIEW `v7` AS select `testdb_1`.`t2`.`f1` AS `f1` from `t2`
  Warnings:
! Warning       1356    View 'testdb_1.v7' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  show fields from testdb_1.v7;
  Field Type    Null    Key     Default Extra
! f1    null    YES             NULL
  Warnings:
  Note  1449    There is no 'no_such_user'@'no_such_host' registered
  create table t3 (f1 char(4), f2 char(4));
--- 125,136 ----
  v6    CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v6` AS select `t1`.`f1` AS `f1` from `t1`
  show create view testdb_1.v7;
  View  Create View
! v7    CREATE ALGORITHM=UNDEFINED DEFINER=`no_such_user`@`no_such_host` SQL SECURITY DEFINER VIEW `v7` AS select `t2`.`f1` AS `f1` from `t2`
  Warnings:
! Note  1449    There is no 'no_such_user'@'no_such_host' registered
  show fields from testdb_1.v7;
  Field Type    Null    Key     Default Extra
! f1    char(4) YES             NULL
  Warnings:
  Note  1449    There is no 'no_such_user'@'no_such_host' registered
  create table t3 (f1 char(4), f2 char(4));
***************
*** 152,165 ****
  v6    CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `testdb_1`.`v6` AS select `testdb_1`.`t1`.`f1` AS `f1` from `testdb_1`.`t1`
  show fields from testdb_1.v7;
  Field Type    Null    Key     Default Extra
! f1    null    YES             NULL
  Warnings:
  Note  1449    There is no 'no_such_user'@'no_such_host' registered
  show create view testdb_1.v7;
  View  Create View
! v7    CREATE ALGORITHM=UNDEFINED DEFINER=`no_such_user`@`no_such_host` SQL SECURITY DEFINER VIEW `v7` AS select `testdb_1`.`t2`.`f1` AS `f1` from `t2`
  Warnings:
! Warning       1356    View 'testdb_1.v7' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  revoke insert(f1) on v3 from testdb_2@localhost;
  revoke show view on v5 from testdb_2@localhost;
  use testdb_1;
--- 152,165 ----
  v6    CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `testdb_1`.`v6` AS select `testdb_1`.`t1`.`f1` AS `f1` from `testdb_1`.`t1`
  show fields from testdb_1.v7;
  Field Type    Null    Key     Default Extra
! f1    char(4) YES             NULL
  Warnings:
  Note  1449    There is no 'no_such_user'@'no_such_host' registered
  show create view testdb_1.v7;
  View  Create View
! v7    CREATE ALGORITHM=UNDEFINED DEFINER=`no_such_user`@`no_such_host` SQL SECURITY DEFINER VIEW `v7` AS select `t2`.`f1` AS `f1` from `t2`
  Warnings:
! Note  1449    There is no 'no_such_user'@'no_such_host' registered
  revoke insert(f1) on v3 from testdb_2@localhost;
  revoke show view on v5 from testdb_2@localhost;
  use testdb_1;
-------------------------------------------------------

How to repeat:
Run the test case on a i5/OS host with PASE
AIX emulation using the AIX 5.2 32 bit binary

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/28146

ChangeSet@1.2485, 2007-06-05 22:18:07+04:00, kaa@polly.local +2 -0
  Fix for bug #28895 "Test 'information_schema_db' fails on i5/OS 32 bit".
  
  In acl_getroot_no_password(), use a separate variable for traversing the acl_users list so that the last entry is not used when no matching entries are found.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/28270

ChangeSet@1.2539, 2007-06-07 12:45:37+04:00, kaa@polly.local +1 -0
  Fixed tests that relied on broken behavior in acl_getroot_no_password(). 
  
  This is to fix PB failures introduced by the patch for bug #28895.

Pushed into 5.0.44

Pushed into 5.1.20-beta

Noted in 5.0.44, 5.1.20 changelogs.

Using a VIEW created with a non-existing DEFINER could lead to
incorrect results under some circumstances.