[jira] [Comment Edited] (CALCITE-2792) Stackoverflow while evaluating filter with large number of OR conditions

[ https://issues.apache.org/jira/browse/CALCITE-2792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750750#comment-16750750 ] pengzhiwei edited comment on CALCITE-2792 at 1/24/19 6:17 AM: ---

[jira] [Commented] (CALCITE-2792) Stackoverflow while evaluating filter with large number of OR conditions

[ https://issues.apache.org/jira/browse/CALCITE-2792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750750#comment-16750750 ] pengzhiwei commented on CALCITE-2792: - Hi [~julianhyde],the StackOverflowError come

[jira] [Updated] (CALCITE-2801) Check input type in AggregateUnionAggregateRule when remove the bottom Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-2801?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hequn Cheng updated CALCITE-2801: - Description: In {{AggregateUnionAggregateRule}}, we may remove the bottom Aggregate and use it

[jira] [Created] (CALCITE-2801) Check input type in AggregateUnionAggregateRule when remove the bottom Aggregate

Hequn Cheng created CALCITE-2801: Summary: Check input type in AggregateUnionAggregateRule when remove the bottom Aggregate Key: CALCITE-2801 URL: https://issues.apache.org/jira/browse/CALCITE-2801 Pr

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750547#comment-16750547 ] Volodymyr Vysotskyi commented on CALCITE-2799: -- I agree with [~vladimirsit

[jira] [Commented] (CALCITE-2798) Optimizer should remove unneeded Sort

[ https://issues.apache.org/jira/browse/CALCITE-2798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750443#comment-16750443 ] Vladimir Sitnikov commented on CALCITE-2798: {quote}I know you have written

[jira] [Comment Edited] (CALCITE-2798) Optimizer should remove unneeded Sort

[ https://issues.apache.org/jira/browse/CALCITE-2798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750443#comment-16750443 ] Vladimir Sitnikov edited comment on CALCITE-2798 at 1/23/19 9:24 PM:

[jira] [Commented] (CALCITE-2798) Optimizer should remove unneeded Sort

[ https://issues.apache.org/jira/browse/CALCITE-2798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750441#comment-16750441 ] Vladimir Sitnikov commented on CALCITE-2798: {quote}Pragmatically, I don't

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750422#comment-16750422 ] Vladimir Sitnikov commented on CALCITE-2799: {quote}based on initial design

[jira] [Issue Comment Deleted] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov updated CALCITE-2799: --- Comment: was deleted (was: Ok, great. Thank you. +1) > Allow alias in having clau

[jira] [Commented] (CALCITE-2798) Optimizer should remove unneeded Sort

[ https://issues.apache.org/jira/browse/CALCITE-2798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750370#comment-16750370 ] Vladimir Sitnikov commented on CALCITE-2798: {quote} The union query isn't

[jira] [Commented] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750383#comment-16750383 ] Julian Hyde commented on CALCITE-2593: -- I'll help find a solution to this bug. I

[jira] [Commented] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750377#comment-16750377 ] Vladimir Sitnikov commented on CALCITE-2593: [~julianhyde], Can we go with

[jira] [Commented] (CALCITE-2798) Optimizer should remove unneeded Sort

[ https://issues.apache.org/jira/browse/CALCITE-2798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750379#comment-16750379 ] Julian Hyde commented on CALCITE-2798: -- In academic relational algebra, Sort is no

[jira] [Commented] (CALCITE-2783) "COALESCE(s, TRUE) = TRUE" and "(s OR s IS UNKNOWN) = TRUE" causes NullPointerException

[ https://issues.apache.org/jira/browse/CALCITE-2783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750361#comment-16750361 ] Julian Hyde commented on CALCITE-2783: -- Thanks. I prefer the plain old commit hash

[jira] [Updated] (CALCITE-2783) "COALESCE(s, TRUE) = TRUE" and "(s OR s IS UNKNOWN) = TRUE" causes NullPointerException

[ https://issues.apache.org/jira/browse/CALCITE-2783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2783: - Summary: "COALESCE(s, TRUE) = TRUE" and "(s OR s IS UNKNOWN) = TRUE" causes NullPointerExceptio

[jira] [Commented] (CALCITE-2798) Optimizer should remove unneeded Sort

[ https://issues.apache.org/jira/browse/CALCITE-2798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750346#comment-16750346 ] Julian Hyde commented on CALCITE-2798: -- The {{union}} query isn't a clear win. Eli

[jira] [Commented] (CALCITE-2783) Fix null related issues during RexToLix translation

[ https://issues.apache.org/jira/browse/CALCITE-2783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750352#comment-16750352 ] Zoltan Haindrich commented on CALCITE-2783: --- It's a [git describe|https://git

[jira] [Commented] (CALCITE-2792) Stackoverflow while evaluating filter with large number of OR conditions

[ https://issues.apache.org/jira/browse/CALCITE-2792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750349#comment-16750349 ] Julian Hyde commented on CALCITE-2792: -- Did you know that the OR operator in a Rex

[jira] [Created] (CALCITE-2800) Geode change to support filtering by enum columns of the GeodeTable

Sandeep Chada created CALCITE-2800: -- Summary: Geode change to support filtering by enum columns of the GeodeTable Key: CALCITE-2800 URL: https://issues.apache.org/jira/browse/CALCITE-2800 Project: Ca

[jira] [Resolved] (CALCITE-2789) Bump version dependencies Jan 2019

[ https://issues.apache.org/jira/browse/CALCITE-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden resolved CALCITE-2789. --- Resolution: Fixed > Bump version dependencies Jan 2019 > --

[jira] [Commented] (CALCITE-2789) Bump version dependencies Jan 2019

[ https://issues.apache.org/jira/browse/CALCITE-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750344#comment-16750344 ] Kevin Risden commented on CALCITE-2789: --- Fixed in commit 074e9f8ca4be967d81aaf1da

[jira] [Commented] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750335#comment-16750335 ] Julian Hyde commented on CALCITE-2593: -- My opinion is that RelSubset should remain

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750325#comment-16750325 ] Julian Hyde commented on CALCITE-2799: -- If an aggregate function has an alias, say

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750310#comment-16750310 ] Julian Hyde commented on CALCITE-2799: -- Personally I'm not a huge fan of this styl

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750305#comment-16750305 ] Vladimir Sitnikov commented on CALCITE-2799: Ok, great. Thank you. +1 > A

[jira] [Commented] (CALCITE-2783) Fix null related issues during RexToLix translation

[ https://issues.apache.org/jira/browse/CALCITE-2783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750300#comment-16750300 ] Julian Hyde commented on CALCITE-2783: -- What is  calcite-1.17.0-260-g217f2d082? Th

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750274#comment-16750274 ] Arina Ielchiieva commented on CALCITE-2799: --- No, this was just FYI :) But jus

[jira] [Commented] (CALCITE-2789) Bump version dependencies Jan 2019

[ https://issues.apache.org/jira/browse/CALCITE-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750155#comment-16750155 ] Kevin Risden commented on CALCITE-2789: --- There are some non trivial deprecations

[jira] [Updated] (CALCITE-2789) Bump version dependencies Jan 2019

[ https://issues.apache.org/jira/browse/CALCITE-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden updated CALCITE-2789: -- Description: Currently there are a bunch of dependencies that can be updated: * apache-rat-p

[jira] [Updated] (CALCITE-2789) Bump version dependencies Jan 2019

[ https://issues.apache.org/jira/browse/CALCITE-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden updated CALCITE-2789: -- Description: Currently there are a bunch of dependencies that can be updated: * apache-rat-p

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750134#comment-16750134 ] Vladimir Sitnikov commented on CALCITE-2799: Sorry, does that mean {code:s

[jira] [Comment Edited] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750063#comment-16750063 ] Arina Ielchiieva edited comment on CALCITE-2799 at 1/23/19 3:25 PM: -

[jira] [Commented] (CALCITE-2788) Building error for sub-project of calcite on "maven-checkstyle-plugin"

[ https://issues.apache.org/jira/browse/CALCITE-2788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750080#comment-16750080 ] Kevin Risden commented on CALCITE-2788: --- Ah yea now I understand the changes. Sor

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750063#comment-16750063 ] Arina Ielchiieva commented on CALCITE-2799: --- [~vladimirsitnikov] based on ini

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750037#comment-16750037 ] Vladimir Sitnikov commented on CALCITE-2799: Would you please add a test fo

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750042#comment-16750042 ] Vladimir Sitnikov commented on CALCITE-2799: [~arina], would you please add

[jira] [Issue Comment Deleted] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov updated CALCITE-2799: --- Comment: was deleted (was: Would you please add a test for `group by x having x>1`

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750027#comment-16750027 ] Arina Ielchiieva commented on CALCITE-2799: --- [~vladimirsitnikov] no, my chang

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750008#comment-16750008 ] Vladimir Sitnikov commented on CALCITE-2799: [~arina], do you intend to cha

[jira] [Comment Edited] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16750008#comment-16750008 ] Vladimir Sitnikov edited comment on CALCITE-2799 at 1/23/19 1:55 PM:

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1674#comment-1674 ] Arina Ielchiieva commented on CALCITE-2799: --- Opened PR - https://github.com/a

[jira] [Commented] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16749989#comment-16749989 ] Vladimir Sitnikov commented on CALCITE-2593: [~zhztheplayer], I think 1) {

[jira] [Commented] (CALCITE-2648) Output collation of EnumerableWindow is not consistent with its implementation

[ https://issues.apache.org/jira/browse/CALCITE-2648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16749959#comment-16749959 ] Vladimir Sitnikov commented on CALCITE-2648: Just in case, PostgreSQL does

[jira] [Updated] (CALCITE-2648) Output collation of EnumerableWindow is not consistent with its implementation

[ https://issues.apache.org/jira/browse/CALCITE-2648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov updated CALCITE-2648: --- Attachment: postgresql_96_doesnt_care_to_keep_collation_for_project_over_expression

[jira] [Resolved] (CALCITE-2783) Fix null related issues during RexToLix translation

[ https://issues.apache.org/jira/browse/CALCITE-2783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Haindrich resolved CALCITE-2783. --- Resolution: Fixed Fix Version/s: 1.19.0 > Fix null related issues during Rex

[jira] [Commented] (CALCITE-2783) Fix null related issues during RexToLix translation

[ https://issues.apache.org/jira/browse/CALCITE-2783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16749946#comment-16749946 ] Zoltan Haindrich commented on CALCITE-2783: --- Fixed in [calcite-1.17.0-260-g2

[jira] [Created] (CALCITE-2799) Allow alias in having clause for aggregate functions

Arina Ielchiieva created CALCITE-2799: - Summary: Allow alias in having clause for aggregate functions Key: CALCITE-2799 URL: https://issues.apache.org/jira/browse/CALCITE-2799 Project: Calcite

[jira] [Created] (CALCITE-2798) Optimizer should remove unneeded Sort

Vladimir Sitnikov created CALCITE-2798: -- Summary: Optimizer should remove unneeded Sort Key: CALCITE-2798 URL: https://issues.apache.org/jira/browse/CALCITE-2798 Project: Calcite Issue T

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

[ https://issues.apache.org/jira/browse/CALCITE-2464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16749709#comment-16749709 ] Stamatis Zampetakis commented on CALCITE-2464: -- [~rubenql] A column defini

[jira] [Commented] (CALCITE-2648) Output collation of EnumerableWindow is not consistent with its implementation

[ https://issues.apache.org/jira/browse/CALCITE-2648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16749661#comment-16749661 ] Hongze Zhang commented on CALCITE-2648: --- Hi [~vladimirsitnikov], could you please