[
https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856882#comment-17856882
]
Norman Jordan commented on CALCITE-6444:
----------------------------------------
For the PR, I went through the Amazon Redshift documentation. If a function was
in the Oracle or PostgreSQL library, I checked the documentation to verify that
it exists in Redshift. There are a few PostgreSQL functions that are not in
Redshift, such as SHA512.
I'll double check the functions again on Monday. It is a big list so another
check is needed.
> 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
>
> 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)
