[jira] [Created] (CALCITE-5185) The required parentheses for WITH ITEM QUERY are missing when SqlPrettyWriter.config().withAlwaysUseParentheses(false)

2022-06-07 Thread yanjing.wang (Jira)
yanjing.wang created CALCITE-5185: - Summary: The required parentheses for WITH ITEM QUERY are missing when SqlPrettyWriter.config().withAlwaysUseParentheses(false) Key: CALCITE-5185 URL: https://issues.apache.org/

[jira] [Commented] (CALCITE-5183) Impossible condition in return type inference for SqlIntervalOperator?

2022-06-07 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551357#comment-17551357 ] Benchao Li commented on CALCITE-5183: - You can construct it via {{MULTIPLY}} instea

[jira] [Comment Edited] (CALCITE-5169) 'xx < 1 OR xx > 1' cannot be simplified to 'xx <> 1'

2022-06-07 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551352#comment-17551352 ] Chunwei Lei edited comment on CALCITE-5169 at 6/8/22 2:18 AM: ---

[jira] [Commented] (CALCITE-5169) 'xx < 1 OR xx > 1' cannot be simplified to 'xx <> 1'

2022-06-07 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551352#comment-17551352 ] Chunwei Lei commented on CALCITE-5169: -- Could you please double confirm the PR is

[jira] [Commented] (CALCITE-5179) In RelToSqlConverter, AssertionError for values with more than two items when SqlDialect#supportsAliasedValues is false

2022-06-07 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551350#comment-17551350 ] Chunwei Lei commented on CALCITE-5179: -- I have put the label "LGTM-will-merge-soon

[jira] [Commented] (CALCITE-5179) In RelToSqlConverter, AssertionError for values with more than two items when SqlDialect#supportsAliasedValues is false

2022-06-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551307#comment-17551307 ] Julian Hyde commented on CALCITE-5179: -- If the PR is good (I haven't checked), can

[jira] [Updated] (CALCITE-5179) In RelToSqlConverter, AssertionError for values with more than two items when SqlDialect#supportsAliasedValues is false

2022-06-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5179: - Fix Version/s: 1.31.0 > In RelToSqlConverter, AssertionError for values with more than two ite

[jira] [Commented] (CALCITE-5179) In RelToSqlConverter, AssertionError for values with more than two items when SqlDialect#supportsAliasedValues is false

2022-06-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551306#comment-17551306 ] Julian Hyde commented on CALCITE-5179: -- {quote} I guess a binary tree would be no

[jira] [Commented] (CALCITE-5183) Impossible condition in return type inference for SqlIntervalOperator?

2022-06-07 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551198#comment-17551198 ] Steven Talbot commented on CALCITE-5183: ^^ regardless of the ergonomics of tha

[jira] [Resolved] (CALCITE-4907) JDBC adapter cannot push down join ON TRUE (cartesian product)

2022-06-07 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-4907. -- Resolution: Fixed Fixed in [https://github.com/apache/calcite/commit/a9aea93

[jira] [Comment Edited] (CALCITE-5157) ClassCastException in checkRollUp with DOT operator

2022-06-07 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551133#comment-17551133 ] Benchao Li edited comment on CALCITE-5157 at 6/7/22 2:49 PM:

[jira] [Commented] (CALCITE-5157) ClassCastException in checkRollUp with DOT operator

2022-06-07 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551133#comment-17551133 ] Benchao Li commented on CALCITE-5157: - I'm ok with the fix. I searched in the codeb

[jira] [Commented] (CALCITE-4865) Extends Table function to support Polymorphic Table Function

2022-06-07 Thread Martijn Visser (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551123#comment-17551123 ] Martijn Visser commented on CALCITE-4865: - [~danny0405] [~julianhyde] Is there

[jira] [Commented] (CALCITE-5183) Impossible condition in return type inference for SqlIntervalOperator?

2022-06-07 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551092#comment-17551092 ] Benchao Li commented on CALCITE-5183: - {{SqlIntervalQualifier}} can be constructed

[jira] [Commented] (CALCITE-4907) JDBC adapter cannot push down join ON TRUE (cartesian product)

2022-06-07 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551083#comment-17551083 ] Stamatis Zampetakis commented on CALCITE-4907: -- I removed the JOIN ON FALS

[jira] [Updated] (CALCITE-4907) JDBC adapter cannot push down join ON TRUE (cartesian product)

2022-06-07 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-4907: - Summary: JDBC adapter cannot push down join ON TRUE (cartesian product) (was:

[jira] [Updated] (CALCITE-4907) JDBC adapter cannot push down join ON TRUE (cartesian product)

2022-06-07 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-4907: - Description: JDBC adapter (in JdbcJoinRule) cannot push down join ON TRUE (cart

[jira] [Updated] (CALCITE-5177) Query loses hint after decorrelation

2022-06-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5177: --- Labels: pull-request-available (was: ) > Query loses hint after decorrelation > --

[jira] [Commented] (CALCITE-5177) Query loses hint after decorrelation

2022-06-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17550914#comment-17550914 ] Ruben Q L commented on CALCITE-5177: Created [PR|https://github.com/apache/calcite/

[jira] [Assigned] (CALCITE-5177) Query loses hint after decorrelation

2022-06-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5177: -- Assignee: Ruben Q L > Query loses hint after decorrelation > ---