krooswu created CALCITE-7109:
--------------------------------
Summary: 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
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)
