[
https://issues.apache.org/jira/browse/CALCITE-5389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17640995#comment-17640995
]
Julian Hyde commented on CALCITE-5389:
--------------------------------------
To create {{BINARY}} literals (which also work as {{VARBINARY}} values), use
'x', e.g. {{x'ABCDEF12'}}. Note that you need an even number of hex digits.
'b', for bit strings, is obsolete in Calcite and in standard SQL. Not sure of
the status in BigQuery.
> 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: 0.5h
> Remaining Estimate: 0h
>
> Adding support for STARTS_WITH for BIG_QUERY dialect
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
