Submitted by: @mrotteveel

The LIKE escape does not work as it should, the escape clause is ignored.

Testsetup:

CREATE TABLE TAB1 (
ID INT CONSTRAINT PK_TAB1 PRIMARY KEY,
VAL VARCHAR(30)
);

INSERT INTO TAB1 (ID, VAL) VALUES (1, 'abcdef');
INSERT INTO TAB1 (ID, VAL) VALUES (2, 'abc_ef');
INSERT INTO TAB1 (ID, VAL) VALUES (3, 'abc%ef');

Tests:
SELECT VAL FROM TAB1 WHERE VAL LIKE 'abc&%ef' ESCAPE '&'
Expected result: 1 row, with value abc%ef
Actual result: no row

SELECT VAL FROM TAB1 WHERE VAL LIKE 'abc&_ef' ESCAPE '&'
Expected result: 1 row, with value abc_ef
Actual result: no row

Firebird 2.5 and earlier do produce the expected result.

Commits: 9e12865 FirebirdSQL/fbt-repository@a74dfe6