Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.40, 10.0.14, 10.1(EOL)
-
None
Description
mysql> SELECT '10' COLLATE utf8_general_ci XOR '20' COLLATE utf8_unicode_ci;
|
ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,EXPLICIT) and (utf8_unicode_ci,EXPLICIT) for operation 'xor'
|
XOR is a numeric operation. It should not aggregate collations. The above query should return a result without an error.
Notice, the other numeric operations work without problems:
mysql> SELECT '10' COLLATE utf8_general_ci + '20' COLLATE utf8_unicode_ci;
|
+-------------------------------------------------------------+
|
| '10' COLLATE utf8_general_ci + '20' COLLATE utf8_unicode_ci |
|
+-------------------------------------------------------------+
|
| 30 |
|
+-------------------------------------------------------------+
|
1 row in set (0.00 sec)
|