[
https://issues.apache.org/jira/browse/CALCITE-5384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tanner Clary updated CALCITE-5384:
----------------------------------
Description:
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().
was:
Implement support for the following BigQuery functions:
* [LEFT|
https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#left]
* [RIGHT|
https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#right]
> 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)
