[
https://issues.apache.org/jira/browse/PHOENIX-6764?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17584940#comment-17584940
]
ASF GitHub Bot commented on PHOENIX-6764:
-----------------------------------------
stoty commented on PR #1490:
URL: https://github.com/apache/phoenix/pull/1490#issuecomment-1227516782
I've updated the patch with a more flexible implementation.
As we don't enable backtracking, implementing the multi-line literals was a
major pain, ended up quite hacky.
The query dumping BINARY format change is probably going to brake a lot of
tests, I'll have to do another pass on those.
> Implement Binary and Hexadecimal literals
> -----------------------------------------
>
> Key: PHOENIX-6764
> URL: https://issues.apache.org/jira/browse/PHOENIX-6764
> Project: Phoenix
> Issue Type: Bug
> Components: core
> Reporter: Istvan Toth
> Assignee: Istvan Toth
> Priority: Major
>
> Currently there is no sane way to specify arbitrary binary and varbinary
> values in the query string.
> They can be set as variables for preparedstatements, and if the length
> corresponds to an existing type, then some casting gymnastics can be used to
> work around the problem, but I have not found a way to write a query that
> upserts an arbitrary three byte value into a binary/varbinary.
> The SQL standard defines Binary and Hex literals in the form ofÂ
> B'01010101001...' and X'0102AAF5...'
> Implement this in the parser.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
