[jira] [Comment Edited] (CALCITE-6900) Support Char type cast in ClickHouse Dialect

2025-03-19 Thread Yu Xu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6900?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937013#comment-17937013 ] Yu Xu edited comment on CALCITE-6900 at 3/20/25 6:23 AM: - [~jen

[jira] [Created] (CALCITE-6901) SINGLE_VALUE rewrite to wrong sql in MySQL dialect

2025-03-19 Thread xiong duan (Jira)
xiong duan created CALCITE-6901: --- Summary: SINGLE_VALUE rewrite to wrong sql in MySQL dialect Key: CALCITE-6901 URL: https://issues.apache.org/jira/browse/CALCITE-6901 Project: Calcite Issue Ty

[jira] [Commented] (CALCITE-6900) Support Char type cast in ClickHouse Dialect

2025-03-19 Thread Yu Xu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6900?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937013#comment-17937013 ] Yu Xu commented on CALCITE-6900: [~jensen] Clickhouse support char with FixedString and

[jira] [Commented] (CALCITE-6902) IS NOT DISTINCT FROM does not implement Implementor

2025-03-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936950#comment-17936950 ] Julian Hyde commented on CALCITE-6902: -- [~nobigo] is correct that IS [NOT] DISTINC

[jira] [Created] (CALCITE-6902) IS NOT DISTINCT FROM does not implement Implementor

2025-03-19 Thread Zhen Chen (Jira)
Zhen Chen created CALCITE-6902: -- Summary: IS NOT DISTINCT FROM does not implement Implementor Key: CALCITE-6902 URL: https://issues.apache.org/jira/browse/CALCITE-6902 Project: Calcite Issue Typ

[jira] [Commented] (CALCITE-6901) SINGLE_VALUE rewrite to wrong sql in MySQL dialect

2025-03-19 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936970#comment-17936970 ] xiong duan commented on CALCITE-6901: - Fixed in [bbcde68|https://github.com/apache

[jira] [Commented] (CALCITE-6902) IS NOT DISTINCT FROM does not implement Implementor

2025-03-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936962#comment-17936962 ] Julian Hyde commented on CALCITE-6902: -- Not immediately. But you could imagine som

[jira] [Commented] (CALCITE-6902) IS NOT DISTINCT FROM does not implement Implementor

2025-03-19 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936957#comment-17936957 ] Zhen Chen commented on CALCITE-6902: [~julianhyde] Do we need implementor for IS [N

[jira] [Commented] (CALCITE-6899) Mismatch of Trait information results in a missing conversion exception

2025-03-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936953#comment-17936953 ] Julian Hyde commented on CALCITE-6899: -- [~nobigo], What would you do to fix the pr

[jira] [Comment Edited] (CALCITE-5212) Attempting to create a Decimal with scale specified but precision not specified results in Decimal with scale 0

2025-03-19 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936895#comment-17936895 ] Ian Bertolacci edited comment on CALCITE-5212 at 3/19/25 5:27 PM: ---

[jira] [Commented] (CALCITE-5212) Attempting to create a Decimal with scale specified but precision not specified results in Decimal with scale 0

2025-03-19 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936895#comment-17936895 ] Ian Bertolacci commented on CALCITE-5212: - This has popped up again. > I thin

[jira] [Comment Edited] (CALCITE-6903) CalciteSchema#getSubSchemaMap must consider implicit sub-schemas

2025-03-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936794#comment-17936794 ] Ruben Q L edited comment on CALCITE-6903 at 3/19/25 11:43 AM: ---

[jira] [Commented] (CALCITE-6900) Support Char type cast in ClickHouse Dialect

2025-03-19 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6900?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936835#comment-17936835 ] Zhen Chen commented on CALCITE-6900: It would be better to change ClickHouse to sup

[jira] [Closed] (CALCITE-6902) IS NOT DISTINCT FROM does not implement Implementor

2025-03-19 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhen Chen closed CALCITE-6902. -- Resolution: Won't Fix > IS NOT DISTINCT FROM does not implement Implementor > ---

[jira] [Commented] (CALCITE-6902) IS NOT DISTINCT FROM does not implement Implementor

2025-03-19 Thread Zhen Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936833#comment-17936833 ] Zhen Chen commented on CALCITE-6902: [~nobigo] Thanks, it works for me, I will clos

[jira] [Updated] (CALCITE-6891) Implement IntersectReorderRule

2025-03-19 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6891: Labels: pull-request-available (was: ) > Implement IntersectReorderRule > --

[jira] [Updated] (CALCITE-6901) SINGLE_VALUE rewrite to wrong sql in MySQL dialect

2025-03-19 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6901: Labels: pull-request-available (was: ) > SINGLE_VALUE rewrite to wrong sql in MySQL dial

[jira] [Updated] (CALCITE-6901) SINGLE_VALUE rewrite to wrong sql in MySQL dialect

2025-03-19 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan updated CALCITE-6901: Description: Now, the MySQL dialect rewrites the SINGLE_VALUE to: {code:java} CASE COUNT(*) WHEN

[jira] [Commented] (CALCITE-6902) IS NOT DISTINCT FROM does not implement Implementor

2025-03-19 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936797#comment-17936797 ] xiong duan commented on CALCITE-6902: - We have transformed IS DISTINCT FROM and IS

[jira] [Updated] (CALCITE-6903) CalciteSchema#getSubSchemaMap must consider implicit sub-schemas

2025-03-19 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6903: Labels: pull-request-available (was: ) > CalciteSchema#getSubSchemaMap must consider imp

[jira] [Comment Edited] (CALCITE-6903) CalciteSchema#getSubSchemaMap must consider implicit sub-schemas

2025-03-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936794#comment-17936794 ] Ruben Q L edited comment on CALCITE-6903 at 3/19/25 11:42 AM: ---

[jira] [Commented] (CALCITE-6903) CalciteSchema#getSubSchemaMap must consider implicit sub-schemas

2025-03-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936794#comment-17936794 ] Ruben Q L commented on CALCITE-6903: See more info here: https://github.com/apache

[jira] [Updated] (CALCITE-6901) SINGLE_VALUE rewrite to wrong sql in MySQL dialect

2025-03-19 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan updated CALCITE-6901: Description: Now, the MySQL dialect rewrites the SINGLE_VALUE to: {code:java} CASE COUNT(*) WHEN

[jira] [Assigned] (CALCITE-6903) CalciteSchema#getSubSchemaMap must consider implicit sub-schemas

2025-03-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-6903: -- Assignee: Ruben Q L > CalciteSchema#getSubSchemaMap must consider implicit sub-schemas > --

[jira] [Assigned] (CALCITE-6901) SINGLE_VALUE rewrite to wrong sql in MySQL dialect

2025-03-19 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan reassigned CALCITE-6901: --- Assignee: xiong duan > SINGLE_VALUE rewrite to wrong sql in MySQL dialect > --

[jira] [Created] (CALCITE-6903) CalciteSchema#getSubSchemaMap must consider implicit sub-schemas

2025-03-19 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-6903: -- Summary: CalciteSchema#getSubSchemaMap must consider implicit sub-schemas Key: CALCITE-6903 URL: https://issues.apache.org/jira/browse/CALCITE-6903 Project: Calcite