--echo # --echo # MDEV-7149 Constant condition propagation erroneously applied for LIKE --echo # CREATE TABLE t1 AS SELECT REPEAT('a',10) AS c1 LIMIT 0; SHOW CREATE TABLE t1; INSERT INTO t1 VALUES ('ae'),('ä'); SELECT * FROM t1 WHERE c1='ä'; SELECT * FROM t1 WHERE c1 LIKE 'ae'; SELECT * FROM t1 WHERE c1='ä' AND c1 LIKE 'ae'; EXPLAIN EXTENDED SELECT * FROM t1 WHERE c1='ä' AND c1 LIKE 'ae'; SELECT * FROM t1 WHERE CONCAT(c1)='ä'; SELECT * FROM t1 WHERE CONCAT(c1) LIKE 'ae'; SELECT * FROM t1 WHERE CONCAT(c1)='ä' AND CONCAT(c1) LIKE 'ae'; EXPLAIN EXTENDED SELECT * FROM t1 WHERE CONCAT(c1)='ä' AND CONCAT(c1) LIKE 'ae'; DROP TABLE IF EXISTS t1;