[jira] [Commented] (CALCITE-5109) RelMdAllPredicates support to analyze left-out-join

2022-04-27 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529164#comment-17529164 ] Xurenhe commented on CALCITE-5109: -- [~Chunwei Lei]  Thanks for your review and advice. I'm not sure

[jira] [Commented] (CALCITE-5119) SqlNode#unparse hides an alias table when using CTE

2022-04-27 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529161#comment-17529161 ] Jiajun Xie commented on CALCITE-5119: - Parsed SqlNode need to be validated, because the CTE will be

[jira] [Commented] (CALCITE-5117) Optimize the EXISTS sub-query by Metadata RowCount

2022-04-27 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529158#comment-17529158 ] xiong duan commented on CALCITE-5117: - Fixed in

[jira] [Resolved] (CALCITE-5117) Optimize the EXISTS sub-query by Metadata RowCount

2022-04-27 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5117?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan resolved CALCITE-5117. - Resolution: Fixed > Optimize the EXISTS sub-query by Metadata RowCount >

[jira] [Updated] (CALCITE-5081) Group keys of Aggregate are wrongly changed during decorrelation

2022-04-27 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5081?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5081: Labels: pull-request-available (was: ) > Group keys of Aggregate are wrongly changed

[jira] [Commented] (CALCITE-5109) RelMdAllPredicates support to analyze left-out-join

2022-04-27 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529152#comment-17529152 ] Chunwei Lei commented on CALCITE-5109: -- I took a glance at the PR and left some comments.  >

[jira] [Commented] (CALCITE-5109) RelMdAllPredicates support to analyze left-out-join

2022-04-27 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529150#comment-17529150 ] Chunwei Lei commented on CALCITE-5109: -- Thank you for your PR, [~wojustme]! I would suggest you

[jira] [Created] (CALCITE-5121) Rethrow RuntimeException as SQLException in Driver#onConnectionInit

2022-04-27 Thread Gregory Hart (Jira)
Gregory Hart created CALCITE-5121: - Summary: Rethrow RuntimeException as SQLException in Driver#onConnectionInit Key: CALCITE-5121 URL: https://issues.apache.org/jira/browse/CALCITE-5121 Project:

[jira] [Commented] (CALCITE-5120) Throw SQLException from UnregisteredDriver#connect if url is null

2022-04-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528938#comment-17528938 ] Julian Hyde commented on CALCITE-5120: -- Makes sense. > Throw SQLException from

[jira] [Created] (CALCITE-5120) Throw SQLException from UnregisteredDriver#connect if url is null

2022-04-27 Thread Gregory Hart (Jira)
Gregory Hart created CALCITE-5120: - Summary: Throw SQLException from UnregisteredDriver#connect if url is null Key: CALCITE-5120 URL: https://issues.apache.org/jira/browse/CALCITE-5120 Project:

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

2022-04-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1776?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528914#comment-17528914 ] Julian Hyde commented on CALCITE-1776: -- [~nobigo], My 1776-corr branch is ready for review. >

[jira] [Commented] (CALCITE-5118) SqlDatePartFunction#rewriteCall should check operands length

2022-04-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528852#comment-17528852 ] Julian Hyde commented on CALCITE-5118: -- I haven’t looked closely at this but I don’t think that

[jira] [Updated] (CALCITE-5119) SqlNode#unparse hides an alias table when using CTE

2022-04-27 Thread Mitsunori Komatsu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mitsunori Komatsu updated CALCITE-5119: --- Description: Hi team, I found SqlNode#unparse hides an alias table when using

[jira] [Created] (CALCITE-5119) SqlNode#unparse hides an alias table when using CTE

2022-04-27 Thread Mitsunori Komatsu (Jira)
Mitsunori Komatsu created CALCITE-5119: -- Summary: SqlNode#unparse hides an alias table when using CTE Key: CALCITE-5119 URL: https://issues.apache.org/jira/browse/CALCITE-5119 Project: Calcite

[jira] [Updated] (CALCITE-5118) SqlDatePartFunction#rewriteCall should check operands length

2022-04-27 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5118: Labels: pull-request-available (was: ) > SqlDatePartFunction#rewriteCall should check

[jira] [Commented] (CALCITE-5118) SqlDatePartFunction#rewriteCall should check operands length

2022-04-27 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528831#comment-17528831 ] Benchao Li commented on CALCITE-5118: - [~asolimando]  I'm proposing to have a more graceful

[jira] [Comment Edited] (CALCITE-5118) SqlDatePartFunction#rewriteCall should check operands length

2022-04-27 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528815#comment-17528815 ] Alessandro Solimando edited comment on CALCITE-5118 at 4/27/22 2:10 PM:

[jira] [Commented] (CALCITE-5118) SqlDatePartFunction#rewriteCall should check operands length

2022-04-27 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528815#comment-17528815 ] Alessandro Solimando commented on CALCITE-5118: --- Thanks [~libenchao], I was wondering

[jira] [Commented] (CALCITE-5118) SqlDatePartFunction#rewriteCall should check operands length

2022-04-27 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528811#comment-17528811 ] Benchao Li commented on CALCITE-5118: - [~asolimando] Thanks for the suggestion, I've updated the

[jira] [Updated] (CALCITE-5118) SqlDatePartFunction#rewriteCall should check operands length

2022-04-27 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li updated CALCITE-5118: Description: {{SqlDatePartFunction#rewriteCall}} does not check operands length for now, and it

[jira] [Commented] (CALCITE-5118) SqlDatePartFunction#rewriteCall should check operands length

2022-04-27 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528801#comment-17528801 ] Alessandro Solimando commented on CALCITE-5118: --- [~libenchao], can you define in the

[jira] [Commented] (CALCITE-5109) RelMdAllPredicates support to analyze left-out-join

2022-04-27 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528800#comment-17528800 ] Xurenhe commented on CALCITE-5109: -- Hi all Please review the commit:

[jira] [Created] (CALCITE-5118) SqlDatePartFunction#rewriteCall should check operands length

2022-04-27 Thread Benchao Li (Jira)
Benchao Li created CALCITE-5118: --- Summary: SqlDatePartFunction#rewriteCall should check operands length Key: CALCITE-5118 URL: https://issues.apache.org/jira/browse/CALCITE-5118 Project: Calcite

[jira] [Commented] (CALCITE-5100) Incorrect syntax in sub-query, unsupported LISTAGG

2022-04-27 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528783#comment-17528783 ] Benchao Li commented on CALCITE-5100: - [~rr111] , I cannot reproduce your case in

[jira] [Commented] (CALCITE-5113) function week(date 'xxx') returns a different number than mysql

2022-04-27 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528776#comment-17528776 ] Ruben Q L commented on CALCITE-5113: Sounds good, [~libenchao]. Please open a separate ticket to

[jira] [Commented] (CALCITE-5113) function week(date 'xxx') returns a different number than mysql

2022-04-27 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528770#comment-17528770 ] Benchao Li commented on CALCITE-5113: - [~rubenql]  You are right,

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

2022-04-27 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1776?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528651#comment-17528651 ] xiong duan commented on CALCITE-1776: - I will review it. > Implement CORR and REGR_* aggregate

[jira] [Commented] (CALCITE-5113) function week(date 'xxx') returns a different number than mysql

2022-04-27 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528602#comment-17528602 ] Ruben Q L commented on CALCITE-5113: Thanks for the confirmation [~itxiangkui]. Regarding your last

[jira] [Commented] (CALCITE-5117) Optimize the EXISTS sub-query by Metadata RowCount

2022-04-27 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528579#comment-17528579 ] Chunwei Lei commented on CALCITE-5117: -- Makes sense.  > Optimize the EXISTS sub-query by Metadata

[jira] [Resolved] (CALCITE-4861) Optimization of chained CAST calls can lead to unexpected behavior

2022-04-27 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei resolved CALCITE-4861. -- Fix Version/s: 1.31.0 Assignee: Benchao Li Resolution: Fixed Fixed in

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

2022-04-27 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1776?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528575#comment-17528575 ] Julian Hyde commented on CALCITE-1776: -- I'm rebasing PR 793 as

[jira] [Resolved] (CALCITE-5110) Geode adapter's java doc url is invalid

2022-04-27 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei resolved CALCITE-5110. -- Resolution: Fixed Fixed in