[jira] [Comment Edited] (CALCITE-5683) Two level nested correlated subquery throws an exception during decorrelation.

2023-05-24 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726066#comment-17726066 ] Hanumath Rao Maduri edited comment on CALCITE-5683 at 5/25/23 6:31 AM: --

[jira] [Commented] (CALCITE-5683) Two level nested correlated subquery throws an exception during decorrelation.

2023-05-24 Thread Hanumath Rao Maduri (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726066#comment-17726066 ] Hanumath Rao Maduri commented on CALCITE-5683: -- With the fix provided for

[jira] [Commented] (CALCITE-5703) Reduce amount of generated runtime code

2023-05-24 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726065#comment-17726065 ] Sergey Nuyanzin commented on CALCITE-5703: -- Unfortunately I can not answer her

[jira] [Commented] (CALCITE-5703) Reduce amount of generated runtime code

2023-05-24 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726056#comment-17726056 ] Evgeny Stanilovsky commented on CALCITE-5703: - [~Sergey Nuyanzin] ok i unde

[jira] [Commented] (CALCITE-5617) count() + left join execution efficiency optimize

2023-05-24 Thread hufukang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726052#comment-17726052 ] hufukang commented on CALCITE-5617: --- select count(0) as total from (select m.USER_COD

[jira] [Reopened] (CALCITE-5617) count() + left join execution efficiency optimize

2023-05-24 Thread hufukang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hufukang reopened CALCITE-5617: --- > count() + left join execution efficiency optimize > -

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

2023-05-24 Thread Ian Bertolacci (Jira)
[ 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] [Commented] (CALCITE-5722) Sarg.isComplementedPoints fails with anti-points which are equal under `compareTo` but not `equals`

2023-05-24 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726024#comment-17726024 ] Benchao Li commented on CALCITE-5722: - [~ian.bertolacci] I've added you to Calcite'

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

2023-05-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726013#comment-17726013 ] Julian Hyde commented on CALCITE-5722: -- The bug and the fix make sense. Does this

[jira] [Commented] (CALCITE-5617) count() + left join execution efficiency optimize

2023-05-24 Thread Runkang He (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726010#comment-17726010 ] Runkang He commented on CALCITE-5617: - [~huge] could you give a SQL example to desc

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

2023-05-24 Thread Ian Bertolacci (Jira)
[ 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`

2023-05-24 Thread Ian Bertolacci (Jira)
[ 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`

2023-05-24 Thread Ian Bertolacci (Jira)
[ 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`

2023-05-24 Thread Ian Bertolacci (Jira)
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] [Created] (CALCITE-5721) Capture build scans on ge.apache.org to benefit from deep build insights

2023-05-24 Thread Clay Johnson (Jira)
Clay Johnson created CALCITE-5721: - Summary: Capture build scans on ge.apache.org to benefit from deep build insights Key: CALCITE-5721 URL: https://issues.apache.org/jira/browse/CALCITE-5721 Project:

[jira] [Commented] (CALCITE-5674) Cast expr to target type should respect nullable when it is complex type

2023-05-24 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725818#comment-17725818 ] Ruben Q L commented on CALCITE-5674: Just for the record: a minor [regression was

[jira] [Updated] (CALCITE-5715) Prune old nodes after projection merging in ProjectMergeRule

2023-05-24 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li updated CALCITE-5715: Fix Version/s: 1.35.0 > Prune old nodes after projection merging in ProjectMergeRule > --

[jira] [Updated] (CALCITE-5717) Prune Project's input if project has no InputRef and the input has 1 row

2023-05-24 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li updated CALCITE-5717: Fix Version/s: 1.35.0 > Prune Project's input if project has no InputRef and the input has 1 row

[jira] [Commented] (CALCITE-5720) improve FilterJoinRule to push filter into both join sides

2023-05-24 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725794#comment-17725794 ] Benchao Li commented on CALCITE-5720: - [~asolimando] Thank you the the info, it's h

[jira] [Updated] (CALCITE-5661) Introduce another way to convert IN predicate to RelNode when IN list is large

2023-05-24 Thread Runkang He (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5661?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He updated CALCITE-5661: Affects Version/s: 1.22.0 (was: 1.34.0) > Introduce another way to con

[jira] [Resolved] (CALCITE-5705) Generalize RemoveEmptySingleRule to work with arbitrary relations and pruning configurations

2023-05-24 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-5705. -- Resolution: Fixed Fixed in https://github.com/apache/calcite/commit/f3228987

[jira] [Commented] (CALCITE-5720) improve FilterJoinRule to push filter into both join sides

2023-05-24 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725690#comment-17725690 ] Alessandro Solimando commented on CALCITE-5720: --- [~maosuhan], thanks for

[jira] [Updated] (CALCITE-5029) Babel parser support identifier starting with number

2023-05-24 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5029: --- Affects Version/s: 1.34.0 > Babel parser support identifier starting with number >

[jira] [Resolved] (CALCITE-5029) Babel parser support identifier starting with number

2023-05-24 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin resolved CALCITE-5029. Fix Version/s: 1.35.0 Resolution: Fixed Fixed in  [0d3cf2c|https://github.

[jira] [Resolved] (CALCITE-5668) When parsing SQL in PostgreSQL dialect, allow unquoted table names to contain dollar sign, letters with diacritical marks and non-Latin letters

2023-05-24 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin resolved CALCITE-5668. Resolution: Fixed Fixed in [0d3cf2c|https://github.com/apache/calcite/commit/0d3

[jira] [Updated] (CALCITE-5668) When parsing SQL in PostgreSQL dialect, allow unquoted table names to contain dollar sign, letters with diacritical marks and non-Latin letters

2023-05-24 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5668: --- Fix Version/s: 1.35.0 > When parsing SQL in PostgreSQL dialect, allow unquoted tabl

[jira] [Commented] (CALCITE-5720) improve FilterJoinRule to push filter into both join sides

2023-05-24 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725670#comment-17725670 ] Benchao Li commented on CALCITE-5720: - It's interesting that JoinPushTransitivePred

[jira] [Closed] (CALCITE-5720) improve FilterJoinRule to push filter into both join sides

2023-05-24 Thread Suhan Mao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suhan Mao closed CALCITE-5720. -- Resolution: Not A Problem > improve FilterJoinRule to push filter into both join sides >

[jira] [Commented] (CALCITE-5720) improve FilterJoinRule to push filter into both join sides

2023-05-24 Thread Suhan Mao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725668#comment-17725668 ] Suhan Mao commented on CALCITE-5720: [~asolimando] Yes, JoinPushTransitivePredicate