[
https://issues.apache.org/jira/browse/CALCITE-7109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18010073#comment-18010073
]
krooswu commented on CALCITE-7109:
----------------------------------
Thanks Julian and Mihai, and apologies for the confusion caused by the previous
bundled proposal.
I now realize that I should have broken these operators into separate issues
and thought through the design more carefully — including behavior differences
across engines and how Calcite should handle edge cases.
I’ll take some time to clearly define the behavior and scope for each operator
(starting with `>>`), and will update the ticket with a complete spec shortly.
Really appreciate your feedback and patience!
> Add support for << operator in Calcite
> --------------------------------------
>
> Key: CALCITE-7109
> URL: https://issues.apache.org/jira/browse/CALCITE-7109
> Project: Calcite
> Issue Type: New Feature
> Reporter: krooswu
> Assignee: krooswu
> Priority: Major
> Labels: pull-request-available
>
> Calcite currently does not support the {{<<}} (bitwise left shift) operator
> in SQL expressions. This operator is commonly used in various SQL dialects
> (e.g., PostgreSQL, SQL Server, MySQL) for efficient manipulation of integer
> bit patterns.
> This issue proposes to add parser, validation, and Rex-level support for the
> {{<<}} operator, consistent with existing bitwise operations like {{{}&{}}},
> {{{}|{}}}, and {{{}^{}}}.
> *Scope:*
> * Extend the SQL parser to recognize the {{<<}} operator.
> * Implement a corresponding {{{}SqlBinaryOperator{}}}.
> * Add support in {{SqlToRelConverter}} and {{{}RexBuilder{}}}.
> * Add type inference and validation logic (e.g., restrict to integer types).
> * Write tests covering SQL parsing, validation, and execution via
> {{{}RexExecutor{}}}.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
