Bug #462 "SET CHARACTER SET DEFAULT" is not working

• Submitted: 20 May 2003 13:39
• Modified: 1 Jul 2003 7:11
• Reporter: [ name withheld ]
• Status: Closed
• Category: Server
• Severity: S2 (Serious)
• Version: 4.0.13
• OS: Any (All)

[20 May 2003 13:39] [ name withheld ]

Description:
If I change character set mapping with SET CHARACTER SET character set name,
I can't change it to DEFAULT (ie. disable mapping) with SET CHARACTER SET
DEFAULT.

How to repeat:
1) Install MySQL from binary distribution.
2) Look at "SHOW VARIABLES", variable "convert_character_set" is empty.
3) Execute "SET CHARACTER SET cp1251_koi8"
4) Look at "SHOW VARIABLES", variable "convert_character_set" is "cp1251_koi8". This is
OK.
5) Execute "SET CHARACTER SET DEFAULT"
6) Look at "SHOW VARIABLES", variable "convert_character_set" is "cp1251_koi8". It should
be empty like in point 2.

Suggested fix:
Sorry, dunno.

[22 May 2003 7:33] [ name withheld ]

I tested it on FreeBSD 4.x and Windows XP. Same bug was in 4.0.12 and I didn't tested
earlier 4.0.x versions. In 3.23.x character mapping can be disabled with SET CHARACTER
SET DEFAULT without any problem.

[1 Jul 2003 7:11] Michael Widenius

Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 
    http://www.mysql.com/doc/en/Installing_source_tree.html

Will be fixed in 4.0.14