[
https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17859734#comment-17859734
]
Julian Hyde edited comment on CALCITE-6444 at 6/25/24 4:31 PM:
---------------------------------------------------------------
I see what you are saying. Something like *excludeLibraries* 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.
was (Author: njordan):
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 a function library for Amazon Redshift
> ------------------------------------------
>
> 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
>
> Add a function library for Amazon Redshift. People would be able to use this
> library by adding "{{fun=redshift}}" to their connect string.
> 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)
