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/11/23 20:12:00 UTC
[jira] [Comment Edited] (CALCITE-5389) STARTS_WITH for BIG_QUERY

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

Oliver Lee edited comment on CALCITE-5389 at 11/23/22 8:11 PM:
---------------------------------------------------------------

I have some questions on how we should handle {{BYTES}}

Context: BIG_QUERY documentation says it should support `STRING` as well as `BYTES` for input

 

Issue: Running a query like
 {{SELECT STARTS_WITH(b'123', b'1');}}  
gives me a parser exception 
{{ParseException: Encountered "\'123\'"}}, unable to parse byte literals.

I've tried casting a string as BYTES with 
{{SELECT CAST("12" as BYTES) ;}}
  and that returns
 {{Unknown identifier 'BYTES' -> SqlValidatorException: Unknown identifier 'BYTES'}}

 

I see in Calcite that we do acknowledge the BYTES/ VARBINARY aliasing [https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/sql/SqlAlienSystemTypeNameSpec.java#L30]

 

 

Question: Could I follow through with this current PR and file a new ticket detailing that BIG_QUERY BYTES is not fully functioning? 


was (Author: JIRAUSER297744):
I have some questions on how we should handle `BYTES`

Context: BIG_QUERY documentation says it should support `STRING` as well as `BYTES` for input

 

Issue: Running a query like `SELECT STARTS_WITH(b'123', b'1');` gives me a parser exception `ParseException: Encountered "\'123\'"`, unable to parse byte literals.

I've tried casting a string as BYTES with `SELECT CAST("12" as BYTES) ;`  and that returns `Unknown identifier 'BYTES' -> SqlValidatorException: Unknown identifier 'BYTES'`

 

I see in Calcite that we do acknowledge the BYTES/ VARBINARY aliasing [https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/sql/SqlAlienSystemTypeNameSpec.java#L30]

 

 

Question: Could I follow through with this current PR and file a new ticket detailing that BIG_QUERY BYTES is not fully functioning? 

> STARTS_WITH for BIG_QUERY
> -------------------------
>
>                 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
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> Adding support for STARTS_WITH for BIG_QUERY dialect



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