Bug #14137 SHOW VARIABLES called on Windows shows a 'non-Windows' path

• Submitted: 19 Oct 2005 11:54
• Modified: 27 Oct 2005 2:37
• Reporter: Carsten Segieth
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.15
• OS: Windows (Windows XP Home)
• Assigned to: Sergey Vlasenko
• CPU Architecture: Any

[19 Oct 2005 11:54] Carsten Segieth

Description:
SHOW VARIABLES; called in mysql.exe on Windows shows the "character_sets_dir" with a trailing '/' instead of '\' like for the other variables:

mysql> show variables ;
+---------------------------------+----------------------------------------------------------------+
| Variable_name                   | Value                                                          |
+---------------------------------+----------------------------------------------------------------+
...
| basedir                         | D:\MySQL\Server-5.0\                                           
...
| character_sets_dir              | D:\MySQL\Server-5.0\share\charsets/                            

This is not a Windows like format of a path.

How to repeat:
- install 5.0.15 to a 'non standard path' (I didn't check with the standard path), without modifying the security settings
- mysql -u root
- SHOW VARIABLES;

Suggested fix:
replace trailing '/' with '\'

[19 Oct 2005 11:57] Carsten Segieth

may be not clearly enough described above: the only "wrong" path seen is in "character_sets_dir". All other looks OK.

[24 Oct 2005 16: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/31382

[26 Oct 2005 15:11] Sergey Vlasenko

Fix available in 5.0.16

[27 Oct 2005 2:37] Paul DuBois

Noted in 5.0.16 changelog.