[CALCITE-5848] Add BIT_GET and GETBIT function (enabled in Spark library)

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.34.0
• Fix Version/s: 1.36.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Runkang He
• Reporter: Runkang He
• Created: 14/Jul/23 15:14
• Updated: 10/Nov/23 11:34
• Resolved: 22/Aug/23 02:22

Description

Add BIT_GET and GETBIT function (enabled in Spark library):
BIT_GET(expr, pos) - Returns the value of the bit (0 or 1) at the specified position. The positions are numbered from right to left, starting at zero. The position argument cannot be negative.
GETBIT is an alias of BIT_GET.
See more details in Spark doc.

Issue Links

• links to: GitHub Pull Request #3319