[jira] [Closed] (CALCITE-2964) testEmptyFilterProjectUnion fails when copyPorject is disabled in FilterProjectTransposeRule

2019-03-31 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan closed CALCITE-2964. -- Resolution: Not A Bug > testEmptyFilterProjectUnion fails when copyPorject is disabled in >

[jira] [Commented] (CALCITE-2964) testEmptyFilterProjectUnion fails when copyPorject is disabled in FilterProjectTransposeRule

2019-03-31 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806398#comment-16806398 ] Haisheng Yuan commented on CALCITE-2964: Looks like we just need to add

[jira] [Commented] (CALCITE-2964) testEmptyFilterProjectUnion fails when copyPorject is disabled in FilterProjectTransposeRule

2019-03-31 Thread Feng Zhu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806388#comment-16806388 ] Feng Zhu commented on CALCITE-2964: --- The *FilterProjectTransposeRule* rule does not create a Project

[jira] [Created] (CALCITE-2966) Problem with Code Generation

2019-03-31 Thread Danny Chan (JIRA)
Danny Chan created CALCITE-2966: --- Summary: Problem with Code Generation Key: CALCITE-2966 URL: https://issues.apache.org/jira/browse/CALCITE-2966 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-2914) Improve how LatticeSuggester deduces foreign keys

2019-03-31 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806348#comment-16806348 ] Danny Chan commented on CALCITE-2914: - [~julianhyde] Reviewing now. > Improve how LatticeSuggester

[jira] [Assigned] (CALCITE-2846) Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference

2019-03-31 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang reassigned CALCITE-2846: - Assignee: (was: Hongze Zhang) > Document Oracle-specific functions, such as NVL

[jira] [Commented] (CALCITE-2846) Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference

2019-03-31 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806346#comment-16806346 ] Hongze Zhang commented on CALCITE-2846: --- I see this issue has been mentioned in CALCITE-2965 as

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for subquery

2019-03-31 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806335#comment-16806335 ] Danny Chan commented on CALCITE-2948: - [~julianhyde] [~hyuan] [~vgarg] The value generator for the

[jira] [Comment Edited] (CALCITE-2964) testEmptyFilterProjectUnion fails when copyPorject is disabled in FilterProjectTransposeRule

2019-03-31 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806333#comment-16806333 ] Chunwei Lei edited comment on CALCITE-2964 at 4/1/19 2:22 AM: -- I debugged

[jira] [Commented] (CALCITE-2964) testEmptyFilterProjectUnion fails when copyPorject is disabled in FilterProjectTransposeRule

2019-03-31 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806333#comment-16806333 ] Chunwei Lei commented on CALCITE-2964: -- I debugged a little since it is a little weird. I find

[jira] [Commented] (CALCITE-2954) SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id

2019-03-31 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806327#comment-16806327 ] Haisheng Yuan commented on CALCITE-2954: OK > SubQueryJoinRemoveRule and

[jira] [Commented] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE and NTH_VALUE window functions

2019-03-31 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806324#comment-16806324 ] Chunwei Lei commented on CALCITE-883: - [~zhztheplayer], thank you for your kindly help.;) > Support

[jira] [Resolved] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

2019-03-31 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-883. - Resolution: Fixed Fix Version/s: 1.20.0 Fixed in

[jira] [Updated] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE and NTH_VALUE window functions

2019-03-31 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-883: Summary: Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE and

[jira] [Updated] (CALCITE-2914) Improve how LatticeSuggester deduces foreign keys

2019-03-31 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2914: Labels: pull-request-available (was: ) > Improve how LatticeSuggester deduces foreign

[jira] [Commented] (CALCITE-2914) Improve how LatticeSuggester deduces foreign keys

2019-03-31 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806281#comment-16806281 ] Julian Hyde commented on CALCITE-2914: -- [~danny0405] Would you like to review my branch now? >

[jira] [Commented] (CALCITE-2954) SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id

2019-03-31 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806272#comment-16806272 ] Vineet Garg commented on CALCITE-2954: -- [~hyuan] This test case fails even with the patch. I'll

[jira] [Commented] (CALCITE-2959) Support collation on struct fields

2019-03-31 Thread Stamatis Zampetakis (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806083#comment-16806083 ] Stamatis Zampetakis commented on CALCITE-2959: -- Postres and other major databases provide