[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17015349#comment-17015349 ]
Rui Wang edited comment on CALCITE-3732 at 1/14/20 7:35 PM: ------------------------------------------------------------ It could be useful to have a spreadsheet to list functions that you want to support, with other major DBs/SQL standard's investigation in it (if they support it, etc.) There is a thread in dev@ about math functions that did it. I found it was particularly for people to inspect and discuss. was (Author: amaliujia): It could useful to have a spreadsheet to list functions that you want to support, with other major DBs/SQL standard's investigation in it (if they support it, etc.) There is a thread in dev@ about math functions that did it. I found it was particularly for people to inspect and discuss. > Implement bit functions and operators > ------------------------------------- > > Key: CALCITE-3732 > URL: https://issues.apache.org/jira/browse/CALCITE-3732 > Project: Calcite > Issue Type: Improvement > Components: core > Affects Versions: 1.21.0 > Reporter: 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 > https://issues.apache.org/jira/browse/CALCITE-2770, BIT_XOR in > https://issues.apache.org/jira/browse/CALCITE-3591. BIT_COUNT is in progress > https://issues.apache.org/jira/browse/CALCITE-3697, BIT_NOT(~) is in progress > https://issues.apache.org/jira/browse/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)