[jira] [Created] (CALCITE-1984) MaterialView rewrite failed

2017-09-12 Thread fei.chen (JIRA)
fei.chen created CALCITE-1984: - Summary: MaterialView rewrite failed Key: CALCITE-1984 URL: https://issues.apache.org/jira/browse/CALCITE-1984 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-1983) Push EQUALS and NOT EQUALS operations with numeric cast on dimensions

2017-09-12 Thread Jesus Camacho Rodriguez (JIRA)
Jesus Camacho Rodriguez created CALCITE-1983: Summary: Push EQUALS and NOT EQUALS operations with numeric cast on dimensions Key: CALCITE-1983 URL: https://issues.apache.org/jira/browse/CALCITE-1983

Re: Could table(...) be implicitly lateral?

2017-09-12 Thread Vladimir Sitnikov
>Are you aware of CROSS APPLY? Ah thanks, it is reasonable. Just in case: "... unnest(tableFunction(..))" throws an error like "function tableFunction does not exist". It was extremely confusing for me. Technically speaking, unnest searches for regular functions, thus it ignores table functions.

Re: Could table(...) be implicitly lateral?

2017-09-12 Thread Julian Hyde
Are you aware of CROSS APPLY? We added it a while back [1], albeit with limitations [2] and I think it does what you need. I believe Oracle also supports it. I would be cautious about making TABLE implicitly LATERAL (as you say Oracle does) or adopting any PostgreSQL extensions. If there are many

Re: calcite git commit: [CALCITE-1982] NPE simplifying range expressions when literal value is null

2017-09-12 Thread Julian Hyde
We're supposed to be stabilizing for release 1.14. No more commits to master please. Julian On Tue, Sep 12, 2017 at 10:16 AM, wrote: > Repository: calcite > Updated Branches: > refs/heads/master 67071b6b0 -> d633402c4 > > > [CALCITE-1982] NPE simplifying range

Calcite-Master - Build # 111 - Still Failing

2017-09-12 Thread Apache Jenkins Server
The Apache Jenkins build system has built Calcite-Master (build #111) Status: Still Failing Check console output at https://builds.apache.org/job/Calcite-Master/111/ to view the results.

[jira] [Created] (CALCITE-1982) NPE simplifying range expressions when literal value is null

2017-09-12 Thread Jesus Camacho Rodriguez (JIRA)
Jesus Camacho Rodriguez created CALCITE-1982: Summary: NPE simplifying range expressions when literal value is null Key: CALCITE-1982 URL: https://issues.apache.org/jira/browse/CALCITE-1982

[jira] [Created] (CALCITE-1981) Cassandra adapter fails

2017-09-12 Thread Michael Mior (JIRA)
Michael Mior created CALCITE-1981: - Summary: Cassandra adapter fails Key: CALCITE-1981 URL: https://issues.apache.org/jira/browse/CALCITE-1981 Project: Calcite Issue Type: Bug

Re: Could table(...) be implicitly lateral?

2017-09-12 Thread Vladimir Sitnikov
I've found a discussion on the PostgreSQL dev list: 1) https://www.postgresql.org/message-id/21317.1385046473%40sss.pgh.pa.us Tom Lane >SQL99 has single-argument UNNEST() but not TABLE(), so why'd they add TABLE() later, and why'd they make it a strict subset of what UNNEST() can do? 2)

Could table(...) be implicitly lateral?

2017-09-12 Thread Vladimir Sitnikov
Hi, org.apache.calcite.test.JdbcTest#testUnnestArrayColumn says "Per SQL std, UNNEST is implicitly LATERAL" Currently lateral table functions are cumbersome to write: select * from main m, lateral (select ... from table(tableFunction(m.col))).. I know table(...) in Oracle is implicitly lateral

[jira] [Created] (CALCITE-1980) java.lang.IndexOutOfBoundsException when building aggregate on top of project

2017-09-12 Thread Pavel Gubin (JIRA)
Pavel Gubin created CALCITE-1980: Summary: java.lang.IndexOutOfBoundsException when building aggregate on top of project Key: CALCITE-1980 URL: https://issues.apache.org/jira/browse/CALCITE-1980