[#MDEV-7366] SELECT 'a' = BINARY 'A' returns 1 (utf8 charset, utf8_unicode

[MDEV-7366] SELECT 'a' = BINARY 'A' returns 1 (utf8 charset, utf8_unicode_ci collation) Created: 2014-12-23 Updated: 2015-01-17 Resolved: 2015-01-17
Status:	Closed
Project:	MariaDB Server
Component/s:	Character Sets
Affects Version/s:	10.0.14, 10.0.15
Fix Version/s:	10.0.16

Type:

Bug

Priority:

Major

Reporter:

Pim Broekhof

Assignee:

Alexander Barkov

Resolution:

Fixed

Votes:

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.

Generated at Thu Feb 08 07:19:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.