Bug #34852 SHOW OPEN TABLES output is not repeatable (show_check.test fails sporadically)
Submitted: 26 Feb 2008 18:29 Modified: 15 Mar 2008 21:35
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any

[26 Feb 2008 18:29] Alexander Nozdrin
Description:
Order of the tables in SHOW OPEN TABLES output is different.
That may mean either that this is the nature of 'SHOW OPEN TABLES' and
one should use
'SELECT * FROM INFORMATION_SCHEMA.OPEN_TABLES ORDER BY Database, Table'
instead. Or that may be a new bug in SHOW OPEN TABLES implementation.

The bug seems to appear on 2008-02-26 in 5.1-runtime tree.

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.show_check

Suggested fix:
- Fix SHOW OPEN TABLES

or

- Use 'SELECT * FROM INFORMATION_SCHEMA.OPEN_TABLES ORDER BY Database, Table'
  in show_check.test to make it stable.
[28 Feb 2008 12:35] 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/commits/43138

ChangeSet@1.2549, 2008-02-28 15:35:25+03:00, anozdrin@quad. +2 -0
  Fix for Bug#34852: SHOW OPEN TABLES output is not repeatable
  (show_check.test fails sporadically).
  
  Fix test case for Bug#12183 to make it stable.
[28 Feb 2008 14:40] Alexander Nozdrin
Pushed into 5.1-runtime.
[3 Mar 2008 18:19] Bugs System
Pushed into 5.1.24-rc
[3 Mar 2008 18:19] Bugs System
Pushed into 6.0.5-alpha
[15 Mar 2008 21:35] Jon Stephens
Test case only, no end-user changes to document; closed without further action.

NOTE: There is no INFORMATION_SCHEMA.OPEN_TABLES table!