[jira] [Created] (CALCITE-7109) Add support for << operator in Calcite

["krooswu (Jira)" <ji...@apache.org>]

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)