[jira] [Updated] (CALCITE-5138) Join on condition generates wrong plan when the condition is sub-query

2022-05-09 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5138: Labels: pull-request-available (was: ) > Join on condition generates wrong plan when the

[jira] [Commented] (CALCITE-5143) Planner#parse fails to parse a function when HOUR is passed as an argument

2022-05-09 Thread Mitsunori Komatsu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17534132#comment-17534132 ] Mitsunori Komatsu commented on CALCITE-5143: [~jiajunbernoulli] I've not th

[jira] [Updated] (CALCITE-5145) AssertionError: "Conversion to relational algebra failed to preserve datatypes" when use derived column in Grouping Sets

2022-05-09 Thread Yingyu Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yingyu Wang updated CALCITE-5145: - Description: Adding following test in SqlToRelConverterTest.java can reproduce the problem Not

[jira] [Updated] (CALCITE-5145) AssertionError: "Conversion to relational algebra failed to preserve datatypes" when use derived column in Grouping Sets

2022-05-09 Thread Yingyu Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yingyu Wang updated CALCITE-5145: - Description: Adding following test in SqlToRelConverterTest.java can reproduce the problem Not

[jira] [Updated] (CALCITE-3890) Derive IS NOT NULL filter from inner join

2022-05-09 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-3890: - Summary: Derive IS NOT NULL filter from inner join (was: Infer IS NOT NULL predicate from join

[jira] [Commented] (CALCITE-3890) Infer IS NOT NULL predicate from join

2022-05-09 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17534097#comment-17534097 ] Chunwei Lei commented on CALCITE-3890: -- I opened a PR for this feature: [https://g

[jira] [Assigned] (CALCITE-3890) Infer IS NOT NULL predicate from join

2022-05-09 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-3890: Assignee: Chunwei Lei (was: Vineet Garg) > Infer IS NOT NULL predicate from join >

[jira] [Updated] (CALCITE-5145) AssertionError: "Conversion to relational algebra failed to preserve datatypes" when use derived column ing Grouping Sets

2022-05-09 Thread Yingyu Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yingyu Wang updated CALCITE-5145: - Description: Adding following test in SqlToRelConverterTest.java can reproduce the problem {cod

[jira] [Updated] (CALCITE-5145) AssertionError: "Conversion to relational algebra failed to preserve datatypes" when use derived column in Grouping Sets

2022-05-09 Thread Yingyu Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yingyu Wang updated CALCITE-5145: - Summary: AssertionError: "Conversion to relational algebra failed to preserve datatypes" when u

[jira] [Updated] (CALCITE-5145) AssertionError: "Conversion to relational algebra failed to preserve datatypes" when use derived column ing Grouping Sets

2022-05-09 Thread Yingyu Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yingyu Wang updated CALCITE-5145: - Description: Adding following test in SqlToRelConverterTest.java can reproduce the problem {cod

[jira] [Created] (CALCITE-5145) AssertionError: "Conversion to relational algebra failed to preserve datatypes" when use derived column ing Grouping Sets

2022-05-09 Thread Yingyu Wang (Jira)
Yingyu Wang created CALCITE-5145: Summary: AssertionError: "Conversion to relational algebra failed to preserve datatypes" when use derived column ing Grouping Sets Key: CALCITE-5145 URL: https://issues.apache.org

[jira] [Commented] (CALCITE-5131) Remove redundant type cast

2022-05-09 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17534078#comment-17534078 ] Chunwei Lei commented on CALCITE-5131: -- Thank you for your trust. I will merge the

[jira] [Commented] (CALCITE-5135) Planner#parse can't parse DAY() function

2022-05-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533975#comment-17533975 ] Julian Hyde commented on CALCITE-5135: -- It seems that CALCITE-1606 (which added da

[jira] [Commented] (CALCITE-5131) Remove redundant type cast

2022-05-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533973#comment-17533973 ] Julian Hyde commented on CALCITE-5131: -- [~Chunwei Lei] I haven't reviewed your PR,

[jira] [Commented] (CALCITE-5143) Planner#parse fails to parse a function when HOUR is passed as an argument

2022-05-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533971#comment-17533971 ] Julian Hyde commented on CALCITE-5143: -- I changed the component to "babel". This s

[jira] [Updated] (CALCITE-5143) Planner#parse fails to parse a function when HOUR is passed as an argument

2022-05-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5143: - Component/s: babel (was: core) > Planner#parse fails to parse a function w

[jira] [Commented] (CALCITE-5141) Incomplete implicit type conversion for insert values

2022-05-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533967#comment-17533967 ] Julian Hyde commented on CALCITE-5141: -- Thanks, that's clearer. The fix should inc

[jira] [Commented] (CALCITE-5144) table alias is lost by SqlToRelConverter

2022-05-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533959#comment-17533959 ] Julian Hyde commented on CALCITE-5144: -- I don’t think this is a bug. The {{RelNode

[jira] [Commented] (CALCITE-5140) The Github CI failed in Linux (OpenJ9 8)

2022-05-09 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533848#comment-17533848 ] Benchao Li commented on CALCITE-5140: - [~nobigo] No, this not works for us, this fi

[jira] [Comment Edited] (CALCITE-5143) Planner#parse fails to parse a function when HOUR is passed as an argument

2022-05-09 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533802#comment-17533802 ] Jiajun Xie edited comment on CALCITE-5143 at 5/9/22 1:22 PM:

[jira] [Comment Edited] (CALCITE-5143) Planner#parse fails to parse a function when HOUR is passed as an argument

2022-05-09 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533802#comment-17533802 ] Jiajun Xie edited comment on CALCITE-5143 at 5/9/22 1:21 PM:

[jira] [Comment Edited] (CALCITE-5143) Planner#parse fails to parse a function when HOUR is passed as an argument

2022-05-09 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533802#comment-17533802 ] Jiajun Xie edited comment on CALCITE-5143 at 5/9/22 1:20 PM:

[jira] [Commented] (CALCITE-5143) Planner#parse fails to parse a function when HOUR is passed as an argument

2022-05-09 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533802#comment-17533802 ] Jiajun Xie commented on CALCITE-5143: - [~komamitsu] Does `S` mean that `{color:#172

[jira] [Created] (CALCITE-5144) table alias is lost by SqlToRelConverter

2022-05-09 Thread xuyang (Jira)
xuyang created CALCITE-5144: --- Summary: table alias is lost by SqlToRelConverter Key: CALCITE-5144 URL: https://issues.apache.org/jira/browse/CALCITE-5144 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-5143) Planner#parse fails to parse a function when HOUR is passed as an argument

2022-05-09 Thread Mitsunori Komatsu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533725#comment-17533725 ] Mitsunori Komatsu commented on CALCITE-5143: [~jiajunbernoulli] Wow, cool.

[jira] [Comment Edited] (CALCITE-5143) Planner#parse fails to parse a function when HOUR is passed as an argument

2022-05-09 Thread Mitsunori Komatsu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533725#comment-17533725 ] Mitsunori Komatsu edited comment on CALCITE-5143 at 5/9/22 9:47 AM: -