[
https://issues.apache.org/jira/browse/CALCITE-7109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18010029#comment-18010029
]
Julian Hyde commented on CALCITE-7109:
--------------------------------------
Darn, I wish that [~krooswu] had linked to the other issue. It would have saved
a lot of time.
> 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)
