Bug #14137 SHOW VARIABLES called on Windows shows a 'non-Windows' path
Submitted: 19 Oct 2005 13:54 Modified: 27 Oct 2005 4:37
Reporter: Carsten Segieth
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:5.0.15 OS:Microsoft Windows (Windows XP Home)
Assigned to: Bugs System Target Version:

[19 Oct 2005 13: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 13: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 18: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 17:11] Sergey Vlasenko
Fix available in 5.0.16
[27 Oct 2005 4:37] Paul DuBois
Noted in 5.0.16 changelog.