fdb-record-layer icon indicating copy to clipboard operation
fdb-record-layer copied to clipboard

Unmatched escape characters for LIKE should error

Open ScottDugas opened this issue 9 months ago • 0 comments

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'

ScottDugas avatar Feb 28 '25 17:02 ScottDugas