[
https://issues.apache.org/jira/browse/CALCITE-4443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17253437#comment-17253437
]
Ondřej Štumpf commented on CALCITE-4443:
----------------------------------------
Thank you for the detailed instructions, it makes sense to me.
* do you want me to create a new conformance level called "postgres", where
{{ILIKE}} would be enabled? From the existing ones, only {{BABEL}} and
{{LENIENT}} seem to be good candidates to support ILIKE. That new conformance
level would then be used in Postgres and Vertica dialects (which are related
anyway).
* the {{ILIKE}} operator will need to end up in {{SqlLibraryOperators}} anyway,
won't it? Otherwise I don't see how it could be used in {{RelBuilder}}.
> 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
> Assignee: Ondřej Štumpf
> Priority: Minor
> Labels: pull-request-available
> Time Spent: 20m
> 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)
