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

Posted to dev@phoenix.apache.org by "Istvan Toth (Jira)" <ji...@apache.org> on 2022/08/09 08:50:00 UTC

[jira] [Created] (PHOENIX-6764) Implement Binary and Hexadecimal literals

Istvan Toth created PHOENIX-6764:
------------------------------------

             Summary: 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


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)