[jira] [Created] (CALCITE-3145) Aggregate duplicate detection bug with group fields

Steven Talbot created CALCITE-3145: -- Summary: Aggregate duplicate detection bug with group fields Key: CALCITE-3145 URL: https://issues.apache.org/jira/browse/CALCITE-3145 Project: Calcite

[jira] [Commented] (CALCITE-3143) Dividing NULLIF clause may cause Division by zero error

[ https://issues.apache.org/jira/browse/CALCITE-3143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871690#comment-16871690 ] Julian Hyde commented on CALCITE-3143: -- My guess is that it is not OK to comment out that line.

[jira] [Updated] (CALCITE-3145) Aggregate duplicate detection bug with group fields

[ https://issues.apache.org/jira/browse/CALCITE-3145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-3145: --- Description:   Can repro with a simple modification (adding more group fields than there

[jira] [Commented] (CALCITE-3145) Aggregate duplicate detection bug with group fields

[ https://issues.apache.org/jira/browse/CALCITE-3145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871713#comment-16871713 ] Steven Talbot commented on CALCITE-3145: cc [~julianhyde] > Aggregate duplicate detection bug

[jira] [Updated] (CALCITE-3145) Aggregate duplicate detection bug with group fields

[ https://issues.apache.org/jira/browse/CALCITE-3145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-3145: --- Description: Can repro with a simple modification (adding more group fields than there are

[jira] [Commented] (CALCITE-3144) Add rule, CaseFilteredAggregatorRule, that converts "SUM(CASE WHEN b THEN x END)" to "SUM(x) FILTER (WHERE b)"

[ https://issues.apache.org/jira/browse/CALCITE-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871685#comment-16871685 ] Haisheng Yuan commented on CALCITE-3144: I agree that it might be better to transform it in

[jira] [Updated] (CALCITE-3145) RelBuilder.aggregate throws IndexOutOfBoundsException if groupKey is non-empty and there are duplicate aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-3145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3145: - Summary: RelBuilder.aggregate throws IndexOutOfBoundsException if groupKey is non-empty and

[jira] [Commented] (CALCITE-3145) RelBuilder.aggregate throws IndexOutOfBoundsException if groupKey is non-empty and there are duplicate aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-3145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871745#comment-16871745 ] Julian Hyde commented on CALCITE-3145: -- The cause is that CALCITE-3123 did not handle the case of

[jira] [Updated] (CALCITE-3145) RelBuilder.aggregate throws IndexOutOfBoundsException if groupKey is non-empty and there are duplicate aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-3145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3145: - Description: There is a bug with aggregate duplicate with group fields. Can repro with a

[jira] [Updated] (CALCITE-3121) VolcanoPlanner hangs due to removing ORDER BY from sub-query

[ https://issues.apache.org/jira/browse/CALCITE-3121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-3121: - Fix Version/s: 1.21.0 > VolcanoPlanner hangs due to removing ORDER BY from

[jira] [Commented] (CALCITE-3145) RelBuilder.aggregate throws IndexOutOfBoundsException if groupKey is non-empty and there are duplicate aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-3145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871747#comment-16871747 ] Julian Hyde commented on CALCITE-3145: -- I have created a fix in 

[jira] [Created] (CALCITE-3144) Add rule, CaseFilteredAggregatorRule, that converts "SUM(CASE WHEN b THEN x END)" to "SUM(x) FILTER (WHERE b)"

Julian Hyde created CALCITE-3144: Summary: Add rule, CaseFilteredAggregatorRule, that converts "SUM(CASE WHEN b THEN x END)" to "SUM(x) FILTER (WHERE b)" Key: CALCITE-3144 URL:

[jira] [Updated] (CALCITE-3144) Add rule, CaseFilteredAggregatorRule, that converts "SUM(CASE WHEN b THEN x END)" to "SUM(x) FILTER (WHERE b)"

[ https://issues.apache.org/jira/browse/CALCITE-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3144: - Description: Add a rule that converts "SUM(CASE WHEN b THEN x END)" to "SUM\(x) FILTER (WHERE

[jira] [Updated] (CALCITE-3145) Aggregate duplicate detection bug with group fields

[ https://issues.apache.org/jira/browse/CALCITE-3145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-3145: --- Description: Can repro with a simple modification (adding more group fields than there are

[jira] [Commented] (CALCITE-3140) Multiple failures when executing slow tests

[ https://issues.apache.org/jira/browse/CALCITE-3140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871920#comment-16871920 ] Danny Chan commented on CALCITE-3140: - For "separately" i mean to run them in the IDEA test suit,

[jira] [Commented] (CALCITE-3122) Convert Pig Latin scripts into Calcite logical plan

[ https://issues.apache.org/jira/browse/CALCITE-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871886#comment-16871886 ] Khai Tran commented on CALCITE-3122: Hi [~julianhyde] and [~hyuan] Please let me know what I can

[jira] [Commented] (CALCITE-771) Use materialization for scan-project-sort query

[ https://issues.apache.org/jira/browse/CALCITE-771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871020#comment-16871020 ] Danny Chan commented on CALCITE-771: Thanks, [~donnyzone], i have left some review comments. > Use

[jira] [Commented] (CALCITE-3128) Joining two tables producing only NULLs will return 0 rows

[ https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16870827#comment-16870827 ] Feng Zhu commented on CALCITE-3128: --- The generated code for query seems to be OK. {code:java} public

[jira] [Comment Edited] (CALCITE-3128) Joining two tables producing only NULLs will return 0 rows

[ https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16864265#comment-16864265 ] Muhammad Gelbana edited comment on CALCITE-3128 at 6/24/19 9:00 AM:

[jira] [Commented] (CALCITE-3140) Multiple failures when executing slow tests

[ https://issues.apache.org/jira/browse/CALCITE-3140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871046#comment-16871046 ] Danny Chan commented on CALCITE-3140: - [~zabetak] I ran them separately, and there is no error for

[jira] [Created] (CALCITE-3143) Dividing NULLIF clause may cause Division by zero error

Li Xian created CALCITE-3143: Summary: Dividing NULLIF clause may cause Division by zero error Key: CALCITE-3143 URL: https://issues.apache.org/jira/browse/CALCITE-3143 Project: Calcite Issue

[jira] [Commented] (CALCITE-3128) Joining two tables producing only NULLs will return 0 rows

[ https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871116#comment-16871116 ] Feng Zhu commented on CALCITE-3128: --- [~danny0405] I ever executed the query in PG. It will produce a

[jira] [Commented] (CALCITE-3128) Joining two tables producing only NULLs will return 0 rows

[ https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871051#comment-16871051 ] Danny Chan commented on CALCITE-3128: - While i execute the query in MYSQL 5.6: {code:sql} SELECT

[jira] [Commented] (CALCITE-3140) Multiple failures when executing slow tests

[ https://issues.apache.org/jira/browse/CALCITE-3140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871083#comment-16871083 ] Stamatis Zampetakis commented on CALCITE-3140: -- Thanks for double-checking this

[jira] [Updated] (CALCITE-3143) Dividing NULLIF clause may cause Division by zero error

[ https://issues.apache.org/jira/browse/CALCITE-3143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Li Xian updated CALCITE-3143: - Description: execution of query with pattern like below (column COL_A with type BigDecimal) 

[jira] [Comment Edited] (CALCITE-3128) Joining two tables producing only NULLs will return 0 rows

[ https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871116#comment-16871116 ] Feng Zhu edited comment on CALCITE-3128 at 6/24/19 12:20 PM: - [~danny0405]

[jira] [Comment Edited] (CALCITE-3128) Joining two tables producing only NULLs will return 0 rows

[ https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871116#comment-16871116 ] Feng Zhu edited comment on CALCITE-3128 at 6/24/19 12:20 PM: - [~danny0405]

[jira] [Updated] (CALCITE-3143) Dividing NULLIF clause may cause Division by zero error

[ https://issues.apache.org/jira/browse/CALCITE-3143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Li Xian updated CALCITE-3143: - Description: execution of query with pattern like below (column COL_A with type BigDecimal)