Bug #10659 information_schema_db fail on Mac OS
Submitted: 16 May 2005 9:15 Modified: 24 May 2005 11:05
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0 OS:MacOS (Mac OS)
Assigned to: Sergei Glukhov CPU Architecture:Any

[16 May 2005 9:15] Oleksandr Byelkin 
Description:
information_schema_db          [ fail ]

Errors are (from /Users/bell/mysql/bk/work-bug-5.0/mysql-test/var/log/mysqltest-time) :
/Users/bell/mysql/bk/work-bug-5.0/client/.libs/mysqltest: At line 10: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/information_schema_db.result      Fri May 13 09:23:06 2005
--- r/information_schema_db.reject      Mon May 16 12:05:18 2005
***************
*** 1,6 ****
  use INFORMATION_SCHEMA;
  show tables;
! Tables_in_INFORMATION_SCHEMA
  SCHEMATA
  TABLES
  COLUMNS
--- 1,6 ----
  use INFORMATION_SCHEMA;
  show tables;
! Tables_in_information_schema
  SCHEMATA
  TABLES
  COLUMNS
***************
*** 17,23 ****
  TABLE_CONSTRAINTS
  KEY_COLUMN_USAGE
  show tables from INFORMATION_SCHEMA like 'T%';
! Tables_in_INFORMATION_SCHEMA (T%)
  TABLES
  TABLE_PRIVILEGES
  TABLE_CONSTRAINTS
--- 17,23 ----
  TABLE_CONSTRAINTS
  KEY_COLUMN_USAGE
  show tables from INFORMATION_SCHEMA like 'T%';
! Tables_in_information_schema (T%)
  TABLES
  TABLE_PRIVILEGES
  TABLE_CONSTRAINTS
-------------------------------------------------------

How to repeat:
./mysql-test-run information_schema_db
[18 May 2005 7:29] Bugs System 
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/internals/25005
[24 May 2005 9:09] Bugs System 
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/internals/25204
[24 May 2005 11:05] Sergei Glukhov 
Fixed in 5.0.6 tree