[MDEV-8729] Wrong result for SELECT..WHERE HEX(enum_column)='61' AND enum_column='a ' - Jira

XML

Word

Printable

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a ENUM('a','A') COLLATE latin1_bin);

INSERT INTO t1 VALUES ('a'),('A');

SELECT * FROM t1 WHERE a='a ';

SELECT * FROM t1 WHERE HEX(a)='61';

SELECT * FROM t1 WHERE HEX(a)='61' AND a='a ';

The first and the second query correctly return one row.
The third query erroneously returns empty set.
Notice, trailing space in the constant 'a '.

The same problem is repeatable with SET:

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a SET('a','A') COLLATE latin1_bin);

INSERT INTO t1 VALUES ('a'),('A');

SELECT * FROM t1 WHERE a='a ';

SELECT * FROM t1 WHERE HEX(a)='61';

SELECT * FROM t1 WHERE HEX(a)='61' AND a='a ';

blocks

MDEV-8728 Fix a number of problems in equal field and equal expression propagation

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.