[jira] [Updated] (CALCITE-5683) Two level nested correlated subquery throws an exception during decorrelation.

2023-05-23 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5683: --- Fix Version/s: 1.35.0 > Two level nested correlated subquery throws an exception during > decorrel

[jira] [Resolved] (CALCITE-5691) IN sub-query inside FILTER clause throws IndexOutOfBoundsException

2023-05-23 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5691?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5691. Resolution: Fixed Fixed via https://github.com/apache/calcite/commit/d08b5cf73f9bb438f282d2089dd

[jira] [Updated] (CALCITE-5608) Implement ASINH, ACOSH, ATANH function

2023-05-23 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5608: --- Fix Version/s: 1.35.0 > Implement ASINH, ACOSH, ATANH function > --

[jira] [Commented] (CALCITE-5674) Cast expr to target type should respect nullable when it is complex type

2023-05-24 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725818#comment-17725818 ] Ruben Q L commented on CALCITE-5674: Just for the record: a minor [regression was

[jira] [Commented] (CALCITE-4334) LITERAL_AGG, an aggregate function that returns a constant value

2023-05-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726266#comment-17726266 ] Ruben Q L commented on CALCITE-4334: I agree with [~libenchao]  on the benefits of

[jira] [Resolved] (CALCITE-5608) Implement ASINH, ACOSH, ATANH function

2023-05-27 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5608. Resolution: Fixed Done in in https://github.com/apache/calcite/commit/af2fb7f02b30bf853cf9f4c384

[jira] [Commented] (CALCITE-5599) Support more trigonometric functions for BigQuery

2023-05-27 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726791#comment-17726791 ] Ruben Q L commented on CALCITE-5599: All the sub-tasks have been done; are there mo

[jira] [Commented] (CALCITE-5599) Support more trigonometric functions for BigQuery

2023-05-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727042#comment-17727042 ] Ruben Q L commented on CALCITE-5599: Ok [~FrankZou]! I will move this ticket to "re

[jira] [Resolved] (CALCITE-5599) Support more trigonometric functions for BigQuery

2023-05-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5599. Resolution: Fixed Resolved. Thanks to everyone that contributed in this ticket! > Support more t

[jira] [Updated] (CALCITE-5599) Support more trigonometric functions for BigQuery

2023-05-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5599: --- Fix Version/s: 1.35.0 > Support more trigonometric functions for BigQuery > ---

[jira] [Updated] (CALCITE-5730) First nulls are dropped by calcite EnumerableSortLimit Node

2023-05-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5730: --- Fix Version/s: 1.35.0 > First nulls are dropped by calcite EnumerableSortLimit Node > -

[jira] [Commented] (CALCITE-5730) First nulls are dropped by calcite EnumerableSortLimit Node

2023-05-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727067#comment-17727067 ] Ruben Q L commented on CALCITE-5730: [~thomas.rebele] could you please help with th

[jira] [Updated] (CALCITE-5730) First nulls can be dropped by EnumerableSortLimit with offset

2023-05-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5730: --- Summary: First nulls can be dropped by EnumerableSortLimit with offset (was: First nulls are dropp

[jira] [Updated] (CALCITE-5730) First nulls can be dropped by EnumerableLimitSort with offset

2023-05-30 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5730: --- Summary: First nulls can be dropped by EnumerableLimitSort with offset (was: First nulls can be dr

[jira] [Commented] (CALCITE-5730) First nulls can be dropped by EnumerableLimitSort with offset

2023-05-30 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727370#comment-17727370 ] Ruben Q L commented on CALCITE-5730: [~gf2121], what [~julianhyde] means is that, n

[jira] [Commented] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727412#comment-17727412 ] Ruben Q L commented on CALCITE-5731: [~jackylau] thanks bringing up this topic. I'

[jira] [Updated] (CALCITE-5730) Initial null values can be dropped by EnumerableLimitSort with offset

2023-05-30 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5730: --- Summary: Initial null values can be dropped by EnumerableLimitSort with offset (was: First nulls c

[jira] [Comment Edited] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727412#comment-17727412 ] Ruben Q L edited comment on CALCITE-5731 at 5/30/23 8:54 AM:

[jira] [Commented] (CALCITE-5732) EnumerableJoin should not return rows matching condition 'null = null'

2023-05-31 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728105#comment-17728105 ] Ruben Q L commented on CALCITE-5732: [~viggoc] just to confirm: the bug occurs with

[jira] [Commented] (CALCITE-5732) EnumerableJoin should not return rows matching condition 'null = null'

2023-06-01 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728250#comment-17728250 ] Ruben Q L commented on CALCITE-5732: I see. The problem is that both algorithms che

[jira] [Commented] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-06-01 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728251#comment-17728251 ] Ruben Q L commented on CALCITE-5731: What's the problem with the current status (th

[jira] [Comment Edited] (CALCITE-5732) EnumerableJoin should not return rows matching condition 'null = null'

2023-06-01 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728250#comment-17728250 ] Ruben Q L edited comment on CALCITE-5732 at 6/1/23 3:45 PM:

[jira] [Resolved] (CALCITE-5730) Initial null values can be dropped by EnumerableLimitSort with offset

2023-06-01 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5730. Resolution: Fixed Fixed via [{{295df90}}|https://github.com/apache/calcite/commit/295df907d126ff

[jira] [Updated] (CALCITE-5401) Rule fired by HepPlanner can return Volcano's RelSubset

2023-06-01 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5401: --- Fix Version/s: (was: 1.35.0) > Rule fired by HepPlanner can return Volcano's RelSubset > --

[jira] [Updated] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

2023-06-01 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5732: --- Summary: EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition

[jira] [Updated] (CALCITE-5728) Add ARRAY_TO_STRING function (enabled in BigQuery library)

2023-06-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5728: --- Fix Version/s: 1.35.0 > Add ARRAY_TO_STRING function (enabled in BigQuery library) > --

[jira] [Updated] (CALCITE-5745) CONCAT2 function (enabled in Oracle library) gets wrong result when one of the arguments is NULL

2023-06-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5745: --- Summary: CONCAT2 function (enabled in Oracle library) gets wrong result when one of the arguments i

[jira] [Updated] (CALCITE-5745) CONCAT2 function (enabled in Oracle library) gets wrong result when one of the arguments is NULL

2023-06-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5745: --- Fix Version/s: 1.35.0 > CONCAT2 function (enabled in Oracle library) gets wrong result when one of

[jira] [Updated] (CALCITE-5401) Rule fired by HepPlanner can return Volcano's RelSubset

2023-06-09 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5401: --- Fix Version/s: 1.35.0 > Rule fired by HepPlanner can return Volcano's RelSubset > -

[jira] [Resolved] (CALCITE-5401) Rule fired by HepPlanner can return Volcano's RelSubset

2023-06-09 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5401. Resolution: Fixed Fixed via https://github.com/apache/calcite/commit/2e3e4ae220a69a0936792caec1f

[jira] [Resolved] (CALCITE-5728) Add ARRAY_TO_STRING function (enabled in BigQuery library)

2023-06-13 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5728. Resolution: Fixed Done via [18ba66d|https://github.com/apache/calcite/commit/18ba66da96aa5e68de5

[jira] [Created] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-20 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-5789: -- Summary: Query with two nested subqueries where the inner-most references the outer-most table returns wrong result Key: CALCITE-5789 URL: https://issues.apache.org/jira/browse/CALCIT

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in sub-query.iq)

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in sub-query.iq)

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Attachment: debugger.png > Query with two nested subqueries where the inner-most references the >

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in sub-query.iq)

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in sub-query.iq)

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in sub-query.iq)

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in sub-query.iq)

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in sub-query.iq)

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in sub-query.iq)

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in sub-query.iq)

[jira] [Commented] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17735414#comment-17735414 ] Ruben Q L commented on CALCITE-5789: If somehow the variableSet when SubQueryRemove

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Fix Version/s: 1.35.0 > Query with two nested subqueries where the inner-most references the > out

[jira] [Assigned] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5789: -- Assignee: Ruben Q L > Query with two nested subqueries where the inner-most references the

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in sub-query.iq)

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in sub-query.iq)

[jira] [Reopened] (CALCITE-5716) Two level nested correlated subquery translates to incorrect ON condition

2023-06-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reopened CALCITE-5716: > Two level nested correlated subquery translates to incorrect ON condition > ---

[jira] [Commented] (CALCITE-5716) Two level nested correlated subquery translates to incorrect ON condition

2023-06-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17737204#comment-17737204 ] Ruben Q L commented on CALCITE-5716: After some discussion between [~libenchao] and

[jira] [Resolved] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5789. Resolution: Fixed Done in https://github.com/apache/calcite/commit/7dd3ecd5a61e876d929a0f4dea6ea

[jira] [Resolved] (CALCITE-5683) Two level nested correlated sub-query throws exception during decorrelation

2023-06-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5683. Resolution: Fixed Done in https://github.com/apache/calcite/commit/7dd3ecd5a61e876d929a0f4dea6ea

[jira] [Comment Edited] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17737225#comment-17737225 ] Ruben Q L edited comment on CALCITE-5789 at 6/26/23 4:11 PM:

[jira] [Comment Edited] (CALCITE-5683) Two level nested correlated sub-query throws exception during decorrelation

2023-06-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17737228#comment-17737228 ] Ruben Q L edited comment on CALCITE-5683 at 6/26/23 4:11 PM:

[jira] [Comment Edited] (CALCITE-5716) Two level nested correlated subquery translates to incorrect ON condition

2023-06-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17737204#comment-17737204 ] Ruben Q L edited comment on CALCITE-5716 at 6/26/23 4:15 PM:

[jira] [Resolved] (CALCITE-5757) Incorrect return type for BigQuery TRUNC functions

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5757. Fix Version/s: 1.35.0 Resolution: Fixed > Incorrect return type for BigQuery TRUNC functio

[jira] [Reopened] (CALCITE-5771) Apply two different NULL semantics for CONCAT function(enabled in MySQL, Postgresql, BigQuery and MSSQL)

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reopened CALCITE-5771: > Apply two different NULL semantics for CONCAT function(enabled in MySQL, > Postgresql, BigQuery an

[jira] [Reopened] (CALCITE-5757) Incorrect return type for BigQuery TRUNC functions

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reopened CALCITE-5757: > Incorrect return type for BigQuery TRUNC functions > --

[jira] [Reopened] (CALCITE-4679) Search/sarg simplification leaves is not null(literal) unsimplified

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reopened CALCITE-4679: > Search/sarg simplification leaves is not null(literal) unsimplified > -

[jira] [Resolved] (CALCITE-5771) Apply two different NULL semantics for CONCAT function(enabled in MySQL, Postgresql, BigQuery and MSSQL)

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5771. Fix Version/s: 1.35.0 Resolution: Fixed > Apply two different NULL semantics for CONCAT fu

[jira] [Resolved] (CALCITE-4679) Search/sarg simplification leaves is not null(literal) unsimplified

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-4679. Resolution: Fixed > Search/sarg simplification leaves is not null(literal) unsimplified > ---

[jira] [Commented] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738285#comment-17738285 ] Ruben Q L commented on CALCITE-5732: [~viggoc] since this is not a regression (it s

[jira] [Updated] (CALCITE-5686) Generalize return types of the linq4j expression shuttle

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5686: --- Priority: Minor (was: Major) > Generalize return types of the linq4j expression shuttle >

[jira] [Commented] (CALCITE-5686) Generalize return types of the linq4j expression shuttle

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738282#comment-17738282 ] Ruben Q L commented on CALCITE-5686: Thanks [~julianhyde] for checking this. I know

[jira] [Updated] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5732: --- Fix Version/s: (was: 1.35.0) > EnumerableHashJoin and EnumerableMergeJoin on composite key retu

[jira] [Updated] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5539: --- Fix Version/s: (was: 1.35.0) > GREATEST/LEAST/COALESCE OperandTypes is not correct, which shoul

[jira] [Commented] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738288#comment-17738288 ] Ruben Q L commented on CALCITE-5539: [~jackylau] if I understand correctly, the pro

[jira] [Commented] (CALCITE-5715) Prune old nodes after projection merging in ProjectMergeRule

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738289#comment-17738289 ] Ruben Q L commented on CALCITE-5715: [~libenchao] what's the status on this one? Gi

[jira] [Commented] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738290#comment-17738290 ] Ruben Q L commented on CALCITE-5731: [~jackylau] I'm removing the "fixVersion=1.35"

[jira] [Updated] (CALCITE-5731) Cast to row type should throw exception when contains null/not null constraint

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5731: --- Summary: Cast to row type should throw exception when contains null/not null constraint (was: cast

[jira] [Updated] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5731: --- Fix Version/s: (was: 1.35.0) > cast to row type should throw exception when contains null/not n

[jira] [Commented] (CALCITE-5715) Prune old nodes after projection merging in ProjectMergeRule

2023-07-06 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17740593#comment-17740593 ] Ruben Q L commented on CALCITE-5715: [~libenchao], at first sight, the change seems

[jira] [Commented] (CALCITE-1776) Implement CORR and REGR_* aggregate functions

2023-07-06 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1776?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17740729#comment-17740729 ] Ruben Q L commented on CALCITE-1776: [~Sergey Nuyanzin], I'm sorry, but it seems th

[jira] [Updated] (CALCITE-1776) Implement CORR and REGR_* aggregate functions

2023-07-06 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1776?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-1776: --- Fix Version/s: (was: 1.35.0) > Implement CORR and REGR_* aggregate functions >

[jira] [Assigned] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

2023-07-12 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5732: -- Assignee: Ruben Q L > EnumerableHashJoin and EnumerableMergeJoin on composite key return row

[jira] [Commented] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

2023-07-12 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742332#comment-17742332 ] Ruben Q L commented on CALCITE-5732: I'll try to work on a solution for this one. I

[jira] [Created] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

2023-07-12 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-5839: -- Summary: EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result Key: CALCITE-5839 URL: https://issues.apache.org/jira/browse/CALCITE-5839

[jira] [Commented] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

2023-07-12 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742430#comment-17742430 ] Ruben Q L commented on CALCITE-5839: Credits to [~thomas.rebele] for finding this.

[jira] [Comment Edited] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

2023-07-12 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742430#comment-17742430 ] Ruben Q L edited comment on CALCITE-5839 at 7/12/23 1:43 PM:

[jira] [Comment Edited] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

2023-07-12 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742430#comment-17742430 ] Ruben Q L edited comment on CALCITE-5839 at 7/12/23 1:43 PM:

[jira] [Commented] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

2023-07-12 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742433#comment-17742433 ] Ruben Q L commented on CALCITE-5732: Created [PR#3311|https://github.com/apache/cal

[jira] [Updated] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

2023-07-12 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5839: --- Fix Version/s: 1.35.0 > EnumerableInterpretable#StaticFieldDetector can overwrite its flag and retu

[jira] [Commented] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

2023-07-12 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742445#comment-17742445 ] Ruben Q L commented on CALCITE-5839: Thanks for the quick confirmation [~zabetak]!

[jira] [Comment Edited] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

2023-07-12 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742445#comment-17742445 ] Ruben Q L edited comment on CALCITE-5839 at 7/12/23 2:46 PM:

[jira] [Resolved] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

2023-07-12 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5839. Resolution: Fixed Fixed via https://github.com/apache/calcite/commit/55f714cc37ca7d60a6c95196f40

[jira] [Updated] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

2023-07-13 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5732: --- Fix Version/s: 1.36.0 > EnumerableHashJoin and EnumerableMergeJoin on composite key return rows >

[jira] [Updated] (CALCITE-5857) set org.apache.calcite.sql.validateScopeChild to protected or public

2023-07-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5857: --- Fix Version/s: (was: 1.34.0) (was: 1.35.0) > set org.apache.calcite.sql.

[jira] [Updated] (CALCITE-5857) set org.apache.calcite.sql.validateScopeChild to protected or public

2023-07-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5857: --- Affects Version/s: (was: 1.36.0) > set org.apache.calcite.sql.validateScopeChild to protected

[jira] [Updated] (CALCITE-5865) ClassCastException with FLOOR and CEIL on conformances that are not builtin

2023-07-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5865: --- Priority: Blocker (was: Major) > ClassCastException with FLOOR and CEIL on conformances that are n

[jira] [Commented] (CALCITE-5865) ClassCastException with FLOOR and CEIL on conformances that are not builtin

2023-07-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17745506#comment-17745506 ] Ruben Q L commented on CALCITE-5865: Thanks for the indo [~nobigo]. I have created

[jira] [Comment Edited] (CALCITE-5865) ClassCastException with FLOOR and CEIL on conformances that are not builtin

2023-07-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17745506#comment-17745506 ] Ruben Q L edited comment on CALCITE-5865 at 7/21/23 9:22 AM:

[jira] [Commented] (CALCITE-5865) ClassCastException with FLOOR and CEIL on conformances that are not builtin

2023-07-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17745596#comment-17745596 ] Ruben Q L commented on CALCITE-5865: [~nobigo], the problem [should be fixed|https

[jira] [Updated] (CALCITE-5867) Add BLOB data type in SqlTypeName

2023-07-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5867: --- Fix Version/s: (was: 1.35.0) > Add BLOB data type in SqlTypeName > ---

[jira] [Updated] (CALCITE-5879) Calcite crashes with AssertionFailure during evaluation of constant SPLIT expression

2023-07-31 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5879: --- Fix Version/s: 1.36.0 > Calcite crashes with AssertionFailure during evaluation of constant SPLIT

[jira] [Resolved] (CALCITE-5877) AssertionError during MOD operation if result scale is greater than maximum numeric scale

2023-08-02 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5877. Resolution: Fixed Done via [https://github.com/apache/calcite/commit/5b9e768d72bd5ed7aa3ca7aa631

[jira] [Resolved] (CALCITE-5879) AssertionError during constant reduction of SPLIT expression that returns NULL

2023-08-03 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5879. Resolution: Fixed Fixed via   [{{ffd58e3}}|https://github.com/apache/calcite/commit/ffd58e3b6d382

[jira] [Updated] (CALCITE-5882) Compile-time evaluation of SPLIT function returns incorrect result

2023-08-03 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5882: --- Fix Version/s: 1.36.0 > Compile-time evaluation of SPLIT function returns incorrect result > --

[jira] [Resolved] (CALCITE-5882) Compile-time evaluation of SPLIT function returns incorrect result

2023-08-03 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5882. Resolution: Fixed Fixed via   [{{98f3048}}|https://github.com/apache/calcite/commit/98f3048fb1407

[jira] [Created] (CALCITE-5903) RelMdCollation does not define collations for EnumerableLimit

2023-08-07 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-5903: -- Summary: RelMdCollation does not define collations for EnumerableLimit Key: CALCITE-5903 URL: https://issues.apache.org/jira/browse/CALCITE-5903 Project: Calcite

[jira] [Resolved] (CALCITE-5903) RelMdCollation does not define collations for EnumerableLimit

2023-08-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5903. Resolution: Fixed Fixed via   [{{0cea91b}}|https://github.com/apache/calcite/commit/0cea91b8426d4

[jira] [Resolved] (CALCITE-5843) Constant expression with nested casts causes a compiler crash

2023-08-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5843. Resolution: Fixed Fixed via [{{bde9110}}|https://github.com/apache/calcite/commit/bde9110ca6d090

<    6   7   8   9   10   11   12   13   >