[jira] [Commented] (CALCITE-1946) Dialects lacking support for nested aggregations should use sub select instead

[ https://issues.apache.org/jira/browse/CALCITE-1946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16156230#comment-16156230 ] Pawel Ruchaj commented on CALCITE-1946: --- More checks added:

[jira] [Commented] (CALCITE-1946) Dialects lacking support for nested aggregations should use sub select instead

[ https://issues.apache.org/jira/browse/CALCITE-1946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16152796#comment-16152796 ] Pawel Ruchaj commented on CALCITE-1946: --- I think we need a code which checks that: - current SQL

[jira] [Updated] (CALCITE-1946) Dialects lacking support for nested aggregations should use sub select instead

[ https://issues.apache.org/jira/browse/CALCITE-1946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pawel Ruchaj updated CALCITE-1946: -- Summary: Dialects lacking support for nested aggregations should use sub select instead

[jira] [Commented] (CALCITE-1946) Query containing cascaded aggregation gets converted to incorrect sql

[ https://issues.apache.org/jira/browse/CALCITE-1946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16130500#comment-16130500 ] Pawel Ruchaj commented on CALCITE-1946: --- [~julianhyde] Please take a look

[jira] [Updated] (CALCITE-1946) Query containing cascaded aggregation gets converted to incorrect sql

[ https://issues.apache.org/jira/browse/CALCITE-1946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pawel Ruchaj updated CALCITE-1946: -- Description: Below query, containing 2 SUM aggregation functions and sub-select, gets

[jira] [Updated] (CALCITE-1946) Query containing cascaded aggregation gets converted to incorrect sql

[ https://issues.apache.org/jira/browse/CALCITE-1946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pawel Ruchaj updated CALCITE-1946: -- Description: Below query, containing 2 SUM aggregation functions and sub-select, gets

[jira] [Updated] (CALCITE-1946) Query containing cascaded aggregation gets converted to incorrect sql

[ https://issues.apache.org/jira/browse/CALCITE-1946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pawel Ruchaj updated CALCITE-1946: -- Description: Below query, containing 2 SUM aggregation functions and sub-select, gets

[jira] [Comment Edited] (CALCITE-1946) Query containing cascaded aggregation gets converted to incorrect sql

[ https://issues.apache.org/jira/browse/CALCITE-1946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16129517#comment-16129517 ] Pawel Ruchaj edited comment on CALCITE-1946 at 8/16/17 10:15 PM: -

[jira] [Comment Edited] (CALCITE-1946) Query containing cascaded aggregation gets converted to incorrect sql

[ https://issues.apache.org/jira/browse/CALCITE-1946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16129517#comment-16129517 ] Pawel Ruchaj edited comment on CALCITE-1946 at 8/16/17 10:13 PM: -

[jira] [Commented] (CALCITE-1946) Query containing cascaded aggregation gets converted to incorrect sql

[ https://issues.apache.org/jira/browse/CALCITE-1946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16129517#comment-16129517 ] Pawel Ruchaj commented on CALCITE-1946: --- Triggering needNew in SqlImplementor.builder when

[jira] [Commented] (CALCITE-1946) Query containing cascaded aggregation gets converted to incorrect sql

[ https://issues.apache.org/jira/browse/CALCITE-1946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16129511#comment-16129511 ] Pawel Ruchaj commented on CALCITE-1946: --- It is valid in Oracle: http://rextester.com/LAJS17477 >

[jira] [Created] (CALCITE-1946) Query containing cascaded aggregation gets converted to incorrect sql

Pawel Ruchaj created CALCITE-1946: - Summary: Query containing cascaded aggregation gets converted to incorrect sql Key: CALCITE-1946 URL: https://issues.apache.org/jira/browse/CALCITE-1946 Project: