Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0.14, 10.0.15
-
Fix Version/s: 10.0.16
-
Component/s: Character Sets
-
Labels:None
Description
In MariaDB 10.0.14 and higher, the following expressions return inconsistent values.
SET NAMES utf8 COLLATE utf8_unicode_ci; |
SELECT 'a' = BINARY 'A'; /* yields 1, expected 0 */ |
SELECT BINARY 'A' = 'a'; /* yields 0, expected 0 */ |
The problem occurs when 'a' has a case insensitive utf8 collation.
MariaDB 10.0.13 does yield 0 in both cases.