Wrong result for SELECT..WHERE view_latin1_swedish_ci_field='a' COLLATE latin1_bin

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;

+------+

| a    |

+------+

| a    |

| A    |

+------+