fdb-record-layer
fdb-record-layer copied to clipboard
Unmatched escape characters for LIKE should error
A query like:
select * from B WHERE B2 NOT LIKE '\'
should error with 22025 because the \ is not escaping anything.
Similarly, if an ESCAPE is specifically provided, it should fail:
select * from B WHERE B2 NOT LIKE 'Z' ESCAPE 'Z'
Right now we will treat it the same as:
select * from B WHERE B2 NOT LIKE 'Z'