You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Oliver Lee (Jira)" <ji...@apache.org> on 2022/12/07 19:51:00 UTC

[jira] [Commented] (CALCITE-5389) Add STARTS_WITH and ENDS_WITH functions (for BIG_QUERY compatibility)

    [ https://issues.apache.org/jira/browse/CALCITE-5389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17644496#comment-17644496 ] 

Oliver Lee commented on CALCITE-5389:
-------------------------------------

Hey [~julianhyde]  I took a look. 

Good to go on the alphabetical sorting and comment updates – thanks. 

On the BQ Console, using 'null' as either the first, second ({{{}SELECT STARTS_WITH("123", null){}}}) , returns {{false}} , and only when both null
({{{}SELECT STARTS_WITH(null, null){}}}) does it returns {{null}}

 

Should this behavior be mirrored?

 

 

 

> Add STARTS_WITH and ENDS_WITH functions (for BIG_QUERY compatibility)
> ---------------------------------------------------------------------
>
>                 Key: CALCITE-5389
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5389
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Oliver Lee
>            Assignee: Oliver Lee
>            Priority: Trivial
>              Labels: pull-request-available
>             Fix For: 1.33.0
>
>          Time Spent: 40m
>  Remaining Estimate: 0h
>
> Adding support for {{STARTS_WITH}} and {{ENDS_WITH}} SQL functions. They are for compatibility with BIG_QUERY, and are enabled only in the BigQuery function library ({{lib=bigquery}} in the connect string).



--
This message was sent by Atlassian Jira
(v8.20.10#820010)