questdb/questdb

Escape mechanism doesn't work in like/ilike functions

Open

#2623 aperta il 11 ott 2022

Vedi su GitHub
 (14 commenti) (0 reazioni) (0 assegnatari)Java (972 fork)batch import
BugGood first issuehacktoberfest

Metriche repository

Star
 (13.403 star)
Metriche merge PR
 (Merge medio 5g 13h) (108 PR mergiate in 30 g)

Descrizione

Describe the bug

Like and ilike functions don't recognize default escape character '\' nor allow using a different one via ESCAPE clause .

To reproduce

SELECT '\quest' LIKE '\_uest'; 
--true but should be false

SELECT 'quest_' LIKE 'quest\_'
--false but should be true 

select 'quest' like 'quest' escape 'Z'
--found [tok=''Z'', len=3] ',', 'from' or 'over' expected

Expected Behavior

No response

Environment

- **QuestDB version**:6.5.4/master
- **OS**:
- **Browser**:

Additional context

No response

Guida contributor