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 Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.15 OS:Microsoft Windows (Windows XP Home)
Assigned to: Bugs System 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.