[jira] [Resolved] (CALCITE-5697) RelBuilder.convert does not match nullability if top of stack is a Project

2023-05-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5697. -- Fix Version/s: 1.35.0 Resolution: Fixed Fixed in

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

2023-05-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-4334. -- Fix Version/s: 1.35.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-5717) Prune Project's input if project has no InputRef and the input has 1 row

2023-05-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5717. -- Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-5717) Prune Project's input if project has no InputRef and the input has 1 row

2023-05-27 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5717?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726881#comment-17726881 ] Benchao Li commented on CALCITE-5717: - Thanks, let's move to CALCITE-4334. > Prune Project's input

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

2023-05-27 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726880#comment-17726880 ] Benchao Li commented on CALCITE-5715: - {quote}The one skill I think you can improve is writing

[jira] [Commented] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic when Project without RexInputRef on the Aggregate

2023-05-27 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726877#comment-17726877 ] Jiajun Xie commented on CALCITE-5506: - [~julianhyde]  Do you have time to submit your branch? I am

[jira] [Comment Edited] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

2023-05-27 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726870#comment-17726870 ] Jiajun Xie edited comment on CALCITE-5723 at 5/28/23 1:42 AM: -- Thank you

[jira] [Commented] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

2023-05-27 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726870#comment-17726870 ] Jiajun Xie commented on CALCITE-5723: - Thank you for your explanation.   The PR looks good and

[jira] [Comment Edited] (CALCITE-5725) Support Doris Dialect

2023-05-27 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726869#comment-17726869 ] Jiajun Xie edited comment on CALCITE-5725 at 5/28/23 1:38 AM: -- 1. It's

[jira] [Commented] (CALCITE-5725) Support Doris Dialect

2023-05-27 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726869#comment-17726869 ] Jiajun Xie commented on CALCITE-5725: - 1. It's worth mentioning that BabelParser can welcome

[jira] [Commented] (CALCITE-5724) Generated SQL uses literal values in ORDER BY clauses

2023-05-27 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726867#comment-17726867 ] Jiajun Xie commented on CALCITE-5724: - Agree with Hyde. Here is

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

2023-05-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726832#comment-17726832 ] Julian Hyde commented on CALCITE-5715: -- [~libenchao], I'm sorry to be so harsh on you. I think you

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

2023-05-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726831#comment-17726831 ] Julian Hyde commented on CALCITE-5715: -- I've been confused by the summaries of a few of your

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

2023-05-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726829#comment-17726829 ] Julian Hyde commented on CALCITE-4334: -- [~libenchao], In the latest

[jira] [Commented] (CALCITE-5717) Prune Project's input if project has no InputRef and the input has 1 row

2023-05-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5717?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726828#comment-17726828 ] Julian Hyde commented on CALCITE-5717: -- In my dev branch for CALCITE-4334 I have created a commit

[jira] [Updated] (CALCITE-5717) Prune Project's input if project has no InputRef and the input has 1 row

2023-05-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5717: - Description: Prune {{Project}}'s input if project has no {{RexInputRef}} and the input has 1

[jira] [Commented] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

2023-05-27 Thread ZheHu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726792#comment-17726792 ] ZheHu commented on CALCITE-5723: As far as I know, the lower version(<12) Oracle doesn't support either

[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] [Comment Edited] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

2023-05-27 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726789#comment-17726789 ] Jiajun Xie edited comment on CALCITE-5723 at 5/27/23 10:01 AM: --- Does

[jira] [Commented] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

2023-05-27 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726789#comment-17726789 ] Jiajun Xie commented on CALCITE-5723: - Does oracle(<12) support other similar syntax? > Oracle

[jira] [Commented] (CALCITE-5725) Support Doris Dialect

2023-05-27 Thread xingyuan cheng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726786#comment-17726786 ] xingyuan cheng commented on CALCITE-5725: - Ok, thank you for your reply. I will start working

[jira] [Updated] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

2023-05-27 Thread ZheHu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ZheHu updated CALCITE-5723: --- Fix Version/s: 1.35.0 > Oracle dialect generates SQL that cannot be recognized by lower version > Oracle