[MDEV-8742] Wrong result for SELECT..WHERE view_latin1_swedish_ci_field='a' COLLATE latin1_bin - Jira

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET latin1);

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

DROP VIEW IF EXISTS v1;

CREATE VIEW v1 AS SELECT * FROM t1 WHERE a='a';

SELECT * FROM v1 WHERE a=_latin1'a' COLLATE latin1_bin;

erroneously returns two rows:

+------+

| a    |

+------+

| a    |

| A    |

+------+

The expected result is to return on row only, with 'a' in lower case.

blocks

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

There are no comments yet on this issue.

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

MariaDB Server