[jira] [Resolved] (CALCITE-3847) Decorrelation for join with lateral table outputs wrong plan if the join condition contains correlation variables

2020-03-09 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3847?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3847. - Resolution: Fixed Fixed in

[jira] [Created] (CALCITE-3849) SUBSTRING Function to support binary

2020-03-09 Thread Ritesh (Jira)
Ritesh created CALCITE-3849: --- Summary: SUBSTRING Function to support binary Key: CALCITE-3849 URL: https://issues.apache.org/jira/browse/CALCITE-3849 Project: Calcite Issue Type: New Feature

[jira] [Closed] (CALCITE-482) Implement SQL and planner hints

2020-03-09 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen closed CALCITE-482. -- Resolved in release 1.22.0 (2020-03-05). > Implement SQL and planner hints >

[jira] [Updated] (CALCITE-482) Implement SQL and planner hints

2020-03-09 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-482: --- Fix Version/s: (was: 1.23.0) 1.22.0 > Implement SQL and planner hints >

[jira] [Resolved] (CALCITE-3041) Query runs endless when setImportance to 0

2020-03-09 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3041?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3041. Resolution: Invalid Can't reproduce the issue any more as of commit

[jira] [Resolved] (CALCITE-3757) When merging sets, relnodes may be reregistered multiple times

2020-03-09 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3757. Fix Version/s: 1.23.0 Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-3753) Remove rulematch ordering and execute substitution rule first

2020-03-09 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3753: --- Summary: Remove rulematch ordering and execute substitution rule first (was: Remove

[jira] [Resolved] (CALCITE-3753) Remove rulematch ordering and execute substitution rule first

2020-03-09 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3753. Fix Version/s: 1.23.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-3848) Materialized view rewriting fails for mv consisting of group by on join keys

2020-03-09 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17055459#comment-17055459 ] Vineet Garg commented on CALCITE-3848: -- [~jcamachorodriguez] can you take a look please? >

[jira] [Commented] (CALCITE-3848) Materialized view rewriting fails for mv consisting of group by on join keys

2020-03-09 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17055457#comment-17055457 ] Vineet Garg commented on CALCITE-3848: -- Please ignore the first pull request #1851 > Materialized

[jira] [Updated] (CALCITE-3848) Materialized view rewriting fails for mv consisting of group by on join keys

2020-03-09 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3848: Labels: pull-request-available (was: ) > Materialized view rewriting fails for mv

[jira] [Updated] (CALCITE-3848) Materialized view rewriting fails for mv consisting of group by on join keys

2020-03-09 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-3848: - Description: Test case {code:java} + @Test public void testAggregateOnJoinKeys() { +

[jira] [Created] (CALCITE-3848) Materialized view rewriting fails for mv consisting of group by on join keys

2020-03-09 Thread Vineet Garg (Jira)
Vineet Garg created CALCITE-3848: Summary: Materialized view rewriting fails for mv consisting of group by on join keys Key: CALCITE-3848 URL: https://issues.apache.org/jira/browse/CALCITE-3848

[jira] [Commented] (CALCITE-1861) Spatial Indexes

2020-03-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17055343#comment-17055343 ] Julian Hyde commented on CALCITE-1861: -- {quote}How to integrate it in Calcite?  {quote} Do you

[jira] [Commented] (CALCITE-3840) Re-aliasing of VALUES that has column aliases produces wrong SQL in the JDBC adapter

2020-03-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3840?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17055335#comment-17055335 ] Julian Hyde commented on CALCITE-3840: -- Regarding CALCITE-3810. I previously said that rewriting

[jira] [Commented] (CALCITE-3840) Re-aliasing of VALUES that has column aliases produces wrong SQL in the JDBC adapter

2020-03-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3840?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17055333#comment-17055333 ] Julian Hyde commented on CALCITE-3840: -- The fix for 3840 looks good. Go ahead and commit. Not so

[jira] [Commented] (CALCITE-3815) Add missing SQL standard aggregate functions: EVERY, SOME, INTERSECTION

2020-03-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17055330#comment-17055330 ] Julian Hyde commented on CALCITE-3815: -- Reviewing PR 06bbf26434209f3e97dfa3f3f5111a5ffb02c164: *

[jira] [Updated] (CALCITE-3847) Decorrelation for join with lateral table outputs wrong plan if the join condition contains correlation variables

2020-03-09 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3847?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3847: Labels: pull-request-available (was: ) > Decorrelation for join with lateral table

[jira] [Created] (CALCITE-3847) Decorrelation for join with lateral table outputs wrong plan if the join condition contains correlation variables

2020-03-09 Thread Danny Chen (Jira)
Danny Chen created CALCITE-3847: --- Summary: Decorrelation for join with lateral table outputs wrong plan if the join condition contains correlation variables Key: CALCITE-3847 URL:

[jira] [Commented] (CALCITE-3840) Re-aliasing of VALUES that has column aliases produces wrong SQL in the JDBC adapter

2020-03-09 Thread Christian Beikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3840?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17054823#comment-17054823 ] Christian Beikov commented on CALCITE-3840: --- Hey [~donnyzone] I already have a test and fix

[jira] [Updated] (CALCITE-3842) RexSimplify doesn't simplify range predicates, as it looks at the operands in a particular order.

2020-03-09 Thread anjali shrishrimal (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] anjali shrishrimal updated CALCITE-3842: Summary: RexSimplify doesn't simplify range predicates, as it looks at the