Description
LikeSimplification rule does not work correctly for many cases that have patterns containing escape characters:
SELECT s LIKE 'm%aca' ESCAPE '%' from t; SELECT s LIKE 'maacaa' ESCAPE 'a' FROM t;
LikeSimplification rule does not work correctly for many cases that have patterns containing escape characters:
SELECT s LIKE 'm%aca' ESCAPE '%' from t; SELECT s LIKE 'maacaa' ESCAPE 'a' FROM t;