[jira] [Commented] (CALCITE-5053) Implement “show catalogs/databases/schemas" semantics

2022-03-23 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511590#comment-17511590 ] itxiangkui commented on CALCITE-5053: - It seems that "PR 218" has been implemented to the SqlParser

[jira] [Commented] (CALCITE-5044) JDBC adapter generates integer literal in ORDER BY, which some dialects wrongly interpret as a reference to a field

2022-03-23 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511586#comment-17511586 ] Xurenhe commented on CALCITE-5044: -- Hi [~julianhyde]  I have finished the review. I think we need

[jira] (CALCITE-5053) Implement “show catalogs/databases/schemas" semantics

2022-03-23 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5053 ] itxiangkui deleted comment on CALCITE-5053: - was (Author: JIRAUSER286541): I have learned that in the Asian market, many companies will use mysql more than orache. If the calcite framework

[jira] [Commented] (CALCITE-5053) Implement “show catalogs/databases/schemas" semantics

2022-03-23 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511574#comment-17511574 ] itxiangkui commented on CALCITE-5053: - I have learned that in the Asian market, many companies will

[jira] [Commented] (CALCITE-5060) SqlTypeUtil#canAssignFrom cover Map/Row/Multiset

2022-03-23 Thread Jianhui Dong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511571#comment-17511571 ] Jianhui Dong commented on CALCITE-5060: --- you can run the case that I provided in the pr, it would

[jira] [Commented] (CALCITE-5060) SqlTypeUtil#canAssignFrom cover Map/Row/Multiset

2022-03-23 Thread Jianhui Dong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511572#comment-17511572 ] Jianhui Dong commented on CALCITE-5060: --- {code:java} @Test void testMapAssignment() { final

[jira] [Commented] (CALCITE-5044) JDBC adapter generates integer literal in ORDER BY, which some dialects wrongly interpret as a reference to a field

2022-03-23 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511529#comment-17511529 ] Xurenhe commented on CALCITE-5044: -- [~julianhyde]  I'm sorry I didn't see your latest reply.:) And,

[jira] [Commented] (CALCITE-5044) JDBC adapter generates integer literal in ORDER BY, which some dialects wrongly interpret as a reference to a field

2022-03-23 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511528#comment-17511528 ] Xurenhe commented on CALCITE-5044: -- [~julianhyde]  Thanks for your reply. My first plan is removing

[jira] [Commented] (CALCITE-5044) JDBC adapter generates integer literal in ORDER BY, which some dialects wrongly interpret as a reference to a field

2022-03-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511526#comment-17511526 ] Julian Hyde commented on CALCITE-5044: -- [~wojustme], I added a commit to your changes; please

[jira] [Resolved] (CALCITE-5063) Replace golang.org/x/xerrors package with errors package in stdlib

2022-03-23 Thread Francis Chuang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang resolved CALCITE-5063. - Resolution: Fixed > Replace golang.org/x/xerrors package with errors package in stdlib

[jira] [Updated] (CALCITE-5044) JDBC adapter generates integer literal in ORDER BY, which some dialects wrongly interpret as a reference to a field

2022-03-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5044?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5044: - Description: When there is a Sort RelNode that references an integer literal, the JDBC

[jira] [Updated] (CALCITE-5044) JDBC adapter generates integer literal in ORDER BY, which some dialects wrongly interpret as a reference to a field

2022-03-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5044?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5044: - Summary: JDBC adapter generates integer literal in ORDER BY, which some dialects wrongly

[jira] [Commented] (CALCITE-5044) OrderBy constant executing RelToSql ambiguously

2022-03-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511503#comment-17511503 ] Julian Hyde commented on CALCITE-5044: -- Reviewing and testing now. There's significant

[jira] [Updated] (CALCITE-5062) Release Avatica-Go 5.1.0

2022-03-23 Thread Francis Chuang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang updated CALCITE-5062: Fix Version/s: avatica-go-5.1.0 > Release Avatica-Go 5.1.0 > >

[jira] [Created] (CALCITE-5063) Replace golang.org/x/xerrors package with errors package in stdlib

2022-03-23 Thread Francis Chuang (Jira)
Francis Chuang created CALCITE-5063: --- Summary: Replace golang.org/x/xerrors package with errors package in stdlib Key: CALCITE-5063 URL: https://issues.apache.org/jira/browse/CALCITE-5063 Project:

[jira] [Created] (CALCITE-5062) Release Avatica-Go 5.1.0

2022-03-23 Thread Francis Chuang (Jira)
Francis Chuang created CALCITE-5062: --- Summary: Release Avatica-Go 5.1.0 Key: CALCITE-5062 URL: https://issues.apache.org/jira/browse/CALCITE-5062 Project: Calcite Issue Type: Task

[jira] [Commented] (CALCITE-5051) UNION query plan prevents projection push down

2022-03-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511471#comment-17511471 ] Julian Hyde commented on CALCITE-5051: -- Thanks for confirming that CALCITE-3399 is the culprit.

[jira] [Comment Edited] (CALCITE-5051) UNION query plan prevents projection push down

2022-03-23 Thread Zachary Gramana (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511457#comment-17511457 ] Zachary Gramana edited comment on CALCITE-5051 at 3/23/22, 7:50 PM:

[jira] [Commented] (CALCITE-5051) UNION query plan prevents projection push down

2022-03-23 Thread Zachary Gramana (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511457#comment-17511457 ] Zachary Gramana commented on CALCITE-5051: -- I looked into this yesterday, and indeed

[jira] [Commented] (CALCITE-5060) SqlTypeUtil#canAssignFrom cover Map/Row/Multiset

2022-03-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511424#comment-17511424 ] Julian Hyde commented on CALCITE-5060: -- If possible, please include a couple of SQL examples in

[jira] [Commented] (CALCITE-5051) UNION query plan prevents projection push down

2022-03-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511419#comment-17511419 ] Julian Hyde commented on CALCITE-5051: -- [~jiajunbernoulli], Yes CALCITE-3399 looks very likely to

[jira] [Commented] (CALCITE-5061) Improve recursive application of the field trimming

2022-03-23 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511415#comment-17511415 ] Julian Hyde commented on CALCITE-5061: -- Unless {{RelFieldTrimmer}} is fundamentally broken it

[jira] [Commented] (CALCITE-5060) SqlTypeUtil#canAssignFrom cover Map/Row/Multiset

2022-03-23 Thread Jianhui Dong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511366#comment-17511366 ] Jianhui Dong commented on CALCITE-5060: --- this issue is similar to the CALCITE-4066, and later I

[jira] [Comment Edited] (CALCITE-5053) Implement “show catalogs/databases/schemas" semantics

2022-03-23 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511333#comment-17511333 ] Xurenhe edited comment on CALCITE-5053 at 3/23/22, 3:59 PM: *SHOW

[jira] [Commented] (CALCITE-5053) Implement “show catalogs/databases/schemas" semantics

2022-03-23 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511333#comment-17511333 ] Xurenhe commented on CALCITE-5053: -- *SHOW DATABASES* may be MySQL's behavior, which is executed for

[jira] [Commented] (CALCITE-5044) OrderBy constant executing RelToSql ambiguously

2022-03-23 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511322#comment-17511322 ] Xurenhe commented on CALCITE-5044: -- Ok, Got it. It's really closely related to *isOrderByOrdinal()*

[jira] [Comment Edited] (CALCITE-5044) OrderBy constant executing RelToSql ambiguously

2022-03-23 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511322#comment-17511322 ] Xurenhe edited comment on CALCITE-5044 at 3/23/22, 3:40 PM: [~julianhyde] 

[jira] [Commented] (CALCITE-5051) UNION query plan prevents projection push down

2022-03-23 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511306#comment-17511306 ] Thomas Rebele commented on CALCITE-5051: I think the problem here is that RelFieldTrimmer stops

[jira] [Commented] (CALCITE-5061) Improve recursive application of the field trimming

2022-03-23 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511305#comment-17511305 ] Thomas Rebele commented on CALCITE-5061: I've started on an alternative field trimmer

[jira] [Created] (CALCITE-5061) Improve recursive application of the field trimming

2022-03-23 Thread Thomas Rebele (Jira)
Thomas Rebele created CALCITE-5061: -- Summary: Improve recursive application of the field trimming Key: CALCITE-5061 URL: https://issues.apache.org/jira/browse/CALCITE-5061 Project: Calcite

[jira] [Commented] (CALCITE-5060) SqlTypeUtil#canAssignFrom cover Map/Row/Multiset

2022-03-23 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1757#comment-1757 ] Ruben Q L commented on CALCITE-5060: [~lam167] could you please add a small description in Jira

[jira] [Commented] (CALCITE-5060) SqlTypeUtil#canAssignFrom cover Map/Row/Multiset

2022-03-23 Thread Jianhui Dong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17511085#comment-17511085 ] Jianhui Dong commented on CALCITE-5060: --- PR: https://github.com/apache/calcite/pull/2751 >

[jira] [Updated] (CALCITE-5060) SqlTypeUtil#canAssignFrom cover Map/Row/Multiset

2022-03-23 Thread Jianhui Dong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5060?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jianhui Dong updated CALCITE-5060: -- Fix Version/s: 1.31.0 (was: 1.30.0) > SqlTypeUtil#canAssignFrom cover

[jira] [Updated] (CALCITE-5060) SqlTypeUtil#canAssignFrom cover Map/Row/Multiset

2022-03-23 Thread Jianhui Dong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5060?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jianhui Dong updated CALCITE-5060: -- Summary: SqlTypeUtil#canAssignFrom cover Map/Row/Multiset (was:

[jira] [Created] (CALCITE-5060) SqlTypeUtil#convertTypeToSpec cover Map

2022-03-23 Thread Jianhui Dong (Jira)
Jianhui Dong created CALCITE-5060: - Summary: SqlTypeUtil#convertTypeToSpec cover Map Key: CALCITE-5060 URL: https://issues.apache.org/jira/browse/CALCITE-5060 Project: Calcite Issue Type: