[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=17726056#comment-17726056 ] Evgeny Stanilovsky commented on CALCITE-5703: - [~Sergey Nuyanzin] ok i understand, but if i

[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=17726052#comment-17726052 ] hufukang commented on CALCITE-5617: --- select count(0) as total from (select m.USER_CODE, m.USER_NAME

[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=17726024#comment-17726024 ] Benchao Li commented on CALCITE-5722: - [~ian.bertolacci] I've added you to Calcite's contributor

[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=17726013#comment-17726013 ] Julian Hyde commented on CALCITE-5722: -- The bug and the fix make sense. Does this bug manifest in

[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=17726010#comment-17726010 ] Runkang He commented on CALCITE-5617: - [~huge] could you give a SQL example to describe this issue?

[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=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=17725957#comment-17725957 ] Ian Bertolacci commented on CALCITE-5722: - Pertinent line from the `Comparable` documents:

[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=17725940#comment-17725940 ] Ian Bertolacci commented on CALCITE-5722: - I don't seem to be in the proper group to assign

[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:

[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

[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=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=17725794#comment-17725794 ] Benchao Li commented on CALCITE-5720: - [~asolimando] Thank you the the info, it's helpful. I'll

[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

[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

[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=17725690#comment-17725690 ] Alessandro Solimando commented on CALCITE-5720: --- [~maosuhan], thanks for sharing!

[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 

[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

[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

[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=17725670#comment-17725670 ] Benchao Li commented on CALCITE-5720: - It's interesting that JoinPushTransitivePredicatesRule is

[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=17725668#comment-17725668 ] Suhan Mao commented on CALCITE-5720: [~asolimando] Yes, JoinPushTransitivePredicatesRule can do the