[jira] [Commented] (CALCITE-1593) JoinAssociateRule throws Exception in thread "main" java.lang.AssertionError: Internal error: Error while applying...

2023-06-28 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738048#comment-17738048 ] Ulrich Kramer commented on CALCITE-1593: We fixed a similar problem by changing

[jira] [Created] (CALCITE-5805) SelectNamespace throws NullPointerException while validating MERGE statement

2023-06-28 Thread Jiajun Xie (Jira)
Jiajun Xie created CALCITE-5805: --- Summary: SelectNamespace throws NullPointerException while validating MERGE statement Key: CALCITE-5805 URL: https://issues.apache.org/jira/browse/CALCITE-5805 Project:

[jira] [Updated] (CALCITE-5805) SqlValidatorImpl throws AssertionError while validating MERGE statement

2023-06-28 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5805: Summary: SqlValidatorImpl throws AssertionError while validating MERGE statement (was: SelectNam

[jira] [Updated] (CALCITE-5805) SqlValidatorImpl throws AssertionError while validating MERGE statement

2023-06-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5805: Labels: pull-request-available (was: ) > SqlValidatorImpl throws AssertionError while va

[jira] [Updated] (CALCITE-5805) SqlValidatorImpl throws AssertionError while validating MERGE statement

2023-06-28 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5805: Description: For the unit test. {code:java} final String sql = "merge into empnullables e " +

[jira] [Updated] (CALCITE-5805) SqlValidatorImpl throws AssertionError while validating MERGE statement

2023-06-28 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5805: Description: For the unit test. {code:java} final String sql = "merge into empnullables e " +

[jira] [Updated] (CALCITE-5681) Support authorization via GRANT and REVOKE DDL commands

2023-06-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5681?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5681: Labels: pull-request-available (was: ) > Support authorization via GRANT and REVOKE DDL

[jira] [Commented] (CALCITE-5805) SqlValidatorImpl throws AssertionError while validating MERGE statement

2023-06-28 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738078#comment-17738078 ] Jiajun Xie commented on CALCITE-5805: - `select * from emp where deptno is null` is

[jira] [Commented] (CALCITE-5681) Support authorization via GRANT and REVOKE DDL commands

2023-06-28 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738088#comment-17738088 ] hongyu guo commented on CALCITE-5681: - Hi, [~julianhyde] I have submitted a PR and

[jira] [Resolved] (CALCITE-5757) Incorrect return type for BigQuery TRUNC functions

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5757. Fix Version/s: 1.35.0 Resolution: Fixed > Incorrect return type for BigQuery TRUNC functio

[jira] [Reopened] (CALCITE-5771) Apply two different NULL semantics for CONCAT function(enabled in MySQL, Postgresql, BigQuery and MSSQL)

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reopened CALCITE-5771: > Apply two different NULL semantics for CONCAT function(enabled in MySQL, > Postgresql, BigQuery an

[jira] [Reopened] (CALCITE-5757) Incorrect return type for BigQuery TRUNC functions

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reopened CALCITE-5757: > Incorrect return type for BigQuery TRUNC functions > --

[jira] [Reopened] (CALCITE-4679) Search/sarg simplification leaves is not null(literal) unsimplified

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reopened CALCITE-4679: > Search/sarg simplification leaves is not null(literal) unsimplified > -

[jira] [Resolved] (CALCITE-5771) Apply two different NULL semantics for CONCAT function(enabled in MySQL, Postgresql, BigQuery and MSSQL)

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5771. Fix Version/s: 1.35.0 Resolution: Fixed > Apply two different NULL semantics for CONCAT fu

[jira] [Resolved] (CALCITE-4679) Search/sarg simplification leaves is not null(literal) unsimplified

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-4679. Resolution: Fixed > Search/sarg simplification leaves is not null(literal) unsimplified > ---

[jira] [Updated] (CALCITE-5803) Migrate Avatica to Gradle 8.0.0

2023-06-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5803: Labels: pull-request-available (was: ) > Migrate Avatica to Gradle 8.0.0 > -

[jira] [Updated] (CALCITE-5803) Migrate Avatica to Gradle 8.1.1

2023-06-28 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Richárd Antal updated CALCITE-5803: --- Summary: Migrate Avatica to Gradle 8.1.1 (was: Migrate Avatica to Gradle 8.0.0) > Migrate

[jira] [Assigned] (CALCITE-5803) Migrate Avatica to Gradle 8.1.1

2023-06-28 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Richárd Antal reassigned CALCITE-5803: -- Assignee: Richárd Antal > Migrate Avatica to Gradle 8.1.1 >

[jira] [Updated] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join removal by using the foreign-unique constraints

2023-06-28 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5756: -- Fix Version/s: (was: 1.35.0) > Expand ProjectJoinRemoveRule to support in

[jira] [Commented] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join removal by using the foreign-unique constraints

2023-06-28 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738176#comment-17738176 ] Alessandro Solimando commented on CALCITE-5756: --- I have removed the fixVe

[jira] [Resolved] (CALCITE-5764) Puffin, an Awk for Java

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5764. -- Resolution: Fixed Fixed in [267326d1|https://github.com/apache/calcite/commit/267326d15e347d

[jira] [Resolved] (CALCITE-5706) Add class PairList

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5706?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5706. -- Fix Version/s: 1.35.0 Resolution: Fixed Fixed in [4219c993|https://github.com/apache/

[jira] [Resolved] (CALCITE-5765) Add LintTest, to apply custom lint rules to source code

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5765. -- Resolution: Fixed Fixed in [c0e6ba26|https://github.com/apache/calcite/commit/c0e6ba264b3e52

[jira] [Resolved] (CALCITE-5762) Create class TestUnsafe, that contains unsafe methods used by tests

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5762. -- Resolution: Fixed Fixed in [644a3f07|https://github.com/apache/calcite/commit/644a3f0727038e

[jira] [Updated] (CALCITE-5737) Support JDK 20

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5737?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5737: - Fix Version/s: (was: 1.35.0) > Support JDK 20 > -- > > Key: CAL

[jira] [Commented] (CALCITE-5737) Support JDK 20

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738257#comment-17738257 ] Julian Hyde commented on CALCITE-5737: -- I removed 'fixVersion = 1.35.0'. It's too

[jira] [Updated] (CALCITE-4987) JDBC adapter generates incorrect query when ORDER BY alias collides with field in SELECT ITEM

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4987?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4987: - Fix Version/s: (was: 1.35.0) > JDBC adapter generates incorrect query when ORDER BY alias c

[jira] [Commented] (CALCITE-4987) JDBC adapter generates incorrect query when ORDER BY alias collides with field in SELECT ITEM

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738261#comment-17738261 ] Julian Hyde commented on CALCITE-4987: -- [~yanjing.wang], I have removed 'fixVersio

[jira] [Commented] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738262#comment-17738262 ] Julian Hyde commented on CALCITE-5708: -- [~Runking] and [~zstan], This is marked 'f

[jira] [Updated] (CALCITE-5687) lazy get scheme

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5687?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5687: - Fix Version/s: (was: 1.35.0) > lazy get scheme > --- > > Key: C

[jira] [Commented] (CALCITE-5687) lazy get scheme

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738264#comment-17738264 ] Julian Hyde commented on CALCITE-5687: -- I removed 'fixVersion = 1.35.0'. Even thou

[jira] [Updated] (CALCITE-5615) Run SQLLogicTests using Calcite

2023-06-28 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-5615: - Fix Version/s: 1.35.0 > Run SQLLogicTests using Calcite > --- > >

[jira] [Resolved] (CALCITE-5747) Conflicting FLOOR return type between Calcite and BigQuery

2023-06-28 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary resolved CALCITE-5747. --- Resolution: Fixed Merged via [08b94e|https://github.com/apache/calcite/commit/08b94e33ec96

[jira] [Commented] (CALCITE-5681) Support authorization via GRANT and REVOKE DDL commands

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738267#comment-17738267 ] Julian Hyde commented on CALCITE-5681: -- What is the equivalent syntax in Postgres?

[jira] [Resolved] (CALCITE-5805) SqlValidatorImpl throws AssertionError while validating MERGE statement

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5805. -- Fix Version/s: 1.35.0 Resolution: Duplicate This is a duplicate of CALCITE-985. We nev

[jira] [Comment Edited] (CALCITE-5805) SqlValidatorImpl throws AssertionError while validating MERGE statement

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738270#comment-17738270 ] Julian Hyde edited comment on CALCITE-5805 at 6/28/23 7:47 PM: --

[jira] [Updated] (CALCITE-5279) Firebolt does not support BETWEEN ASYMMETRIC

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5279?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5279: - Fix Version/s: (was: 1.35.0) > Firebolt does not support BETWEEN ASYMMETRIC > -

[jira] [Commented] (CALCITE-5279) Firebolt does not support BETWEEN ASYMMETRIC

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738277#comment-17738277 ] Julian Hyde commented on CALCITE-5279: -- I have removed 'fixVersion = 1.35.0' becau

[jira] [Updated] (CALCITE-5686) Generalize return types of the linq4j expression shuttle

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5686: - Fix Version/s: (was: 1.35.0) > Generalize return types of the linq4j expression shuttle > -

[jira] [Comment Edited] (CALCITE-5686) Generalize return types of the linq4j expression shuttle

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738278#comment-17738278 ] Julian Hyde edited comment on CALCITE-5686 at 6/28/23 8:03 PM: --

[jira] [Commented] (CALCITE-5686) Generalize return types of the linq4j expression shuttle

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738278#comment-17738278 ] Julian Hyde commented on CALCITE-5686: -- I removed 'fixVersion = 1.35' because ther

[jira] [Commented] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738285#comment-17738285 ] Ruben Q L commented on CALCITE-5732: [~viggoc] since this is not a regression (it s

[jira] [Updated] (CALCITE-5686) Generalize return types of the linq4j expression shuttle

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5686: --- Priority: Minor (was: Major) > Generalize return types of the linq4j expression shuttle >

[jira] [Commented] (CALCITE-5686) Generalize return types of the linq4j expression shuttle

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738282#comment-17738282 ] Ruben Q L commented on CALCITE-5686: Thanks [~julianhyde] for checking this. I know

[jira] [Updated] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5732: --- Fix Version/s: (was: 1.35.0) > EnumerableHashJoin and EnumerableMergeJoin on composite key retu

[jira] [Updated] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5539: --- Fix Version/s: (was: 1.35.0) > GREATEST/LEAST/COALESCE OperandTypes is not correct, which shoul

[jira] [Commented] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738288#comment-17738288 ] Ruben Q L commented on CALCITE-5539: [~jackylau] if I understand correctly, the pro

[jira] [Commented] (CALCITE-5715) Prune old nodes after projection merging in ProjectMergeRule

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738289#comment-17738289 ] Ruben Q L commented on CALCITE-5715: [~libenchao] what's the status on this one? Gi

[jira] [Commented] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738290#comment-17738290 ] Ruben Q L commented on CALCITE-5731: [~jackylau] I'm removing the "fixVersion=1.35"

[jira] [Updated] (CALCITE-5731) Cast to row type should throw exception when contains null/not null constraint

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5731: --- Summary: Cast to row type should throw exception when contains null/not null constraint (was: cast

[jira] [Updated] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-06-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5731: --- Fix Version/s: (was: 1.35.0) > cast to row type should throw exception when contains null/not n

[jira] [Created] (CALCITE-5806) add a String data type

2023-06-28 Thread Jira
Guillaume Massé created CALCITE-5806: Summary: add a String data type Key: CALCITE-5806 URL: https://issues.apache.org/jira/browse/CALCITE-5806 Project: Calcite Issue Type: Improvement

[jira] [Created] (CALCITE-5807) implement substring_index in Apache Spark Library

2023-06-28 Thread Jira
Guillaume Massé created CALCITE-5807: Summary: implement substring_index in Apache Spark Library Key: CALCITE-5807 URL: https://issues.apache.org/jira/browse/CALCITE-5807 Project: Calcite

[jira] [Commented] (CALCITE-5807) implement substring_index in Apache Spark Library

2023-06-28 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738320#comment-17738320 ] Tanner Clary commented on CALCITE-5807: --- I'm not positive but I would imagine som

[jira] [Created] (CALCITE-5808) Rel-to-Sql conversion should better support grouping or sorting by references or ordinals

2023-06-28 Thread Will Noble (Jira)
Will Noble created CALCITE-5808: --- Summary: Rel-to-Sql conversion should better support grouping or sorting by references or ordinals Key: CALCITE-5808 URL: https://issues.apache.org/jira/browse/CALCITE-5808

[jira] [Updated] (CALCITE-5808) Rel-to-Sql conversion should better support grouping or sorting by references or ordinals

2023-06-28 Thread Will Noble (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Will Noble updated CALCITE-5808: Description: While exploring solutions to CALCITE-5724 I produced [this draft commit|https://git

[jira] [Created] (CALCITE-5809) enable to_date and to_timestamp in Apache Spark Library

2023-06-28 Thread Jira
Guillaume Massé created CALCITE-5809: Summary: enable to_date and to_timestamp in Apache Spark Library Key: CALCITE-5809 URL: https://issues.apache.org/jira/browse/CALCITE-5809 Project: Calcite

[jira] [Commented] (CALCITE-5809) enable to_date and to_timestamp in Apache Spark Library

2023-06-28 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738324#comment-17738324 ] Guillaume Massé commented on CALCITE-5809: -- It looks like there is more: spli

[jira] [Commented] (CALCITE-5747) Conflicting FLOOR return type between Calcite and BigQuery

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5747?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738325#comment-17738325 ] Julian Hyde commented on CALCITE-5747: -- [~tanclary], Can you also set fixVersion t

[jira] [Comment Edited] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join removal by using the foreign-unique constraints

2023-06-28 Thread winds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17736942#comment-17736942 ] winds edited comment on CALCITE-5756 at 6/28/23 11:17 PM: -- [~j

[jira] [Comment Edited] (CALCITE-5756) Expand ProjectJoinRemoveRule to support inner join removal by using the foreign-unique constraints

2023-06-28 Thread winds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17736942#comment-17736942 ] winds edited comment on CALCITE-5756 at 6/28/23 11:17 PM: -- [~j

[jira] [Updated] (CALCITE-5775) Null direction emulation broken for complex expressions on some dialects

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5775: - Labels: (was: pull-request-available) > Null direction emulation broken for complex expressio

[jira] [Commented] (CALCITE-5747) Conflicting FLOOR return type between Calcite and BigQuery

2023-06-28 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5747?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738326#comment-17738326 ] Tanner Clary commented on CALCITE-5747: --- [~julianhyde] Done, thanks for letting m

[jira] [Updated] (CALCITE-5747) Conflicting FLOOR return type between Calcite and BigQuery

2023-06-28 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5747: -- Fix Version/s: 1.35.0 > Conflicting FLOOR return type between Calcite and BigQuery >

[jira] [Resolved] (CALCITE-5793) Use NULLS FIRST / LAST when unparsing in BigQuery

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5793. -- Fix Version/s: 1.35.0 Resolution: Fixed Fixed in [7bb4f419|https://github.com/apache/

[jira] [Resolved] (CALCITE-5786) QuidemTest and DiffRepository have incremental build issues

2023-06-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5786. -- Fix Version/s: 1.35.0 Resolution: Fixed Fixed in [d4276bcc|https://github.com/apache/

[jira] [Updated] (CALCITE-5808) Rel-to-Sql conversion should better support grouping or sorting by references or ordinals

2023-06-28 Thread Will Noble (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Will Noble updated CALCITE-5808: Description: While exploring solutions to CALCITE-5724 I produced [this draft commit|https://git

[jira] [Commented] (CALCITE-5715) Prune old nodes after projection merging in ProjectMergeRule

2023-06-28 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738339#comment-17738339 ] Benchao Li commented on CALCITE-5715: - [~rubenql] Thanks, the [PR|https://github.co

[jira] [Commented] (CALCITE-5805) SqlValidatorImpl throws AssertionError while validating MERGE statement

2023-06-28 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738341#comment-17738341 ] Jiajun Xie commented on CALCITE-5805: - Thanks for your information. It seems that

[jira] [Assigned] (CALCITE-985) Validate MERGE

2023-06-28 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-985: -- Assignee: Jiajun Xie > Validate MERGE > -- > > Key: CALCITE-985 >

[jira] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-28 Thread Jacky Lau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772 ] Jacky Lau deleted comment on CALCITE-5772: was (Author: jackylau): hi [~julianhyde] do you have time to help review? > Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect >

[jira] [Commented] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-28 Thread Jacky Lau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738345#comment-17738345 ] Jacky Lau commented on CALCITE-5772: hi [~julianhyde] sorry to bother you, do you h

[jira] [Commented] (CALCITE-5809) enable to_date and to_timestamp in Apache Spark Library

2023-06-28 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738350#comment-17738350 ] Guillaume Massé commented on CALCITE-5809: -- Here is a list of functions that a

[jira] [Comment Edited] (CALCITE-5809) enable to_date and to_timestamp in Apache Spark Library

2023-06-28 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738350#comment-17738350 ] Guillaume Massé edited comment on CALCITE-5809 at 6/29/23 3:18 AM: --

[jira] [Comment Edited] (CALCITE-5809) enable to_date and to_timestamp in Apache Spark Library

2023-06-28 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738350#comment-17738350 ] Guillaume Massé edited comment on CALCITE-5809 at 6/29/23 3:18 AM: --

[jira] [Comment Edited] (CALCITE-5809) enable to_date and to_timestamp in Apache Spark Library

2023-06-28 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738350#comment-17738350 ] Guillaume Massé edited comment on CALCITE-5809 at 6/29/23 3:18 AM: --

[jira] [Commented] (CALCITE-5681) Support authorization via GRANT and REVOKE DDL commands

2023-06-28 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738352#comment-17738352 ] hongyu guo commented on CALCITE-5681: - [postgres grant sql|https://www.postgresql.o

[jira] [Comment Edited] (CALCITE-5681) Support authorization via GRANT and REVOKE DDL commands

2023-06-28 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738352#comment-17738352 ] hongyu guo edited comment on CALCITE-5681 at 6/29/23 3:30 AM: ---

[jira] [Created] (CALCITE-5810) SUBSTRING compile-time evaluation gives wrong result for large lengths

2023-06-28 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-5810: Summary: SUBSTRING compile-time evaluation gives wrong result for large lengths Key: CALCITE-5810 URL: https://issues.apache.org/jira/browse/CALCITE-5810 Project: Cal

[jira] [Updated] (CALCITE-5810) SUBSTRING compile-time evaluation gives wrong result for large lengths

2023-06-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5810: Labels: pull-request-available (was: ) > SUBSTRING compile-time evaluation gives wrong r