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

[ 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

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

[ 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

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

[ 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

[ 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

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

[ 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

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

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:

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

[ 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

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

[ 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

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

[ 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] [Updated] (CALCITE-5745) CONCAT2 function (enabled in Oracle library) gets wrong result when one of the arguments is NULL

[ 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-5745) CONCAT2 function (enabled in Oracle library) gets wrong result when one of the arguments is NULL

[ 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

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

[ 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-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

[ 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

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

[ 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] [Resolved] (CALCITE-5730) Initial null values can be dropped by EnumerableLimitSort with offset

[ 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

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

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728250#comment-17728250 ] Ruben Q L edited comment on CALCITE-5732 at 6/1/23 3:45 PM: I see. The

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

[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728251#comment-17728251 ] Ruben Q L commented on CALCITE-5731: What's the problem with the current status (that goes beyond

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

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728250#comment-17728250 ] Ruben Q L commented on CALCITE-5732: I see. The problem is that both algorithms check for a null

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

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728105#comment-17728105 ] Ruben Q L commented on CALCITE-5732: [~viggoc] just to confirm: the bug occurs with both HashJoin

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

[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727412#comment-17727412 ] Ruben Q L edited comment on CALCITE-5731 at 5/30/23 8:54 AM: - [~jackylau] 

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

[ 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

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

[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727412#comment-17727412 ] Ruben Q L commented on CALCITE-5731: [~jackylau] thanks bringing up this topic. I'm not an expert

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

[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727370#comment-17727370 ] Ruben Q L commented on CALCITE-5730: [~gf2121], what [~julianhyde] means is that, normally, the

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

[ 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

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

[ 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

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

[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727067#comment-17727067 ] Ruben Q L commented on CALCITE-5730: [~thomas.rebele] could you please help with this one? > First

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

[ 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] [Updated] (CALCITE-5599) Support more trigonometric functions for BigQuery

[ 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] [Resolved] (CALCITE-5599) Support more trigonometric functions for BigQuery

[ 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

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

[ https://issues.apache.org/jira/browse/CALCITE-5599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727042#comment-17727042 ] Ruben Q L commented on CALCITE-5599: Ok [~FrankZou]! I will move this ticket to "resolved". >

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

[ https://issues.apache.org/jira/browse/CALCITE-5599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726791#comment-17726791 ] Ruben Q L commented on CALCITE-5599: All the sub-tasks have been done; are there more to come or

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

[ 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

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

[ https://issues.apache.org/jira/browse/CALCITE-4334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726266#comment-17726266 ] Ruben Q L commented on CALCITE-4334: I agree with [~libenchao]  on the benefits of this change.

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

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

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

[ 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] [Resolved] (CALCITE-5691) IN sub-query inside FILTER clause throws IndexOutOfBoundsException

[ 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

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

[ 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 >

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

[ https://issues.apache.org/jira/browse/CALCITE-5691?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5691: --- Fix Version/s: 1.35.0 > IN sub-query inside FILTER clause throws IndexOutOfBoundsException >

[jira] [Resolved] (CALCITE-5602) Implement CSC and SEC functions

[ https://issues.apache.org/jira/browse/CALCITE-5602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5602. Resolution: Fixed Done in

[jira] [Updated] (CALCITE-5602) Implement CSC and SEC functions

[ https://issues.apache.org/jira/browse/CALCITE-5602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5602: --- Fix Version/s: 1.35.0 > Implement CSC and SEC functions > --- > >

[jira] [Updated] (CALCITE-5602) Implement CSC and SEC functions

[ https://issues.apache.org/jira/browse/CALCITE-5602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5602: --- Summary: Implement CSC and SEC functions (was: Implement CSC and SEC function) > Implement CSC

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

[ https://issues.apache.org/jira/browse/CALCITE-5691?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17723374#comment-17723374 ] Ruben Q L commented on CALCITE-5691: [~Runking] would it be possible to include in the PR not just

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

[ https://issues.apache.org/jira/browse/CALCITE-5401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17718551#comment-17718551 ] Ruben Q L edited comment on CALCITE-5401 at 5/2/23 12:29 PM: - Thanks for

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

[ https://issues.apache.org/jira/browse/CALCITE-5401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17718551#comment-17718551 ] Ruben Q L edited comment on CALCITE-5401 at 5/2/23 12:27 PM: - Thanks for

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

[ https://issues.apache.org/jira/browse/CALCITE-5401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17718551#comment-17718551 ] Ruben Q L commented on CALCITE-5401: Thanks for the feedback [~zabetak]. I agree that using

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

[ 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] [Assigned] (CALCITE-5401) Rule fired by HepPlanner can return Volcano's RelSubset

[ https://issues.apache.org/jira/browse/CALCITE-5401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5401: -- Assignee: Ruben Q L > Rule fired by HepPlanner can return Volcano's RelSubset >

[jira] [Resolved] (CALCITE-5679) HepPlanner#buildFinalPlan: do not clear metadata cache if RelNode has not changed

[ https://issues.apache.org/jira/browse/CALCITE-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5679. Resolution: Fixed Done via

[jira] [Updated] (CALCITE-5679) HepPlanner#buildFinalPlan: do not clear metadata cache if RelNode has not changed

[ https://issues.apache.org/jira/browse/CALCITE-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5679: --- Description: Minor optimization: {{HepPlanner#buildFinalPlan}} clears the metadata cache info of

[jira] [Updated] (CALCITE-5679) HepPlanner#buildFinalPlan: do not clear metadata cache if RelNode has not changed

[ https://issues.apache.org/jira/browse/CALCITE-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5679: --- Summary: HepPlanner#buildFinalPlan: do not clear metadata cache if RelNode has not changed (was:

[jira] [Updated] (CALCITE-5679) HepPlanner#buildFinalplan: do not clear metadata cache if RelNode has not changed

[ https://issues.apache.org/jira/browse/CALCITE-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5679: --- Description: Minor optimization: {{HepPlanner#buildFinalplan}} clears the metadata cache info of

[jira] [Assigned] (CALCITE-5679) HepPlanner#buildFinalplan: do not clear metadata cache if RelNode has not changed

[ https://issues.apache.org/jira/browse/CALCITE-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5679: -- Assignee: Ruben Q L > HepPlanner#buildFinalplan: do not clear metadata cache if RelNode has

[jira] [Created] (CALCITE-5679) HepPlanner#buildFinalplan: do not clear metadata cache if RelNode has not changed

Ruben Q L created CALCITE-5679: -- Summary: HepPlanner#buildFinalplan: do not clear metadata cache if RelNode has not changed Key: CALCITE-5679 URL: https://issues.apache.org/jira/browse/CALCITE-5679

[jira] [Resolved] (CALCITE-5670) Assertion error in SemiJoinJoinTransposeRule when Semi-Join has keys from both tables of the bottom Join

[ https://issues.apache.org/jira/browse/CALCITE-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5670. Resolution: Fixed Fixed via

[jira] [Resolved] (CALCITE-5642) Add SHA256, SHA512 functions (enabled in BigQuery and PostgreSQL libraries)

[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5642. Resolution: Fixed Done via

[jira] [Updated] (CALCITE-5642) Add SHA256, SHA512 functions (enabled in BigQuery and PostgreSQL libraries)

[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5642: --- Summary: Add SHA256, SHA512 functions (enabled in BigQuery and PostgreSQL libraries) (was: Add

[jira] [Updated] (CALCITE-5642) Add SHA256, SHA512 functions

[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5642: --- Fix Version/s: 1.35.0 > Add SHA256, SHA512 functions > > >

[jira] [Resolved] (CALCITE-5563) Reduce loops to optimize RelSubset#getParents and RelSubset#getParentSubsets

[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5563. Resolution: Fixed Fixed via

[jira] [Commented] (CALCITE-5642) Add SHA256, SHA512 functions

[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17714996#comment-17714996 ] Ruben Q L commented on CALCITE-5642: [~FrankZou] PR looks good overall. One minor question: should

[jira] [Commented] (CALCITE-5642) Add SHA256, SHA512 functions

[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17714993#comment-17714993 ] Ruben Q L commented on CALCITE-5642: I have checked the previous comments. My understanding is that

[jira] [Resolved] (CALCITE-5651) Type system decimal scale in inferred types may exceed allowed scale

[ https://issues.apache.org/jira/browse/CALCITE-5651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5651. Resolution: Fixed Fixed via

[jira] [Updated] (CALCITE-5651) Type system decimal scale in inferred types may exceed allowed scale

[ https://issues.apache.org/jira/browse/CALCITE-5651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5651: --- Fix Version/s: 1.35.0 > Type system decimal scale in inferred types may exceed allowed scale >

[jira] [Assigned] (CALCITE-5563) Reduce loops to optimize RelSubset#getParents and RelSubset#getParentSubsets

[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5563: -- Assignee: asdfgh19 (was: Ruben Q L) > Reduce loops to optimize RelSubset#getParents and

[jira] [Updated] (CALCITE-5563) Reduce loops to optimize RelSubset#getParents and RelSubset#getParentSubsets

[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5563: --- Summary: Reduce loops to optimize RelSubset#getParents and RelSubset#getParentSubsets (was:

[jira] [Assigned] (CALCITE-5563) Reduce loops to optimize RelSubset#getParents and RelSubset#getParentSubsets

[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5563: -- Assignee: Ruben Q L (was: asdfgh19) > Reduce loops to optimize RelSubset#getParents and

[jira] [Updated] (CALCITE-5638) Assertion Failure during planning correlated query with orderby

[ https://issues.apache.org/jira/browse/CALCITE-5638?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5638: --- Description: Here is a test which fails if pasted in jdbcTest.java: {code} @Test void testCrash()

[jira] [Updated] (CALCITE-5651) Type system decimal scale in inferred types may exceed allowed scale

[ https://issues.apache.org/jira/browse/CALCITE-5651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5651: --- Description: If one uses a type system with a scale which is < precision/2 the calcite compiler

[jira] [Commented] (CALCITE-5559) Improve RepeatUnion by discarding duplicates at TableSpool level

[ https://issues.apache.org/jira/browse/CALCITE-5559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17703119#comment-17703119 ] Ruben Q L commented on CALCITE-5559: Any feedback on the proposed PR? Could we consider this as a

[jira] [Commented] (CALCITE-5559) Improve RepeatUnion by discarding duplicates at TableSpool level

[ https://issues.apache.org/jira/browse/CALCITE-5559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698388#comment-17698388 ] Ruben Q L commented on CALCITE-5559: I have created

[jira] [Commented] (CALCITE-5559) Improve RepeatUnion by discarding duplicates at TableSpool level

[ https://issues.apache.org/jira/browse/CALCITE-5559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697778#comment-17697778 ] Ruben Q L commented on CALCITE-5559: Correct [~julianhyde], at this moment RepeatUnion has a

[jira] [Commented] (CALCITE-5559) Improve RepeatUnion by discarding duplicates at TableSpool level

[ https://issues.apache.org/jira/browse/CALCITE-5559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697311#comment-17697311 ] Ruben Q L commented on CALCITE-5559: I have tried both approaches: A) Deal with duplicates inside

[jira] [Updated] (CALCITE-5559) Improve RepeatUnion by discarding duplicates at TableSpool level

[ https://issues.apache.org/jira/browse/CALCITE-5559?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5559: --- Description: Currently, RepeatUnion operator with all=false keeps track of the elements that it

[jira] [Commented] (CALCITE-5559) Improve RepeatUnion by discarding duplicates at TableSpool level

[ https://issues.apache.org/jira/browse/CALCITE-5559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17696956#comment-17696956 ] Ruben Q L commented on CALCITE-5559: Thanks for the input [~zabetak], indeed that seems a valid,

[jira] [Created] (CALCITE-5559) Improve RepeatUnion by discarding duplicates at TableSpool level

Ruben Q L created CALCITE-5559: -- Summary: Improve RepeatUnion by discarding duplicates at TableSpool level Key: CALCITE-5559 URL: https://issues.apache.org/jira/browse/CALCITE-5559 Project: Calcite

[jira] [Assigned] (CALCITE-5559) Improve RepeatUnion by discarding duplicates at TableSpool level

[ https://issues.apache.org/jira/browse/CALCITE-5559?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5559: -- Assignee: Ruben Q L > Improve RepeatUnion by discarding duplicates at TableSpool level >

[jira] [Resolved] (CALCITE-5494) Time zone tests in DateTimeUtilsTest should pass in Europe/London

[ https://issues.apache.org/jira/browse/CALCITE-5494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5494. Resolution: Fixed Fixed via

[jira] [Commented] (CALCITE-5480) Release Avatica 1.23.0

[ https://issues.apache.org/jira/browse/CALCITE-5480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17680783#comment-17680783 ] Ruben Q L commented on CALCITE-5480: Thanks! I have just created avatica-1.24.0. > Release Avatica

[jira] [Updated] (CALCITE-5494) Time zone tests in DateTimeUtilsTest should pass in Europe/London

[ https://issues.apache.org/jira/browse/CALCITE-5494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5494: --- Fix Version/s: avatica-1.24.0 > Time zone tests in DateTimeUtilsTest should pass in Europe/London

[jira] [Commented] (CALCITE-5480) Release Avatica 1.23.0

[ https://issues.apache.org/jira/browse/CALCITE-5480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17680555#comment-17680555 ] Ruben Q L commented on CALCITE-5480: [~julianhyde] thanks for producing this release. One minor

[jira] [Commented] (CALCITE-5493) Time zone tests in SqlFunctions should pass in Europe/London

[ https://issues.apache.org/jira/browse/CALCITE-5493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17680503#comment-17680503 ] Ruben Q L commented on CALCITE-5493: Thanks for the reactivity [~freastro]! I confirm this fixed

[jira] [Resolved] (CALCITE-5471) RelSupplier.SqlRelSupplier#apply should use .project(), not .rel

[ https://issues.apache.org/jira/browse/CALCITE-5471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5471. Fix Version/s: 1.33.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-5456) Hints on Tablescan will lost when plannerImpl execute flattenTypes

[ https://issues.apache.org/jira/browse/CALCITE-5456?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17651557#comment-17651557 ] Ruben Q L commented on CALCITE-5456: [~grandfisher] thanks for reporting the issue, do you think

[jira] [Comment Edited] (CALCITE-5448) ReduceExpressionsRule does not always constant fold expressions

[ https://issues.apache.org/jira/browse/CALCITE-5448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17649869#comment-17649869 ] Ruben Q L edited comment on CALCITE-5448 at 12/20/22 4:16 PM: --

[jira] [Commented] (CALCITE-5448) ReduceExpressionsRule does not always constant fold expressions

[ https://issues.apache.org/jira/browse/CALCITE-5448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17649869#comment-17649869 ] Ruben Q L commented on CALCITE-5448: [~julianhyde], I agree that is the general case. But in the

[jira] [Commented] (CALCITE-5448) ReduceExpressionsRule does not always constant fold expressions

[ https://issues.apache.org/jira/browse/CALCITE-5448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17649626#comment-17649626 ] Ruben Q L commented on CALCITE-5448: [~mbudiu], I think you are right. That code seems a bit

[jira] [Updated] (CALCITE-5448) ReduceExpressionsRule does not always constant fold expressions

[ https://issues.apache.org/jira/browse/CALCITE-5448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5448: --- Description: I have manually built a HepPlanner to optimize the SQL queries, and I discovered

[jira] [Commented] (CALCITE-5417) Include Proj4J as an api dependency once the license allows it

[ https://issues.apache.org/jira/browse/CALCITE-5417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17648580#comment-17648580 ] Ruben Q L commented on CALCITE-5417: No problem at all [~bchapuis], thanks for your reactivity! >

[jira] [Commented] (CALCITE-5281) Implement geometry set returning functions (SRF)

[ https://issues.apache.org/jira/browse/CALCITE-5281?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17648572#comment-17648572 ] Ruben Q L commented on CALCITE-5281: [~bchapuis], could you please complete the "fixVersion = 1.33"

[jira] [Commented] (CALCITE-5417) Include Proj4J as an api dependency once the license allows it

[ https://issues.apache.org/jira/browse/CALCITE-5417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17648568#comment-17648568 ] Ruben Q L commented on CALCITE-5417: [~bchapuis] I saw that you moved this ticket to "closed". In

[jira] [Commented] (CALCITE-4987) JDBC adapter generates incorrect query when ORDER BY alias collides with field in SELECT ITEM

[ https://issues.apache.org/jira/browse/CALCITE-4987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17646537#comment-17646537 ] Ruben Q L commented on CALCITE-4987: Is there any update on this ticket? The PR has not been

[jira] [Commented] (CALCITE-4908) Support classpath resource name as model resource path

[ https://issues.apache.org/jira/browse/CALCITE-4908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17646038#comment-17646038 ] Ruben Q L commented on CALCITE-4908: Is there any update on this ticket? Should we consider the PR

[jira] [Resolved] (CALCITE-5394) RelToSql converter fails when semi-join is under a join node

[ https://issues.apache.org/jira/browse/CALCITE-5394?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5394. Resolution: Fixed Fixed via

[jira] [Resolved] (CALCITE-5395) RelToSql converter fails when SELECT * is under a semi-join node

[ https://issues.apache.org/jira/browse/CALCITE-5395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5395. Resolution: Fixed Fixed via

[jira] [Updated] (CALCITE-5394) RelToSql converter fails when semi-join is under a join node

[ https://issues.apache.org/jira/browse/CALCITE-5394?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5394: --- Fix Version/s: 1.33.0 > RelToSql converter fails when semi-join is under a join node >

[jira] [Updated] (CALCITE-5395) RelToSql converter fails when SELECT * is under a semi-join node

[ https://issues.apache.org/jira/browse/CALCITE-5395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5395: --- Fix Version/s: 1.33.0 > RelToSql converter fails when SELECT * is under a semi-join node >

[jira] [Commented] (CALCITE-5399) Proj4J license is not compatible with Apache

[ https://issues.apache.org/jira/browse/CALCITE-5399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17642389#comment-17642389 ] Ruben Q L commented on CALCITE-5399: [~bchapuis], thanks for pushing this forward. I can see the PR

[jira] [Commented] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17641428#comment-17641428 ] Ruben Q L commented on CALCITE-5409: Thanks for the clarification. > Jdbc doesn't support

[jira] [Commented] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17641336#comment-17641336 ] Ruben Q L commented on CALCITE-5409: [~zabetak], thanks for confirming that this issue is a

[jira] [Commented] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17641329#comment-17641329 ] Ruben Q L commented on CALCITE-5409: Maybe related to (or duplicate of?) CALCITE-4188 > Jdbc

[jira] [Commented] (CALCITE-5285) CalcReduceExpressionsRule may transform to same rel

[ https://issues.apache.org/jira/browse/CALCITE-5285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17640829#comment-17640829 ] Ruben Q L commented on CALCITE-5285: I agree with [~zabetak]. IMO the problem seems to be located

<    1   2   3   4   5   6   7   8   9   10   >