[jira] [Created] (CALCITE-3591) Add BIT_XOR BIT aggregate function

hailong wang created CALCITE-3591: - Summary: Add BIT_XOR BIT aggregate function Key: CALCITE-3591 URL: https://issues.apache.org/jira/browse/CALCITE-3591 Project: Calcite Issue Type: Improvem

[jira] [Created] (CALCITE-3592) Add "~" SqlPrefixOperator for bitwise not

hailong wang created CALCITE-3592: - Summary: Add "~" SqlPrefixOperator for bitwise not Key: CALCITE-3592 URL: https://issues.apache.org/jira/browse/CALCITE-3592 Project: Calcite Issue Type: I

[jira] [Commented] (CALCITE-3591) Add BIT_XOR BIT aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-3591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16994125#comment-16994125 ] hailong wang commented on CALCITE-3591: --- Hi [~julianhyde], do we need support? >

[jira] [Commented] (CALCITE-3592) Add "~" SqlPrefixOperator for bitwise not

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16994127#comment-16994127 ] hailong wang commented on CALCITE-3592: --- cc [~julianhyde], what do you think of i

[jira] [Updated] (CALCITE-3592) Add "~" SqlPrefixOperator for bitwise not

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3592: -- Description: Mysql、Postgresql or SQL Server  support non-standard operator as Bitwise not ope

[jira] [Commented] (CALCITE-3592) Add "~" SqlPrefixOperator for bitwise not

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16996639#comment-16996639 ] hailong wang commented on CALCITE-3592: --- [~Chunwei Lei] Oh, I am sorry for that.

[jira] [Assigned] (CALCITE-3592) Add "~" SqlPrefixOperator for bitwise not

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang reassigned CALCITE-3592: - Assignee: hailong wang > Add "~" SqlPrefixOperator for bitwise not > -

[jira] [Updated] (CALCITE-3592) Babel parser support "~" SqlPrefixOperator for bitwise not

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3592: -- Summary: Babel parser support "~" SqlPrefixOperator for bitwise not (was: Add "~" SqlPrefixO

[jira] [Updated] (CALCITE-3592) Babel parser support "~" SqlPrefixOperator for bitwise not

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3592: -- Description: Mysql、Postgresql or SQL Server  support non-standard operator as Bitwise not ope

[jira] [Commented] (CALCITE-3592) Babel parser support "~" SqlPrefixOperator for bitwise not

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16998341#comment-16998341 ] hailong wang commented on CALCITE-3592: --- [~julianhyde], Thank you for your advise

[jira] [Assigned] (CALCITE-3591) Add BIT_XOR BIT aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-3591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang reassigned CALCITE-3591: - Assignee: hailong wang > Add BIT_XOR BIT aggregate function >

[jira] [Commented] (CALCITE-3591) Add BIT_XOR BIT aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-3591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16998343#comment-16998343 ] hailong wang commented on CALCITE-3591: --- Thank you [~hyuan] [~julianhyde]. It is

[jira] [Commented] (CALCITE-3782) Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type

[ https://issues.apache.org/jira/browse/CALCITE-3782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17206789#comment-17206789 ] hailong wang commented on CALCITE-3782: --- Thanks [~julianhyde], [~vladimirsitnikov

[jira] [Commented] (CALCITE-3686) Implement bit_not function

[ https://issues.apache.org/jira/browse/CALCITE-3686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17015047#comment-17015047 ] hailong wang commented on CALCITE-3686: --- Hi [~x1q1j1], is this duplicate for a no

[jira] [Created] (CALCITE-3732) Implement bit functions and operators

hailong wang created CALCITE-3732: - Summary: Implement bit functions and operators Key: CALCITE-3732 URL: https://issues.apache.org/jira/browse/CALCITE-3732 Project: Calcite Issue Type: Impro

[jira] [Commented] (CALCITE-3686) Implement bit_not function

[ https://issues.apache.org/jira/browse/CALCITE-3686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17015070#comment-17015070 ] hailong wang commented on CALCITE-3686: --- Hi [~x1q1j1], it doesn't matter. But I f

[jira] [Commented] (CALCITE-3732) Implement bit functions and operators

[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17015559#comment-17015559 ] hailong wang commented on CALCITE-3732: --- Thanks [~zabetak] [~amaliujia]. Yes, I a

[jira] [Assigned] (CALCITE-3732) Implement bit functions and operators

[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang reassigned CALCITE-3732: - Assignee: hailong wang > Implement bit functions and operators > -

[jira] [Commented] (CALCITE-3732) Implement bit functions and operators

[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17016880#comment-17016880 ] hailong wang commented on CALCITE-3732: --- Thanks [~julianhyde] [~amaliujia]. I con

[jira] [Comment Edited] (CALCITE-3732) Implement bit functions and operators

[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17016880#comment-17016880 ] hailong wang edited comment on CALCITE-3732 at 1/16/20 12:51 PM:

[jira] [Commented] (CALCITE-3732) Implement bit functions and operators

[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17017856#comment-17017856 ] hailong wang commented on CALCITE-3732: --- [~julianhyde] Maybe we can call BITAND, 

[jira] [Updated] (CALCITE-3592) Implement BITNOT function

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3592: -- Summary: Implement BITNOT function (was: Add BITNOT bitwise operator, and infix "~" operator

[jira] [Updated] (CALCITE-3592) Implement BITNOT function

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3592: -- Description: (was: Mysql、Postgresql or SQL Server  support non-standard operator as Bitwi

[jira] [Commented] (CALCITE-3592) Implement BITNOT function

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17032404#comment-17032404 ] hailong wang commented on CALCITE-3592: --- Updated > Implement BITNOT function > -

[jira] [Updated] (CALCITE-3592) Implement BITNOT function

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3592: -- Description: Implement BITNOT function which support tinyint, smallint, int, bigint, binary a

[jira] [Updated] (CALCITE-3592) Implement BITNOT function

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3592: -- Issue Type: Task (was: Improvement) > Implement BITNOT function > -

[jira] [Updated] (CALCITE-3592) Implement BITNOT function

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3592: -- Issue Type: Improvement (was: Task) > Implement BITNOT function > -

[jira] [Updated] (CALCITE-3732) Implement bit functions and operators

[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3732: -- Issue Type: Task (was: Improvement) > Implement bit functions and operators > --

[jira] [Updated] (CALCITE-3592) Implement BITNOT function

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3592: -- Parent: CALCITE-3732 Issue Type: Sub-task (was: Improvement) > Implement BITNOT func

[jira] [Commented] (CALCITE-3732) Implement bit functions and operators

[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17032440#comment-17032440 ] hailong wang commented on CALCITE-3732: --- Thanks [~julianhyde]. I have updated, an

[jira] [Created] (CALCITE-3779) Implement BITAND scalar function

hailong wang created CALCITE-3779: - Summary: Implement BITAND scalar function Key: CALCITE-3779 URL: https://issues.apache.org/jira/browse/CALCITE-3779 Project: Calcite Issue Type: Sub-task

[jira] [Updated] (CALCITE-3592) Implement BITNOT scalar function

[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3592: -- Description: Implement BITNOT scalar function which support tinyint, smallint, int, bigint, b

[jira] [Created] (CALCITE-3782) Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type

hailong wang created CALCITE-3782: - Summary: Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type Key: CALCITE-3782 URL: https://issues.apache.org/jira/browse/CALCITE-3782 Pr

[jira] [Updated] (CALCITE-3782) Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type

[ https://issues.apache.org/jira/browse/CALCITE-3782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3782: -- Fix Version/s: 1.23.0 > Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbi

[jira] [Commented] (CALCITE-3779) Implement BITAND scalar function

[ https://issues.apache.org/jira/browse/CALCITE-3779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17063804#comment-17063804 ] hailong wang commented on CALCITE-3779: --- It is ok. Thank you [~danny0405] ~ > Im

[jira] [Updated] (CALCITE-3782) Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type

[ https://issues.apache.org/jira/browse/CALCITE-3782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3782: -- Affects Version/s: (was: 1.21.0) 1.22.0 > Bitwise operator Bit_And

[jira] [Updated] (CALCITE-3782) Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type

[ https://issues.apache.org/jira/browse/CALCITE-3782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3782: -- Description: According to the discussion  > Bitwise operator Bit_And, Bit_OR and Bit_XOR supp

[jira] [Updated] (CALCITE-3782) Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type

[ https://issues.apache.org/jira/browse/CALCITE-3782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3782: -- Description: According to the discussion [link CALCITE_3732|https://issues.apache.org/jira/br

[jira] [Updated] (CALCITE-3782) Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type

[ https://issues.apache.org/jira/browse/CALCITE-3782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3782: -- Description: According to the discussion  [link CALCITE-3732|https://issues.apache.org/jira/b

[jira] [Updated] (CALCITE-3782) Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type

[ https://issues.apache.org/jira/browse/CALCITE-3782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3782: -- Description: According to the discussion CALCITE_3732 We should make bitwise operators work o

[jira] [Updated] (CALCITE-3782) Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type

[ https://issues.apache.org/jira/browse/CALCITE-3782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang updated CALCITE-3782: -- Description: According to the discussion  link CALCITE-3732 , We should make bitwise operator