MySQL Bugs: #14746: Incorrect collation name listed in mysqlx_dbm

Bug #14746	Incorrect collation name listed in mysqlx_dbm_charsets.xml
Submitted:	8 Nov 2005 14:45	Modified:	30 Nov 2006 15:31
Reporter:	Gisbert Selke (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.17	OS:	Windows (Win XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	Generic

Description:
mysqlx_dbm_charsets.xml lists as one of the collations "latin1_german1".
The trailing "_ci" is missing. (The corresponding MySQL Administrator
file suffers from the same problem.)   As it stands, this is not a valid collation.

How to repeat:
in "edit table", try to edit some (var)char column to collation "latin1_german1", which is being offered as one of the choices. This will lead to "alter table..." failing.

Suggested fix:
Change "latin1_german1" to "latin1_german1_ci" in mysqlx_dbm_charsets.xml for both Query Browser and Administrator.

Thank you for the bug report.

<collation>
      <name>latin1_swedish_ci</name>
      <id>8</id>
      <is_default>1</is_default>
      <is_compiled>1</is_compiled>
      <sort_len>1</sort_len>
    </collation>
    <collation>
      <name>latin1_german1</name>
      <id>5</id>
      <is_compiled>1</is_compiled>
      <sort_len>1</sort_len>
    </collation>

c:\mysql\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.0.16-nt-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show collation like "latin1_ger%";
+-------------------+---------+----+---------+----------+---------+
| Collation         | Charset | Id | Default | Compiled | Sortlen |
+-------------------+---------+----+---------+----------+---------+
| latin1_german1_ci | latin1  |  5 |         |          |       0 |
| latin1_german2_ci | latin1  | 31 |         | Yes      |       2 |
+-------------------+---------+----+---------+----------+---------+
2 rows in set (0.00 sec)

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html