[CALCITE-3732] Implement bit functions and operators

• Type: Task
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.21.0
• Component/s: core
• Assignee: hailong wang
• Reporter: hailong wang
• Created: 14/Jan/20 12:56
• Updated: 07/Apr/22 13:13

Description

Bit function is non-standard operators, but all db has implemented, such as mysql, postgresql.

Calcite has implemented BIT_AND, BIT_OR in CALCITE-2770, BIT_XOR in CALCITE-3591. BIT_COUNT is in progress CALCITE-3697, BIT_NOT(~) is in progress CALCITE-3592.

So I think we should also implement Bitwise AND(&), Right shift(>>), Left shift(<<), Bitwise XOR(^), Bitwise OR(|). And data types support tinyint, smallint, int, bigint like before.

 

Refence: https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html#operator_bitwise-invert 

Issue Links

• Blocked: CALCITE-5087 Support bitwise operators
• relates to: CALCITE-3697 Implement BITCOUNT scalar function
• relates to: CALCITE-3592 Implement BITNOT scalar function

Sub-Tasks

• Implement BITAND scalar function: In Progress
• Implement BITNOT scalar function: In Progress
• Implement BITCOUNT scalar function: Open