[CALCITE-6444] Add a function library for Amazon Redshift

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.34.0
• Fix Version/s: 1.38.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Norman Jordan
• Reporter: Norman Jordan
• Created: 21/Jun/24 21:57
• Updated: 17/Oct/24 22:41
• Resolved: 17/Oct/24 22:41

Description

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

Issue Links

• links to: GitHub Pull Request #3829