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

2019-12-14 Thread hailong wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16996639#comment-16996639 ] hailong wang commented on CALCITE-3592: --- [~Chunwei Lei] Oh, I am sorry for that. I have updated,

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

2019-12-14 Thread hailong wang (Jira)
[ 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

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

2019-12-17 Thread hailong wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16998341#comment-16998341 ] hailong wang commented on CALCITE-3592: --- [~julianhyde], Thank you for your advise. I have updated

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

2019-12-17 Thread hailong wang (Jira)
[ 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] [Updated] (CALCITE-3592) Babel parser support "~" SqlPrefixOperator for bitwise not

2019-12-17 Thread hailong wang (Jira)
[ 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 "~"

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

2019-12-17 Thread hailong wang (Jira)
[ 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

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

2019-12-17 Thread hailong wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16998343#comment-16998343 ] hailong wang commented on CALCITE-3591: --- Thank you [~hyuan] [~julianhyde]. It is my pleasure to

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

2019-12-11 Thread hailong wang (Jira)
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:

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

2019-12-11 Thread hailong wang (Jira)
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:

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

2019-12-16 Thread hailong wang (Jira)
[ 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] [Commented] (CALCITE-3591) Add BIT_XOR BIT aggregate function

2019-12-11 Thread hailong wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16994125#comment-16994125 ] hailong wang commented on CALCITE-3591: --- Hi [~julianhyde], do we need support? > Add BIT_XOR BIT

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

2019-12-11 Thread hailong wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16994127#comment-16994127 ] hailong wang commented on CALCITE-3592: --- cc [~julianhyde], what do you think of it. > Add "~"

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

2020-02-07 Thread hailong wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17032440#comment-17032440 ] hailong wang commented on CALCITE-3732: --- Thanks [~julianhyde]. I have updated, and this ticket is

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

2020-02-07 Thread hailong wang (Jira)
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 function

2020-02-07 Thread hailong wang (Jira)
[ 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

2020-02-07 Thread hailong wang (Jira)
[ 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

2020-02-07 Thread hailong wang (Jira)
[ 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

2020-02-07 Thread hailong wang (Jira)
[ 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 "~"

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

2020-02-07 Thread hailong wang (Jira)
[ 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

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

2020-02-07 Thread hailong wang (Jira)
[ 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,

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

2020-02-07 Thread hailong wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17032404#comment-17032404 ] hailong wang commented on CALCITE-3592: --- Updated > Implement BITNOT function >

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

2020-02-07 Thread hailong wang (Jira)
[ 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

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

2020-02-07 Thread hailong wang (Jira)
[ 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

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

2020-02-11 Thread hailong wang (Jira)
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

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

2020-01-14 Thread hailong wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17015559#comment-17015559 ] hailong wang commented on CALCITE-3732: --- Thanks [~zabetak] [~amaliujia]. Yes, I am planning to

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

2020-01-17 Thread hailong wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017856#comment-17017856 ] hailong wang commented on CALCITE-3732: --- [~julianhyde] Maybe we can call BITAND, BITOR etc. like  

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

2020-01-16 Thread hailong wang (Jira)
[ 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

2020-01-16 Thread hailong wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016880#comment-17016880 ] hailong wang commented on CALCITE-3732: --- Thanks [~julianhyde] [~amaliujia]. I conclude as

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

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

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

2020-01-14 Thread hailong wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17015047#comment-17015047 ] hailong wang commented on CALCITE-3686: --- Hi [~x1q1j1], is this duplicate for a normal bitnot

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

2020-01-14 Thread hailong wang (Jira)
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:

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

2020-01-14 Thread hailong wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17015070#comment-17015070 ] hailong wang commented on CALCITE-3686: --- Hi [~x1q1j1], it doesn't matter. But I found there is no 

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

2020-03-27 Thread hailong wang (Jira)
[ 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

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

2020-03-27 Thread hailong wang (Jira)
[ 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

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

2020-03-27 Thread hailong wang (Jira)
[ 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

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

2020-03-27 Thread hailong wang (Jira)
[ 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

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

2020-03-27 Thread hailong wang (Jira)
[ 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

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

2020-03-21 Thread hailong wang (Jira)
[ 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

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

2020-03-21 Thread hailong wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17063804#comment-17063804 ] hailong wang commented on CALCITE-3779: --- It is ok. Thank you [~danny0405] ~ > Implement BITAND

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

2020-03-23 Thread hailong wang (Jira)
[ 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

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

2020-10-03 Thread hailong wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17206789#comment-17206789 ] hailong wang commented on CALCITE-3782: --- Thanks [~julianhyde], [~vladimirsitnikov]. Sorry for