[jira] [Comment Edited] (CALCITE-6587) Support JDK 23 and Guava 33.3.0

2024-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882822#comment-17882822 ] Julian Hyde edited comment on CALCITE-6587 at 9/21/24 12:35 AM: -

[jira] [Resolved] (CALCITE-6587) Support JDK 23 and Guava 33.3.0

2024-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6587. -- Resolution: Fixed Fixed in [e314fcc|https://github.com/apache/calcite/commit/e314fcc8a8d2594

[jira] [Updated] (CALCITE-6590) Remove use of Java SecurityManager in Avatica

2024-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6590?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6590: - Description: Remove use of Java SecurityManager in Avatica. Running Avatica on JDK 23 (or JRE

[jira] [Created] (CALCITE-6590) Remove use of Java SecurityManager in Avatica

2024-09-20 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-6590: Summary: Remove use of Java SecurityManager in Avatica Key: CALCITE-6590 URL: https://issues.apache.org/jira/browse/CALCITE-6590 Project: Calcite Issue Type:

[jira] [Comment Edited] (CALCITE-5136) Avatica build (or CI) must fail if there are deprecation warnings

2024-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17883430#comment-17883430 ] Julian Hyde edited comment on CALCITE-5136 at 9/20/24 11:35 PM: -

[jira] [Updated] (CALCITE-6590) Remove use of Java SecurityManager in Avatica

2024-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6590?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6590: - Description: Remove use of Java SecurityManager in Avatica. Running Avatica on JDK 23 (or JRE

[jira] [Updated] (CALCITE-6588) Support JDK 23 and Guava 33.3.0 in Avatica

2024-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6588?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6588: - Description: Support JDK 23 and Guava 33.3.0-jre, which are the latest available versions. The

[jira] [Commented] (CALCITE-5136) Avatica build (or CI) must fail if there are deprecation warnings

2024-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17883430#comment-17883430 ] Julian Hyde commented on CALCITE-5136: -- We must get this done in 1.26. As we disco

[jira] [Assigned] (CALCITE-5136) Avatica build (or CI) must fail if there are deprecation warnings

2024-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-5136: Assignee: Benchao Li > Avatica build (or CI) must fail if there are deprecation warnings

[jira] [Updated] (CALCITE-5136) Avatica build (or CI) must fail if there are deprecation warnings

2024-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5136: - Fix Version/s: avatica-1.26.0 > Avatica build (or CI) must fail if there are deprecation warnin

[jira] [Updated] (CALCITE-6588) Support JDK 23 and Guava 33.3.0 in Avatica

2024-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6588?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6588: - Description: Support JDK 23 and Guava 33.3.0-jre, which are the latest available versions. The

[jira] [Commented] (CALCITE-5156) Support implicit number type cast for IN Sub-query

2024-09-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17883108#comment-17883108 ] Julian Hyde commented on CALCITE-5156: -- [~nobigo], I saw that you removed fixVersi

[jira] [Commented] (CALCITE-6587) Support JDK 23 and Guava 33.3.0

2024-09-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17883055#comment-17883055 ] Julian Hyde commented on CALCITE-6587: -- Sorry to hear about your GitHub issues. Th

[jira] [Commented] (CALCITE-6566) JDBC adapter should generate PI function with parentheses in most dialects

2024-09-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17883052#comment-17883052 ] Julian Hyde commented on CALCITE-6566: -- [~nobigo], You're right. I hadn't thought

[jira] [Comment Edited] (CALCITE-6587) Support JDK 23 and Guava 33.3.0

2024-09-18 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882822#comment-17882822 ] Julian Hyde edited comment on CALCITE-6587 at 9/18/24 11:09 PM: -

[jira] [Comment Edited] (CALCITE-6587) Support JDK 23 and Guava 33.3.0

2024-09-18 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882822#comment-17882822 ] Julian Hyde edited comment on CALCITE-6587 at 9/18/24 11:07 PM: -

[jira] [Commented] (CALCITE-6587) Support JDK 23 and Guava 33.3.0

2024-09-18 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882822#comment-17882822 ] Julian Hyde commented on CALCITE-6587: -- We are running into HADOOP-19212 and will

[jira] [Comment Edited] (CALCITE-6566) JDBC adapter should generate PI function with parentheses in most dialects

2024-09-18 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882773#comment-17882773 ] Julian Hyde edited comment on CALCITE-6566 at 9/18/24 5:53 PM: --

[jira] [Commented] (CALCITE-6566) JDBC adapter should generate PI function with parentheses in most dialects

2024-09-18 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882773#comment-17882773 ] Julian Hyde commented on CALCITE-6566: -- I think that CURRENT_DATE etc. are special

[jira] [Commented] (CALCITE-6583) Case Statement reformulation in JdbcAdapter

2024-09-18 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882762#comment-17882762 ] Julian Hyde commented on CALCITE-6583: -- [~mbudiu], I agree that it's probably rela

[jira] [Commented] (CALCITE-6588) Support JDK 23 and Guava 33.3.0 in Avatica

2024-09-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882541#comment-17882541 ] Julian Hyde commented on CALCITE-6588: -- When this case is fixed, re-enable Calcite

[jira] [Created] (CALCITE-6588) Support JDK 23 and Guava 33.3.0 in Avatica

2024-09-17 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-6588: Summary: Support JDK 23 and Guava 33.3.0 in Avatica Key: CALCITE-6588 URL: https://issues.apache.org/jira/browse/CALCITE-6588 Project: Calcite Issue Type: Im

[jira] [Assigned] (CALCITE-6587) Support JDK 23 and Guava 33.3.0

2024-09-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-6587: Assignee: Julian Hyde > Support JDK 23 and Guava 33.3.0 > --

[jira] [Updated] (CALCITE-6587) Support JDK 23 and Guava 33.3.0

2024-09-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6587: - Fix Version/s: 1.38.0 > Support JDK 23 and Guava 33.3.0 > --- > >

[jira] [Created] (CALCITE-6587) Support JDK 23 and Guava 33.3.0

2024-09-17 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-6587: Summary: Support JDK 23 and Guava 33.3.0 Key: CALCITE-6587 URL: https://issues.apache.org/jira/browse/CALCITE-6587 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-6585) In the Postgres TO_CHAR function, improve caching

2024-09-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882492#comment-17882492 ] Julian Hyde commented on CALCITE-6585: -- I agree. Again, this issue will improve p

[jira] [Comment Edited] (CALCITE-6582) Release Calcite 1.38.0

2024-09-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881875#comment-17881875 ] Julian Hyde edited comment on CALCITE-6582 at 9/17/24 6:42 PM: --

[jira] [Commented] (CALCITE-6573) Refactor SqlValidatorImpl

2024-09-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882488#comment-17882488 ] Julian Hyde commented on CALCITE-6573: -- I reviewed [PR 3965|https://github.com/apa

[jira] [Updated] (CALCITE-6343) Ensure that AS operator (column alias) doesn't change return type of measures

2024-09-16 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: - Summary: Ensure that AS operator (column alias) doesn't change return type of measures (was: A

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

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6343. -- Resolution: Fixed Fixed in [36b8a99d|https://github.com/apache/calcite/commit/36b8a99d896008

[jira] [Resolved] (CALCITE-6576) In SET clause of UPDATE statement, allow column identifiers to be prefixed with table alias

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6576. -- Resolution: Fixed Fixed in [fc792668|https://github.com/apache/calcite/commit/fc792668047014

[jira] [Resolved] (CALCITE-6550) Improve SQL function overloading

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6550. -- Resolution: Fixed Fixed in [a00d5654|https://github.com/apache/calcite/commit/a00d565456b43a

[jira] [Resolved] (CALCITE-6580) Remove Locale.setDefault

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6580. -- Resolution: Fixed Fixed in [963f898b|https://github.com/apache/calcite/commit/963f898b2c1355

[jira] [Commented] (CALCITE-6527) Add DATE_ADD function (enabled in Spark library)

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882217#comment-17882217 ] Julian Hyde commented on CALCITE-6527: -- I find these exchanges very time consuming

[jira] [Comment Edited] (CALCITE-6580) Remove Locale.setDefault

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882211#comment-17882211 ] Julian Hyde edited comment on CALCITE-6580 at 9/17/24 12:43 AM: -

[jira] [Updated] (CALCITE-6580) Remove Locale.setDefault

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6580: - Fix Version/s: 1.38.0 > Remove Locale.setDefault > > >

[jira] [Commented] (CALCITE-6580) Remove Locale.setDefault

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882211#comment-17882211 ] Julian Hyde commented on CALCITE-6580: -- I have reviewed, and it looks good. I appr

[jira] [Created] (CALCITE-6585) In the Postgres TO_CHAR function, improve caching

2024-09-16 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-6585: Summary: In the Postgres TO_CHAR function, improve caching Key: CALCITE-6585 URL: https://issues.apache.org/jira/browse/CALCITE-6585 Project: Calcite Issue T

[jira] [Updated] (CALCITE-6584) Validate prefixed column identifiers in SET clause of UPDATE statement

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6584?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6584: - Summary: Validate prefixed column identifiers in SET clause of UPDATE statement (was: Validate

[jira] [Comment Edited] (CALCITE-6576) In SET clause of UPDATE statement, allow column identifiers to be prefixed with table alias

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882156#comment-17882156 ] Julian Hyde edited comment on CALCITE-6576 at 9/16/24 11:18 PM: -

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

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882202#comment-17882202 ] Julian Hyde commented on CALCITE-6343: -- Reviewing now. It seems that my revised fi

[jira] [Updated] (CALCITE-6493) Add MySQL and other professional term restrictions

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6493: - Fix Version/s: 1.38.0 > Add MySQL and other professional term restrictions > --

[jira] [Updated] (CALCITE-6566) JDBC adapter should generate PI function with parentheses in most dialects

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6566: - Fix Version/s: 1.38.0 > JDBC adapter should generate PI function with parentheses in most diale

[jira] [Updated] (CALCITE-6560) Add supportsNegativeScale in RelDataTypeSystem

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6560: - Fix Version/s: 1.38.0 > Add supportsNegativeScale in RelDataTypeSystem > -

[jira] [Commented] (CALCITE-6560) Add supportsNegativeScale in RelDataTypeSystem

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882151#comment-17882151 ] Julian Hyde commented on CALCITE-6560: -- Added fixVersion = 1.38. I think we can ge

[jira] [Commented] (CALCITE-2067) RexLiteral cannot represent accurately floating point values, including NaN, Infinity

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882146#comment-17882146 ] Julian Hyde commented on CALCITE-2067: -- I've assigned to [~mbudiu], so it's clear

[jira] [Assigned] (CALCITE-2067) RexLiteral cannot represent accurately floating point values, including NaN, Infinity

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-2067: Assignee: Mihai Budiu > RexLiteral cannot represent accurately floating point values, in

[jira] [Commented] (CALCITE-6527) Add DATE_ADD function (enabled in Spark library)

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882145#comment-17882145 ] Julian Hyde commented on CALCITE-6527: -- Link to its jira. By 'only date type' do

[jira] [Updated] (CALCITE-6570) UPDATE with sub-query that requires type cast gives AssertionError

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6570?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6570: - Fix Version/s: 1.38.0 > UPDATE with sub-query that requires type cast gives AssertionError > --

[jira] [Comment Edited] (CALCITE-6576) In SET clause of UPDATE statement, allow column identifiers to be prefixed with table alias

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882134#comment-17882134 ] Julian Hyde edited comment on CALCITE-6576 at 9/16/24 5:48 PM: --

[jira] [Commented] (CALCITE-6576) In SET clause of UPDATE statement, allow column identifiers to be prefixed with table alias

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882134#comment-17882134 ] Julian Hyde commented on CALCITE-6576: -- The parser change looks good. However, the

[jira] [Updated] (CALCITE-6576) In SET clause of UPDATE statement, allow column identifiers to be prefixed with table alias

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6576: - Summary: In SET clause of UPDATE statement, allow column identifiers to be prefixed with table

[jira] [Commented] (CALCITE-6583) Case Statement reformulation in JdbcAdapter

2024-09-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882128#comment-17882128 ] Julian Hyde commented on CALCITE-6583: -- Does the reformulated version return the s

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

2024-09-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17831110#comment-17831110 ] Julian Hyde edited comment on CALCITE-6343 at 9/16/24 1:55 AM: --

[jira] [Commented] (CALCITE-6226) Wrong ISOWEEK and no ISOYEAR on BigQuery FORMAT_DATE

2024-09-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6226?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881893#comment-17881893 ] Julian Hyde commented on CALCITE-6226: -- [~tanclary], Is this PR good to go? If so

[jira] [Resolved] (CALCITE-6408) Not-null ThreadLocal

2024-09-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6408. -- Resolution: Fixed Fixed in [740f2ee2|https://github.com/apache/calcite/commit/740f2ee2511cf2

[jira] [Commented] (CALCITE-5541) Upgrade JavaCC

2024-09-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5541?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881891#comment-17881891 ] Julian Hyde commented on CALCITE-5541: -- There is a [dev branch|https://github.com

[jira] [Updated] (CALCITE-5541) Upgrade JavaCC

2024-09-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5541: - Fix Version/s: (was: 1.38.0) > Upgrade JavaCC > -- > > Key: CAL

[jira] [Commented] (CALCITE-6582) Release Calcite 1.38.0

2024-09-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881875#comment-17881875 ] Julian Hyde commented on CALCITE-6582: -- There are 26 [open bugs marked to fix for

[jira] [Commented] (CALCITE-2067) RexLiteral cannot represent accurately floating point values, including NaN, Infinity

2024-09-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881874#comment-17881874 ] Julian Hyde commented on CALCITE-2067: -- [~mbudiu], As you have done a lot of work

[jira] [Created] (CALCITE-6582) Release Calcite 1.38.0

2024-09-15 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-6582: Summary: Release Calcite 1.38.0 Key: CALCITE-6582 URL: https://issues.apache.org/jira/browse/CALCITE-6582 Project: Calcite Issue Type: Improvement

[jira] [Closed] (CALCITE-6302) Release Calcite 1.37.0

2024-09-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-6302. > Release Calcite 1.37.0 > -- > > Key: CALCITE-6302 >

[jira] [Assigned] (CALCITE-6582) Release Calcite 1.38.0

2024-09-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-6582: Assignee: Julian Hyde > Release Calcite 1.38.0 > -- > >

[jira] [Resolved] (CALCITE-6302) Release Calcite 1.37.0

2024-09-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6302. -- Resolution: Fixed > Release Calcite 1.37.0 > -- > > Key:

[jira] [Updated] (CALCITE-6302) Release Calcite 1.37.0

2024-09-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6302: - Fix Version/s: 1.37.0 (was: 1.38.0) > Release Calcite 1.37.0 > -

[jira] [Comment Edited] (CALCITE-6580) Remove Locale.setDefault

2024-09-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881708#comment-17881708 ] Julian Hyde edited comment on CALCITE-6580 at 9/13/24 10:16 PM: -

[jira] [Commented] (CALCITE-6580) Remove Locale.setDefault

2024-09-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881708#comment-17881708 ] Julian Hyde commented on CALCITE-6580: -- Mihai is correct. The {{DAYNAME}} and {{MO

[jira] [Commented] (CALCITE-6549) Add LOG1P function (enabled in Spark library)

2024-09-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881682#comment-17881682 ] Julian Hyde commented on CALCITE-6549: -- Note that, consistent with Spark, {{log1p(

[jira] [Commented] (CALCITE-6580) Remove Locale.setDefault

2024-09-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881680#comment-17881680 ] Julian Hyde commented on CALCITE-6580: -- To address this, which I missed the first

[jira] [Commented] (CALCITE-6580) Remove Locale.setDefault

2024-09-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881677#comment-17881677 ] Julian Hyde commented on CALCITE-6580: -- If the production code doesn't depend on t

[jira] [Commented] (CALCITE-6452) Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result

2024-09-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881440#comment-17881440 ] Julian Hyde commented on CALCITE-6452: -- I don't quite follow, but it sounds like y

[jira] [Commented] (CALCITE-6580) Remove Locale.setDefault

2024-09-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881436#comment-17881436 ] Julian Hyde commented on CALCITE-6580: -- [~njordan], Are you able to get this one f

[jira] [Comment Edited] (CALCITE-6572) Add more tests for NULL arguments to TO_CHAR functions

2024-09-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881435#comment-17881435 ] Julian Hyde edited comment on CALCITE-6572 at 9/13/24 12:56 AM: -

[jira] [Created] (CALCITE-6580) Remove Locale.setDefault

2024-09-12 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-6580: Summary: Remove Locale.setDefault Key: CALCITE-6580 URL: https://issues.apache.org/jira/browse/CALCITE-6580 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-6572) Add more tests for NULL arguments to TO_CHAR functions

2024-09-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881435#comment-17881435 ] Julian Hyde commented on CALCITE-6572: -- [~njordan], While you're there, can you re

[jira] [Comment Edited] (CALCITE-6572) Add more tests for NULL arguments to TO_CHAR functions

2024-09-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881083#comment-17881083 ] Julian Hyde edited comment on CALCITE-6572 at 9/13/24 12:46 AM: -

[jira] [Comment Edited] (CALCITE-6572) Add more tests for NULL arguments to TO_CHAR functions

2024-09-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881124#comment-17881124 ] Julian Hyde edited comment on CALCITE-6572 at 9/13/24 12:45 AM: -

[jira] [Updated] (CALCITE-6572) Add more tests for NULL arguments to TO_CHAR functions

2024-09-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6572: - Summary: Add more tests for NULL arguments to TO_CHAR functions (was: Add more tests for NULL

[jira] [Updated] (CALCITE-6572) Add more tests for NULL arguments to TO_CHAR functions

2024-09-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6572: - Fix Version/s: 1.38.0 > Add more tests for NULL arguments to TO_CHAR functions > --

[jira] [Updated] (CALCITE-6572) Add more tests for NULL result of TO_CHAR PostgreSQL function

2024-09-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6572: - Description: When the argument to the {{TO_CHAR(, )}} function is nullable, the return type sh

[jira] [Commented] (CALCITE-6572) Add more tests for NULL result of TO_CHAR PostgreSQL function

2024-09-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881434#comment-17881434 ] Julian Hyde commented on CALCITE-6572: -- Thanks for updating the title. But when yo

[jira] [Commented] (CALCITE-6574) Add ScopeMap

2024-09-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881400#comment-17881400 ] Julian Hyde commented on CALCITE-6574: -- I wonder whether those helper functions tr

[jira] [Commented] (CALCITE-6574) Add SqlQueryScopes

2024-09-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881120#comment-17881120 ] Julian Hyde commented on CALCITE-6574: -- I take your point that the {{SqlValidatorS

[jira] [Commented] (CALCITE-6571) Impossible to create/extend RelOptRule without using deprecated APIs

2024-09-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881091#comment-17881091 ] Julian Hyde commented on CALCITE-6571: -- Yes, I think we want to discourage people

[jira] [Commented] (CALCITE-6572) Calcite TO_CHAR function is incorrectly marked as returning a non-nullable result

2024-09-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881083#comment-17881083 ] Julian Hyde commented on CALCITE-6572: -- Looks like [~njordan] already fixed this i

[jira] [Comment Edited] (CALCITE-6572) Calcite TO_CHAR function is incorrectly marked as returning a non-nullable result

2024-09-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881020#comment-17881020 ] Julian Hyde edited comment on CALCITE-6572 at 9/11/24 5:33 PM: --

[jira] [Commented] (CALCITE-6572) Calcite TO_CHAR function is incorrectly marked as returning a non-nullable result

2024-09-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881020#comment-17881020 ] Julian Hyde commented on CALCITE-6572: -- I agree. We generally test each function w

[jira] [Commented] (CALCITE-6566) JDBC adapter should generate PI function with parentheses in most dialects

2024-09-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17880691#comment-17880691 ] Julian Hyde commented on CALCITE-6566: -- Reviewing the PR: * I think you should ge

[jira] [Updated] (CALCITE-6566) JDBC adapter should generate PI function with parentheses in most dialects

2024-09-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6566: - Summary: JDBC adapter should generate PI function with parentheses in most dialects (was: JDBC

[jira] [Comment Edited] (CALCITE-6550) Improve SQL function overloading

2024-09-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17880452#comment-17880452 ] Julian Hyde edited comment on CALCITE-6550 at 9/9/24 11:21 PM: --

[jira] [Updated] (CALCITE-6550) Improve SQL function overloading

2024-09-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6550: - Fix Version/s: 1.38.0 > Improve SQL function overloading > > >

[jira] [Commented] (CALCITE-6550) Improve SQL function overloading

2024-09-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17880452#comment-17880452 ] Julian Hyde commented on CALCITE-6550: -- [~njordan],Thanks for raising this. I see

[jira] [Commented] (CALCITE-6566) PI function without parentheses shoud failed

2024-09-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17880396#comment-17880396 ] Julian Hyde commented on CALCITE-6566: -- In Calcite SQL, a function with no argumen

[jira] [Resolved] (CALCITE-6559) Query with measure that applies AVG to SMALLINT throws AssertionError "Cannot add expression of different type to set"

2024-09-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6559?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6559. -- Resolution: Fixed Fixed in [ded06515| https://github.com/apache/calcite/commit/ded0651582b73

[jira] [Assigned] (CALCITE-6557) AggregateMergeRule throws 'type mismatch' AssertionError

2024-09-05 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-6557: Assignee: Julian Hyde > AggregateMergeRule throws 'type mismatch' AssertionError > -

[jira] [Updated] (CALCITE-6557) AggregateMergeRule throws 'type mismatch' AssertionError

2024-09-05 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6557: - Summary: AggregateMergeRule throws 'type mismatch' AssertionError (was: Type Assertion Error I

[jira] [Commented] (CALCITE-6406) Negative scales for DECIMAL types are not tested

2024-09-05 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17879658#comment-17879658 ] Julian Hyde commented on CALCITE-6406: -- This should be done as part of CALCITE-656

[jira] [Commented] (CALCITE-6560) Add supportsNegativeScale in RelDataTypeSystem

2024-09-05 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17879631#comment-17879631 ] Julian Hyde commented on CALCITE-6560: -- As I commented in the PR, and also in CALC

[jira] [Created] (CALCITE-6564) Support queries with measures on top of a VALUES relation

2024-09-05 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-6564: Summary: Support queries with measures on top of a VALUES relation Key: CALCITE-6564 URL: https://issues.apache.org/jira/browse/CALCITE-6564 Project: Calcite

[jira] [Updated] (CALCITE-6559) Query with measure that applies AVG to SMALLINT throws AssertionError "Cannot add expression of different type to set"

2024-09-05 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6559?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6559: - Summary: Query with measure that applies AVG to SMALLINT throws AssertionError "Cannot add expr

  1   2   3   4   5   6   7   8   9   10   >