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

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

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

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

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

[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

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

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

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

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

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

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

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

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

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

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

2023-05-22 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 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

2023-05-18 Thread Ruben Q L (Jira)
[ 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

2023-05-18 Thread Ruben Q L (Jira)
[ 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

2023-05-18 Thread Ruben Q L (Jira)
[ 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

2023-05-17 Thread Ruben Q L (Jira)
[ 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

2023-05-02 Thread Ruben Q L (Jira)
[ 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

2023-05-02 Thread Ruben Q L (Jira)
[ 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

2023-05-02 Thread Ruben Q L (Jira)
[ 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

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

2023-05-02 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 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

2023-04-29 Thread Ruben Q L (Jira)
[ 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

2023-04-28 Thread Ruben Q L (Jira)
[ 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

2023-04-28 Thread Ruben Q L (Jira)
[ 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

2023-04-28 Thread Ruben Q L (Jira)
[ 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

2023-04-28 Thread Ruben Q L (Jira)
[ 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

2023-04-28 Thread Ruben Q L (Jira)
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

2023-04-25 Thread Ruben Q L (Jira)
[ 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)

2023-04-25 Thread Ruben Q L (Jira)
[ 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)

2023-04-24 Thread Ruben Q L (Jira)
[ 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

2023-04-24 Thread Ruben Q L (Jira)
[ 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

2023-04-21 Thread Ruben Q L (Jira)
[ 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

2023-04-21 Thread Ruben Q L (Jira)
[ 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

2023-04-21 Thread Ruben Q L (Jira)
[ 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

2023-04-21 Thread Ruben Q L (Jira)
[ 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

2023-04-21 Thread Ruben Q L (Jira)
[ 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

2023-04-20 Thread Ruben Q L (Jira)
[ 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

2023-04-20 Thread Ruben Q L (Jira)
[ 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

2023-04-20 Thread Ruben Q L (Jira)
[ 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

2023-04-17 Thread Ruben Q L (Jira)
[ 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

2023-04-17 Thread Ruben Q L (Jira)
[ 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

2023-03-21 Thread Ruben Q L (Jira)
[ 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

2023-03-09 Thread Ruben Q L (Jira)
[ 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

2023-03-08 Thread Ruben Q L (Jira)
[ 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

2023-03-07 Thread Ruben Q L (Jira)
[ 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

2023-03-07 Thread Ruben Q L (Jira)
[ 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

2023-03-06 Thread Ruben Q L (Jira)
[ 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

2023-03-06 Thread Ruben Q L (Jira)
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

2023-03-06 Thread Ruben Q L (Jira)
[ 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

2023-01-25 Thread Ruben Q L (Jira)
[ 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

2023-01-25 Thread Ruben Q L (Jira)
[ 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

2023-01-25 Thread Ruben Q L (Jira)
[ 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

2023-01-25 Thread Ruben Q L (Jira)
[ 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

2023-01-25 Thread Ruben Q L (Jira)
[ 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

2023-01-16 Thread Ruben Q L (Jira)
[ 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

2022-12-23 Thread Ruben Q L (Jira)
[ 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

2022-12-20 Thread Ruben Q L (Jira)
[ 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

2022-12-20 Thread Ruben Q L (Jira)
[ 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

2022-12-20 Thread Ruben Q L (Jira)
[ 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

2022-12-20 Thread Ruben Q L (Jira)
[ 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

2022-12-16 Thread Ruben Q L (Jira)
[ 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)

2022-12-16 Thread Ruben Q L (Jira)
[ 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

2022-12-16 Thread Ruben Q L (Jira)
[ 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

2022-12-13 Thread Ruben Q L (Jira)
[ 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

2022-12-12 Thread Ruben Q L (Jira)
[ 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

2022-12-12 Thread Ruben Q L (Jira)
[ 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

2022-12-12 Thread Ruben Q L (Jira)
[ 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

2022-12-02 Thread Ruben Q L (Jira)
[ 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

2022-12-02 Thread Ruben Q L (Jira)
[ 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

2022-12-02 Thread Ruben Q L (Jira)
[ 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

2022-11-30 Thread Ruben Q L (Jira)
[ 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

2022-11-30 Thread Ruben Q L (Jira)
[ 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

2022-11-30 Thread Ruben Q L (Jira)
[ 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

2022-11-29 Thread Ruben Q L (Jira)
[ 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

[jira] [Commented] (CALCITE-5043) GROUP BY alias or SELECT field should be determined by using sql dialect when alias and field are same

2022-11-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5043?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17640463#comment-17640463 ] Ruben Q L commented on CALCITE-5043: [~yanjing.wang] any update on this ticket? If there's still

[jira] [Updated] (CALCITE-2989) The method ymdToJulian in DateTimeUtils returns wrong value

2022-11-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-2989: --- Fix Version/s: (was: 1.33.0) > The method ymdToJulian in DateTimeUtils returns wrong value >

[jira] [Updated] (CALCITE-5399) Proj4j license is not compatible with Apache

2022-11-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5399: --- Labels: pull-request-available (was: ) > Proj4j license is not compatible with Apache >

[jira] [Updated] (CALCITE-5399) Proj4j license is not compatible with Apache

2022-11-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5399: --- Priority: Blocker (was: Major) > Proj4j license is not compatible with Apache >

[jira] [Commented] (CALCITE-2989) The method ymdToJulian in DateTimeUtils returns wrong value

2022-11-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17640219#comment-17640219 ] Ruben Q L commented on CALCITE-2989: [~freastro], could you please take a look at [~julianhyde]'s

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

2022-11-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17638725#comment-17638725 ] Ruben Q L edited comment on CALCITE-5401 at 11/25/22 5:34 PM: -- Not sure

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

2022-11-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17638725#comment-17638725 ] Ruben Q L commented on CALCITE-5401: Not sure how to best solve this issue. {{RelOptRule}}'s

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

2022-11-25 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: --- Description: TLDR; {{CoreRules.AGGREGATE_REMOVE}} is fired by a {{HepPlanner}} but while removing

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

2022-11-25 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-5401: -- Summary: Rule fired by HepPlanner can return Volcano's RelSubset Key: CALCITE-5401 URL: https://issues.apache.org/jira/browse/CALCITE-5401 Project: Calcite

[jira] [Resolved] (CALCITE-5377) RelFieldTrimmer support Sort with dynamic param

2022-11-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5377. Fix Version/s: 1.33.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-5397) There is a bug in judging whether traits are different in RelTraitSet#difference.

2022-11-23 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5397?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17637630#comment-17637630 ] Ruben Q L commented on CALCITE-5397: RelTraits should always be canonized, which allows them to be

[jira] [Resolved] (CALCITE-5257) NVARCHAR is treated as "UNKNOWN TYPE" when searching Oracle

2022-10-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5257. Fix Version/s: avatica-1.23.0 Resolution: Fixed Fixed via

[jira] [Resolved] (CALCITE-4900) NullPointerException when send ExectuteRequest via protobuf with no parameters

2022-10-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4900?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-4900. Fix Version/s: avatica-1.23.0 Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-5264) HintStrategy rule exclusion does not match innermost rels

2022-10-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5264: --- Description: In CALCITE-3781, calcite can specify a hint for a relNode to let the planner exclude

[jira] [Resolved] (CALCITE-5286) Join with parameterized LIMIT throws AssertionError "not a literal"

2022-10-03 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5286. Resolution: Fixed Done in

[jira] [Updated] (CALCITE-5286) Join with parameterized LIMIT throws AssertionError "not a literal"

2022-09-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5286: --- Fix Version/s: 1.33.0 > Join with parameterized LIMIT throws AssertionError "not a literal" >

[jira] [Commented] (CALCITE-5286) Join with parameterized LIMIT throws AssertionError "not a literal"

2022-09-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17610937#comment-17610937 ] Ruben Q L commented on CALCITE-5286: It seems we missed {code} public Double

[jira] [Resolved] (CALCITE-5274) Improve DocumentBuilderFactory in DiffRepository test class by using secure features

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5274. Resolution: Fixed Fixed in

[jira] [Comment Edited] (CALCITE-5277) Make EnumerableRelImplementor stashedParameters order deterministic to increase BINDABLE_CACHE hit rate

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17601965#comment-17601965 ] Ruben Q L edited comment on CALCITE-5277 at 9/8/22 6:57 PM: Done in

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