[
https://issues.apache.org/jira/browse/PHOENIX-1273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14145176#comment-14145176
]
Jean-Marc Spaggiari commented on PHOENIX-1273:
----------------------------------------------
Excellent. Thatnks again for this detailed feedback. I have attached an updated
version.
Just one thing about the "WHERE pk LIKE 'foo%'". When you say "we'd need to
generate two ranges" is it not 2^n ranges instead of 2, where n is the lenght
of the prefix?
Like for 'foo%' we will need:
foo
foO
fOo
fOO
Foo
FoO
FOo
FOO
and not just Foo and foo?
> Phoenix should provide ILIKE keyword
> ------------------------------------
>
> Key: PHOENIX-1273
> URL: https://issues.apache.org/jira/browse/PHOENIX-1273
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.2
> Reporter: Jean-Marc Spaggiari
> Assignee: Jean-Marc Spaggiari
> Priority: Minor
> Attachments: PHOENIX-1273-v1.patch, PHOENIX-1273-v2.patch,
> PHOENIX-1273-v3.patch, PHOENIX-1273.patch
>
>
> Phoenix provides LIKE keyword but not ILIKE which is a case insensitive LIKE.
> Goal of this patch is to add this keyword.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
