[jira] [Commented] (CALCITE-4495) Sarg simplification with IS_NULL and unknown type throws IllegalArgumentException

2021-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17283478#comment-17283478 ] Julian Hyde commented on CALCITE-4495: -- [~swtalbot], It looks as if {{RexLiteral.v

[jira] [Updated] (CALCITE-4495) Sarg simplification with IS_NULL and unknown type throws IllegalArgumentException

2021-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4495: - Description: Apologies. After spending an hour or so trying to write a simple repro for this I

[jira] [Updated] (CALCITE-4495) Sarg simplification with IS_NULL and unknown type throws IllegalArgumentException

2021-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4495: - Description: Apologies. After spending an hour or so trying to write a simple repro for this I

[jira] [Updated] (CALCITE-4495) Sarg simplification with IS_NULL and unknown type throws IllegalArgumentException

2021-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4495: - Description: Apologies. After spending an hour or so trying to write a simple repro for this I

[jira] [Commented] (CALCITE-4496) Measure columns ("SELECT ... AS MEASURE")

2021-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17283449#comment-17283449 ] Julian Hyde commented on CALCITE-4496: -- Work in progress: [julianhyde/4496-measur

[jira] [Created] (CALCITE-4497) In RelBuilder, support windowed aggregate functions (OVER)

2021-02-11 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-4497: Summary: In RelBuilder, support windowed aggregate functions (OVER) Key: CALCITE-4497 URL: https://issues.apache.org/jira/browse/CALCITE-4497 Project: Calcite

[jira] [Comment Edited] (CALCITE-4483) WITHIN DISTINCT clause for aggregate functions (experimental)

2021-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17283432#comment-17283432 ] Julian Hyde edited comment on CALCITE-4483 at 2/11/21, 11:58 PM:

[jira] [Comment Edited] (CALCITE-4483) WITHIN DISTINCT clause for aggregate functions (experimental)

2021-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17283432#comment-17283432 ] Julian Hyde edited comment on CALCITE-4483 at 2/11/21, 11:58 PM:

[jira] [Resolved] (CALCITE-4483) WITHIN DISTINCT clause for aggregate functions (experimental)

2021-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-4483. -- Fix Version/s: 1.27.0 Resolution: Fixed Fixed in [f1da6550|https://github.com/apache/

[jira] [Commented] (CALCITE-4483) WITHIN DISTINCT clause for aggregate functions (experimental)

2021-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17283432#comment-17283432 ] Julian Hyde commented on CALCITE-4483: -- I implemented {{UNIQUE_VALUE}}, but it was

[jira] [Updated] (CALCITE-4483) WITHIN DISTINCT clause for aggregate functions (experimental)

2021-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4483: - Description: Add a {{WITHIN DISTINCT}} clause to aggregate functions, allowing duplicate rows

[jira] [Updated] (CALCITE-4483) WITHIN DISTINCT clause for aggregate functions (experimental)

2021-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4483: - Summary: WITHIN DISTINCT clause for aggregate functions (experimental) (was: Add WITHIN DISTIN

[jira] [Created] (CALCITE-4496) Measure columns ("SELECT ... AS MEASURE")

2021-02-11 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-4496: Summary: Measure columns ("SELECT ... AS MEASURE") Key: CALCITE-4496 URL: https://issues.apache.org/jira/browse/CALCITE-4496 Project: Calcite Issue Type: Bug

[jira] [Updated] (CALCITE-4495) Sarg simplification with IS_NULL and unknown type throws IllegalArgumentException

2021-02-11 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov updated CALCITE-4495: --- Fix Version/s: 1.27.0 > Sarg simplification with IS_NULL and unknown type throws >

[jira] [Updated] (CALCITE-4495) Sarg simplification with IS_NULL and unknown type throws IllegalArgumentException

2021-02-11 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-4495: --- Description: Apologies. After spending an hour or so trying to write a simple repro for thi

[jira] [Created] (CALCITE-4495) Sarg simplification with IS_NULL and unknown type throws IllegalArgumentException

2021-02-11 Thread Steven Talbot (Jira)
Steven Talbot created CALCITE-4495: -- Summary: Sarg simplification with IS_NULL and unknown type throws IllegalArgumentException Key: CALCITE-4495 URL: https://issues.apache.org/jira/browse/CALCITE-4495

[jira] [Assigned] (CALCITE-4494) Improve planning performance with RelSubset check for Rel presence

2021-02-11 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-4494: Assignee: Igor Lozynskyi > Improve planning performance with RelSubset

[jira] [Updated] (CALCITE-4494) Improve planning performance with RelSubset check for Rel presence

2021-02-11 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4494: Labels: performance pull-request-available (was: performance) > Improve planning perfor

[jira] [Updated] (CALCITE-4494) Improve planning performance with RelSubset check for Rel presence

2021-02-11 Thread Igor Lozynskyi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Igor Lozynskyi updated CALCITE-4494: Description: *Problem* Currently, the planning process shows a performance degradation w

[jira] [Created] (CALCITE-4494) Improve planning performance with RelSubset check for Rel presence

2021-02-11 Thread Igor Lozynskyi (Jira)
Igor Lozynskyi created CALCITE-4494: --- Summary: Improve planning performance with RelSubset check for Rel presence Key: CALCITE-4494 URL: https://issues.apache.org/jira/browse/CALCITE-4494 Project:

[jira] [Resolved] (CALCITE-4489) Avatica JdbcMeta statement IDs Concurrency problem

2021-02-11 Thread Vlad Skarzhevskyy (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vlad Skarzhevskyy resolved CALCITE-4489. Resolution: Invalid > Avatica JdbcMeta statement IDs Concurrency problem > --

[jira] [Commented] (CALCITE-4489) Avatica JdbcMeta statement IDs Concurrency problem

2021-02-11 Thread Vlad Skarzhevskyy (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17283091#comment-17283091 ] Vlad Skarzhevskyy commented on CALCITE-4489: [~zabetak] thanks for the feed

[jira] [Commented] (CALCITE-4491) Aggregation of window function produces invalid SQL for PostgreSQL

2021-02-11 Thread Dominik Labuda (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17282926#comment-17282926 ] Dominik Labuda commented on CALCITE-4491: - Awesome, thanks for the final cleanu