[
https://issues.apache.org/jira/browse/CALCITE-6156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tanner Clary updated CALCITE-6156:
----------------------------------
Description:
Calcite already offers BigQuery's {{STARTS_WITH}} and {{ENDS_WITH}} functions.
Postgres offers these functions as well. Snowflake offers two very similar
functions (the only difference being the naming).
Examples of each function can be found in their original implementation commit
[742d477|https://github.com/apache/calcite/commit/742d47795b878576f8cbdab5f62b26d95559792a]
There will also need to be a small change necessary since Snowflake uses
{{ENDSWITH}} and {{STARTSWITH}} as the function names.
was:
Calcite already offers BigQuery's {{STARTS_WITH}} and {{ENDS_WITH}} functions.
Snowflake offers two very similar functions (the only difference being the
naming).
Examples of each function can be found in their original implementation commit
[742d477|https://github.com/apache/calcite/commit/742d47795b878576f8cbdab5f62b26d95559792a]
I noticed there is currently no {{SqlLibrary}} entry for {{Snowflake}} so that
might need to be added.
> Add ENDS_WITH, STARTS_WITH functions (enabled in Postgres, Snowflake
> libraries)
> -------------------------------------------------------------------------------
>
> Key: CALCITE-6156
> URL: https://issues.apache.org/jira/browse/CALCITE-6156
> Project: Calcite
> Issue Type: New Feature
> Reporter: Tanner Clary
> Assignee: Tanner Clary
> Priority: Major
>
> Calcite already offers BigQuery's {{STARTS_WITH}} and {{ENDS_WITH}}
> functions. Postgres offers these functions as well. Snowflake offers two very
> similar functions (the only difference being the naming).
> Examples of each function can be found in their original implementation
> commit
> [742d477|https://github.com/apache/calcite/commit/742d47795b878576f8cbdab5f62b26d95559792a]
> There will also need to be a small change necessary since Snowflake uses
> {{ENDSWITH}} and {{STARTSWITH}} as the function names.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
