[
https://issues.apache.org/jira/browse/CALCITE-5384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tanner Clary closed CALCITE-5384.
---------------------------------
Resolution: Duplicate
Opened separate ticket to include all functions that have been implemented for
other libraries and need BigQuery added as a supported library. New ticket may
be found at: [Calcite-5385|https://issues.apache.org/jira/browse/CALCITE-5385]
> Implement LEFT/RIGHT String functions for BigQuery
> --------------------------------------------------
>
> Key: CALCITE-5384
> URL: https://issues.apache.org/jira/browse/CALCITE-5384
> Project: Calcite
> Issue Type: Task
> Reporter: Tanner Clary
> Priority: Major
>
> Implement support for the following BigQuery functions:
> * LEFT(value, length)
> ** Returns the leftmost _length_ characters of _value._ If _length_ is zero,
> an empty string or byte will be returned. If _length_ is greater than
> _length(value),_ _value_ will be returned. If _length_ is negative, an error
> will be returned.
> * RIGHT(value, length)
> ** Returns the rightmost _length_ characters of {_}value{_}. Follows the
> same edge-case behavior as LEFT().
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
