[jira] [Commented] (CALCITE-6427) Use a higher precision for DECIMAL intermediate results for some aggregate functions like STDDEV

[ https://issues.apache.org/jira/browse/CALCITE-6427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17852205#comment-17852205 ] Mihai Budiu commented on CALCITE-6427: -- There are also aggregates like var_pop, which return a

[jira] [Resolved] (CALCITE-6428) Typo in adapter documentation

[ https://issues.apache.org/jira/browse/CALCITE-6428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6428. -- Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-6422) Query with '<>' throws NullPointerException during materialized view matching

[ https://issues.apache.org/jira/browse/CALCITE-6422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6422. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed by

[jira] [Commented] (CALCITE-6427) Use a higher precision for DECIMAL intermediate results for some aggregate functions like STDDEV

[ https://issues.apache.org/jira/browse/CALCITE-6427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17851858#comment-17851858 ] Mihai Budiu commented on CALCITE-6427: -- The code doing the expansion is in

[jira] [Created] (CALCITE-6427) Use a higher precision for DECIMAL intermediate results for some aggregate functions like STDDEV

Mihai Budiu created CALCITE-6427: Summary: Use a higher precision for DECIMAL intermediate results for some aggregate functions like STDDEV Key: CALCITE-6427 URL:

[jira] [Resolved] (CALCITE-6397) Add NVL2 function (enabled in Oracle, Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-6397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6397. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-6358) Support all PostgreSQL 14 date/time patterns for to_char

[ https://issues.apache.org/jira/browse/CALCITE-6358?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6358. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-6244) Improve `Expressions#constant` to allow Java records

[ https://issues.apache.org/jira/browse/CALCITE-6244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6244. -- Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-6244) Improve `Expressions#constant` to allow Java records

[ https://issues.apache.org/jira/browse/CALCITE-6244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17850782#comment-17850782 ] Mihai Budiu commented on CALCITE-6244: -- PR link: https://github.com/apache/calcite/pull/3681 >

[jira] [Commented] (CALCITE-6244) Improve `Expressions#constant` to allow Java records

[ https://issues.apache.org/jira/browse/CALCITE-6244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17850780#comment-17850780 ] Mihai Budiu commented on CALCITE-6244: -- As Julian said, you are supposed to use the same text for

[jira] [Commented] (CALCITE-6409) Char types and Boolean types are comparable

[ https://issues.apache.org/jira/browse/CALCITE-6409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17846119#comment-17846119 ] Mihai Budiu commented on CALCITE-6409: -- If this is an issue with NVL, it should be in the title of

[jira] [Resolved] (CALCITE-6313) Add POWER function for PostgreSQL

[ https://issues.apache.org/jira/browse/CALCITE-6313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6313. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in

[jira] (CALCITE-6392) Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp

[ https://issues.apache.org/jira/browse/CALCITE-6392 ] Mihai Budiu deleted comment on CALCITE-6392: -- was (Author: JIRAUSER295926): Fixed in https://github.com/apache/calcite/commit/4b73a2f15e1f14390cea47334b87e242377d2846. Thank you

[jira] [Reopened] (CALCITE-6392) Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp

[ https://issues.apache.org/jira/browse/CALCITE-6392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu reopened CALCITE-6392: -- I merged the wrong PR by mistake, reopening this issue > Support all PostgreSQL 14 date/time

[jira] [Resolved] (CALCITE-6392) Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp

[ https://issues.apache.org/jira/browse/CALCITE-6392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6392. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-6400) MAP_ENTRIES allows null as a map key

[ https://issues.apache.org/jira/browse/CALCITE-6400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17846050#comment-17846050 ] Mihai Budiu commented on CALCITE-6400: -- Is the spark error caused by map_entries or by the map

[jira] [Commented] (CALCITE-6409) Char types and Boolean types are comparable

[ https://issues.apache.org/jira/browse/CALCITE-6409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17846049#comment-17846049 ] Mihai Budiu commented on CALCITE-6409: -- I don't understand what this issue about. > Char types

[jira] [Resolved] (CALCITE-6389) RexBuilder.removeCastFromLiteral does not preserve semantics for some types of literals

[ https://issues.apache.org/jira/browse/CALCITE-6389?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6389. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in

[jira] [Created] (CALCITE-6407) DECIMAL types with scale > precision should be tested

Mihai Budiu created CALCITE-6407: Summary: DECIMAL types with scale > precision should be tested Key: CALCITE-6407 URL: https://issues.apache.org/jira/browse/CALCITE-6407 Project: Calcite

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

Mihai Budiu created CALCITE-6406: Summary: Negative scales for DECIMAL types are not tested Key: CALCITE-6406 URL: https://issues.apache.org/jira/browse/CALCITE-6406 Project: Calcite Issue

[jira] [Resolved] (CALCITE-5838) derive wrong decimal divide type

[ https://issues.apache.org/jira/browse/CALCITE-5838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-5838. -- Resolution: Not A Problem > derive wrong decimal divide type >

[jira] [Commented] (CALCITE-5838) derive wrong decimal divide type

[ https://issues.apache.org/jira/browse/CALCITE-5838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17845447#comment-17845447 ] Mihai Budiu commented on CALCITE-5838: -- I think this issue is invalid. Indeed, Calcite does not

[jira] [Resolved] (CALCITE-2565) Suspicious code in org.apache.calcite.rex.RexBuilder#makeCastIntervalToExact

[ https://issues.apache.org/jira/browse/CALCITE-2565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-2565. -- Resolution: Invalid This issue seems to no longer be valid. > Suspicious code in

[jira] [Commented] (CALCITE-6397) Add NVL2 function (enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-6397?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17845441#comment-17845441 ] Mihai Budiu commented on CALCITE-6397: -- The Spark specification should be your guideline. If

[jira] [Resolved] (CALCITE-6365) Support for RETURNING clause of JSON_QUERY

[ https://issues.apache.org/jira/browse/CALCITE-6365?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6365. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-6404) update support subquery

[ https://issues.apache.org/jira/browse/CALCITE-6404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17845435#comment-17845435 ] Mihai Budiu commented on CALCITE-6404: -- In this case you should probably update the title of this

[jira] [Resolved] (CALCITE-6382) Type inference for SqlLeadLagAggFunction is incorrect

[ https://issues.apache.org/jira/browse/CALCITE-6382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6382. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-6404) update support subquery

[ https://issues.apache.org/jira/browse/CALCITE-6404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17845070#comment-17845070 ] Mihai Budiu commented on CALCITE-6404: -- According to the reference grammar

[jira] [Commented] (CALCITE-6403) Rule AGGREGATE_EXPAND_DISTINCT_AGGREGATES is unsound

[ https://issues.apache.org/jira/browse/CALCITE-6403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17844802#comment-17844802 ] Mihai Budiu commented on CALCITE-6403: -- In this instance indeed I have applied the rule to a plan

[jira] [Commented] (CALCITE-6392) Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp

[ https://issues.apache.org/jira/browse/CALCITE-6392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17844792#comment-17844792 ] Mihai Budiu commented on CALCITE-6392: -- 1 makes sense. You could also consider adding only a few

[jira] [Updated] (CALCITE-6403) Rule AGGREGATE_EXPAND_DISTINCT_AGGREGATES is unsound

[ https://issues.apache.org/jira/browse/CALCITE-6403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6403: - Description: Here is a simple SQL program that operates on a collection with no input rows:

[jira] [Created] (CALCITE-6403) Rule AGGREGATE_EXPAND_DISTINCT_AGGREGATES is unsound

Mihai Budiu created CALCITE-6403: Summary: Rule AGGREGATE_EXPAND_DISTINCT_AGGREGATES is unsound Key: CALCITE-6403 URL: https://issues.apache.org/jira/browse/CALCITE-6403 Project: Calcite

[jira] [Commented] (CALCITE-5328) The rule of AGGREGATE_EXPAND_DISTINCT_AGGREGATES_TO_JOIN throws error when meeting the rollup's query

[ https://issues.apache.org/jira/browse/CALCITE-5328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17844789#comment-17844789 ] Mihai Budiu commented on CALCITE-5328: -- If that is true, we should probably resolve this issue >

[jira] [Commented] (CALCITE-5328) The rule of AGGREGATE_EXPAND_DISTINCT_AGGREGATES_TO_JOIN throws error when meeting the rollup's query

[ https://issues.apache.org/jira/browse/CALCITE-5328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17844788#comment-17844788 ] Mihai Budiu commented on CALCITE-5328: -- I think that the fix for [CALCITE-6332] will take care of

[jira] [Resolved] (CALCITE-6395) Significant precision loss when representing REAL literals

[ https://issues.apache.org/jira/browse/CALCITE-6395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6395. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-6377) Time expression causes IllegalStateException

[ https://issues.apache.org/jira/browse/CALCITE-6377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6377. -- Fix Version/s: 1.38.0 Assignee: Mihai Budiu Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-6389) RexBuilder.removeCastFromLiteral does not preserve semantics for some types of literals

[ https://issues.apache.org/jira/browse/CALCITE-6389?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6389: - Labels: pull-request-available (was: ) > RexBuilder.removeCastFromLiteral does not preserve

[jira] [Updated] (CALCITE-6382) Type inference for SqlLeadLagAggFunction is incorrect

[ https://issues.apache.org/jira/browse/CALCITE-6382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6382: - Description: Currently the LeadLag operator does not use the default value when inferring the

[jira] [Resolved] (CALCITE-6361) Uncollect.deriveUncollectRowType throws AssertionFailure if the input data is not a collection

[ https://issues.apache.org/jira/browse/CALCITE-6361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6361. -- Fix Version/s: 1.38.0 Assignee: Mihai Budiu Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-6361) Uncollect.deriveUncollectRowType throws AssertionFailure if the input data is not a collection

[ https://issues.apache.org/jira/browse/CALCITE-6361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6361: - Summary: Uncollect.deriveUncollectRowType throws AssertionFailure if the input data is not a

[jira] [Resolved] (CALCITE-6383) The class SameOperandTypeChecker is incorrectly documented

[ https://issues.apache.org/jira/browse/CALCITE-6383?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6383. -- Fix Version/s: 1.38.0 Resolution: Fixed Resolved in

[jira] [Commented] (CALCITE-6207) Improve connection resource in JDBCUtils

[ https://issues.apache.org/jira/browse/CALCITE-6207?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17844363#comment-17844363 ] Mihai Budiu commented on CALCITE-6207: -- The version change just mean that we haven't merged this

[jira] [Resolved] (CALCITE-6376) Selecting 6 columns with QUALIFY operation results in exception

[ https://issues.apache.org/jira/browse/CALCITE-6376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6376. -- Fix Version/s: 1.38.0 Assignee: Mihai Budiu (was: ShenDa) Resolution: Fixed

[jira] [Created] (CALCITE-6395) Significant precision loss when representing REAL literals

Mihai Budiu created CALCITE-6395: Summary: Significant precision loss when representing REAL literals Key: CALCITE-6395 URL: https://issues.apache.org/jira/browse/CALCITE-6395 Project: Calcite

[jira] [Resolved] (CALCITE-5795) Type inference for VALUES with numeric values infers incorrect scale

[ https://issues.apache.org/jira/browse/CALCITE-5795?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-5795. -- Resolution: Cannot Reproduce Maybe this got fixed as a side-effect of some other changes? >

[jira] [Commented] (CALCITE-6376) Selecting 6 columns with QUALIFY operation results in exception

[ https://issues.apache.org/jira/browse/CALCITE-6376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17842479#comment-17842479 ] Mihai Budiu commented on CALCITE-6376: -- I have renamed this issue, the CTE does not seem to be

[jira] [Updated] (CALCITE-6376) Selecting 6 columns with QUALIFY operation results in exception

[ https://issues.apache.org/jira/browse/CALCITE-6376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6376: - Summary: Selecting 6 columns with QUALIFY operation results in exception (was: Filtering CTE

[jira] [Updated] (CALCITE-6389) RexBuilder.removeCastFromLiteral does not preserve semantics for some types of literals

[ https://issues.apache.org/jira/browse/CALCITE-6389?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6389: - Summary: RexBuilder.removeCastFromLiteral does not preserve semantics for some types of

[jira] [Commented] (CALCITE-6300) Function MAP_VALUES/MAP_KEYS gives exception when mapVauleType and mapKeyType not equals map Biggest mapKeytype or mapValueType

[ https://issues.apache.org/jira/browse/CALCITE-6300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17841552#comment-17841552 ] Mihai Budiu commented on CALCITE-6300: -- [~julianhyde], you may know the answer to this question

[jira] [Commented] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17841550#comment-17841550 ] Mihai Budiu commented on CALCITE-5634: -- According to

[jira] [Created] (CALCITE-6389) RexBuilder.removeCastFromLiteral does not preserve semantics for decimal literals

Mihai Budiu created CALCITE-6389: Summary: RexBuilder.removeCastFromLiteral does not preserve semantics for decimal literals Key: CALCITE-6389 URL: https://issues.apache.org/jira/browse/CALCITE-6389

[jira] [Updated] (CALCITE-6383) The class SameOperandTypeChecker is incorrectly documented

[ https://issues.apache.org/jira/browse/CALCITE-6383?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6383: - Summary: The class SameOperandTypeChecker is incorrectly documented (was: The class

[jira] [Created] (CALCITE-6383) The class SameOperandTypeChecker is incorrectly named and documented

Mihai Budiu created CALCITE-6383: Summary: The class SameOperandTypeChecker is incorrectly named and documented Key: CALCITE-6383 URL: https://issues.apache.org/jira/browse/CALCITE-6383 Project:

[jira] [Created] (CALCITE-6382) Type inference for SqlLeadLagAggFunction is incorrect

Mihai Budiu created CALCITE-6382: Summary: Type inference for SqlLeadLagAggFunction is incorrect Key: CALCITE-6382 URL: https://issues.apache.org/jira/browse/CALCITE-6382 Project: Calcite

[jira] [Commented] (CALCITE-6373) Distinct optimization produces broken sql query

[ https://issues.apache.org/jira/browse/CALCITE-6373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17840146#comment-17840146 ] Mihai Budiu commented on CALCITE-6373: -- Do you plan to contribute the code to Calcite? I think

[jira] [Created] (CALCITE-6380) Casts from INTERVAL and STRING to DECIMAL are incorrect

Mihai Budiu created CALCITE-6380: Summary: Casts from INTERVAL and STRING to DECIMAL are incorrect Key: CALCITE-6380 URL: https://issues.apache.org/jira/browse/CALCITE-6380 Project: Calcite

[jira] [Created] (CALCITE-6379) Arithmetic in Calcite does not produce results with the expected type

Mihai Budiu created CALCITE-6379: Summary: Arithmetic in Calcite does not produce results with the expected type Key: CALCITE-6379 URL: https://issues.apache.org/jira/browse/CALCITE-6379 Project:

[jira] [Commented] (CALCITE-6361) Uncollect.deriveUncollectRowType crashes if the input data is not a collection

[ https://issues.apache.org/jira/browse/CALCITE-6361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17839124#comment-17839124 ] Mihai Budiu commented on CALCITE-6361: -- What I find strange here is that the row type is derived

[jira] [Commented] (CALCITE-6361) Uncollect.deriveUncollectRowType crashes if the input data is not a collection

[ https://issues.apache.org/jira/browse/CALCITE-6361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17839121#comment-17839121 ] Mihai Budiu commented on CALCITE-6361: -- I have managed to create a small reproduction for this.

[jira] [Commented] (CALCITE-6322) Casts to DECIMAL types are ignored

[ https://issues.apache.org/jira/browse/CALCITE-6322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17839110#comment-17839110 ] Mihai Budiu commented on CALCITE-6322: -- See also

[jira] [Created] (CALCITE-6377) Time expression causes IllegalStateException

Mihai Budiu created CALCITE-6377: Summary: Time expression causes IllegalStateException Key: CALCITE-6377 URL: https://issues.apache.org/jira/browse/CALCITE-6377 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-6322) Casts to DECIMAL types are ignored

[ https://issues.apache.org/jira/browse/CALCITE-6322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17839069#comment-17839069 ] Mihai Budiu commented on CALCITE-6322: -- Indeed, the two PRs address the same problem. I wasn't

[jira] [Resolved] (CALCITE-5289) Assertion failure in MultiJoinOptimizeBushyRule

[ https://issues.apache.org/jira/browse/CALCITE-5289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-5289. -- Resolution: Fixed Fixed in

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

[ https://issues.apache.org/jira/browse/CALCITE-6345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6345. -- Fix Version/s: 1.37.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-6371) Add ability to configure RexExecutable behavior on exceptions

[ https://issues.apache.org/jira/browse/CALCITE-6371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17838299#comment-17838299 ] Mihai Budiu commented on CALCITE-6371: -- Strictly speaking these are not literals, but expressions

[jira] [Created] (CALCITE-6372) Support ASOF joins

Mihai Budiu created CALCITE-6372: Summary: Support ASOF joins Key: CALCITE-6372 URL: https://issues.apache.org/jira/browse/CALCITE-6372 Project: Calcite Issue Type: New Feature

[jira] [Resolved] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6265. -- Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-6366) Code generated by EnumUtils#convert should throw an exception if the target type is overflowed

[ https://issues.apache.org/jira/browse/CALCITE-6366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17837356#comment-17837356 ] Mihai Budiu commented on CALCITE-6366: -- I have submitted (at least a partial) fix in

[jira] [Commented] (CALCITE-6367) Add timezone support for FORMAT clause in CAST (enabled in BigQuery)

[ https://issues.apache.org/jira/browse/CALCITE-6367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17837353#comment-17837353 ] Mihai Budiu commented on CALCITE-6367: -- Partial support for date time/times with timezone has been

[jira] [Commented] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836721#comment-17836721 ] Mihai Budiu commented on CALCITE-6265: -- Tangentially related, I have a fix that implements

[jira] [Commented] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836719#comment-17836719 ] Mihai Budiu commented on CALCITE-6265: -- [~tnieradzik] can you check that this new proposed fix

[jira] [Commented] (CALCITE-6361) Uncollect.deriveUncollectRowType crashes if the input data is not a collection

[ https://issues.apache.org/jira/browse/CALCITE-6361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836363#comment-17836363 ] Mihai Budiu commented on CALCITE-6361: -- This is an assertion failure: {code:java}

[jira] [Commented] (CALCITE-6362) JSON_OBJECT. Internal representation DATE values leaks into resulting JSON object

[ https://issues.apache.org/jira/browse/CALCITE-6362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836274#comment-17836274 ] Mihai Budiu commented on CALCITE-6362: -- I guess that the spec for JSON_OBJECT is not really clear

[jira] [Commented] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17836260#comment-17836260 ] Mihai Budiu commented on CALCITE-6265: -- It looks to me like the right course of action is to file

[jira] [Created] (CALCITE-6361) Uncollect.deriveUncollectRowType crashes if the input data is not a collection

Mihai Budiu created CALCITE-6361: Summary: Uncollect.deriveUncollectRowType crashes if the input data is not a collection Key: CALCITE-6361 URL: https://issues.apache.org/jira/browse/CALCITE-6361

[jira] [Resolved] (CALCITE-6355) RelToSqlConverter[ORDER BY] generates an incorrect order by when NULLS LAST is used in non-projected field

[ https://issues.apache.org/jira/browse/CALCITE-6355?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6355. -- Fix Version/s: 1.37.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-6286) Optimizing ARRAY_REPEAT expression causes an assertion failure

[ https://issues.apache.org/jira/browse/CALCITE-6286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6286. -- Fix Version/s: 1.37.0 Resolution: Fixed > Optimizing ARRAY_REPEAT expression causes

[jira] [Resolved] (CALCITE-6210) Cast to VARBINARY causes an assertion failure

[ https://issues.apache.org/jira/browse/CALCITE-6210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6210. -- Resolution: Fixed > Cast to VARBINARY causes an assertion failure >

[jira] [Commented] (CALCITE-6210) Cast to VARBINARY causes an assertion failure

[ https://issues.apache.org/jira/browse/CALCITE-6210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17835830#comment-17835830 ] Mihai Budiu commented on CALCITE-6210: -- Fixed in

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

[ https://issues.apache.org/jira/browse/CALCITE-6315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6315. -- Fix Version/s: 1.37.0 Resolution: Fixed Fixed in

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

[ https://issues.apache.org/jira/browse/CALCITE-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17835548#comment-17835548 ] Mihai Budiu commented on CALCITE-6327: -- You don't need to assign it, but if you are confident the

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

[ https://issues.apache.org/jira/browse/CALCITE-6315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6315: - Summary: Support PostgreSQL TO_DATE, TO_TIMESTAMP (was: Support PostgreSQL TO_CHAR, TO_DATE,

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

[ https://issues.apache.org/jira/browse/CALCITE-6349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6349. -- Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-6333) Queries with distinct aggregations with filter throw NPE when planned using joins

[ https://issues.apache.org/jira/browse/CALCITE-6333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6333. -- Fix Version/s: 1.37.0 Resolution: Fixed Fixed in

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

[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6285. -- Fix Version/s: 1.37.0 Resolution: Fixed Fixed in

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

[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6309. -- Resolution: Fixed Fixed in

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

[ https://issues.apache.org/jira/browse/CALCITE-6332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6332. -- Fix Version/s: 1.37.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-6353) Optimization CoreRules.PROJECT_REDUCE_EXPRESSIONS crashes while optimizing ARRAY_CONCAT expression

[ https://issues.apache.org/jira/browse/CALCITE-6353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6353. -- Fix Version/s: 1.37.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6265. -- Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-6353) Optimization CoreRules.PROJECT_REDUCE_EXPRESSIONS crashes while optimizing ARRAY_CONCAT expression

[ https://issues.apache.org/jira/browse/CALCITE-6353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17834084#comment-17834084 ] Mihai Budiu commented on CALCITE-6353: -- This actually is a combination of 3 bugs. Two are in the

[jira] [Created] (CALCITE-6353) Optimization CoreRules.PROJECT_REDUCE_EXPRESSIONS crashes while optimizing ARRAY_CONCAT expression

Mihai Budiu created CALCITE-6353: Summary: Optimization CoreRules.PROJECT_REDUCE_EXPRESSIONS crashes while optimizing ARRAY_CONCAT expression Key: CALCITE-6353 URL:

[jira] [Updated] (CALCITE-6322) Casts to DECIMAL types are ignored

[ https://issues.apache.org/jira/browse/CALCITE-6322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6322: - Fix Version/s: 1.37.0 > Casts to DECIMAL types are ignored >

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

[ https://issues.apache.org/jira/browse/CALCITE-6348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6348. -- Resolution: Fixed Fixed by

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

[ https://issues.apache.org/jira/browse/CALCITE-6347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6347. -- Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-6352) The map_contains_key function may return true when the key and mapkeytype types are different.

[ https://issues.apache.org/jira/browse/CALCITE-6352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17834028#comment-17834028 ] Mihai Budiu commented on CALCITE-6352: -- To decide whether this program is correct you have first

[jira] [Comment Edited] (CALCITE-6352) The map_contains_key function may return true when the key and mapkeytype types are different.

[ https://issues.apache.org/jira/browse/CALCITE-6352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17834028#comment-17834028 ] Mihai Budiu edited comment on CALCITE-6352 at 4/4/24 5:05 PM: -- To decide

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

[ https://issues.apache.org/jira/browse/CALCITE-6345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6345: - Issue Type: Improvement (was: Bug) > Intervals with more than 100 years are not supported >

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

[ https://issues.apache.org/jira/browse/CALCITE-6345?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17833711#comment-17833711 ] Mihai Budiu commented on CALCITE-6345: -- It turns out that there is a way to get intervals longer

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

[ https://issues.apache.org/jira/browse/CALCITE-6321?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17833042#comment-17833042 ] Mihai Budiu commented on CALCITE-6321: -- Fixed by

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

[ 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) > Optimization

  1   2   3   4   5   6   >