[jira] [Commented] (CALCITE-1515) Support TableFunctionScan in RelBuilder

2016-12-01 Thread Anton Mushin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15714315#comment-15714315 ] Anton Mushin commented on CALCITE-1515: --- Hi [~julianhyde], Do you do this issue? C

[jira] [Created] (CALCITE-1524) Add a project to the planner root so that rules know which output fields are used

2016-12-01 Thread Julian Hyde (JIRA)
Julian Hyde created CALCITE-1524: Summary: Add a project to the planner root so that rules know which output fields are used Key: CALCITE-1524 URL: https://issues.apache.org/jira/browse/CALCITE-1524 P

[jira] [Commented] (CALCITE-1523) Add RelBuilder field() method to reference aliased relations not on top of stack

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15713734#comment-15713734 ] Julian Hyde commented on CALCITE-1523: -- Yes, I think that would be useful. But if w

[jira] [Commented] (CALCITE-1523) Add RelBuilder field() method to reference aliased relations not on top of stack

2016-12-01 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15713502#comment-15713502 ] Jess Balint commented on CALCITE-1523: -- I don't see anything preventing conflicting

[jira] [Updated] (CALCITE-1495) SemiJoinRule should not apply to RIGHT and FULL JOIN

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1495: - Description: SemiJoinRule should not apply to RIGHT and FULL JOIN; and it should strip LEFT JOI

[jira] [Commented] (CALCITE-328) Introduce semi-join-like flag in JoinRelBase

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15713456#comment-15713456 ] Julian Hyde commented on CALCITE-328: - Since we added SemiJoin in CALCITE-368 we will

[jira] [Commented] (CALCITE-330) Add a rule that converts join-on-aggregate to semi-join

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15713452#comment-15713452 ] Julian Hyde commented on CALCITE-330: - Since we opted to create {{SemiJoin}} (see CAL

[jira] [Updated] (CALCITE-330) Add a rule that converts join-on-aggregate to semi-join

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-330: Description: Once CALCITE-328 is completed and {{Join}} has a flag {{eliminateRightDuplicates}}, w

[jira] [Created] (CALCITE-1523) Add RelBuilder field() method to reference aliased relations not on top of stack

2016-12-01 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1523: Summary: Add RelBuilder field() method to reference aliased relations not on top of stack Key: CALCITE-1523 URL: https://issues.apache.org/jira/browse/CALCITE-1523 Pr

[jira] [Updated] (CALCITE-1495) SemiJoinRule should not apply to RIGHT and FULL JOIN

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1495: - Summary: SemiJoinRule should not apply to RIGHT and FULL JOIN (was: Add a rule to convert INNER

[jira] [Commented] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15713199#comment-15713199 ] Julian Hyde commented on CALCITE-1495: -- Changing the subject to refer to the incorr

[jira] [Updated] (CALCITE-375) Support simpler decorrelation transformations for Exists and In

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-375: Labels: sub-query (was: ) > Support simpler decorrelation transformations for Exists and In > ---

[jira] [Resolved] (CALCITE-463) Left correlation for table functions does not work

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-463. - Resolution: Not A Problem I don't believe this is a bug. A table reference (including a table fun

[jira] [Updated] (CALCITE-863) AssertionError while translating query with UNNEST and having two correlation conditions

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-863?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-863: Labels: sub-query (was: ) > AssertionError while translating query with UNNEST and having two corr

[jira] [Updated] (CALCITE-709) Errors with LIMIT inside scalar sub-query

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-709: Labels: sub-query (was: ) > Errors with LIMIT inside scalar sub-query > --

[jira] [Updated] (CALCITE-1045) Decorrelate sub-queries in Project and Join

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1045?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1045: - Labels: sub-query (was: ) > Decorrelate sub-queries in Project and Join > -

[jira] [Updated] (CALCITE-1494) Inefficient plan for correlated subqueries

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1494: - Labels: sub-query (was: ) > Inefficient plan for correlated subqueries > --

[jira] [Updated] (CALCITE-1511) RelDecorrelator's allLessThan failing for NOT EXISTS subquery

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1511?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1511: - Labels: sub-query (was: ) > RelDecorrelator's allLessThan failing for NOT EXISTS subquery > ---

[jira] [Updated] (CALCITE-365) AssertionError while translating query with WITH and correlated sub-query

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-365?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-365: Labels: sub-query (was: ) > AssertionError while translating query with WITH and correlated sub-qu

[jira] [Updated] (CALCITE-1513) Correlated NOT IN query throws AssertionError

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1513: - Labels: sub-query (was: ) > Correlated NOT IN query throws AssertionError > ---

[jira] [Updated] (CALCITE-1493) Wrong plan for NOT IN correlated queries

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1493: - Labels: sub-query (was: ) > Wrong plan for NOT IN correlated queries >

[jira] [Created] (CALCITE-1522) RelBuilder.union() hits assertion when arguments can't have a common row type

2016-12-01 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1522: Summary: RelBuilder.union() hits assertion when arguments can't have a common row type Key: CALCITE-1522 URL: https://issues.apache.org/jira/browse/CALCITE-1522 Proje

[jira] [Commented] (CALCITE-1519) Standardize on "sub-query" rather than "subquery" in class names and comments

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1519?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15711614#comment-15711614 ] Julian Hyde commented on CALCITE-1519: -- Can someone please review and +1? I know th

[jira] [Updated] (CALCITE-1519) Standardize on "sub-query" rather than "subquery" in class names and comments

2016-12-01 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1519: - Fix Version/s: 1.11.0 > Standardize on "sub-query" rather than "subquery" in class names and com

[jira] [Resolved] (CALCITE-1425) Support two-level column structure in INSERT/UPDATE/MERGE

2016-12-01 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1425?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue resolved CALCITE-1425. -- Resolution: Fixed Fixed in https://git1-us-west.apache.org/repos/asf?p=calcite.git;a=commit;h