[jira] [Commented] (CALCITE-6554) nested correlated sub-query in aggregation does not have inner correlation variable bound to inner projection

[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882758#comment-17882758 ] Ian Bertolacci commented on CALCITE-6554: - Happy to help! > nested correlated

[jira] [Commented] (CALCITE-6554) nested correlated sub-query in aggregation does not have inner correlation variable bound to inner projection

[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17878187#comment-17878187 ] Ian Bertolacci commented on CALCITE-6554: - [Done](https://github.com/apache/cal

[jira] [Comment Edited] (CALCITE-6554) nested correlated sub-query in aggregation does not have inner correlation variable bound to inner projection

[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17878187#comment-17878187 ] Ian Bertolacci edited comment on CALCITE-6554 at 8/30/24 4:32 PM: ---

[jira] [Commented] (CALCITE-6508) Parse error when using scalar sub-query as operand to Array constructor function

[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877899#comment-17877899 ] Ian Bertolacci commented on CALCITE-6508: - Happy to help! Its nice to finally b

[jira] [Commented] (CALCITE-6554) nested correlated sub-query in aggregation does not have inner correlation variable bound to inner projection

[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877516#comment-17877516 ] Ian Bertolacci commented on CALCITE-6554: - Tested and it seems to work: https:

[jira] [Commented] (CALCITE-6554) nested correlated sub-query in aggregation does not have inner correlation variable bound to inner projection

[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877507#comment-17877507 ] Ian Bertolacci commented on CALCITE-6554: - I do wonder if this is correct when

[jira] [Commented] (CALCITE-6554) nested correlated sub-query in aggregation does not have inner correlation variable bound to inner projection

[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877496#comment-17877496 ] Ian Bertolacci commented on CALCITE-6554: - [~libenchao] Would it make sense for

[jira] [Comment Edited] (CALCITE-6554) nested correlated sub-query in aggregation does not have inner correlation variable bound to inner projection

[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877496#comment-17877496 ] Ian Bertolacci edited comment on CALCITE-6554 at 8/28/24 6:46 PM: ---

[jira] [Assigned] (CALCITE-6554) nested correlated sub-query in aggregation does not have inner correlation variable bound to inner projection

[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci reassigned CALCITE-6554: --- Assignee: Ian Bertolacci > nested correlated sub-query in aggregation does not hav

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877494#comment-17877494 ] Ian Bertolacci commented on CALCITE-5213: - It looks like there is still an issu

[jira] [Created] (CALCITE-6554) nested correlated sub-query in aggregation does not have inner correlation variable bound to inner projection

Ian Bertolacci created CALCITE-6554: --- Summary: nested correlated sub-query in aggregation does not have inner correlation variable bound to inner projection Key: CALCITE-6554 URL: https://issues.apache.org/jira/

[jira] [Comment Edited] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877197#comment-17877197 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/27/24 10:58 PM: --

[jira] [Comment Edited] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877197#comment-17877197 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/27/24 10:14 PM: --

[jira] [Comment Edited] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877089#comment-17877089 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/27/24 10:12 PM: --

[jira] [Comment Edited] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877197#comment-17877197 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/27/24 10:12 PM: --

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877197#comment-17877197 ] Ian Bertolacci commented on CALCITE-5213: - I figured out the discrepancy. In ou

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877089#comment-17877089 ] Ian Bertolacci commented on CALCITE-5213: - Hm. Something strange is going on, I

[jira] [Comment Edited] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877089#comment-17877089 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/27/24 4:08 PM: ---

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876842#comment-17876842 ] Ian Bertolacci commented on CALCITE-5213: - [~libenchao] Looks like that no corr

[jira] [Comment Edited] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876837#comment-17876837 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/26/24 9:13 PM: ---

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876837#comment-17876837 ] Ian Bertolacci commented on CALCITE-5213: - [~libenchao] I now realize the impor

[jira] [Comment Edited] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876825#comment-17876825 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/26/24 7:05 PM: ---

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876828#comment-17876828 ] Ian Bertolacci commented on CALCITE-5213: - It also appears that the decorrelato

[jira] [Comment Edited] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876825#comment-17876825 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/26/24 7:04 PM: ---

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876825#comment-17876825 ] Ian Bertolacci commented on CALCITE-5213: - So I was able to quickly come up wit

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17876789#comment-17876789 ] Ian Bertolacci commented on CALCITE-5213: - Ya we've been looking at that, but t

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875243#comment-17875243 ] Ian Bertolacci commented on CALCITE-5213: - I was hoping from something like thi

[jira] [Updated] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-5213: Affects Version/s: 1.37.0 > PROJECT_TO_SUBQUERY producing Incorrect tree from nested corr

[jira] [Comment Edited] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875234#comment-17875234 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/20/24 4:19 PM: ---

[jira] [Comment Edited] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875234#comment-17875234 ] Ian Bertolacci edited comment on CALCITE-5213 at 8/20/24 4:17 PM: ---

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875234#comment-17875234 ] Ian Bertolacci commented on CALCITE-5213: - Here is some replication code in sca

[jira] [Commented] (CALCITE-6508) Parse error when using scalar sub-query as operand to Array constructor function

[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17873653#comment-17873653 ] Ian Bertolacci commented on CALCITE-6508: - Thats fair. Do you think the change

[jira] [Commented] (CALCITE-6508) Parse error when using scalar sub-query as operant to Array constructor function

[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872160#comment-17872160 ] Ian Bertolacci commented on CALCITE-6508: - PR up. > Parse error when using sca

[jira] [Commented] (CALCITE-6508) Parse error when using scalar sub-query as operant to Array constructor function

[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872146#comment-17872146 ] Ian Bertolacci commented on CALCITE-6508: - Yes. > Parse error when using scala

[jira] [Assigned] (CALCITE-6508) Parse error when using scalar sub-query as operant to Array constructor function

[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci reassigned CALCITE-6508: --- Assignee: Ian Bertolacci > Parse error when using scalar sub-query as operant to A

[jira] [Commented] (CALCITE-6508) Parse error when using scalar sub-query as operant to Array constructor function

[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872144#comment-17872144 ] Ian Bertolacci commented on CALCITE-6508: - We extended the parser to use {{`Exp

[jira] [Comment Edited] (CALCITE-6508) Parse error when using scalar sub-query as operant to Array constructor function

[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872144#comment-17872144 ] Ian Bertolacci edited comment on CALCITE-6508 at 8/8/24 10:02 PM: ---

[jira] [Updated] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-5213: Affects Version/s: 1.36.0 > PROJECT_TO_SUBQUERY producing Incorrect tree from nested corr

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872090#comment-17872090 ] Ian Bertolacci commented on CALCITE-5213: - [~libenchao] this does not appear to

[jira] [Commented] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17870298#comment-17870298 ] Ian Bertolacci commented on CALCITE-6504: - A colleague pointed out that JoinPus

[jira] [Created] (CALCITE-6508) Parse error when using scalar sub-query as operant to Array constructor function

Ian Bertolacci created CALCITE-6508: --- Summary: Parse error when using scalar sub-query as operant to Array constructor function Key: CALCITE-6508 URL: https://issues.apache.org/jira/browse/CALCITE-6508

[jira] [Comment Edited] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869048#comment-17869048 ] Ian Bertolacci edited comment on CALCITE-6504 at 7/26/24 11:39 PM: --

[jira] [Commented] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869048#comment-17869048 ] Ian Bertolacci commented on CALCITE-6504: - Some light math and playing around w

[jira] [Commented] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869038#comment-17869038 ] Ian Bertolacci commented on CALCITE-6504: - We're currently investigating if pus

[jira] [Comment Edited] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869038#comment-17869038 ] Ian Bertolacci edited comment on CALCITE-6504 at 7/26/24 10:18 PM: --

[jira] [Updated] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-6504: Description: JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect trees

[jira] [Created] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

Ian Bertolacci created CALCITE-6504: --- Summary: JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join Key: CALCITE-6504 URL: https:

[jira] [Updated] (CALCITE-6504) JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect tree when using correlated sub-query in on clause of equi-join

[ https://issues.apache.org/jira/browse/CALCITE-6504?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-6504: Description: JOIN_SUB_QUERY_TO_CORRELATE/Join SubQueryRemoveRule produces incorrect trees

[jira] [Created] (CALCITE-6499) Deep Clone SqlNodes

Ian Bertolacci created CALCITE-6499: --- Summary: Deep Clone SqlNodes Key: CALCITE-6499 URL: https://issues.apache.org/jira/browse/CALCITE-6499 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726356#comment-17726356 ] Ian Bertolacci commented on CALCITE-5722: - It also has the effect that {{`not (

[jira] [Comment Edited] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726339#comment-17726339 ] Ian Bertolacci edited comment on CALCITE-5722 at 5/25/23 6:21 PM: ---

[jira] [Comment Edited] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726339#comment-17726339 ] Ian Bertolacci edited comment on CALCITE-5722 at 5/25/23 6:20 PM: ---

[jira] [Commented] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726342#comment-17726342 ] Ian Bertolacci commented on CALCITE-5722: - I mention this because the RexProgra

[jira] [Commented] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726339#comment-17726339 ] Ian Bertolacci commented on CALCITE-5722: - I've also noticed that this affects

[jira] [Commented] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726315#comment-17726315 ] Ian Bertolacci commented on CALCITE-5722: - [~libenchao] Thanks! [~julianhyde]

[jira] [Assigned] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci reassigned CALCITE-5722: --- Assignee: Ian Bertolacci > Sarg.isComplementedPoints fails with anti-points which

[jira] [Comment Edited] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725957#comment-17725957 ] Ian Bertolacci edited comment on CALCITE-5722 at 5/24/23 9:30 PM: ---

[jira] [Commented] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725957#comment-17725957 ] Ian Bertolacci commented on CALCITE-5722: - Pertinent line from the `Comparable`

[jira] [Commented] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725940#comment-17725940 ] Ian Bertolacci commented on CALCITE-5722: - I don't seem to be in the proper gro

[jira] [Created] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

Ian Bertolacci created CALCITE-5722: --- Summary: Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals` Key: CALCITE-5722 URL: https://issues.apache.org/jira/browse/CAL

[jira] [Commented] (CALCITE-5210) "type mismatch" litmus test failure during during SqlToRelConverter for group-by on `case` having `in` expression predicates exceeding SqlRelConverter.Config InSubQue

[ https://issues.apache.org/jira/browse/CALCITE-5210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713234#comment-17713234 ] Ian Bertolacci commented on CALCITE-5210: - It appears to be fixed. Closing > "

[jira] [Closed] (CALCITE-5210) "type mismatch" litmus test failure during during SqlToRelConverter for group-by on `case` having `in` expression predicates exceeding SqlRelConverter.Config InSubQueryT

[ https://issues.apache.org/jira/browse/CALCITE-5210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci closed CALCITE-5210. --- Fix Version/s: 1.33.0 Resolution: Fixed > "type mismatch" litmus test failure during

[jira] [Updated] (CALCITE-5631) Optimization to merge redundant joins

[ https://issues.apache.org/jira/browse/CALCITE-5631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-5631: Description: There are situations where multiple joins can be merged into one. For exampl

[jira] [Updated] (CALCITE-5631) Optimization to merge redundant joins

[ https://issues.apache.org/jira/browse/CALCITE-5631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-5631: Description: There are situations where multiple joins can be merged into one. For exampl

[jira] [Created] (CALCITE-5631) Optimization to merge redundant joins

Ian Bertolacci created CALCITE-5631: --- Summary: Optimization to merge redundant joins Key: CALCITE-5631 URL: https://issues.apache.org/jira/browse/CALCITE-5631 Project: Calcite Issue Type: W

[jira] [Commented] (CALCITE-5387) type-mismatch on nullability in JOIN_PUSH_TRANSITIVE_PREDICATES

[ https://issues.apache.org/jira/browse/CALCITE-5387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17635513#comment-17635513 ] Ian Bertolacci commented on CALCITE-5387: - Ya I've confirmed the expression ori

[jira] [Comment Edited] (CALCITE-5387) type-mismatch on nullability in JOIN_PUSH_TRANSITIVE_PREDICATES

[ https://issues.apache.org/jira/browse/CALCITE-5387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17635490#comment-17635490 ] Ian Bertolacci edited comment on CALCITE-5387 at 11/17/22 6:14 PM: --

[jira] [Commented] (CALCITE-5387) type-mismatch on nullability in JOIN_PUSH_TRANSITIVE_PREDICATES

[ https://issues.apache.org/jira/browse/CALCITE-5387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17635490#comment-17635490 ] Ian Bertolacci commented on CALCITE-5387: - [~zabetak] I believe that it is beca

[jira] [Updated] (CALCITE-5387) type-mismatch on nullability in JOIN_PUSH_TRANSITIVE_PREDICATES

[ https://issues.apache.org/jira/browse/CALCITE-5387?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-5387: Affects Version/s: 1.30.0 > type-mismatch on nullability in JOIN_PUSH_TRANSITIVE_PREDICAT

[jira] [Created] (CALCITE-5387) type-mismatch on nullability in JOIN_PUSH_TRANSITIVE_PREDICATES

Ian Bertolacci created CALCITE-5387: --- Summary: type-mismatch on nullability in JOIN_PUSH_TRANSITIVE_PREDICATES Key: CALCITE-5387 URL: https://issues.apache.org/jira/browse/CALCITE-5387 Project: Calc

[jira] [Commented] (CALCITE-5127) Support correlation variables in Project

[ https://issues.apache.org/jira/browse/CALCITE-5127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17630545#comment-17630545 ] Ian Bertolacci commented on CALCITE-5127: - [~dmsysolyatin] Probably the same as

[jira] [Commented] (CALCITE-4120) Inconsistent Calendar used In JdbcMeta between prepareAndExecute and Fetch

[ https://issues.apache.org/jira/browse/CALCITE-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17627979#comment-17627979 ] Ian Bertolacci commented on CALCITE-4120: - {quote}the offsetting should be symm

[jira] [Commented] (CALCITE-4120) Inconsistent Calendar used In JdbcMeta between prepareAndExecute and Fetch

[ https://issues.apache.org/jira/browse/CALCITE-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17627880#comment-17627880 ] Ian Bertolacci commented on CALCITE-4120: - I think we're on the same page there

[jira] [Comment Edited] (CALCITE-4120) Inconsistent Calendar used In JdbcMeta between prepareAndExecute and Fetch

[ https://issues.apache.org/jira/browse/CALCITE-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17627829#comment-17627829 ] Ian Bertolacci edited comment on CALCITE-4120 at 11/2/22 4:49 PM: ---

[jira] [Comment Edited] (CALCITE-4120) Inconsistent Calendar used In JdbcMeta between prepareAndExecute and Fetch

[ https://issues.apache.org/jira/browse/CALCITE-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17627829#comment-17627829 ] Ian Bertolacci edited comment on CALCITE-4120 at 11/2/22 4:48 PM: ---

[jira] [Comment Edited] (CALCITE-4120) Inconsistent Calendar used In JdbcMeta between prepareAndExecute and Fetch

[ https://issues.apache.org/jira/browse/CALCITE-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17627829#comment-17627829 ] Ian Bertolacci edited comment on CALCITE-4120 at 11/2/22 4:39 PM: ---

[jira] [Commented] (CALCITE-4120) Inconsistent Calendar used In JdbcMeta between prepareAndExecute and Fetch

[ https://issues.apache.org/jira/browse/CALCITE-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17627829#comment-17627829 ] Ian Bertolacci commented on CALCITE-4120: - I tried that, and with JdbcMeta usin

[jira] [Commented] (CALCITE-2394) Avatica applies calendar offset to timestamps when they should remain unchanged

[ https://issues.apache.org/jira/browse/CALCITE-2394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17627304#comment-17627304 ] Ian Bertolacci commented on CALCITE-2394: - Is this related to, or the cause of,

[jira] [Commented] (CALCITE-4120) Inconsistent Calendar used In JdbcMeta between prepareAndExecute and Fetch

[ https://issues.apache.org/jira/browse/CALCITE-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17626784#comment-17626784 ] Ian Bertolacci commented on CALCITE-4120: - Further, by changing my machine's ti

[jira] [Comment Edited] (CALCITE-4120) Inconsistent Calendar used In JdbcMeta between prepareAndExecute and Fetch

[ https://issues.apache.org/jira/browse/CALCITE-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17626781#comment-17626781 ] Ian Bertolacci edited comment on CALCITE-4120 at 10/31/22 7:19 PM: --

[jira] [Commented] (CALCITE-4120) Inconsistent Calendar used In JdbcMeta between prepareAndExecute and Fetch

[ https://issues.apache.org/jira/browse/CALCITE-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17626781#comment-17626781 ] Ian Bertolacci commented on CALCITE-4120: - To add to this, I believe that this

[jira] [Closed] (CALCITE-5273) RelToSqlConverter allows unparsing of invalid CASE expression

[ https://issues.apache.org/jira/browse/CALCITE-5273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci closed CALCITE-5273. --- Resolution: Won't Fix > RelToSqlConverter allows unparsing of invalid CASE expression > ---

[jira] [Closed] (CALCITE-5272) RelBuilder/RexBuilder allow creation of invalid CASE expression

[ https://issues.apache.org/jira/browse/CALCITE-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci closed CALCITE-5272. --- Resolution: Not A Problem Realized that RelBuilder/RexBuilder actually *does* guard against

[jira] [Commented] (CALCITE-5272) RelBuilder/RexBuilder allow creation of invalid CASE expression

[ https://issues.apache.org/jira/browse/CALCITE-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17601475#comment-17601475 ] Ian Bertolacci commented on CALCITE-5272: - {quote}I am inclined to say that a C

[jira] [Commented] (CALCITE-5273) RelToSqlConverter allows unparsing of invalid CASE expression

[ https://issues.apache.org/jira/browse/CALCITE-5273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17601470#comment-17601470 ] Ian Bertolacci commented on CALCITE-5273: - {quote}Can you make the case for and

[jira] [Updated] (CALCITE-5272) RelBuilder/RexBuilder allow creation of invalid CASE expression

[ https://issues.apache.org/jira/browse/CALCITE-5272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-5272: Priority: Minor (was: Major) > RelBuilder/RexBuilder allow creation of invalid CASE expr

[jira] [Created] (CALCITE-5273) RelToSqlConverter allows unparsing of invalid CASE expression

Ian Bertolacci created CALCITE-5273: --- Summary: RelToSqlConverter allows unparsing of invalid CASE expression Key: CALCITE-5273 URL: https://issues.apache.org/jira/browse/CALCITE-5273 Project: Calcit

[jira] [Created] (CALCITE-5272) RelBuilder/RexBuilder allow creation of invalid CASE expression

Ian Bertolacci created CALCITE-5272: --- Summary: RelBuilder/RexBuilder allow creation of invalid CASE expression Key: CALCITE-5272 URL: https://issues.apache.org/jira/browse/CALCITE-5272 Project: Calc

[jira] [Commented] (CALCITE-4663) And predicate in one subtree of Join causes JoinPushTransitivePredicatesRule pulls up predicates infinitely and StackOverflowError

[ https://issues.apache.org/jira/browse/CALCITE-4663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17581286#comment-17581286 ] Ian Bertolacci commented on CALCITE-4663: - [~libenchao] Unfortunately our proce

[jira] [Comment Edited] (CALCITE-4663) And predicate in one subtree of Join causes JoinPushTransitivePredicatesRule pulls up predicates infinitely and StackOverflowError

[ https://issues.apache.org/jira/browse/CALCITE-4663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17581267#comment-17581267 ] Ian Bertolacci edited comment on CALCITE-4663 at 8/18/22 10:19 AM: --

[jira] [Commented] (CALCITE-4663) And predicate in one subtree of Join causes JoinPushTransitivePredicatesRule pulls up predicates infinitely and StackOverflowError

[ https://issues.apache.org/jira/browse/CALCITE-4663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17581267#comment-17581267 ] Ian Bertolacci commented on CALCITE-4663: - We are using 1.30. I'm able to prov

[jira] [Commented] (CALCITE-4663) And predicate in one subtree of Join causes JoinPushTransitivePredicatesRule pulls up predicates infinitely and StackOverflowError

[ https://issues.apache.org/jira/browse/CALCITE-4663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17580793#comment-17580793 ] Ian Bertolacci commented on CALCITE-4663: - Another example: {code} select LHS.C

[jira] [Commented] (CALCITE-5092) Calcite Web: API doc search gives links with invalid "undefined" subpath resulting in 404

[ https://issues.apache.org/jira/browse/CALCITE-5092?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17575351#comment-17575351 ] Ian Bertolacci commented on CALCITE-5092: - I've also confirmed that this is fix

[jira] [Comment Edited] (CALCITE-5127) Error when executing query with subquery in select list that uses outer column of array type

[ https://issues.apache.org/jira/browse/CALCITE-5127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17567390#comment-17567390 ] Ian Bertolacci edited comment on CALCITE-5127 at 7/15/22 9:50 PM: ---

[jira] [Updated] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-5213: Description: CoreRules.PROJECT_SUB_QUERY_TO_CORRELATE produces (what I believe to be) in

[jira] [Updated] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-5213: Description: CoreRules.PROJECT_SUB_QUERY_TO_CORRELATE produces (what I believe to be) in

[jira] [Updated] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-5213: Description: CoreRules.PROJECT_SUB_QUERY_TO_CORRELATE produces (what I believe to be) in

[jira] [Commented] (CALCITE-5127) Error when executing query with subquery in select list that uses outer column of array type

[ https://issues.apache.org/jira/browse/CALCITE-5127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17567390#comment-17567390 ] Ian Bertolacci commented on CALCITE-5127: - Also, would this PR resolve the main

[jira] [Updated] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-5213: Description: CoreRules.PROJECT_SUB_QUERY_TO_CORRELATE produces (what I believe to be) in

[jira] [Updated] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci updated CALCITE-5213: Description: CoreRules.PROJECT_SUB_QUERY_TO_CORRELATE produces (what I believe to be) in

  1   2   >