Skip to content

Case-sensitive comparison of string literal #1232

@andy-wm-arthur

Description

@andy-wm-arthur

repro:

SELECT HEX(UNHEX('c0a80000')) = 'c0a80000', HEX(UNHEX('c0a80000'));

MySQL:

mysql> select HEX(UNHEX('c0a80000')) = 'c0a80000', HEX(UNHEX('c0a80000'));
+-------------------------------------+------------------------+
| HEX(UNHEX('c0a80000')) = 'c0a80000' | HEX(UNHEX('c0a80000')) |
+-------------------------------------+------------------------+
|                                   1 | C0A80000               |
+-------------------------------------+------------------------+
1 row in set (0.00 sec)

1 row in set (0.00 sec)

go-mysql-server (Dolt)

tmp> select HEX(UNHEX('c0a80000')) = 'c0a80000', HEX(UNHEX('c0a80000'));
+-------------------------------------+------------------------+
| HEX(UNHEX('c0a80000')) = 'c0a80000' | HEX(UNHEX('c0a80000')) |
+-------------------------------------+------------------------+
| false                               | C0A80000               |
+-------------------------------------+------------------------+

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions