Skip to content

ESCAPE <expression> must not interpret Escape codes. #1638

Closed
@manticore-projects

Description

@manticore-projects

ESCAPE <expression> must not interpret Escape codes.

-- fails
select case 
    when id_portfolio like '%\_1' escape '\' then '1'
    end;

-- works
select case 
    when id_portfolio like '%\_1'  then '1'
    end;

-- works
select *
from dual
where id_portfolio like '%\_1' escape '\';

Odd enough even GitHub Syntax highlighting gets confused?!

Metadata

Metadata

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions