[
https://issues.apache.org/jira/browse/CALCITE-4443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17253657#comment-17253657
]
Julian Hyde commented on CALCITE-4443:
--------------------------------------
A {{POSTGRESQL}} constant in {{SqlConformanceEnum}} makes sense. Better if you
do it as a separate commit & JIRA case. For now, it is sufficient to test
against {{LENIENT}}.
Yes, add the operator instances to SqlLibraryOperators.
> 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)
