[jira] [Created] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-02-22 Thread jackylau (Jira)
jackylau created CALCITE-5539: - Summary: GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat Key: CALCITE-5539 URL: https://issues.apache.org/jira/browse/

[jira] [Updated] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-02-22 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5539: -- Description: i found it  is not correct. and  > GREATEST/LEAST/COALESCE OperandTypes is not correct,

[jira] [Updated] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-02-22 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5539: -- Description: i found it  is not correct. and  SAME_VARIADIC is developped in 2014, which may not fix

[jira] [Updated] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-02-22 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5539: -- Attachment: image-2023-02-22-18-59-50-951.png > GREATEST/LEAST/COALESCE OperandTypes is not correct,

[jira] [Updated] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-02-22 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5539: -- Description: i found it  is not correct. and  SAME_VARIADIC is developped in 2014, which may not fixe

[jira] [Commented] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-02-22 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692130#comment-17692130 ] Sergey Nuyanzin commented on CALCITE-5539: -- Thanks for the issue however may

[jira] [Updated] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-02-22 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5539: -- Attachment: image-2023-02-22-19-24-46-574.png > GREATEST/LEAST/COALESCE OperandTypes is not correct,

[jira] [Commented] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-02-22 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692137#comment-17692137 ] jackylau commented on CALCITE-5539: --- so does greatest/least [~Sergey Nuyanzin] , what

[jira] [Commented] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-02-22 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692139#comment-17692139 ] Sergey Nuyanzin commented on CALCITE-5539: -- it's much better to provide links

[jira] [Commented] (CALCITE-5537) Slow test case failures in LatticeSuggesterTest

2023-02-22 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692173#comment-17692173 ] Stamatis Zampetakis commented on CALCITE-5537: -- Thanks for reporting this

[jira] [Commented] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-02-22 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692181#comment-17692181 ] jackylau commented on CALCITE-5539: --- thanks for your response [~Sergey Nuyanzin] , do

[jira] [Commented] (CALCITE-5503) CheapestPlanReplacer should reuse repeated nodes in a DAG plan

2023-02-22 Thread Moritz Mack (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692185#comment-17692185 ] Moritz Mack commented on CALCITE-5503: -- (y) Thanks [~julianhyde] and [~libenchao] 

[jira] [Updated] (CALCITE-5537) Slow test case failures in LatticeSuggesterTest

2023-02-22 Thread peng wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] peng wang updated CALCITE-5537: --- Attachment: testFoodMartAllEvolve > Slow test case failures in LatticeSuggesterTest > -

[jira] [Commented] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-02-22 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692190#comment-17692190 ] Sergey Nuyanzin commented on CALCITE-5539: -- {quote} do you think it should fix

[jira] [Comment Edited] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-02-22 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692190#comment-17692190 ] Sergey Nuyanzin edited comment on CALCITE-5539 at 2/22/23 1:05 PM: --

[jira] [Updated] (CALCITE-5537) Slow test case failures in LatticeSuggesterTest

2023-02-22 Thread peng wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] peng wang updated CALCITE-5537: --- Description: LatticeSuggesterTest#testFoodMartAll LatticeSuggesterTest#testFoodMartAllEvolve May

[jira] [Commented] (CALCITE-5537) Slow test case failures in LatticeSuggesterTest

2023-02-22 Thread peng wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692193#comment-17692193 ] peng wang commented on CALCITE-5537: [~zabetak] I edited the description and attach

[jira] [Comment Edited] (CALCITE-5537) Slow test case failures in LatticeSuggesterTest

2023-02-22 Thread peng wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692193#comment-17692193 ] peng wang edited comment on CALCITE-5537 at 2/22/23 1:22 PM:

[jira] [Commented] (CALCITE-5537) Slow test case failures in LatticeSuggesterTest

2023-02-22 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692194#comment-17692194 ] Stamatis Zampetakis commented on CALCITE-5537: -- Is the actual output wrong

[jira] [Updated] (CALCITE-5538) TimestampString rejects timestamp literals that end with 0 after the period

2023-02-22 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-5538: - Summary: TimestampString rejects timestamp literals that end with 0 after the period (was: SQL

[jira] [Commented] (CALCITE-5538) TimestampString rejects timestamp literals that end with 0 after the period

2023-02-22 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692319#comment-17692319 ] Mihai Budiu commented on CALCITE-5538: -- I have tried to create a test case, and I

[jira] [Commented] (CALCITE-5538) TimestampString rejects timestamp literals that end with 0 after the period

2023-02-22 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692328#comment-17692328 ] Julian Hyde commented on CALCITE-5538: -- As I said, the parser has lots of unit tes

[jira] [Assigned] (CALCITE-5446) Support TIMESTAMP WITH LOCAL TIME ZONE type in JDBC driver

2023-02-22 Thread Will Noble (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Will Noble reassigned CALCITE-5446: --- Assignee: Will Noble (was: Oliver Lee) > Support TIMESTAMP WITH LOCAL TIME ZONE type in J

[jira] [Commented] (CALCITE-5532) CompositeOperandTypeChecker should check operands without type coercion first

2023-02-22 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692347#comment-17692347 ] Julian Hyde commented on CALCITE-5532: -- Thank you for the explanation. Would it b

[jira] [Updated] (CALCITE-5537) Slow test case failures in LatticeSuggesterTest

2023-02-22 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5537: - Description: LatticeSuggesterTest#testFoodMartAll LatticeSuggesterTest#testFoodMartAllEvolve

[jira] [Commented] (CALCITE-5537) Slow test case failures in LatticeSuggesterTest

2023-02-22 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692363#comment-17692363 ] Julian Hyde commented on CALCITE-5537: -- Sorry I broke this in CALCITE-3870. > Slo

[jira] [Comment Edited] (CALCITE-5537) Slow test case failures in LatticeSuggesterTest

2023-02-22 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17691557#comment-17691557 ] Julian Hyde edited comment on CALCITE-5537 at 2/22/23 8:42 PM: --

[jira] [Commented] (CALCITE-5527) RelOptRulesTest testAnyInProjectNullable optimized query not equivalent to the original one

2023-02-22 Thread Pinhan Zhao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692433#comment-17692433 ] Pinhan Zhao commented on CALCITE-5527: -- [~libenchao] Thank you for the clarificati

[jira] [Closed] (CALCITE-5527) RelOptRulesTest testAnyInProjectNullable optimized query not equivalent to the original one

2023-02-22 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5527?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li closed CALCITE-5527. --- Resolution: Not A Problem [~pinhan] Thanks for confirming, I'm closing this as "Not A Problem". >