[jira] [Created] (CALCITE-2128) Add jethro sql dialect and jdbc support

2018-01-10 Thread Jonathan Doron (JIRA)
Jonathan Doron created CALCITE-2128: --- Summary: Add jethro sql dialect and jdbc support Key: CALCITE-2128 URL: https://issues.apache.org/jira/browse/CALCITE-2128 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-2088) More complex end2end tests in Calcite Plus module

2018-01-10 Thread Piotr Bojko (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16320163#comment-16320163 ] Piotr Bojko commented on CALCITE-2088: -- I've created the pull request for this - h

[jira] [Created] (CALCITE-2129) Aggregating function from subquery not projected properly

2018-01-10 Thread Paul Jackson (JIRA)
Paul Jackson created CALCITE-2129: - Summary: Aggregating function from subquery not projected properly Key: CALCITE-2129 URL: https://issues.apache.org/jira/browse/CALCITE-2129 Project: Calcite

[jira] [Commented] (CALCITE-2129) Aggregating function from subquery not projected properly

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16320818#comment-16320818 ] Julian Hyde commented on CALCITE-2129: -- I agree, it looks like a problem in RelToSq

[jira] [Updated] (CALCITE-2129) Aggregating function from sub-query not projected properly

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2129?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2129: - Summary: Aggregating function from sub-query not projected properly (was: Aggregating function

[jira] [Updated] (CALCITE-2129) RelToSqlConverter incorrectly projects aggregate function from sub-query

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2129?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2129: - Summary: RelToSqlConverter incorrectly projects aggregate function from sub-query (was: Aggrega

[jira] [Updated] (CALCITE-2129) RelToSqlConverter incorrectly projects aggregate function from sub-query

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2129?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2129: - Component/s: jdbc-adapter > RelToSqlConverter incorrectly projects aggregate function from sub-q

[jira] [Assigned] (CALCITE-2128) Add jethro sql dialect and jdbc support

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-2128: Assignee: Jonathan Doron (was: Julian Hyde) > Add jethro sql dialect and jdbc support >

[jira] [Updated] (CALCITE-2128) Add jethro sql dialect and jdbc support

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2128: - Fix Version/s: (was: 1.15.0) 1.16.0 > Add jethro sql dialect and jdbc sup

[jira] [Created] (CALCITE-2130) Converting subquery to join is not always giving equivalent behavior

2018-01-10 Thread Paul Jackson (JIRA)
Paul Jackson created CALCITE-2130: - Summary: Converting subquery to join is not always giving equivalent behavior Key: CALCITE-2130 URL: https://issues.apache.org/jira/browse/CALCITE-2130 Project: Cal

[jira] [Created] (CALCITE-2131) Provide an option to NOT convert subquery to JOIN

2018-01-10 Thread Paul Jackson (JIRA)
Paul Jackson created CALCITE-2131: - Summary: Provide an option to NOT convert subquery to JOIN Key: CALCITE-2131 URL: https://issues.apache.org/jira/browse/CALCITE-2131 Project: Calcite Issue

[jira] [Commented] (CALCITE-2130) Converting subquery to join is not always giving equivalent behavior

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16320958#comment-16320958 ] Julian Hyde commented on CALCITE-2130: -- I see the problem. The decorrelated query i

[jira] [Resolved] (CALCITE-2127) In Interpreter, allow a node to have more than one consumer

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-2127. -- Resolution: Fixed Fix Version/s: 1.16.0 Fixed in [7b85d445|http://git-wip-us.apache.or

[jira] [Commented] (CALCITE-2128) Add jethro sql dialect and jdbc support

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16320965#comment-16320965 ] Julian Hyde commented on CALCITE-2128: -- [~msydoron], I have made you a contributor

[jira] [Resolved] (CALCITE-2116) The digests are not same for the common sub-expressions in HepPlanner

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-2116. -- Resolution: Fixed Fix Version/s: 1.16.0 Fixed in [c0f912dd|http://git-wip-us.apache.or

[jira] [Updated] (CALCITE-2047) AggregateReduceFunctionsRule throws "Type mismatch" AssertionError

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2047: - Summary: AggregateReduceFunctionsRule throws "Type mismatch" AssertionError (was: java.lang.Ass

[jira] [Created] (CALCITE-2132) Unify rewrites for aggregate functions and windowed aggregate functions

2018-01-10 Thread Julian Hyde (JIRA)
Julian Hyde created CALCITE-2132: Summary: Unify rewrites for aggregate functions and windowed aggregate functions Key: CALCITE-2132 URL: https://issues.apache.org/jira/browse/CALCITE-2132 Project: Ca

[jira] [Updated] (CALCITE-2047) AggregateReduceFunctionsRule throws "Type mismatch" AssertionError

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2047: - Description: Given the following SQL: {code} select sum(ss_list_price) SM ,count(ss_list_price)

[jira] [Commented] (CALCITE-2047) AggregateReduceFunctionsRule throws "Type mismatch" AssertionError

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16321056#comment-16321056 ] Julian Hyde commented on CALCITE-2047: -- Probably connected to the fact that SUM ret

[jira] [Commented] (CALCITE-2126) Optimization of COUNT (1) in OVER window

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16321059#comment-16321059 ] Julian Hyde commented on CALCITE-2126: -- We perform a similar rewrite of non-windowe

[jira] [Updated] (CALCITE-2132) Unify rewrites for aggregate functions and windowed aggregate functions

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2132?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2132: - Description: Similar rewrites apply to aggregate functions and windowed aggregate functions. Fo

[jira] [Commented] (CALCITE-2127) In Interpreter, allow a node to have more than one consumer

2018-01-10 Thread Nishant Bangarwa (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16321095#comment-16321095 ] Nishant Bangarwa commented on CALCITE-2127: --- [~julianhyde] this broke compilat

[jira] [Comment Edited] (CALCITE-2127) In Interpreter, allow a node to have more than one consumer

2018-01-10 Thread Nishant Bangarwa (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16321095#comment-16321095 ] Nishant Bangarwa edited comment on CALCITE-2127 at 1/10/18 8:59 PM: --

[jira] [Commented] (CALCITE-2127) In Interpreter, allow a node to have more than one consumer

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16321126#comment-16321126 ] Julian Hyde commented on CALCITE-2127: -- Oops, thanks for the fix. > In Interpreter

[jira] [Commented] (CALCITE-2088) More complex end2end tests in Calcite Plus module

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16321201#comment-16321201 ] Julian Hyde commented on CALCITE-2088: -- Reviewing your PR: * I agree with [~vlsi]'s

[jira] [Commented] (CALCITE-2088) More complex end2end tests in Calcite Plus module

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16321436#comment-16321436 ] Julian Hyde commented on CALCITE-2088: -- I have added the following project to build

[jira] [Updated] (CALCITE-2124) AggregateExpandDistinctAggregatesRule should make SUM nullable if there is no GROUP BY

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2124: - Summary: AggregateExpandDistinctAggregatesRule should make SUM nullable if there is no GROUP BY

[jira] [Updated] (CALCITE-2124) AggregateExpandDistinctAggregatesRule should make SUM nullable if there is no GROUP BY

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2124: - Description: AggregateExpandDistinctAggregatesRule should make SUM nullable if there is no GROU

[jira] [Resolved] (CALCITE-2124) AggregateExpandDistinctAggregatesRule should make SUM nullable if there is no GROUP BY

2018-01-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-2124. -- Resolution: Fixed Fix Version/s: 1.16.0 Fixed in [1c7f690d|http://git-wip-us.apache.or