[jira] [Updated] (CALCITE-4323) If a view definition has an ORDER BY clause, retain the sort if the view is used in a query at top level

2022-02-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4323: - Description: If you have a view that has an ORDER BY clause, and try to execute a query on tha

[jira] [Updated] (CALCITE-4323) If a view definition has an ORDER BY clause, retain the sort if the view is used in a query at top level

2022-02-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4323: - Description: If you have a view that has an ORDER BY clause, and try to execute a query on tha

[jira] [Updated] (CALCITE-4323) If a view definition has an ORDER BY clause, retain the sort if the view is used in a query at top level

2022-02-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4323: - Summary: If a view definition has an ORDER BY clause, retain the sort if the view is used in a

[jira] [Resolved] (CALCITE-4323) View with ORDER BY throws AssertionError during view expansion

2022-02-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-4323. -- Resolution: Fixed Fixed in [de86d4f8|https://github.com/apache/calcite/commit/de86d4f8dc2d70

[jira] [Commented] (CALCITE-4999) `least restrictive` type inference does not work when one operand is scalar and another is row with one field

2022-02-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17493478#comment-17493478 ] Julian Hyde commented on CALCITE-4999: -- Thanks for checking, [~rubenql]. That's as

[jira] [Commented] (CALCITE-4999) `least restrictive` type inference does not work when one operand is scalar and another is row with one field

2022-02-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17493206#comment-17493206 ] Ruben Q L commented on CALCITE-4999: [~dmsysolyatin] you can find some draft versio

[jira] [Comment Edited] (CALCITE-4993) Simplify EQUALS or NOT-EQUALS with other number comparison

2022-02-16 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17493193#comment-17493193 ] xiong duan edited comment on CALCITE-4993 at 2/16/22, 11:59 AM: -

[jira] [Commented] (CALCITE-4993) Simplify EQUALS or NOT-EQUALS with other number comparison

2022-02-16 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17493193#comment-17493193 ] xiong duan commented on CALCITE-4993: - If we just test the "x = 5 AND x > 6 AND x <

[jira] [Updated] (CALCITE-4912) Confusing javadoc of RexSimplify.simplify

2022-02-16 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan updated CALCITE-4912: Labels: pull-request-available (was: ) > Confusing javadoc of RexSimplify.simplify > ---

[jira] [Assigned] (CALCITE-4912) Confusing javadoc of RexSimplify.simplify

2022-02-16 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan reassigned CALCITE-4912: --- Assignee: xiong duan > Confusing javadoc of RexSimplify.simplify > ---

[jira] [Commented] (CALCITE-4912) Confusing javadoc of RexSimplify.simplify

2022-02-16 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17493140#comment-17493140 ] xiong duan commented on CALCITE-4912: - Looks like the PR link is a auto job but not

[jira] [Commented] (CALCITE-4912) Confusing javadoc of RexSimplify.simplify

2022-02-16 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17493105#comment-17493105 ] Xurenhe commented on CALCITE-4912: -- Hi [~nobigo]  Could you put the PR's url to help m

[jira] [Commented] (CALCITE-4912) Confusing javadoc of RexSimplify.simplify

2022-02-16 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17493067#comment-17493067 ] xiong duan commented on CALCITE-4912: - The PR is ready for review. Welcome, everyon