Bug #79911 Get ERROR 1267 with string LIKE date

• Submitted: 11 Jan 2016 6:52
• Modified: 9 Dec 2019 21:44
• Reporter: Su Dylan
• Status: Closed
• Category: MySQL Server: DML
• Severity: S3 (Non-critical)
• Version: 5.7.8, 5.6.28, 5.7.10
• OS: Any
• CPU Architecture: Any

[11 Jan 2016 6:52] Su Dylan

Description:
Output:
=====
mysql> set names 'utf8';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT 'a' LIKE date '2016-01-01';
ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,NUMERIC) for operation 'like'

Problem:
=====
Success is expected.

How to repeat:
set names 'utf8';
SELECT 'a' LIKE date '2016-01-01';

Suggested fix:
Succeed.

[11 Jan 2016 7:25] MySQL Verification Team

Hello Su Dylan,

Thank you for the report and test case.
Observed that 5.6.28/5.7.10 are affected.

Thanks,
Umesh

[9 Dec 2019 21:44] Roy Lyseng

Posted by developer:
 
Fixed in 8.0.18