Bug #25830 SHOW TABLE STATUS behaves differently depending on table name
Submitted: 24 Jan 2007 15:21 Modified: 13 Mar 2009 20:08
Reporter: Mike Lischke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:5.0.27, 4.1 BK, 5.1 BK OS:Microsoft Windows (Windows XP Pro, Linux)
Assigned to: Sergey Glukhov
Triage: Triaged: D3 (Medium) / R1 (None/Negligible) / E2 (Low)

[24 Jan 2007 15:21] Mike Lischke
Description:
SHOW TABLE STATUS sometimes does not show a result if a table with non-ASCII name is used. This has to do with automatic lower case conversion of table names.

How to repeat:
1) Create a table "OOO", any structure should do it.
2) Issue a SHOW TABLE STATUS FROM test LIKE 'OOO';
3) It will return a line for the new table, but with 'ooo' as table name.
4) Do the same but name the table 'ÖÖÖ'.
5) A result is only returned if you specify 'ööö' in the SHOW TABLE STATUS command.

Suggested fix:
1) Find a consence on the automatic case conversion issue for case-insensitive file systems.
2) Apply this consence consistently to all commands.
[25 Jan 2007 20:11] Valerii Kravchuk
Thank you for a problem report. Please, send the results of:

SHOW VARIABLES LIKE 'char%';

from the same environment.
[26 Jan 2007 8:47] Mike Lischke
Query show variables like 'char%', Fri Jan 26 09:45:55 2007
Variable_name	Value
character_set_client	utf8
character_set_connection	utf8
character_set_database	utf8
character_set_filesystem	binary
character_set_results	utf8
character_set_server	utf8
character_set_system	utf8
character_sets_dir	C:\Programme\MySQL\MySQL Server 5.0\share\charsets\
[30 Jan 2007 10:42] Sveta Smirnova
test

Attachment: bug25830.test (application/octet-stream, text), 467 bytes.

[30 Jan 2007 10:42] Sveta Smirnova
options

Attachment: bug25830-master.opt (application/octet-stream, text), 55 bytes.

[30 Jan 2007 10:43] Sveta Smirnova
Thank you for the report.

Verified as described on Linux using last BK sources and attached test and options.
[10 Apr 2008 8:38] 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/45172

ChangeSet@1.2605, 2008-04-10 13:30:58+05:00, gluh@mysql.com +4 -0
  Bug#25830 SHOW TABLE STATUS behaves differently depending on table name
  replace wild_case_compare with my_wildcmp which is multibyte safe function
[10 Apr 2008 10:31] Alexander Barkov
http://lists.mysql.com/commits/45172  is ok to push.
[10 Apr 2008 16:19] Martin Hansson
Hi Gluh,
Just some minor remarks:

- What are the effects of the bug? Consider putting this in the cset comment.
- Please use uppercase for reserved SQL words in your test case.
- my_wildcmp is a macro (an unconditional one at that). Why don't you just call the function pointer files_charset_info->coll->wildcmp?

Anyways, I check my mark as the bug is fixed.
[18 Apr 2008 17:34] 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/45623

ChangeSet@1.2607, 2008-04-18 22:31:39+05:00, gluh@mysql.com +4 -0
  Bug#25830 SHOW TABLE STATUS behaves differently depending on table name
  replace wild_case_compare with my_wildcmp which is multibyte safe function
[28 May 2008 10:01] Bugs System
Pushed into 6.0.6-alpha
[24 Dec 2008 15:02] 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/62296

2722 Sergey Glukhov	2008-12-24
      Bug#25830 SHOW TABLE STATUS behaves differently depending on table name
      replace wild_case_compare with my_wildcmp which is multibyte safe function
[5 Jan 2009 10:41] 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/62474

2723 Georgi Kodinov	2009-01-05
      Reverted the fix for bug #25830 because of omissions and non-complete test
      case.
[6 Jan 2009 13:57] Bugs System
Pushed into 5.0.76 (revid:joro@sun.com-20090105160414-8q9j4bi1klkfwiup) (version source revid:kgeorge@mysql.com-20090105103756-kqu360iirnaj4lf8) (merge vers: 5.0.76) (pib:6)
[15 Jan 2009 6:36] Bugs System
Pushed into 5.1.31 (revid:joro@sun.com-20090115053147-tx1oapthnzgvs1ro) (version source revid:joro@sun.com-20090105184728-ocgzdp3ynu8p1vro) (merge vers: 5.1.31) (pib:6)
[19 Jan 2009 11:33] Bugs System
Pushed into 5.1.31-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090119095303-uwwvxiibtr38djii) (version source revid:tomas.ulin@sun.com-20090115073240-1wanl85vlvw2she1) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)
[19 Jan 2009 13:10] Bugs System
Pushed into 5.1.31-ndb-6.3.21 (revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (version source revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)
[19 Jan 2009 16:15] Bugs System
Pushed into 5.1.31-ndb-6.4.1 (revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (version source revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)
[20 Jan 2009 19:01] Bugs System
Pushed into 6.0.10-alpha (revid:joro@sun.com-20090119171328-2hemf2ndc1dxl0et) (version source revid:joro@sun.com-20090106165232-k93dttabhaiaigvr) (merge vers: 6.0.10-alpha) (pib:6)
[17 Feb 2009 14:23] 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/66668

2750 Sergey Glukhov	2009-02-17
      Bug#25830 SHOW TABLE STATUS behaves differently depending on table name(for 5.0 only)
      replace wild_case_compare with my_wildcmp which is multibyte safe function
[18 Feb 2009 11:41] Alexander Barkov
http://lists.mysql.com/commits/66668 ok to push for 5.0
[19 Feb 2009 13:04] Bugs System
Pushed into 6.0.10-alpha (revid:sergey.glukhov@sun.com-20090218125737-5y5b2xo3duo1wlvo) (version source revid:sergey.glukhov@sun.com-20090218125737-5y5b2xo3duo1wlvo) (merge vers: 6.0.10-alpha) (pib:6)
[27 Feb 2009 21:10] Paul Dubois
Noted in 6.0.10 changelog.

SHOW TABLE STATUS could fail to produce output for tables with 
non-ASCII characters in their name.

Setting report to NDI pending push into 5.0.x/5.1.x.
[9 Mar 2009 14:14] Bugs System
Pushed into 5.0.79 (revid:joro@sun.com-20090309135922-a0di9ebkxoj4d4wv) (version source revid:sergey.glukhov@sun.com-20090217142248-g1l9cpxva1j2fxp2) (merge vers: 5.0.79) (pib:6)
[9 Mar 2009 14:51] Paul Dubois
Noted in 5.0.79 changelog.

Setting report to NDI pending push into 5.1.x.
[13 Mar 2009 19:08] Bugs System
Pushed into 5.1.33 (revid:joro@sun.com-20090313111355-7bsi1hgkvrg8pdds) (version source revid:sergey.glukhov@sun.com-20090218120946-9lmwofaqme4dkvgm) (merge vers: 5.1.33) (pib:6)
[13 Mar 2009 20:08] Paul Dubois
Noted in 5.1.33 changelog.
[9 May 2009 16:47] Bugs System
Pushed into 5.1.34-ndb-6.2.18 (revid:jonas@mysql.com-20090508185236-p9b3as7qyauybefl) (version source revid:jonas@mysql.com-20090508100057-30ote4xggi4nq14v) (merge vers: 5.1.33-ndb-6.2.18) (pib:6)
[9 May 2009 17:44] Bugs System
Pushed into 5.1.34-ndb-6.3.25 (revid:jonas@mysql.com-20090509063138-1u3q3v09wnn2txyt) (version source revid:jonas@mysql.com-20090508175813-s6yele2z3oh6o99z) (merge vers: 5.1.33-ndb-6.3.25) (pib:6)
[9 May 2009 18:41] Bugs System
Pushed into 5.1.34-ndb-7.0.6 (revid:jonas@mysql.com-20090509154927-im9a7g846c6u1hzc) (version source revid:jonas@mysql.com-20090509073226-09bljakh9eppogec) (merge vers: 5.1.33-ndb-7.0.6) (pib:6)