[
https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17859734#comment-17859734
]
Norman Jordan commented on CALCITE-6444:
----------------------------------------
I see what you are saying. Something like *excludeLibaries* may be a simpler
solution. For the functions in {*}SqlLibraryOperators{*},
Functions in PostgreSQL and/or Redshift: 44
Only in PostgreSQL: 8
Only in Redshift: 5
In both with different implementations: 2
There is more discussion on the mailing list.
> Add an Amazon Redshift SqlLibrary
> ----------------------------------
>
> Key: CALCITE-6444
> URL: https://issues.apache.org/jira/browse/CALCITE-6444
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.34.0
> Reporter: Norman Jordan
> Assignee: Norman Jordan
> Priority: Major
> Labels: pull-request-available
>
> The Babel tests assume that RedShift is a union of the Oracle and PostgreSQL
> libraries. This is not accurate. There are functions such as *INCR* that are
> supported by Oracle and not by RedShift. Problems will also occur when Oracle
> and Postgres both support a function of the same name that needs different
> implementations.
> [https://github.com/apache/calcite/blob/main/babel/src/test/java/org/apache/calcite/test/BabelQuidemTest.java#L110]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
