[jira] [Updated] (CALCITE-6282) Avatica ignores time precision when returning TIME results

2024-04-01 Thread Francis Chuang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6282?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang updated CALCITE-6282: Fix Version/s: avatica-1.25.0 (was: 1.25.0) > Avatica igno

[jira] [Updated] (CALCITE-6334) Release Avatica 1.25.0

2024-04-01 Thread Francis Chuang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang updated CALCITE-6334: Fix Version/s: avatica-1.25.0 > Release Avatica 1.2

[jira] [Updated] (CALCITE-6332) Optimization CoreRules.AGGREGATE_EXPAND_DISTINCT_AGGREGATES_TO_JOIN produces incorrect results for aggregates with groupSets

2024-04-01 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6332: - Fix Version/s: (was: 1.37.0) > Optimizat

[jira] [Commented] (CALCITE-6317) Incorrect constant replacement when group keys are NULL

2024-04-01 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6317?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17832965#comment-17832965 ] Mihai Budiu commented on CALCITE-6317: -- I will try to create a new test and submit another PR

[jira] [Updated] (CALCITE-6332) Optimization CoreRules.AGGREGATE_EXPAND_DISTINCT_AGGREGATES_TO_JOIN produces incorrect results for aggregates with groupSets

2024-04-01 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6332: - Fix Version/s: 1.37.0 > Optimization CoreRules.AGGREGATE_EXPAND_DISTINCT_AGGREGATES_TO_J

[jira] [Updated] (CALCITE-6332) Optimization CoreRules.AGGREGATE_EXPAND_DISTINCT_AGGREGATES_TO_JOIN produces incorrect results for aggregates with groupSets

2024-04-01 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6332: Labels: pull-request-available (was: ) > Optimizat

[jira] [Assigned] (CALCITE-6332) Optimization CoreRules.AGGREGATE_EXPAND_DISTINCT_AGGREGATES_TO_JOIN produces incorrect results for aggregates with groupSets

2024-04-01 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu reassigned CALCITE-6332: Assignee: Mihai Budiu > Optimizat

[jira] [Updated] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-04-01 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6285: Labels: pull-request-available (was: ) > Function ARRAY_INSERT produces an incorr

[jira] [Assigned] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-04-01 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu reassigned CALCITE-6285: Assignee: Mihai Budiu (was: Ran Tao) > Function ARRAY_INSERT produces an incorr

[jira] [Updated] (CALCITE-6349) CoreRules.PROJECT_REDUCE_EXPRESSIONS crashes on expression with ARRAY_REPEAT

2024-04-01 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6349: - Fix Version/s: 1.37.0 > CoreRules.PROJECT_REDUCE_EXPRESSIONS crashes on express

[jira] [Updated] (CALCITE-6349) CoreRules.PROJECT_REDUCE_EXPRESSIONS crashes on expression with ARRAY_REPEAT

2024-04-01 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6349: Labels: pull-request-available (was: ) > CoreRules.PROJECT_REDUCE_EXPRESSIONS cras

[jira] [Assigned] (CALCITE-6349) CoreRules.PROJECT_REDUCE_EXPRESSIONS crashes on expression with ARRAY_REPEAT

2024-04-01 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu reassigned CALCITE-6349: Assignee: Mihai Budiu > CoreRules.PROJECT_REDUCE_EXPRESSIONS crashes on express

[jira] [Commented] (CALCITE-6349) CoreRules.PROJECT_REDUCE_EXPRESSIONS crashes on expression with ARRAY_REPEAT

2024-04-01 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17832943#comment-17832943 ] Mihai Budiu commented on CALCITE-6349: -- This seems to be due to incorrect type inference

[jira] [Created] (CALCITE-6349) CoreRules.PROJECT_REDUCE_EXPRESSIONS crashes on expression with ARRAY_REPEAT

2024-04-01 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6349: Summary: CoreRules.PROJECT_REDUCE_EXPRESSIONS crashes on expression with ARRAY_REPEAT Key: CALCITE-6349 URL: https://issues.apache.org/jira/browse/CALCITE-6349

[jira] [Assigned] (CALCITE-6348) ARRAY_OVERLAP with a NULL argument crashes the compiler

2024-04-01 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu reassigned CALCITE-6348: Assignee: Mihai Budiu > ARRAY_OVERLAP with a NULL argument crashes the compi

[jira] [Updated] (CALCITE-6348) ARRAY_OVERLAP with a NULL argument crashes the compiler

2024-04-01 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6348: - Fix Version/s: 1.37.0 > ARRAY_OVERLAP with a NULL argument crashes the compi

[jira] [Updated] (CALCITE-6348) ARRAY_OVERLAP with a NULL argument crashes the compiler

2024-04-01 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6348: Labels: pull-request-available (was: ) > ARRAY_OVERLAP with a NULL argument cras

[jira] [Created] (CALCITE-6348) ARRAY_OVERLAP with a NULL argument crashes the compiler

2024-04-01 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6348: Summary: ARRAY_OVERLAP with a NULL argument crashes the compiler Key: CALCITE-6348 URL: https://issues.apache.org/jira/browse/CALCITE-6348 Project: Calcite

[jira] [Updated] (CALCITE-6347) ARRAY_REPEAT with a string argument causes a compiler crash

2024-04-01 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6347: - Fix Version/s: 1.37.0 > ARRAY_REPEAT with a string argument causes a compiler cr

[jira] [Assigned] (CALCITE-6347) ARRAY_REPEAT with a string argument causes a compiler crash

2024-04-01 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu reassigned CALCITE-6347: Assignee: Mihai Budiu > ARRAY_REPEAT with a string argument causes a compiler cr

[jira] [Updated] (CALCITE-6347) ARRAY_REPEAT with a string argument causes a compiler crash

2024-04-01 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6347: Labels: pull-request-available (was: ) > ARRAY_REPEAT with a string argument cau

[jira] [Created] (CALCITE-6347) ARRAY_REPEAT with a string argument causes a compiler crash

2024-04-01 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6347: Summary: ARRAY_REPEAT with a string argument causes a compiler crash Key: CALCITE-6347 URL: https://issues.apache.org/jira/browse/CALCITE-6347 Project: Calcite

[jira] [Resolved] (CALCITE-6321) Add copy(List constants) method to Window class.

2024-04-01 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6321. -- Fix Version/s: 1.37.0 Resolution: Fixed Fixed by https://issues.apache.org/jira

[jira] [Updated] (CALCITE-6325) Add LOG function (enabled in Mysql and Spark library)

2024-04-01 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6325: Summary: Add LOG function (enabled in Mysql and Spark library) (was: Add LOG function (enabled

[jira] [Updated] (CALCITE-6325) Add LOG function (enabled in Mysql Style library)

2024-04-01 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6325: Summary: Add LOG function (enabled in Mysql Style library) (was: Add LOG function (enabled

[jira] [Updated] (CALCITE-6325) Add LOG function (enabled in Mysql* library)

2024-04-01 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6325: Summary: Add LOG function (enabled in Mysql* library) (was: Add LOG function (enabled in Mysql

[jira] [Updated] (CALCITE-6346) JdbcAdapter: Cast for dynamic filter arguments is lost

2024-03-31 Thread Corvin Kuebler (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Corvin Kuebler updated CALCITE-6346: Description: Hey,  today we encouraged some issues with the jdbc adapter behaviour. We

[jira] [Updated] (CALCITE-6346) JdbcAdapter: Cast for dynamic filter arguments is lost

2024-03-31 Thread Corvin Kuebler (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Corvin Kuebler updated CALCITE-6346: Description: Hey,  today we encouraged some issues with the jdbc adapter behaviour. We

[jira] [Updated] (CALCITE-6346) JdbcAdapter: Cast for dynamic filter arguments is lost

2024-03-31 Thread Corvin Kuebler (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Corvin Kuebler updated CALCITE-6346: Description: Hey,  today we encouraged some issues with the jdbc adapter behaviour. We

[jira] [Created] (CALCITE-6346) JdbcAdapter: Cast for dynamic filter arguments is lost

2024-03-31 Thread Corvin Kuebler (Jira)
Corvin Kuebler created CALCITE-6346: --- Summary: JdbcAdapter: Cast for dynamic filter arguments is lost Key: CALCITE-6346 URL: https://issues.apache.org/jira/browse/CALCITE-6346 Project: Calcite

[jira] [Updated] (CALCITE-6346) JdbcAdapter: Cast for dynamic filter arguments is lost

2024-03-31 Thread Corvin Kuebler (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Corvin Kuebler updated CALCITE-6346: Issue Type: Bug (was: Improvement) > JdbcAdapter: Cast for dynamic filter argume

[jira] [Updated] (CALCITE-6345) Intervals with more than 100 years are not supported

2024-03-29 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6345: Labels: pull-request-available (was: ) > Intervals with more than 100 ye

[jira] [Commented] (CALCITE-6345) Intervals with more than 100 years are not supported

2024-03-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6345?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17832347#comment-17832347 ] Mihai Budiu commented on CALCITE-6345: -- I see a test in IntervalTest.subTestIntervalYearNegative

[jira] [Commented] (CALCITE-6345) Intervals with more than 100 years are not supported

2024-03-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6345?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17832343#comment-17832343 ] Mihai Budiu commented on CALCITE-6345: -- This happens because

[jira] [Created] (CALCITE-6345) Intervals with more than 100 years are not supported

2024-03-29 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6345: Summary: Intervals with more than 100 years are not supported Key: CALCITE-6345 URL: https://issues.apache.org/jira/browse/CALCITE-6345 Project: Calcite

[jira] [Commented] (CALCITE-6282) Avatica ignores time precision when returning TIME results

2024-03-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17832274#comment-17832274 ] Mihai Budiu commented on CALCITE-6282: -- I will prepare a Calcite PR to reenable the tests

[jira] [Commented] (CALCITE-6282) Avatica ignores time precision when returning TIME results

2024-03-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17832271#comment-17832271 ] Mihai Budiu commented on CALCITE-6282: -- I will only close this issue after the Calcite 1.37

[jira] [Commented] (CALCITE-6343) AS alias operator strips MEASUREness from measures

2024-03-27 Thread Barry Kelly (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17831426#comment-17831426 ] Barry Kelly commented on CALCITE-6343: -- I added a test to {{SqlToRelConverterTest}} because

[jira] [Commented] (CALCITE-6343) AS alias operator strips MEASUREness from measures

2024-03-27 Thread Barry Kelly (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17831408#comment-17831408 ] Barry Kelly commented on CALCITE-6343: -- I'll give a stab at adding another test and I'm willing

[jira] [Created] (CALCITE-6344) RelToSqlConverter invalid quotation for arrays and item operator(ansi dialect)

2024-03-27 Thread Anton Kovalevsky (Jira)
Anton Kovalevsky created CALCITE-6344: - Summary: RelToSqlConverter invalid quotation for arrays and item operator(ansi dialect) Key: CALCITE-6344 URL: https://issues.apache.org/jira/browse/CALCITE-6344

[jira] [Commented] (CALCITE-6343) AS alias operator strips MEASUREness from measures

2024-03-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17831113#comment-17831113 ] Julian Hyde commented on CALCITE-6343: -- Your PR looks fine, but I would like you to add a simple

[jira] [Commented] (CALCITE-6343) AS alias operator strips MEASUREness from measures

2024-03-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17831110#comment-17831110 ] Julian Hyde commented on CALCITE-6343: -- I edited the description, removing the explicit link. Note

[jira] [Updated] (CALCITE-6343) AS alias operator strips MEASUREness from measures

2024-03-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6343: - Description: CALCITE-5869 introduced a change which removes MEASURE when inferring the return

[jira] [Updated] (CALCITE-6137) Upgrade gradle to 8.5 and support java 21

2024-03-26 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6137?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6137: - Summary: Upgrade gradle to 8.5 and support java 21 (was: Upgrade gradle to 8.4

[jira] [Resolved] (CALCITE-6137) Upgrade gradle to 8.4 and support java 21

2024-03-26 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6137?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin resolved CALCITE-6137. -- Fix Version/s: avatica-1.25.0 Resolution: Fixed > Upgrade gradle to

[jira] [Assigned] (CALCITE-6137) Upgrade gradle to 8.4 and support java 21

2024-03-26 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6137?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin reassigned CALCITE-6137: Assignee: Sergey Nuyanzin > Upgrade gradle to 8.4 and support java

[jira] [Commented] (CALCITE-6137) Upgrade gradle to 8.4 and support java 21

2024-03-26 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17831089#comment-17831089 ] Sergey Nuyanzin commented on CALCITE-6137: -- Merged

[jira] [Updated] (CALCITE-6343) AS alias operator strips MEASUREness from measures

2024-03-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6343: Labels: pull-request-available (was: ) > AS alias operator strips MEASUREness f

[jira] [Created] (CALCITE-6343) AS alias operator strips MEASUREness from measures

2024-03-26 Thread Barry Kelly (Jira)
Barry Kelly created CALCITE-6343: Summary: AS alias operator strips MEASUREness from measures Key: CALCITE-6343 URL: https://issues.apache.org/jira/browse/CALCITE-6343 Project: Calcite Issue

[jira] [Created] (CALCITE-6342) Use highest input precision for datetime with/without local time zone

2024-03-26 Thread Dawid Wysakowicz (Jira)
Dawid Wysakowicz created CALCITE-6342: - Summary: Use highest input precision for datetime with/without local time zone Key: CALCITE-6342 URL: https://issues.apache.org/jira/browse/CALCITE-6342

[jira] [Created] (CALCITE-6341) DynamicRecordType join query will generate uncompailable code

2024-03-25 Thread Yonatan Graber (Jira)
Yonatan Graber created CALCITE-6341: --- Summary: DynamicRecordType join query will generate uncompailable code Key: CALCITE-6341 URL: https://issues.apache.org/jira/browse/CALCITE-6341 Project

[jira] [Commented] (CALCITE-6248) Illegal dates are accepted by casts

2024-03-25 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6248?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17830774#comment-17830774 ] Mihai Budiu commented on CALCITE-6248: -- I thought we were ready to close this one

[jira] [Created] (CALCITE-6340) RelBuilder always creates Project with Convention.NONE during aggregate_

2024-03-25 Thread Adam Kennedy (Jira)
Adam Kennedy created CALCITE-6340: - Summary: RelBuilder always creates Project with Convention.NONE during aggregate_ Key: CALCITE-6340 URL: https://issues.apache.org/jira/browse/CALCITE-6340 Project

[jira] [Resolved] (CALCITE-6338) RelMdCollation#project can return an incomplete list of collations in the presence of aliasing

2024-03-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-6338. Resolution: Fixed Fixed via [{{d5b6b5c}}|https://github.com/apache/calcite/commit

[jira] [Resolved] (CALCITE-6339) Replace hashicorp/go-uuid with google/uuid

2024-03-25 Thread Francis Chuang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang resolved CALCITE-6339. - Resolution: Fixed > Replace hashicorp/go-uuid with google/u

[jira] [Created] (CALCITE-6339) Replace hashicorp/go-uuid with google/uuid

2024-03-25 Thread Francis Chuang (Jira)
Francis Chuang created CALCITE-6339: --- Summary: Replace hashicorp/go-uuid with google/uuid Key: CALCITE-6339 URL: https://issues.apache.org/jira/browse/CALCITE-6339 Project: Calcite Issue

[jira] [Resolved] (CALCITE-6337) Distinguish naked measure support between inside and outside aggregation

2024-03-24 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary resolved CALCITE-6337. --- Fix Version/s: 1.37.0 Resolution: Fixed Merged via [14ade3a|https://github.com

[jira] [Commented] (CALCITE-6315) Support PostgreSQL TO_CHAR, TO_DATE, TO_TIMESTAMP

2024-03-22 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17829994#comment-17829994 ] Jerin John commented on CALCITE-6315: - Hi [~njordan], I am also currently working on a ticket

[jira] [Commented] (CALCITE-6315) Support PostgreSQL TO_CHAR, TO_DATE, TO_TIMESTAMP

2024-03-22 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17829930#comment-17829930 ] Julian Hyde commented on CALCITE-6315: -- OK, great, make sure that it tests all format elements

[jira] [Commented] (CALCITE-6315) Support PostgreSQL TO_CHAR, TO_DATE, TO_TIMESTAMP

2024-03-22 Thread Norman Jordan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17829925#comment-17829925 ] Norman Jordan commented on CALCITE-6315: There is already a test for `to_char` with PostgreSQL

[jira] [Updated] (CALCITE-6338) RelMdCollation#project can return an incomplete list of collations in the presence of aliasing

2024-03-22 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-6338: --- Description: {{RelMdCollation#project}} can return an incomplete list of collations. Let us say

[jira] [Commented] (CALCITE-6338) RelMdCollation#project can return an incomplete list of collations in the presence of aliasing

2024-03-22 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17829792#comment-17829792 ] Ruben Q L commented on CALCITE-6338: Thanks for the feedback [~julianhyde], I have improved

[jira] [Updated] (CALCITE-6338) RelMdCollation#project can return an incomplete list of collations in the presence of aliasing

2024-03-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-6338: --- Summary: RelMdCollation#project can return an incomplete list of collations in the presence

[jira] [Commented] (CALCITE-6338) RelMdCollation#project can return an incomplete list of collations

2024-03-21 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17829666#comment-17829666 ] Julian Hyde commented on CALCITE-6338: -- Makes sense. I would mention 'in the presence of aliasing

[jira] [Resolved] (CALCITE-6015) AssertionError during optimization of EXTRACT expression

2024-03-21 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6015. -- Resolution: Fixed Fixed in https://github.com/apache/calcite/commit

[jira] [Updated] (CALCITE-6338) RelMdCollation#project can return an incomplete list of collations

2024-03-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-6338: --- Description: {{RelMdCollation#project}} can return an incomplete list of collations. Let us say

[jira] [Updated] (CALCITE-6338) RelMdCollation#project can return an incomplete list of collations

2024-03-21 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6338: Labels: pull-request-available (was: ) > RelMdCollation#project can ret

[jira] [Updated] (CALCITE-6338) RelMdCollation#project can return an incomplete list of collations

2024-03-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-6338: --- Fix Version/s: 1.37.0 > RelMdCollation#project can return an incomplete list of collati

[jira] [Created] (CALCITE-6338) RelMdCollation#project can return an incomplete list of collations

2024-03-21 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-6338: -- Summary: RelMdCollation#project can return an incomplete list of collations Key: CALCITE-6338 URL: https://issues.apache.org/jira/browse/CALCITE-6338 Project: Calcite

[jira] [Commented] (CALCITE-5155) Custom time frames

2024-03-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17829343#comment-17829343 ] Julian Hyde commented on CALCITE-5155: -- I'm not aware of any SQL systems that have a SQL syntax

[jira] [Commented] (CALCITE-5155) Custom time frames

2024-03-20 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17829339#comment-17829339 ] Mihai Budiu commented on CALCITE-5155: -- Is there any SQL syntax to define custom time frames

[jira] [Updated] (CALCITE-6337) Distinguish naked measure support between inside and outside aggregation

2024-03-20 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6337: Labels: pull-request-available (was: ) > Distinguish naked measure support betw

[jira] [Created] (CALCITE-6337) Distinguish naked measure support between inside and outside aggregation

2024-03-20 Thread Barry Kelly (Jira)
Barry Kelly created CALCITE-6337: Summary: Distinguish naked measure support between inside and outside aggregation Key: CALCITE-6337 URL: https://issues.apache.org/jira/browse/CALCITE-6337 Project

[jira] [Created] (CALCITE-6336) When inserting an insert SQL statement containing non-ANSII characters into an Oracle database, an exception occurs

2024-03-19 Thread gunveda (Jira)
gunveda created CALCITE-6336: Summary: When inserting an insert SQL statement containing non-ANSII characters into an Oracle database, an exception occurs Key: CALCITE-6336 URL: https://issues.apache.org/jira/browse

[jira] [Comment Edited] (CALCITE-6327) getValidatedNodeTypeIfKnown should never throw

2024-03-19 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828550#comment-17828550 ] James Duong edited comment on CALCITE-6327 at 3/20/24 12:28 AM: Note

[jira] [Commented] (CALCITE-6327) getValidatedNodeTypeIfKnown should never throw

2024-03-19 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828550#comment-17828550 ] James Duong commented on CALCITE-6327: -- To reproduce it (and build a test case), the easiest way

[jira] [Commented] (CALCITE-6313) Support PostgreSQL POW

2024-03-19 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828534#comment-17828534 ] Tanner Clary commented on CALCITE-6313: --- [~njordan] can you format the title similar to other

[jira] [Commented] (CALCITE-6315) Support PostgreSQL TO_CHAR, TO_DATE, TO_TIMESTAMP

2024-03-19 Thread Norman Jordan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828529#comment-17828529 ] Norman Jordan commented on CALCITE-6315: [~julianhyde] Thanks, I'll start with adding tests

[jira] [Commented] (CALCITE-6313) Support PostgreSQL POW

2024-03-19 Thread Norman Jordan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828528#comment-17828528 ] Norman Jordan commented on CALCITE-6313: [~tanclary] Returning a numeric result (rather than

[jira] [Commented] (CALCITE-6313) Support PostgreSQL POW

2024-03-19 Thread Norman Jordan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828525#comment-17828525 ] Norman Jordan commented on CALCITE-6313: It looks like this can cause different results

[jira] [Commented] (CALCITE-6315) Support PostgreSQL TO_CHAR, TO_DATE, TO_TIMESTAMP

2024-03-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828522#comment-17828522 ] Julian Hyde commented on CALCITE-6315: -- If you want to help, add some tests. For CALCITE-2980 I

[jira] [Commented] (CALCITE-6315) Support PostgreSQL TO_CHAR, TO_DATE, TO_TIMESTAMP

2024-03-19 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828505#comment-17828505 ] Tanner Clary commented on CALCITE-6315: --- Yes of course it'd be great to add elements that aren't

[jira] [Commented] (CALCITE-6315) Support PostgreSQL TO_CHAR, TO_DATE, TO_TIMESTAMP

2024-03-19 Thread Norman Jordan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828504#comment-17828504 ] Norman Jordan commented on CALCITE-6315: [~tanclary] [~julianhyde] How can this issue

[jira] [Commented] (CALCITE-6315) Support PostgreSQL TO_CHAR, TO_DATE, TO_TIMESTAMP

2024-03-19 Thread Norman Jordan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828503#comment-17828503 ] Norman Jordan commented on CALCITE-6315: These template patterns are supported by PostgreSQL 14

[jira] [Updated] (CALCITE-6325) Add LOG function (enabled in Mysql library)

2024-03-18 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6325: Summary: Add LOG function (enabled in Mysql library) (was: Add LOG function (enabled in Mysql

[jira] [Commented] (CALCITE-6335) Quidem tests should allow specifying optimization passes to apply to programs

2024-03-18 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828131#comment-17828131 ] Julian Hyde commented on CALCITE-6335: -- I agree. Currently we look over XML plans produced

[jira] [Commented] (CALCITE-2980) Implement the FORMAT clause of the CAST operator

2024-03-18 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828130#comment-17828130 ] Julian Hyde commented on CALCITE-2980: -- It's a judgment call for you to make. I think it's based

[jira] [Created] (CALCITE-6335) Quidem tests should allow specifying optimization passes to apply to programs

2024-03-18 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6335: Summary: Quidem tests should allow specifying optimization passes to apply to programs Key: CALCITE-6335 URL: https://issues.apache.org/jira/browse/CALCITE-6335

[jira] [Updated] (CALCITE-6309) Add REGEXP_LIKE function (enabled in MySQL, Oracle, PostgreSQL and Spark libraries)

2024-03-18 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong updated CALCITE-6309: - Fix Version/s: 1.37.0 > Add REGEXP_LIKE function (enabled in MySQL, Oracle, Postgre

[jira] [Updated] (CALCITE-6310) Add REGEXP_REPLACE function (enabled in PostgreSQL library)

2024-03-18 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong updated CALCITE-6310: - Summary: Add REGEXP_REPLACE function (enabled in PostgreSQL library) (was: Add REGEXP_LIKE

[jira] [Updated] (CALCITE-6321) Add copy(List constants) method to Window class.

2024-03-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6321: Labels: pull-request-available (was: ) > Add copy(List constants) method to Win

[jira] [Comment Edited] (CALCITE-2980) Implement the FORMAT clause of the CAST operator

2024-03-18 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828058#comment-17828058 ] Jerin John edited comment on CALCITE-2980 at 3/18/24 5:28 PM: -- Makes sense

[jira] [Commented] (CALCITE-2980) Implement the FORMAT clause of the CAST operator

2024-03-18 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17828058#comment-17828058 ] Jerin John commented on CALCITE-2980: - Makes sense [~julianhyde], the whole set of tests

[jira] [Created] (CALCITE-6334) Release Avatica 1.25.0

2024-03-18 Thread Francis Chuang (Jira)
Francis Chuang created CALCITE-6334: --- Summary: Release Avatica 1.25.0 Key: CALCITE-6334 URL: https://issues.apache.org/jira/browse/CALCITE-6334 Project: Calcite Issue Type: Task

[jira] [Commented] (CALCITE-6332) Optimization CoreRules.AGGREGATE_EXPAND_DISTINCT_AGGREGATES_TO_JOIN produces incorrect results for aggregates with groupSets

2024-03-18 Thread Abhishek Agarwal (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827872#comment-17827872 ] Abhishek Agarwal commented on CALCITE-6332: --- FWIW, the new rule doesn't produce a correct

[jira] [Commented] (CALCITE-6270) Support FORMAT in CAST from Numeric and BYTES to String (Enabled in BigQuery)

2024-03-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827761#comment-17827761 ] Julian Hyde commented on CALCITE-6270: -- [~jerin_john], Please use Calcite's type names in jira

[jira] [Commented] (CALCITE-6327) getValidatedNodeTypeIfKnown should never throw

2024-03-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827760#comment-17827760 ] Julian Hyde commented on CALCITE-6327: -- A test case would be useful

[jira] [Commented] (CALCITE-6327) getValidatedNodeTypeIfKnown should never throw

2024-03-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827759#comment-17827759 ] Julian Hyde commented on CALCITE-6327: -- That sounds right. However, mutations of the AST make me

[jira] [Commented] (CALCITE-6317) Incorrect constant replacement when group keys are NULL

2024-03-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6317?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827758#comment-17827758 ] Julian Hyde commented on CALCITE-6317: -- Since the root cause is {{RelMdPredicates}}, can you add

[jira] [Commented] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

2024-03-16 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827757#comment-17827757 ] James Duong commented on CALCITE-6314: -- Yes, my Jira issues were because I was a committer

<    5   6   7   8   9   10   11   12   13   14   >