[jira] [Commented] (CALCITE-3786) Add Digest interface to enable efficient hashCode(equals) for RexNode and RelNode

2020-06-19 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140958#comment-17140958 ] Haisheng Yuan commented on CALCITE-3786: OK, let me put it in another way. What

[jira] [Comment Edited] (CALCITE-4074) Wrong plan for IS NULL in join query

2020-06-19 Thread Zhixiong Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140952#comment-17140952 ] Zhixiong Chen edited comment on CALCITE-4074 at 6/20/20, 3:48 AM: ---

[jira] [Commented] (CALCITE-4074) Wrong plan for IS NULL in join query

2020-06-19 Thread Zhixiong Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140952#comment-17140952 ] Zhixiong Chen commented on CALCITE-4074: Hi [~danny0405] The join condition I

[jira] [Updated] (CALCITE-4074) Wrong plan for IS NULL in join query

2020-06-19 Thread Zhixiong Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhixiong Chen updated CALCITE-4074: --- Description: sql:  {code:java} SELECT count(*) FROM t6 INNER JOIN t5 ON T6.NUM = T5.NUM

[jira] [Assigned] (CALCITE-4075) Mock table 'EMPNULLABLES' should allow nulls in all non-pk columns

2020-06-19 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-4075: Assignee: Stamatis Zampetakis > Mock table 'EMPNULLABLES' should allow n

[jira] [Created] (CALCITE-4075) Mock table 'EMPNULLABLES' should allow nulls in all non-pk columns

2020-06-19 Thread Stamatis Zampetakis (Jira)
Stamatis Zampetakis created CALCITE-4075: Summary: Mock table 'EMPNULLABLES' should allow nulls in all non-pk columns Key: CALCITE-4075 URL: https://issues.apache.org/jira/browse/CALCITE-4075

[jira] [Commented] (CALCITE-4073) Add a new component RexNormalize for more effect rex nodes normalization

2020-06-19 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140810#comment-17140810 ] Haisheng Yuan commented on CALCITE-4073: I would refrain from adding new config

[jira] [Commented] (CALCITE-3923) Refactor how planner rules are parameterized

2020-06-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140762#comment-17140762 ] Julian Hyde commented on CALCITE-3923: -- {quote}Comparing the new approach, the old

[jira] [Commented] (CALCITE-4071) Make RelNode Immutable

2020-06-19 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140751#comment-17140751 ] Haisheng Yuan commented on CALCITE-4071: lol. HepPlanner is indeed a tricky one

[jira] [Commented] (CALCITE-3963) Maintain logical properties at RelSet (equivalent group) instead of RelNode

2020-06-19 Thread Xiening Dai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140741#comment-17140741 ] Xiening Dai commented on CALCITE-3963: -- {quote} For sets of predicates and unique

[jira] [Commented] (CALCITE-4073) Add a new component RexNormalize for more effect rex nodes normalization

2020-06-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140695#comment-17140695 ] Julian Hyde commented on CALCITE-4073: -- My intuition is that there is not 'one tru

[jira] [Commented] (CALCITE-4071) Make RelNode Immutable

2020-06-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140691#comment-17140691 ] Julian Hyde commented on CALCITE-4071: -- [~hyuan] See if you can remove the current

[jira] [Commented] (CALCITE-3907) CassandraSchema ignores username and password if no port is specified

2020-06-19 Thread Michael Mior (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140657#comment-17140657 ] Michael Mior commented on CALCITE-3907: --- Fixed in [{{3e98d75}}|https://github.co

[jira] [Resolved] (CALCITE-3907) CassandraSchema ignores username and password if no port is specified

2020-06-19 Thread Michael Mior (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michael Mior resolved CALCITE-3907. --- Resolution: Fixed > CassandraSchema ignores username and password if no port is specified >

[jira] [Updated] (CALCITE-4008) Implement Code generation for EnumerableSortedAggregate

2020-06-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4008: --- Labels: pull-request-available (was: ) > Implement Code generation for EnumerableSortedAggregate >

[jira] [Commented] (CALCITE-4074) Wrong plan for IS NULL in join query

2020-06-19 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140551#comment-17140551 ] Stamatis Zampetakis commented on CALCITE-4074: -- I am not sure if it is fix

[jira] [Commented] (CALCITE-3094) Code of method grows beyond 64 KB

2020-06-19 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140508#comment-17140508 ] Thomas Rebele commented on CALCITE-3094: I would not apply a transformation to

[jira] [Updated] (CALCITE-3094) Code of method grows beyond 64 KB

2020-06-19 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Rebele updated CALCITE-3094: --- Attachment: CTE-3094.zip > Code of method grows beyond 64 KB >

[jira] [Commented] (CALCITE-4074) Wrong plan for IS NULL in join query

2020-06-19 Thread Zhixiong Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140404#comment-17140404 ] Zhixiong Chen commented on CALCITE-4074: Hi [~zabetak] , my calcite version is

[jira] [Commented] (CALCITE-2464) Allow to set nullability for columns of structured types

2020-06-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140377#comment-17140377 ] Ruben Q L commented on CALCITE-2464: [~danny0405], I think your example cannot be c

[jira] [Commented] (CALCITE-4074) Wrong plan for IS NULL in join query

2020-06-19 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140367#comment-17140367 ] Stamatis Zampetakis commented on CALCITE-4074: -- Hi [~Zhixiong Chen], the p

[jira] [Commented] (CALCITE-2464) Allow to set nullability for columns of structured types

2020-06-19 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140353#comment-17140353 ] Danny Chen commented on CALCITE-2464: - > If someone declares a column r ROW(x INT N

[jira] [Updated] (CALCITE-3834) Support AntiJoin in EnumerableMergeJoin

2020-06-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3834: --- Labels: pull-request-available (was: ) > Support AntiJoin in EnumerableMergeJoin > ---

[jira] [Updated] (CALCITE-3834) Support AntiJoin in EnumerableMergeJoin

2020-06-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3834: --- Fix Version/s: 1.24.0 > Support AntiJoin in EnumerableMergeJoin > -

[jira] [Updated] (CALCITE-3834) Support AntiJoin in EnumerableMergeJoin

2020-06-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3834: --- Description: Currently, {{EnumerableMergeJoin}} only supports INNER & SEMI joins. The goal of this

[jira] [Updated] (CALCITE-3834) Support AntiJoin in EnumerableMergeJoin

2020-06-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3834: --- Description: Currently, {{EnumerableMergeJoin}} only supports INNER joins. The goal of this ticket

[jira] [Commented] (CALCITE-4074) Wrong plan for IS NULL in join query

2020-06-19 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17140315#comment-17140315 ] Danny Chen commented on CALCITE-4074: - It seems the join condition you want is "is