1--echo #
2--echo # MDEV-7149 Constant condition propagation erroneously applied for LIKE
3--echo #
4
5CREATE TABLE t1 AS SELECT REPEAT('a',10) AS c1 LIMIT 0;
6SHOW CREATE TABLE t1;
7INSERT INTO t1 VALUES ('ae'),('ä');
8SELECT * FROM t1 WHERE c1='ä';
9SELECT * FROM t1 WHERE c1 LIKE 'ae';
10SELECT * FROM t1 WHERE c1='ä' AND c1 LIKE 'ae';
11EXPLAIN EXTENDED SELECT * FROM t1 WHERE c1='ä' AND c1 LIKE 'ae';
12SELECT * FROM t1 WHERE CONCAT(c1)='ä';
13SELECT * FROM t1 WHERE CONCAT(c1) LIKE 'ae';
14SELECT * FROM t1 WHERE CONCAT(c1)='ä' AND CONCAT(c1) LIKE 'ae';
15EXPLAIN EXTENDED SELECT * FROM t1 WHERE CONCAT(c1)='ä' AND CONCAT(c1) LIKE 'ae';
16DROP TABLE IF EXISTS t1;
17