[jira] [Commented] (CALCITE-5828) When converting the calcite dialect, it is not determined whether the ordinal number can be used in the order by in the window function

2023-07-11 Thread LiHao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742232#comment-17742232 ] LiHao commented on CALCITE-5828: I see what you mean, so {{isSortByOrdinalInWindow}} is

[jira] [Comment Edited] (CALCITE-5838) derive wrong decimal divide type

2023-07-11 Thread pengfei.zhan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742225#comment-17742225 ] pengfei.zhan edited comment on CALCITE-5838 at 7/12/23 1:27 AM: -

[jira] [Comment Edited] (CALCITE-5838) derive wrong decimal divide type

2023-07-11 Thread pengfei.zhan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742225#comment-17742225 ] pengfei.zhan edited comment on CALCITE-5838 at 7/12/23 1:26 AM: -

[jira] [Comment Edited] (CALCITE-5838) derive wrong decimal divide type

2023-07-11 Thread pengfei.zhan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742225#comment-17742225 ] pengfei.zhan edited comment on CALCITE-5838 at 7/12/23 1:26 AM: -

[jira] [Commented] (CALCITE-5838) derive wrong decimal divide type

2023-07-11 Thread pengfei.zhan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742225#comment-17742225 ] pengfei.zhan commented on CALCITE-5838: --- Yes, this is a solution to the problem.

[jira] [Updated] (CALCITE-5836) Implement Rel2Sql for MERGE

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

[jira] [Commented] (CALCITE-5827) Add IS_INF and IS_NAN functions (enabled in BigQuery library)

2023-07-11 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5827?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742127#comment-17742127 ] Tanner Clary commented on CALCITE-5827: --- [~julianhyde] Sorry, just pushed commit

[jira] [Commented] (CALCITE-5828) When converting the calcite dialect, it is not determined whether the ordinal number can be used in the order by in the window function

2023-07-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742122#comment-17742122 ] Julian Hyde commented on CALCITE-5828: -- I would be surprised if {{ORDER BY }} is v

[jira] [Commented] (CALCITE-5827) Add IS_INF and IS_NAN functions (enabled in BigQuery library)

2023-07-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5827?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742121#comment-17742121 ] Julian Hyde commented on CALCITE-5827: -- Is there a test for {{CAST('NaN' AS DOUBLE

[jira] [Comment Edited] (CALCITE-5827) Add IS_INF and IS_NAN functions (enabled in BigQuery library)

2023-07-11 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5827?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742113#comment-17742113 ] Tanner Clary edited comment on CALCITE-5827 at 7/11/23 5:28 PM: -

[jira] [Commented] (CALCITE-5827) Add IS_INF and IS_NAN functions (enabled in BigQuery library)

2023-07-11 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5827?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742113#comment-17742113 ] Tanner Clary commented on CALCITE-5827: --- I think they are fixed. All the tests I'

[jira] [Updated] (CALCITE-5828) When converting the calcite dialect, it is not determined whether the ordinal number can be used in the order by in the window function

2023-07-11 Thread LiHao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5828?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LiHao updated CALCITE-5828: --- Description: *Currently, calcite does not judge whether it is in a window function when translating order

[jira] [Commented] (CALCITE-5837) After RexUtil.pullFactors method,sometimes the condition order of RexNode is not the same as before

2023-07-11 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17741893#comment-17741893 ] Alessandro Solimando commented on CALCITE-5837: --- +1 from me too, we shoul

[jira] [Commented] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

2023-07-11 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17741889#comment-17741889 ] Ulrich Kramer commented on CALCITE-5832: This is the incomplete graphviz output

[jira] [Commented] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

2023-07-11 Thread Roman Kondakov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17741881#comment-17741881 ] Roman Kondakov commented on CALCITE-5832: - Can you set this property to 'true'

[jira] [Commented] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

2023-07-11 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17741880#comment-17741880 ] Ulrich Kramer commented on CALCITE-5832: After catching the exception  {code:j

[jira] [Commented] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

2023-07-11 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17741876#comment-17741876 ] Ulrich Kramer commented on CALCITE-5832: This log statement is never reached. T