[jira] [Commented] (CALCITE-5566) agg can't be pushed down correctly

2023-03-09 Thread shampoo liu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698706#comment-17698706 ] shampoo liu commented on CALCITE-5566: -- [~libenchao] Yes, you're right. The graphviz file

[jira] [Updated] (CALCITE-5566) agg can't be pushed down correctly

2023-03-09 Thread shampoo liu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] shampoo liu updated CALCITE-5566: - Attachment: dump.dot > agg can't be pushed down correctly > --

[jira] [Commented] (CALCITE-5521) Remove redundant rowtype check in RelSubset#add

2023-03-09 Thread asdfgh19 (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698695#comment-17698695 ] asdfgh19 commented on CALCITE-5521: --- Hey [~zabetak] xinqiu.hu is fine! Thanks! > Remove redundant

[jira] [Commented] (CALCITE-5554) Add DAYOFWEEK and DAYOFYEAR as valid synonyms of DOW, DOY

2023-03-09 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698690#comment-17698690 ] Tanner Clary commented on CALCITE-5554: --- [~julianhyde] That sounds good to me. Please tag me for

[jira] [Commented] (CALCITE-5554) Add DAYOFWEEK and DAYOFYEAR as valid synonyms of DOW, DOY

2023-03-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698688#comment-17698688 ] Julian Hyde commented on CALCITE-5554: -- [~tanclary], You're right, {{EXTRACT}} could use a little

[jira] [Commented] (CALCITE-5413) Nested Subqueries with correlated variables are not decorrelated correctly

2023-03-09 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5413?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698665#comment-17698665 ] Benchao Li commented on CALCITE-5413: - [~jamesstarr] That would be great! > Nested Subqueries with

[jira] [Updated] (CALCITE-5572) Release Calcite 1.34.0

2023-03-09 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5572: Labels: pull-request-available (was: ) > Release Calcite 1.34.0 >

[jira] [Commented] (CALCITE-5521) Remove redundant rowtype check in RelSubset#add

2023-03-09 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698632#comment-17698632 ] Stamatis Zampetakis commented on CALCITE-5521: -- Hey [~xinqiu] how do you want your name to

[jira] [Created] (CALCITE-5572) Release Calcite 1.34.0

2023-03-09 Thread Stamatis Zampetakis (Jira)
Stamatis Zampetakis created CALCITE-5572: Summary: Release Calcite 1.34.0 Key: CALCITE-5572 URL: https://issues.apache.org/jira/browse/CALCITE-5572 Project: Calcite Issue Type: Task

[jira] [Updated] (CALCITE-5571) Remove org.jetbrains.annotations from java source code

2023-03-09 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5571: Labels: pull-request-available (was: ) > Remove org.jetbrains.annotations from java

[jira] [Created] (CALCITE-5571) Remove org.jetbrains.annotations from java source code

2023-03-09 Thread Stamatis Zampetakis (Jira)
Stamatis Zampetakis created CALCITE-5571: Summary: Remove org.jetbrains.annotations from java source code Key: CALCITE-5571 URL: https://issues.apache.org/jira/browse/CALCITE-5571 Project:

[jira] [Commented] (CALCITE-5557) Add SAFE_CAST (BigQuery compatibility)

2023-03-09 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698606#comment-17698606 ] Oliver Lee commented on CALCITE-5557: - I have been investigating the test failures:

[jira] [Commented] (CALCITE-5554) Add DAYOFWEEK and DAYOFYEAR as valid synonyms of DOW, DOY

2023-03-09 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698581#comment-17698581 ] Tanner Clary commented on CALCITE-5554: --- [~julianhyde] After thinking about it some more, I think

[jira] [Comment Edited] (CALCITE-5554) Add DAYOFWEEK and DAYOFYEAR as valid synonyms of DOW, DOY

2023-03-09 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698581#comment-17698581 ] Tanner Clary edited comment on CALCITE-5554 at 3/9/23 7:38 PM: ---

[jira] [Commented] (CALCITE-5413) Nested Subqueries with correlated variables are not decorrelated correctly

2023-03-09 Thread James Starr (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5413?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698573#comment-17698573 ] James Starr commented on CALCITE-5413: -- [~libenchao]Would you like me to try and find another

[jira] [Created] (CALCITE-5570) Support nested map type for SqlDataTypeSpec

2023-03-09 Thread Sergey Nuyanzin (Jira)
Sergey Nuyanzin created CALCITE-5570: Summary: Support nested map type for SqlDataTypeSpec Key: CALCITE-5570 URL: https://issues.apache.org/jira/browse/CALCITE-5570 Project: Calcite

[jira] [Comment Edited] (CALCITE-5557) Add SAFE_CAST (BigQuery compatibility)

2023-03-09 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698137#comment-17698137 ] Oliver Lee edited comment on CALCITE-5557 at 3/9/23 5:11 PM: - Julian, can

[jira] [Commented] (CALCITE-5548) Add support for MSSQL CONVERT function

2023-03-09 Thread Askar Bozcan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698488#comment-17698488 ] Askar Bozcan commented on CALCITE-5548: --- Requested changes have been made. Regarding tests, a

[jira] [Updated] (CALCITE-5548) Add support for MSSQL CONVERT function

2023-03-09 Thread Askar Bozcan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5548?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Askar Bozcan updated CALCITE-5548: -- Description: Add support for MSSQL CONVERT function (which is the same as CAST, with

[jira] [Commented] (CALCITE-5559) Improve RepeatUnion by discarding duplicates at TableSpool level

2023-03-09 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698388#comment-17698388 ] Ruben Q L commented on CALCITE-5559: I have created

[jira] [Updated] (CALCITE-5559) Improve RepeatUnion by discarding duplicates at TableSpool level

2023-03-09 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5559?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5559: Labels: pull-request-available (was: ) > Improve RepeatUnion by discarding duplicates

[jira] [Resolved] (CALCITE-5569) Functions with 'SPECIAL' SqlSyntax could not be created in SqlLibraryOperators

2023-03-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5569?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5569. -- Resolution: Not A Bug Functions with SPECIAL syntax don't have normal function syntax,

[jira] [Updated] (CALCITE-5569) Functions with 'SPECIAL' SqlSyntax could not be created in SqlLibraryOperators

2023-03-09 Thread Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5569?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zou updated CALCITE-5569: - Description: I want to add a function with 'SPECIAL' SqlSyntax in SqlLibraryOperators, but I get a function

[jira] [Updated] (CALCITE-5569) Functions with 'SPECIAL' SqlSyntax could not be created in SqlLibraryOperators

2023-03-09 Thread Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5569?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zou updated CALCITE-5569: - Description: I want to add a function with 'SPECIAL' SqlSyntax in SqlLibraryOperators, but I get a function

[jira] [Updated] (CALCITE-5569) Functions with 'SPECIAL' SqlSyntax could not be created in SqlLibraryOperators

2023-03-09 Thread Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5569?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zou updated CALCITE-5569: - Description: I want to add a function with 'SPECIAL' SqlSyntax in SqlLibraryOperators, but I get a function

[jira] [Created] (CALCITE-5569) Functions with 'SPECIAL' SqlSyntax could not be created in SqlLibraryOperators

2023-03-09 Thread Zou (Jira)
Zou created CALCITE-5569: Summary: Functions with 'SPECIAL' SqlSyntax could not be created in SqlLibraryOperators Key: CALCITE-5569 URL: https://issues.apache.org/jira/browse/CALCITE-5569 Project: Calcite

[jira] [Commented] (CALCITE-5568) LogicalValues causes decorrelate to fail

2023-03-09 Thread Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698234#comment-17698234 ] Zou commented on CALCITE-5568: -- [~leepb] Could you please add a test to reproduce this case? >