[jira] [Comment Edited] (CALCITE-3224) New RexNode-to-Expression CodeGen Implementation

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17145699#comment-17145699 ] Julian Hyde edited comment on CALCITE-3224 at 6/26/20, 6:41 AM: -

[jira] [Updated] (CALCITE-3717) Dividing by nullable numeric throws "ArithmeticException: Division by zero"

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3717: - Summary: Dividing by nullable numeric throws "ArithmeticException: Division by zero" (was: Que

[jira] [Updated] (CALCITE-3150) NullPointerException when UPPER is repeated and combined with LIKE

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3150: - Summary: NullPointerException when UPPER is repeated and combined with LIKE (was: NPE in UPPER

[jira] [Updated] (CALCITE-3143) Dividing by NULLIF may cause "ArithmeticException: Division by zero"

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3143: - Summary: Dividing by NULLIF may cause "ArithmeticException: Division by zero" (was: Dividing N

[jira] [Updated] (CALCITE-3142) NullPointerException when rounding a nullable numeric

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3142?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3142: - Summary: NullPointerException when rounding a nullable numeric (was: An NPE when rounding a nu

[jira] [Updated] (CALCITE-4092) NPE using WITH clause without a corresponding SELECT FROM

2020-06-25 Thread James Kim (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Kim updated CALCITE-4092: --- Description: Running the below query:   {code:java} final String sql = "with emp2 as (select max(e

[jira] [Updated] (CALCITE-4092) NPE using WITH clause without a corresponding SELECT FROM

2020-06-25 Thread James Kim (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Kim updated CALCITE-4092: --- Description: Running the below query:   {code:java} final String sql = "with emp2 as (select max(e

[jira] [Updated] (CALCITE-4092) NPE using WITH clause without a corresponding SELECT FROM

2020-06-25 Thread Laurent Goujon (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laurent Goujon updated CALCITE-4092: Component/s: core > NPE using WITH clause without a corresponding SELECT FROM > -

[jira] [Updated] (CALCITE-4092) NPE using WITH clause without a corresponding SELECT FROM

2020-06-25 Thread James Kim (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Kim updated CALCITE-4092: --- Priority: Major (was: Critical) > NPE using WITH clause without a corresponding SELECT FROM >

[jira] [Commented] (CALCITE-3963) Maintain logical properties at RelSet (equivalent group) instead of RelNode

2020-06-25 Thread Xiening Dai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17145911#comment-17145911 ] Xiening Dai commented on CALCITE-3963: -- [~julianhyde] do you have more comments re

[jira] [Updated] (CALCITE-4092) NPE using WITH clause without a corresponding SELECT FROM

2020-06-25 Thread James Kim (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Kim updated CALCITE-4092: --- Description: Running the below query:   {code:java} final String sql = "with emp2 as (select max(e

[jira] [Updated] (CALCITE-4092) NPE using WITH clause without a corresponding SELECT FROM

2020-06-25 Thread James Kim (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Kim updated CALCITE-4092: --- Description: Running the below query:   {code:java} final String sql = "with emp2 as (select max(e

[jira] [Updated] (CALCITE-4092) NPE using WITH clause without a corresponding SELECT FROM

2020-06-25 Thread James Kim (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Kim updated CALCITE-4092: --- Description: Running the below query:   {code:java} final String sql = "with emp2 as (select max(e

[jira] [Created] (CALCITE-4092) NPE using WITH clause without a corresponding SELECT FROM

2020-06-25 Thread James Kim (Jira)
James Kim created CALCITE-4092: -- Summary: NPE using WITH clause without a corresponding SELECT FROM Key: CALCITE-4092 URL: https://issues.apache.org/jira/browse/CALCITE-4092 Project: Calcite Iss

[jira] [Updated] (CALCITE-4092) NPE using WITH clause without a corresponding SELECT FROM

2020-06-25 Thread James Kim (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Kim updated CALCITE-4092: --- Priority: Critical (was: Major) > NPE using WITH clause without a corresponding SELECT FROM >

[jira] [Commented] (CALCITE-3224) New RexNode-to-Expression CodeGen Implementation

2020-06-25 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17145846#comment-17145846 ] Stamatis Zampetakis commented on CALCITE-3224: -- I went over the design doc

[jira] [Comment Edited] (CALCITE-4091) Extend INTERVAL literal syntax

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17145829#comment-17145829 ] Julian Hyde edited comment on CALCITE-4091 at 6/25/20, 9:00 PM: -

[jira] [Updated] (CALCITE-4091) Extend INTERVAL literal syntax

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4091: - Summary: Extend INTERVAL literal syntax (was: Temporal Intervals improvements ) > Extend INTE

[jira] [Commented] (CALCITE-4091) Temporal Intervals improvements

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17145829#comment-17145829 ] Julian Hyde commented on CALCITE-4091: -- Since {{DATE_ADD}} is a MySQL-specific fun

[jira] [Updated] (CALCITE-4091) Temporal Intervals improvements

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4091: - Environment: (was: {code:java}   {code}) > Temporal Intervals improvements > -

[jira] [Resolved] (CALCITE-4087) Hoist, a utility to replace literals in a SQL string with placeholders

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4087?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-4087. -- Fix Version/s: 1.24.0 Resolution: Fixed Fixed in [6f90acaa|https://github.com/apache/

[jira] [Commented] (CALCITE-4087) Hoist, a utility to replace literals in a SQL string with placeholders

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4087?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17145811#comment-17145811 ] Julian Hyde commented on CALCITE-4087: -- [~rubenql], Hoisting at RelNode level make

[jira] [Commented] (CALCITE-3094) Code of method grows beyond 64 KB

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17145809#comment-17145809 ] Julian Hyde commented on CALCITE-3094: -- Please wait until CALCITE-3224 is in. (Maj

[jira] [Commented] (CALCITE-4091) Temporal Intervals improvements

2020-06-25 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17145739#comment-17145739 ] Rui Wang commented on CALCITE-4091: --- Interval type is a relatively complicated type i

[jira] [Comment Edited] (CALCITE-3224) New RexNode-to-Expression CodeGen Implementation

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17145699#comment-17145699 ] Julian Hyde edited comment on CALCITE-3224 at 6/25/20, 5:52 PM: -

[jira] [Commented] (CALCITE-3224) New RexNode-to-Expression CodeGen Implementation

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17145699#comment-17145699 ] Julian Hyde commented on CALCITE-3224: -- Wow, this PR fixes (and has test cases for

[jira] [Commented] (CALCITE-3224) New RexNode-to-Expression CodeGen Implementation

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17145084#comment-17145084 ] Julian Hyde commented on CALCITE-3224: -- I am dusting this one off, because it bloc

[jira] [Commented] (CALCITE-4089) In Babel, allow 'CAST(integer AS DATE)' even though it is illegal in Calcite SQL

2020-06-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17145083#comment-17145083 ] Julian Hyde commented on CALCITE-4089: -- My initial fix hits NPEs because CALCITE-3

[jira] [Commented] (CALCITE-3094) Code of method grows beyond 64 KB

2020-06-25 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17144900#comment-17144900 ] Stamatis Zampetakis commented on CALCITE-3094: -- The change proposed by [~t

[jira] [Assigned] (CALCITE-3920) Improve ORDER BY computation in Enumerable convention by exploiting LIMIT

2020-06-25 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-3920: Assignee: Thomas Rebele > Improve ORDER BY computation in Enumerable con

[jira] [Commented] (CALCITE-3920) Improve ORDER BY computation in Enumerable convention by exploiting LIMIT

2020-06-25 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17144893#comment-17144893 ] Stamatis Zampetakis commented on CALCITE-3920: -- Sure [~thomas.rebele], go

[jira] [Commented] (CALCITE-3533) Map non-jdbc data types to ANY in JdbcSchema

2020-06-25 Thread Charles Givre (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17144878#comment-17144878 ] Charles Givre commented on CALCITE-3533: I encountered this as well when someon

[jira] [Commented] (CALCITE-4087) Hoist, a utility to replace literals in a SQL string with placeholders

2020-06-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4087?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17144857#comment-17144857 ] Ruben Q L commented on CALCITE-4087: [~julianhyde] thanks for starting this evoluti

[jira] [Commented] (CALCITE-3920) Improve ORDER BY computation in Enumerable convention by exploiting LIMIT

2020-06-25 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17144822#comment-17144822 ] Thomas Rebele commented on CALCITE-3920: If no one has started to work on it ye

[jira] [Updated] (CALCITE-4091) Temporal Intervals improvements

2020-06-25 Thread Dan Cojocaru (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dan Cojocaru updated CALCITE-4091: -- Description: Using this parser configuration:  {code:java} final FrameworkConfig config = Fra

[jira] [Updated] (CALCITE-4091) Temporal Intervals improvements

2020-06-25 Thread Dan Cojocaru (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dan Cojocaru updated CALCITE-4091: -- Description: Using this parser configuration:  {code:java} final FrameworkConfig config = Fra

[jira] [Created] (CALCITE-4091) Temporal Intervals improvements

2020-06-25 Thread Dan Cojocaru (Jira)
Dan Cojocaru created CALCITE-4091: - Summary: Temporal Intervals improvements Key: CALCITE-4091 URL: https://issues.apache.org/jira/browse/CALCITE-4091 Project: Calcite Issue Type: Improvemen

[jira] [Commented] (CALCITE-4085) Improve nullability support for fields of structured type

2020-06-25 Thread Dawid Wysakowicz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17144737#comment-17144737 ] Dawid Wysakowicz commented on CALCITE-4085: --- I updated the PR: * dropped the

[jira] [Comment Edited] (CALCITE-4085) Improve nullability support for fields of structured type

2020-06-25 Thread Dawid Wysakowicz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17144724#comment-17144724 ] Dawid Wysakowicz edited comment on CALCITE-4085 at 6/25/20, 7:48 AM:

[jira] [Commented] (CALCITE-4085) Improve nullability support for fields of structured type

2020-06-25 Thread Dawid Wysakowicz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17144724#comment-17144724 ] Dawid Wysakowicz commented on CALCITE-4085: --- I can't see how the [1] can be o