[
https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856884#comment-17856884
]
Julian Hyde commented on CALCITE-6444:
--------------------------------------
I'm thinking about the effort going forward. Would it make sense for every
function in the Postgres to be automatically in the Redshift library unless the
author declares otherwise?
Say, add an {{exceptLibraries}} argument, like this:
{code:java}
@LibraryOperator(libraries = {BIG_QUERY, MYSQL, POSTGRESQL},
excludeLibraries = {REDSHIFT})
public static final SqlFunction SHA512 = ...;
{code}
> 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)
