[
https://issues.apache.org/jira/browse/CALCITE-4443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17252969#comment-17252969
]
Ondřej Štumpf commented on CALCITE-4443:
----------------------------------------
Hi [~julianhyde], thanks for looking into this.
It's not really standard SQL, I need it to query Postgres and Vertica. AFAIK
Snowflake and Redshift support it as well, possibly with more databases.
And yes, it's basically a copy-paste of LIKE, because frankly, that's what
ILIKE is. I would solve it within my codebase by inheriting from
SqlLikeOperator, but sadly, that class has a package-private constructor...
If changing that to protected constructor is more acceptable to you, I'm more
than happy to change the PR. Otherwise, I'd be grateful if you could provide
some hints how to change the approach so that it works for you.
> Add support for the ILIKE operator to core
> ------------------------------------------
>
> Key: CALCITE-4443
> URL: https://issues.apache.org/jira/browse/CALCITE-4443
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Ondřej Štumpf
> Priority: Minor
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Extend the list of supported relational operators in SqlStdOperatorTable with
> ILIKE. The new ILIKE keyword should be unreserved and behave exactly like
> LIKE, but without case-sensitivity.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
