Skip to content

Unmatched escape characters for LIKE should error #3216

Open
@ScottDugas

Description

@ScottDugas

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'

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions