[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17041517#comment-17041517 ]
Danny Chen commented on CALCITE-3732: ------------------------------------- This is an umbrella issue, so i remove the fix version tag ~ > Implement bit functions and operators > ------------------------------------- > > Key: CALCITE-3732 > URL: https://issues.apache.org/jira/browse/CALCITE-3732 > Project: Calcite > Issue Type: Task > Components: core > Affects Versions: 1.21.0 > Reporter: hailong wang > Assignee: hailong wang > Priority: Major > Fix For: 1.22.0 > > > 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] > -- This message was sent by Atlassian Jira (v8.3.4#803005)