[jira] [Commented] (CALCITE-6363) Introduce a rule to derive more filters from inner join condition

2024-05-21 Thread ruanhui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17848427#comment-17848427 ] ruanhui commented on CALCITE-6363: -- Yes, recently I have been working on trying to improve this

[jira] [Commented] (CALCITE-6380) Casts from INTERVAL and STRING to DECIMAL are incorrect

2024-05-21 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17848419#comment-17848419 ] Caican Cai commented on CALCITE-6380: - [~julianhyde] As [~eveywu]  mentioned. Different systems

[jira] [Updated] (CALCITE-6311) Support PostgreSQL DATE_PART

2024-05-21 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6311: Labels: pull-request-available (was: ) > Support PostgreSQL DATE_PART >

[jira] [Commented] (CALCITE-6413) SqlValidator does not invoke TypeCoercionImpl::binaryComparisonCoercion for both NATURAL and USING join conditions

2024-05-21 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6413?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17848330#comment-17848330 ] Julian Hyde commented on CALCITE-6413: -- One small quibble. I believe the coercion logic is invoked

[jira] [Commented] (CALCITE-6414) Snowflake JDBC adapter should generate BOOLOR_AGG, BOOLAND_AGG for MAX, MIN on BOOLEAN values

2024-05-21 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17848328#comment-17848328 ] Julian Hyde commented on CALCITE-6414: -- [~jswett], I changed the summary. Let me know if the new

[jira] [Updated] (CALCITE-6414) Snowflake JDBC adapter should generate BOOLOR_AGG, BOOLAND_AGG for MAX, MIN on BOOLEAN values

2024-05-21 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6414: - Summary: Snowflake JDBC adapter should generate BOOLOR_AGG, BOOLAND_AGG for MAX, MIN on

[jira] [Updated] (CALCITE-6414) Resolve Snoflake SQL generation of BOOL_OR, BOOL_AND

2024-05-21 Thread Justin Swett (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Justin Swett updated CALCITE-6414: -- Description: The rewriteMacMInExpr is generating incorrect SQL for Snowflake. Instead of

[jira] [Updated] (CALCITE-6414) Resolve Snoflake SQL generation of BOOL_OR, BOOL_AND

2024-05-21 Thread Justin Swett (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Justin Swett updated CALCITE-6414: -- Description: The rewriteMacMInExpr is generating incorrect SQL for Snowflake. Instead of

[jira] [Updated] (CALCITE-6414) Resolve Snoflake SQL generation of BOOL_OR, BOOL_AND

2024-05-21 Thread Justin Swett (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Justin Swett updated CALCITE-6414: -- Description: The rewriteMacMInExpr is generating incorrect SQL for Snowflake. Instead of

[jira] [Created] (CALCITE-6414) Resolve Snoflake SQL generation of BOOL_OR, BOOL_AND

2024-05-21 Thread Justin Swett (Jira)
Justin Swett created CALCITE-6414: - Summary: Resolve Snoflake SQL generation of BOOL_OR, BOOL_AND Key: CALCITE-6414 URL: https://issues.apache.org/jira/browse/CALCITE-6414 Project: Calcite

[jira] [Comment Edited] (CALCITE-6363) Introduce a rule to derive more filters from inner join condition

2024-05-21 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17848232#comment-17848232 ] Caican Cai edited comment on CALCITE-6363 at 5/21/24 2:43 PM: --

[jira] [Comment Edited] (CALCITE-6363) Introduce a rule to derive more filters from inner join condition

2024-05-21 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17848232#comment-17848232 ] Caican Cai edited comment on CALCITE-6363 at 5/21/24 2:44 PM: --

[jira] [Updated] (CALCITE-6413) SqlValidator does not invoke TypeCoercionImpl::binaryComparisonCoercion for both NATURAL and USING join conditions

2024-05-21 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated CALCITE-6413: -- Summary: SqlValidator does not invoke TypeCoercionImpl::binaryComparisonCoercion

[jira] [Created] (CALCITE-6413) SqlValidator does not invoke type coercion for both NATURAL and USING join conditions

2024-05-21 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created CALCITE-6413: - Summary: SqlValidator does not invoke type coercion for both NATURAL and USING join conditions Key: CALCITE-6413 URL: https://issues.apache.org/jira/browse/CALCITE-6413

[jira] [Commented] (CALCITE-6363) Introduce a rule to derive more filters from inner join condition

2024-05-21 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17848232#comment-17848232 ] Caican Cai commented on CALCITE-6363: - [~frostruan] I think this is a very good proposal, I have

[jira] [Updated] (CALCITE-6412) SqlToRelConverter fails to convert SqlMerge AST to relational expression

2024-05-21 Thread Pavel Pereslegin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pavel Pereslegin updated CALCITE-6412: -- Affects Version/s: 1.37.0 > SqlToRelConverter fails to convert SqlMerge AST to

[jira] [Created] (CALCITE-6412) SqlToRelConverter fails to convert SqlMerge AST to relational expression

2024-05-21 Thread Pavel Pereslegin (Jira)
Pavel Pereslegin created CALCITE-6412: - Summary: SqlToRelConverter fails to convert SqlMerge AST to relational expression Key: CALCITE-6412 URL: https://issues.apache.org/jira/browse/CALCITE-6412