MySQL Bugs: #18035: Information Schema: Output is not Sorted

Bug #18035	Information Schema: Output is not Sorted
Submitted:	7 Mar 2006 14:43	Modified:	6 Jun 2006 16:05
Reporter:	Joerg Bruehe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Information schema	Severity:	S3 (Non-critical)
Version:	5.0.19	OS:	Other (SCO OSR 6)
Assigned to:	Sergei Glukhov	CPU Architecture:	Any

Description:
Release build of 5.0.19.

The error occurred in only one of the ten runs of this test
(five builds, for each there was both a default and a  PS protocol test run).

This error could not be found in any previous log.

-------------------------------------------------------
*** r/information_schema.result
--- r/information_schema.reject
***************
*** 912,917
  'user3'@'localhost'   NULL    mysqltest       SELECT  NO
  select * from information_schema.user_privileges where grantee like '%user%';
  GRANTEE       TABLE_CATALOG   PRIVILEGE_TYPE  IS_GRANTABLE
  'user1'@'localhost'   NULL    USAGE   NO
  'user2'@'localhost'   NULL    USAGE   NO
  'user3'@'localhost'   NULL    USAGE   NO
--- 912,918
  'user3'@'localhost'   NULL    mysqltest       SELECT  NO
  select * from information_schema.user_privileges where grantee like '%user%';
  GRANTEE       TABLE_CATALOG   PRIVILEGE_TYPE  IS_GRANTABLE
+ 'user3'@'localhost'   NULL    USAGE   NO
  'user1'@'localhost'   NULL    USAGE   NO
  'user2'@'localhost'   NULL    USAGE   NO
  'user4'@'localhost'   NULL    SELECT  NO
***************
*** 914,920
  GRANTEE       TABLE_CATALOG   PRIVILEGE_TYPE  IS_GRANTABLE
  'user1'@'localhost'   NULL    USAGE   NO
  'user2'@'localhost'   NULL    USAGE   NO
- 'user3'@'localhost'   NULL    USAGE   NO
  'user4'@'localhost'   NULL    SELECT  NO
  show grants;
  Grants for user4@localhost
--- 915,920
  'user3'@'localhost'   NULL    USAGE   NO
  'user1'@'localhost'   NULL    USAGE   NO
  'user2'@'localhost'   NULL    USAGE   NO
  'user4'@'localhost'   NULL    SELECT  NO
  show grants;
  Grants for user4@localhost
-------------------------------------------------------

opnsrv6c-5.0-standard.log   normal

(I really think that output is broken, it reports the same difference in two ways.)

How to repeat:
Test suite.

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/6955

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/7310

Fixed in 5.0.23

Test case change only. No changelog entry needed.