|
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a VARBINARY(10));
|
INSERT INTO t1 VALUES ('a'),('A');
|
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a>=_utf8'a' COLLATE utf8_general_ci AND a='A';
|
SHOW WARNINGS;
|
returns
+-------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Note | 1003 | select `test`.`t1`.`a` AS `a` from `test`.`t1` where ((`test`.`t1`.`a` = 'A') and (convert(`test`.`t1`.`a` using utf8) >= <cache>((_utf8'a' collate utf8_general_ci)))) |
|
+-------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
The equality a='A' was not propagated into >=. It safely could.
|