Bug #72565 gb18030_chinese_ci erroneously considers 'Y' is equal to '~'

• Submitted: 8 May 2014 6:33
• Modified: 9 Jun 2014 23:54
• Reporter: Alexander Barkov
• Status: Closed
• Category: MySQL Server: Charsets
• Severity: S3 (Non-critical)
• Version: 5.7.5
• OS: Any
• CPU Architecture: Any

[8 May 2014 6:33] Alexander Barkov

Description:
It seems there is a bug in gb18030_chinese_ci that erroneously
treats 'Y' as equal to '~'.

How to repeat:
mysql> set names gb18030; select 'Y'='~';
Query OK, 0 rows affected (0.00 sec)

+---------+
| 'Y'='~' |
+---------+
|       1 |
+---------+
1 row in set (0.00 sec)

[8 May 2014 7:25] MySQL Verification Team

Hello!

Thank you for the bug report.
Verified as described.

Thanks,
Umesh

[8 May 2014 7:25] MySQL Verification Team

// 5.7.5 - affected

mysql> select version();
+----------------------------------------------+
| version()                                    |
+----------------------------------------------+
| 5.7.5-m15-enterprise-commercial-advanced-log |
+----------------------------------------------+
1 row in set (0.00 sec)

mysql> set names gb18030; select 'Y'='~';
Query OK, 0 rows affected (0.00 sec)

+---------+
| 'Y'='~' |
+---------+
|       1 |
+---------+
1 row in set (0.00 sec)

[9 Jun 2014 23:54] Paul DuBois

Noted in 5.7.5 changelog.

The gb18030_chinese_ci character set treated 'Y' equal to '~'.

[9 Jun 2014 23:59] Paul DuBois

Correction: gb18030_chinese_ci collation, not character set.