[jira] [Assigned] (CALCITE-4771) change the value of the CAST function to be nullable

2023-03-07 Thread Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zou reassigned CALCITE-4771: Assignee: Zou > change the value of the CAST function to be nullable >

[jira] [Commented] (CALCITE-4771) change the value of the CAST function to be nullable

2023-03-07 Thread Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697751#comment-17697751 ] Zou commented on CALCITE-4771: -- I'd like to take this ticket > change the value of the CAST function to

[jira] [Commented] (CALCITE-5563) Reduce loops to improve RelSubset

2023-03-07 Thread asdfgh19 (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697694#comment-17697694 ] asdfgh19 commented on CALCITE-5563: --- [~julianhyde] Reduce loops to improve RelSubset, how about this

[jira] [Updated] (CALCITE-5563) Reduce loops to improve RelSubset

2023-03-07 Thread asdfgh19 (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] asdfgh19 updated CALCITE-5563: -- Summary: Reduce loops to improve RelSubset (was: Add a break to the inner loop of

[jira] [Updated] (CALCITE-5565) Implement BigQuery LOG function

2023-03-07 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5565: -- Description: Calcite currently supports the {{LN}} and {{LOG10}} function. BigQuery offers

[jira] [Updated] (CALCITE-5565) Implement BigQuery LOG function

2023-03-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5565: Labels: pull-request-available (was: ) > Implement BigQuery LOG function >

[jira] [Created] (CALCITE-5565) Implement BigQuery LOG function

2023-03-07 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5565: - Summary: Implement BigQuery LOG function Key: CALCITE-5565 URL: https://issues.apache.org/jira/browse/CALCITE-5565 Project: Calcite Issue Type: Task

[jira] [Commented] (CALCITE-5563) Add a break to the inner loop of RelSubset#getParents and RelSubset#getParentSubsets after we find a matching Relsubset from its parent input

2023-03-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697668#comment-17697668 ] Julian Hyde commented on CALCITE-5563: -- It makes sense, but you need to provide a summary that is

[jira] [Commented] (CALCITE-5552) Returned timestamp is incorrect after the 100th row

2023-03-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5552?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697667#comment-17697667 ] Julian Hyde commented on CALCITE-5552: -- I agree. CALCITE-5488 is related. My hunch is that we

[jira] [Commented] (CALCITE-5563) Add a break to the inner loop of RelSubset#getParents and RelSubset#getParentSubsets after we find a matching Relsubset from its parent input

2023-03-07 Thread asdfgh19 (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697663#comment-17697663 ] asdfgh19 commented on CALCITE-5563: --- [~julianhyde] It is not a bug, just a minor improvement to save

[jira] [Updated] (CALCITE-5563) Add a break to the inner loop of RelSubset#getParents and RelSubset#getParentSubsets after we find a matching Relsubset from its parent input

2023-03-07 Thread asdfgh19 (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] asdfgh19 updated CALCITE-5563: -- Description:   {code:java} /** * Returns the collection of RelNodes one of whose inputs is in this

[jira] [Updated] (CALCITE-5563) Add a break to the inner loop of RelSubset#getParents and RelSubset#getParentSubsets after we find a matching Relsubset from its parent input

2023-03-07 Thread asdfgh19 (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] asdfgh19 updated CALCITE-5563: -- Description:   {code:java} /** * Returns the collection of RelNodes one of whose inputs is in this

[jira] [Commented] (CALCITE-5552) Returned timestamp is incorrect after the 100th row

2023-03-07 Thread Will Noble (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5552?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697659#comment-17697659 ] Will Noble commented on CALCITE-5552: - Sounds like this is similar in nature to, though probably

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

2023-03-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697593#comment-17697593 ] Julian Hyde commented on CALCITE-5559: -- Sorry, coming late to this, and haven't read everything,

[jira] [Commented] (CALCITE-5558) avatica protobuf update_count and other signed ints should not be unsigned

2023-03-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697586#comment-17697586 ] Julian Hyde commented on CALCITE-5558: -- Would this be a breaking change? Update count never needs

[jira] [Commented] (CALCITE-5557) Add SAFE_CAST (BigQuery compatibility)

2023-03-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697581#comment-17697581 ] Julian Hyde commented on CALCITE-5557: -- I don't know. It's a judgment call as to what causes the

[jira] [Commented] (CALCITE-5554) Add DAYOFWEEK and DAYOFYEAR as valid synonyms of DOW, DOY

2023-03-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697578#comment-17697578 ] Julian Hyde commented on CALCITE-5554: -- That sounds reasonable, given that {{EXTRACT}} is

[jira] [Closed] (CALCITE-5562) The result data is disordered when u tried to get data from an ordered set

2023-03-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-5562. Resolution: Not A Bug Not a bug. ORDER BY in a subquery is ignored. This seems to be a

[jira] [Updated] (CALCITE-5564) Support 2-argument PERCENTILE_CONT, PERCENTILE_DISC aggregate functions (as in BigQuery)

2023-03-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5564: - Summary: Support 2-argument PERCENTILE_CONT, PERCENTILE_DISC aggregate functions (as in

[jira] [Commented] (CALCITE-5563) Add a break to the inner loop of RelSubset#getParents and RelSubset#getParentSubsets after we find a matching Relsubset from its parent input

2023-03-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697573#comment-17697573 ] Julian Hyde commented on CALCITE-5563: -- What's the bug? Change your summary to describe the

[jira] [Commented] (CALCITE-5564) Add 2-argument support for PERCENTILE_CONT/DISC

2023-03-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5564?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697571#comment-17697571 ] Julian Hyde commented on CALCITE-5564: -- It seems to me that the main difference is that BigQuery's

[jira] [Created] (CALCITE-5564) Add 2-argument support for PERCENTILE_CONT/DISC

2023-03-07 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5564: - Summary: Add 2-argument support for PERCENTILE_CONT/DISC Key: CALCITE-5564 URL: https://issues.apache.org/jira/browse/CALCITE-5564 Project: Calcite Issue

[jira] [Updated] (CALCITE-5390) RelDecorrelator throws NullPointerException

2023-03-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-5390: - Description: The current query throws NullPointerException {code:java} SELECT

[jira] [Commented] (CALCITE-5390) RelDecorrelator throws NullPointerException

2023-03-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697487#comment-17697487 ] Sergey Nuyanzin commented on CALCITE-5390: -- Thanks for the quick response. I will try to see

[jira] [Updated] (CALCITE-5563) Add a break to the inner loop of RelSubset#getParents and RelSubset#getParentSubsets after we find a matching Relsubset from its parent input

2023-03-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5563: Labels: pull-request-available (was: ) > Add a break to the inner loop of

[jira] [Created] (CALCITE-5563) Add a break to the inner loop of RelSubset#getParents and RelSubset#getParentSubsets after we find a matching Relsubset from its parent input

2023-03-07 Thread asdfgh19 (Jira)
asdfgh19 created CALCITE-5563: - Summary: Add a break to the inner loop of RelSubset#getParents and RelSubset#getParentSubsets after we find a matching Relsubset from its parent input Key: CALCITE-5563 URL:

[jira] [Commented] (CALCITE-5403) Babel parser should parse PostgreSQL's SET, RESET, BEGIN, SHOW, ROLLBACK, COMMIT commands

2023-03-07 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697403#comment-17697403 ] Dmitry Sysolyatin commented on CALCITE-5403: [~julianhyde] I have changed summary to "Babel

[jira] [Commented] (CALCITE-5390) RelDecorrelator throws NullPointerException

2023-03-07 Thread Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697401#comment-17697401 ] Zou commented on CALCITE-5390: -- [~Sergey Nuyanzin] I am sorry that I haven't started this work yet as I am

[jira] [Updated] (CALCITE-5403) Babel parser should parse PostgreSQL's SET, RESET, BEGIN, SHOW, ROLLBACK, COMMIT commands

2023-03-07 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5403: --- Summary: Babel parser should parse PostgreSQL's SET, RESET, BEGIN, SHOW, ROLLBACK,

[jira] [Commented] (CALCITE-5390) RelDecorrelator throws NullPointerException

2023-03-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697394#comment-17697394 ] Sergey Nuyanzin commented on CALCITE-5390: -- Hi [~FrankZou] , do you have any plans to work on

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

2023-03-07 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697334#comment-17697334 ] Stamatis Zampetakis commented on CALCITE-5559: -- I am leaning more towards *B* even though

[jira] [Updated] (CALCITE-5562) The result data is disordered when u tried to get data from an ordered set

2023-03-07 Thread Yuxin Wu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yuxin Wu updated CALCITE-5562: -- Description: *It's based on CSV-TEST-MODEL. The same as {{{}lex=MYSQL{}}}.* {quote}!connect

[jira] [Updated] (CALCITE-5562) The result data is disordered when u tried to get data from an ordered set

2023-03-07 Thread Yuxin Wu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yuxin Wu updated CALCITE-5562: -- Description: *It's based on CSV-TEST-MODEL. The same as {{{}lex=MYSQL{}}}.* {quote}!connect

[jira] [Created] (CALCITE-5562) The result data is disordered when u tried to get data from an ordered set

2023-03-07 Thread Yuxin Wu (Jira)
Yuxin Wu created CALCITE-5562: - Summary: The result data is disordered when u tried to get data from an ordered set Key: CALCITE-5562 URL: https://issues.apache.org/jira/browse/CALCITE-5562 Project:

[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] [Commented] (CALCITE-5403) PostgreSQL dialect should support SET, RESET, BEGIN, SHOW, ROLLBACK, COMMIT

2023-03-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697295#comment-17697295 ] Julian Hyde commented on CALCITE-5403: -- The word “dialect” in generally refers to the SQL that

[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