[jira] [Closed] (CALCITE-5481) Release Calcite 1.33.0

[ https://issues.apache.org/jira/browse/CALCITE-5481?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5481. Resolution: Fixed > Release Calcite 1.33.0 > -- > > Key:

[jira] [Closed] (CALCITE-5360) Implement TIMESTAMP_ADD function (compatible with BigQuery)

[ https://issues.apache.org/jira/browse/CALCITE-5360?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5360. Resolved in release 1.33.0 (2023-02-06) > Implement TIMESTAMP_ADD function (compatible with

[jira] [Closed] (CALCITE-5391) JoinOnUniqueToSemiJoinRule should preserve field names, if possible

[ https://issues.apache.org/jira/browse/CALCITE-5391?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5391. Resolved in release 1.33.0 (2023-02-06) > JoinOnUniqueToSemiJoinRule should preserve field names,

[jira] [Closed] (CALCITE-5296) In a query with ROLLUP, validator wrongly infers that a column is NOT NULL

[ https://issues.apache.org/jira/browse/CALCITE-5296?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5296. Resolved in release 1.33.0 (2023-02-06) > In a query with ROLLUP, validator wrongly infers that a

[jira] [Closed] (CALCITE-5286) Join with parameterized LIMIT throws AssertionError "not a literal"

[ https://issues.apache.org/jira/browse/CALCITE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5286. Resolved in release 1.33.0 (2023-02-06) > Join with parameterized LIMIT throws AssertionError "not

[jira] [Closed] (CALCITE-5239) Site: JDBC Adapter's current limitations is incorrect

[ https://issues.apache.org/jira/browse/CALCITE-5239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5239. Resolved in release 1.33.0 (2023-02-06) > Site: JDBC Adapter's current limitations is incorrect >

[jira] [Closed] (CALCITE-5427) Provide code quality/coverage metrics with SonarCloud and JaCoCo

[ https://issues.apache.org/jira/browse/CALCITE-5427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5427. Resolved in release 1.33.0 (2023-02-06) > Provide code quality/coverage metrics with SonarCloud and

[jira] [Closed] (CALCITE-5388) tempList expression inside EnumerableWindow.getPartitionIterator should be unoptimized

[ https://issues.apache.org/jira/browse/CALCITE-5388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5388. Resolved in release 1.33.0 (2023-02-06) > tempList expression inside

[jira] [Closed] (CALCITE-4186) Add ST_CoveredBy spatial function

[ https://issues.apache.org/jira/browse/CALCITE-4186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-4186. Resolved in release 1.33.0 (2023-02-06) > Add ST_CoveredBy spatial function >

[jira] [Closed] (CALCITE-5393) VALUE as an synonym for VALUES keyword (enabled in MySQL conformance)

[ https://issues.apache.org/jira/browse/CALCITE-5393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5393. Resolved in release 1.33.0 (2023-02-06) > VALUE as an synonym for VALUES keyword (enabled in MySQL

[jira] [Closed] (CALCITE-5336) Support inferring constants from predicates with IS NOT DISTINCT FROM operator

[ https://issues.apache.org/jira/browse/CALCITE-5336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5336. Resolved in release 1.33.0 (2023-02-06) > Support inferring constants from predicates with IS NOT

[jira] [Closed] (CALCITE-5281) Implement geometry set returning functions (SRF)

[ https://issues.apache.org/jira/browse/CALCITE-5281?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5281. Resolved in release 1.33.0 (2023-02-06) > Implement geometry set returning functions (SRF) >

[jira] [Closed] (CALCITE-5452) Add BigQuery LENGTH() as synonym for CHAR_LENGTH()

[ https://issues.apache.org/jira/browse/CALCITE-5452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5452. Resolved in release 1.33.0 (2023-02-06) > Add BigQuery LENGTH() as synonym for CHAR_LENGTH() >

[jira] [Closed] (CALCITE-5230) Return type of PERCENTILE_DISC should be the same as sort expression

[ https://issues.apache.org/jira/browse/CALCITE-5230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5230. Resolved in release 1.33.0 (2023-02-06) > Return type of PERCENTILE_DISC should be the same as sort

[jira] [Closed] (CALCITE-5362) Implement geometry measurement functions

[ https://issues.apache.org/jira/browse/CALCITE-5362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5362. Resolved in release 1.33.0 (2023-02-06) > Implement geometry measurement functions >

[jira] [Closed] (CALCITE-5417) Include Proj4J as an api dependency once the license allows it

[ https://issues.apache.org/jira/browse/CALCITE-5417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5417. Resolved in release 1.33.0 (2023-02-06) > Include Proj4J as an api dependency once the license

[jira] [Closed] (CALCITE-5337) UnionPullUpConstantsRule produces an invalid plan when pulling up constants for nullable fields

[ https://issues.apache.org/jira/browse/CALCITE-5337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5337. Resolved in release 1.33.0 (2023-02-06) > UnionPullUpConstantsRule produces an invalid plan when

[jira] [Closed] (CALCITE-5394) RelToSql converter fails when semi-join is under a join node

[ https://issues.apache.org/jira/browse/CALCITE-5394?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5394. Resolved in release 1.33.0 (2023-02-06) > RelToSql converter fails when semi-join is under a join

[jira] [Closed] (CALCITE-5410) Assertion error on PERCENT_REMAINDER operator with DECIMAL type

[ https://issues.apache.org/jira/browse/CALCITE-5410?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5410. Resolved in release 1.33.0 (2023-02-06) > Assertion error on PERCENT_REMAINDER operator with

[jira] [Closed] (CALCITE-5339) Use Method#getParameterCount rather than Method#getParameters to get length

[ https://issues.apache.org/jira/browse/CALCITE-5339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5339. Resolved in release 1.33.0 (2023-02-06) > Use Method#getParameterCount rather than

[jira] [Closed] (CALCITE-5466) Constant condition can't be reduced after correlate

[ https://issues.apache.org/jira/browse/CALCITE-5466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5466. Resolved in release 1.33.0 (2023-02-06) > Constant condition can't be reduced after correlate >

[jira] [Closed] (CALCITE-5253) NATURAL join and USING should fail if join columns are not unique - expression validation partially broken

[ https://issues.apache.org/jira/browse/CALCITE-5253?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5253. Resolved in release 1.33.0 (2023-02-06) > NATURAL join and USING should fail if join columns are

[jira] [Closed] (CALCITE-5209) Proper sub-query handling if it is used inside select list and group by

[ https://issues.apache.org/jira/browse/CALCITE-5209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5209. Resolved in release 1.33.0 (2023-02-06) > Proper sub-query handling if it is used inside select

[jira] [Closed] (CALCITE-5141) Incomplete implicit type conversion for insert values

[ https://issues.apache.org/jira/browse/CALCITE-5141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5141. Resolved in release 1.33.0 (2023-02-06) > Incomplete implicit type conversion for insert values >

[jira] [Closed] (CALCITE-5351) Bump jackson to 2.13.4 and jackson databind to 2.13.4.2 to avoid CVEs

[ https://issues.apache.org/jira/browse/CALCITE-5351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5351. Resolved in release 1.33.0 (2023-02-06) > Bump jackson to 2.13.4 and jackson databind to 2.13.4.2

[jira] [Closed] (CALCITE-5454) Update BigQuery Conformance for != and % operators

[ https://issues.apache.org/jira/browse/CALCITE-5454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5454. Resolved in release 1.33.0 (2023-02-06) > Update BigQuery Conformance for != and % operators >

[jira] [Closed] (CALCITE-5159) ARRAY string constructor, and implicit cast from string literal (enabled in PostgreSQL conformance)

[ https://issues.apache.org/jira/browse/CALCITE-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5159. Resolved in release 1.33.0 (2023-02-06) > ARRAY string constructor, and implicit cast from string

[jira] [Closed] (CALCITE-5252) JDBC adapter sometimes miss parentheses around SELECT in WITH_ITEM body

[ https://issues.apache.org/jira/browse/CALCITE-5252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5252. Resolved in release 1.33.0 (2023-02-06) > JDBC adapter sometimes miss parentheses around SELECT in

[jira] [Closed] (CALCITE-5314) Prune empty parts of a query by exploiting stats/metadata

[ https://issues.apache.org/jira/browse/CALCITE-5314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5314. Resolved in release 1.33.0 (2023-02-06) > Prune empty parts of a query by exploiting stats/metadata

[jira] [Closed] (CALCITE-5491) Allow TIME and DATE to be args for TIMESTAMPDIFF

[ https://issues.apache.org/jira/browse/CALCITE-5491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5491. Resolved in release 1.33.0 (2023-02-06) > Allow TIME and DATE to be args for TIMESTAMPDIFF >

[jira] [Closed] (CALCITE-5342) Refactor SqlFunctions lastDay, addMonths, subtractMonths to use DateTimeUtils from Avatica

[ https://issues.apache.org/jira/browse/CALCITE-5342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5342. Resolved in release 1.33.0 (2023-02-06) > Refactor SqlFunctions lastDay, addMonths, subtractMonths

[jira] [Closed] (CALCITE-5269) Implement BigQuery TIME_TRUNC and TIMESTAMP_TRUNC functions

[ https://issues.apache.org/jira/browse/CALCITE-5269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5269. Resolved in release 1.33.0 (2023-02-06) > Implement BigQuery TIME_TRUNC and TIMESTAMP_TRUNC

[jira] [Closed] (CALCITE-5127) Support correlation variables in Project

[ https://issues.apache.org/jira/browse/CALCITE-5127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5127. Resolved in release 1.33.0 (2023-02-06) > Support correlation variables in Project >

[jira] [Closed] (CALCITE-5433) Druid tests hang/fail intermittently in CI

[ https://issues.apache.org/jira/browse/CALCITE-5433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5433. Resolved in release 1.33.0 (2023-02-06) > Druid tests hang/fail intermittently in CI >

[jira] [Closed] (CALCITE-5432) Implement BigQuery TIME_ADD/TIME_DIFF

[ https://issues.apache.org/jira/browse/CALCITE-5432?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5432. Resolved in release 1.33.0 (2023-02-06) > Implement BigQuery TIME_ADD/TIME_DIFF >

[jira] [Closed] (CALCITE-5474) Disable Sonar quality gates to avoid checks appearing as failures

[ https://issues.apache.org/jira/browse/CALCITE-5474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5474. Resolved in release 1.33.0 (2023-02-06) > Disable Sonar quality gates to avoid checks appearing as

[jira] [Closed] (CALCITE-5276) Implicitly convert strings to geometries

[ https://issues.apache.org/jira/browse/CALCITE-5276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5276. Resolved in release 1.33.0 (2023-02-06) > Implicitly convert strings to geometries >

[jira] [Closed] (CALCITE-5451) Implement LPAD() and RPAD() functions

[ https://issues.apache.org/jira/browse/CALCITE-5451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5451. Resolved in release 1.33.0 (2023-02-06) > Implement LPAD() and RPAD() functions >

[jira] [Closed] (CALCITE-5405) MongoDB: Invalid TIMESTAMP conversion

[ https://issues.apache.org/jira/browse/CALCITE-5405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5405. Resolved in release 1.33.0 (2023-02-06) > MongoDB: Invalid TIMESTAMP conversion >

[jira] [Closed] (CALCITE-5450) Add support for WEEK(WEEKDAY) for custom time frames to relevant functions

[ https://issues.apache.org/jira/browse/CALCITE-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5450. Resolved in release 1.33.0 (2023-02-06) > Add support for WEEK(WEEKDAY) for custom time frames to

[jira] [Closed] (CALCITE-5326) SqlMerge generate extra bracket on toSqlString

[ https://issues.apache.org/jira/browse/CALCITE-5326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5326. Resolved in release 1.33.0 (2023-02-06) > SqlMerge generate extra bracket on toSqlString >

[jira] [Closed] (CALCITE-5428) Reduce minimum Guava version to 16.0.1

[ https://issues.apache.org/jira/browse/CALCITE-5428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5428. Resolved in release 1.33.0 (2023-02-06) > Reduce minimum Guava version to 16.0.1 >

[jira] [Closed] (CALCITE-5424) Customize handling of literals based on type system

[ https://issues.apache.org/jira/browse/CALCITE-5424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5424. Resolved in release 1.33.0 (2023-02-06) > Customize handling of literals based on type system >

[jira] [Closed] (CALCITE-5217) Implement unparseSqlIntervalLiteral in the Firebolt dialect

[ https://issues.apache.org/jira/browse/CALCITE-5217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5217. Resolved in release 1.33.0 (2023-02-06) > Implement unparseSqlIntervalLiteral in the Firebolt

[jira] [Closed] (CALCITE-5436) Implement DATE_SUB, TIME_SUB, TIMESTAMP_SUB (compatible w/ BigQuery)

[ https://issues.apache.org/jira/browse/CALCITE-5436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5436. Resolved in release 1.33.0 (2023-02-06) > Implement DATE_SUB, TIME_SUB, TIMESTAMP_SUB (compatible

[jira] [Closed] (CALCITE-5332) Configuring PruneEmptyRules is cumbersome

[ https://issues.apache.org/jira/browse/CALCITE-5332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5332. Resolved in release 1.33.0 (2023-02-06) > Configuring PruneEmptyRules is cumbersome >

[jira] [Closed] (CALCITE-5495) Allow WEEK and QUARTER in INTERVAL literals

[ https://issues.apache.org/jira/browse/CALCITE-5495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5495. Resolved in release 1.33.0 (2023-02-06) > Allow WEEK and QUARTER in INTERVAL literals >

[jira] [Closed] (CALCITE-5105) Add MEASURE type and AGGREGATE aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-5105?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5105. Resolved in release 1.33.0 (2023-02-06) > Add MEASURE type and AGGREGATE aggregate function >

[jira] [Closed] (CALCITE-4632) Exception in RelToSqlConverter: "Cannot convert x to DECIMAL(n, m) due to overflow"

[ https://issues.apache.org/jira/browse/CALCITE-4632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-4632. Resolved in release 1.33.0 (2023-02-06) > Exception in RelToSqlConverter: "Cannot convert x to

[jira] [Closed] (CALCITE-5385) Add BigQuery as supported library for implemented functions

[ https://issues.apache.org/jira/browse/CALCITE-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5385. Resolved in release 1.33.0 (2023-02-06) > Add BigQuery as supported library for implemented

[jira] [Closed] (CALCITE-5294) Prune the null-generating side of an outer join if it is empty

[ https://issues.apache.org/jira/browse/CALCITE-5294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5294. Resolved in release 1.33.0 (2023-02-06) > Prune the null-generating side of an outer join if it is

[jira] [Closed] (CALCITE-5447) Add DATE_TRUNC for BigQuery

[ https://issues.apache.org/jira/browse/CALCITE-5447?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5447. Resolved in release 1.33.0 (2023-02-06) > Add DATE_TRUNC for BigQuery > ---

[jira] [Closed] (CALCITE-5299) JDBC adapter sometimes adds unnecessary parentheses around SELECT in WITH body

[ https://issues.apache.org/jira/browse/CALCITE-5299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5299. Resolved in release 1.33.0 (2023-02-06) > JDBC adapter sometimes adds unnecessary parentheses

[jira] [Closed] (CALCITE-5298) CalciteSystemProperty calcite.test.dataset path check fails under Java Security Manager

[ https://issues.apache.org/jira/browse/CALCITE-5298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5298. Resolved in release 1.33.0 (2023-02-06) > CalciteSystemProperty calcite.test.dataset path check

[jira] [Closed] (CALCITE-5399) Proj4J license is not compatible with Apache

[ https://issues.apache.org/jira/browse/CALCITE-5399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5399. Resolved in release 1.33.0 (2023-02-06) > Proj4J license is not compatible with Apache >

[jira] [Closed] (CALCITE-5407) MongoDB: Invalid ARRAY conversion

[ https://issues.apache.org/jira/browse/CALCITE-5407?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5407. Resolved in release 1.33.0 (2023-02-06) > MongoDB: Invalid ARRAY conversion >

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

[ https://issues.apache.org/jira/browse/CALCITE-5155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5155. Resolved in release 1.33.0 (2023-02-06) > Custom time frames > -- > >

[jira] [Closed] (CALCITE-5287) SQL reference page is missing from website

[ https://issues.apache.org/jira/browse/CALCITE-5287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5287. Resolved in release 1.33.0 (2023-02-06) > SQL reference page is missing from website >

[jira] [Closed] (CALCITE-5264) HintStrategy rule exclusion does not match innermost rels

[ https://issues.apache.org/jira/browse/CALCITE-5264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5264. Resolved in release 1.33.0 (2023-02-06) > HintStrategy rule exclusion does not match innermost rels

[jira] [Closed] (CALCITE-5267) Remove unused variable 'newCasts' in AggregateCaseToFilterRule

[ https://issues.apache.org/jira/browse/CALCITE-5267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5267. Resolved in release 1.33.0 (2023-02-06) > Remove unused variable 'newCasts' in

[jira] [Closed] (CALCITE-5493) Time zone tests in SqlFunctions should pass in Europe/London

[ https://issues.apache.org/jira/browse/CALCITE-5493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5493. Resolved in release 1.33.0 (2023-02-06) > Time zone tests in SqlFunctions should pass in

[jira] [Closed] (CALCITE-5197) Bump gradle to 7.4.2 and add checksum autoupdate

[ https://issues.apache.org/jira/browse/CALCITE-5197?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5197. Resolved in release 1.33.0 (2023-02-06) > Bump gradle to 7.4.2 and add checksum autoupdate >

[jira] [Closed] (CALCITE-5283) Add ARG_MIN, ARG_MAX (aka MIN_BY, MAX_BY) aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-5283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5283. Resolved in release 1.33.0 (2023-02-06) > Add ARG_MIN, ARG_MAX (aka MIN_BY, MAX_BY) aggregate

[jira] [Closed] (CALCITE-5395) RelToSql converter fails when SELECT * is under a semi-join node

[ https://issues.apache.org/jira/browse/CALCITE-5395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5395. Resolved in release 1.33.0 (2023-02-06) > RelToSql converter fails when SELECT * is under a

[jira] [Closed] (CALCITE-4982) Do not push 'cast to not null' through Join in ProjectJoinTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-4982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-4982. Resolved in release 1.33.0 (2023-02-06) > Do not push 'cast to not null' through Join in

[jira] [Closed] (CALCITE-5389) Add STARTS_WITH and ENDS_WITH functions (for BIG_QUERY compatibility)

[ https://issues.apache.org/jira/browse/CALCITE-5389?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5389. Resolved in release 1.33.0 (2023-02-06) > Add STARTS_WITH and ENDS_WITH functions (for BIG_QUERY

[jira] [Closed] (CALCITE-5356) Update junit4 to 4.13.2 and junit5 to 5.9.1

[ https://issues.apache.org/jira/browse/CALCITE-5356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5356. Resolved in release 1.33.0 (2023-02-06) > Update junit4 to 4.13.2 and junit5 to 5.9.1 >

[jira] [Closed] (CALCITE-5377) RelFieldTrimmer support Sort with dynamic param

[ https://issues.apache.org/jira/browse/CALCITE-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5377. Resolved in release 1.33.0 (2023-02-06) > RelFieldTrimmer support Sort with dynamic param >

[jira] [Closed] (CALCITE-5310) JSON_OBJECT in scalar sub-query throws AssertionError

[ https://issues.apache.org/jira/browse/CALCITE-5310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5310. Resolved in release 1.33.0 (2023-02-06) > JSON_OBJECT in scalar sub-query throws AssertionError >

[jira] [Closed] (CALCITE-5383) Update CONCAT function to allow BIG_QUERY

[ https://issues.apache.org/jira/browse/CALCITE-5383?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5383. Resolved in release 1.33.0 (2023-02-06) > Update CONCAT function to allow BIG_QUERY >

[jira] [Closed] (CALCITE-5489) When creating a RexCall to TIMESTAMP_DIFF function, cannot convert a TIMESTAMP literal to a org.apache.calcite.avatica.util.TimeUnit

[ https://issues.apache.org/jira/browse/CALCITE-5489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5489. Resolved in release 1.33.0 (2023-02-06) > When creating a RexCall to TIMESTAMP_DIFF function,

[jira] [Closed] (CALCITE-5349) RelJson should support non-standard operators

[ https://issues.apache.org/jira/browse/CALCITE-5349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5349. Resolved in release 1.33.0 (2023-02-06) > RelJson should support non-standard operators >

[jira] [Closed] (CALCITE-4351) RelMdUtil#numDistinctVals always returns 0 for large inputs

[ https://issues.apache.org/jira/browse/CALCITE-4351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-4351. Resolved in release 1.33.0 (2023-02-06) > RelMdUtil#numDistinctVals always returns 0 for large

[jira] [Closed] (CALCITE-5404) Implement BigQuery's POW() and TRUNC() math functions

[ https://issues.apache.org/jira/browse/CALCITE-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5404. Resolved in release 1.33.0 (2023-02-06) > Implement BigQuery's POW() and TRUNC() math functions >

[jira] [Closed] (CALCITE-5280) Implement geometry aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-5280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5280. Resolved in release 1.33.0 (2023-02-06) > Implement geometry aggregate functions >

[jira] [Closed] (CALCITE-5265) JDBC adapter sometimes adds unnecessary parentheses around SELECT in INSERT

[ https://issues.apache.org/jira/browse/CALCITE-5265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5265. Resolved in release 1.33.0 (2023-02-06) > JDBC adapter sometimes adds unnecessary parentheses

[jira] [Closed] (CALCITE-5348) When translating ORDER BY in OVER, use the session's default null collation (e.g. NULLS LAST)

[ https://issues.apache.org/jira/browse/CALCITE-5348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5348. Resolved in release 1.33.0 (2023-02-06) > When translating ORDER BY in OVER, use the session's

[jira] [Closed] (CALCITE-5471) RelSupplier.SqlRelSupplier#apply should use .project(), not .rel

[ https://issues.apache.org/jira/browse/CALCITE-5471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5471. Resolved in release 1.33.0 (2023-02-06) > RelSupplier.SqlRelSupplier#apply should use .project(),

[jira] [Closed] (CALCITE-5341) Upgrade Calcite to Avatica 1.23.0

[ https://issues.apache.org/jira/browse/CALCITE-5341?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5341. Resolved in release 1.33.0 (2023-02-06) > Upgrade Calcite to Avatica 1.23.0 >

[jira] [Closed] (CALCITE-5408) Return type of PERCENTILE_CONT should be the same as sort expression

[ https://issues.apache.org/jira/browse/CALCITE-5408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5408. Resolved in release 1.33.0 (2023-02-06) > Return type of PERCENTILE_CONT should be the same as sort

[jira] [Closed] (CALCITE-2884) Implement JSON_INSERT, JSON_REPLACE, JSON_SET

[ https://issues.apache.org/jira/browse/CALCITE-2884?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-2884. Resolved in release 1.33.0 (2023-02-06) > Implement JSON_INSERT, JSON_REPLACE, JSON_SET >

[jira] [Closed] (CALCITE-4972) Subfields of array columns containing structs are not qualified in getFieldOrigins

[ https://issues.apache.org/jira/browse/CALCITE-4972?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-4972. Resolved in release 1.33.0 (2023-02-06) > Subfields of array columns containing structs are not

[jira] [Closed] (CALCITE-5259) Add getParameterRowType method to Planner interface

[ https://issues.apache.org/jira/browse/CALCITE-5259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5259. Resolved in release 1.33.0 (2023-02-06) > Add getParameterRowType method to Planner interface >

[jira] [Closed] (CALCITE-4804) Support Snapshot operator serialization and deserialization

[ https://issues.apache.org/jira/browse/CALCITE-4804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-4804. Resolved in release 1.33.0 (2023-02-06) > Support Snapshot operator serialization and

[jira] [Closed] (CALCITE-5288) Expression '(a > 5 and a < 15) or (a > 10 and a < 20)' should be simplified to 'SEARCH(a, Sarg[(5..20)])'

[ https://issues.apache.org/jira/browse/CALCITE-5288?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5288. Resolved in release 1.33.0 (2023-02-06) > Expression '(a > 5 and a < 15) or (a > 10 and a < 20)'

[jira] [Closed] (CALCITE-5297) Casting dynamic variable twice throws exception

[ https://issues.apache.org/jira/browse/CALCITE-5297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5297. Resolved in release 1.33.0 (2023-02-06) > Casting dynamic variable twice throws exception >

[jira] [Closed] (CALCITE-5306) Remove JDK15/16 EOL non-LTS JDKs in CI

[ https://issues.apache.org/jira/browse/CALCITE-5306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5306. Resolved in release 1.33.0 (2023-02-06) > Remove JDK15/16 EOL non-LTS JDKs in CI >

[jira] [Closed] (CALCITE-5439) Validation of Pivot fails after creating a deep copy of SqlNode

[ https://issues.apache.org/jira/browse/CALCITE-5439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5439. Resolved in release 1.33.0 (2023-02-06) > Validation of Pivot fails after creating a deep copy of

[jira] [Closed] (CALCITE-5355) Use the Presto SQL dialect for AWS Athena

[ https://issues.apache.org/jira/browse/CALCITE-5355?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5355. Resolved in release 1.33.0 (2023-02-06) > Use the Presto SQL dialect for AWS Athena >

[jira] [Closed] (CALCITE-5293) Support general set operators in PruneEmptyRules

[ https://issues.apache.org/jira/browse/CALCITE-5293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5293. Resolved in release 1.33.0 (2023-02-06) > Support general set operators in PruneEmptyRules >

[jira] [Closed] (CALCITE-5392) Support Snapshot in RelMdExpressionLineage

[ https://issues.apache.org/jira/browse/CALCITE-5392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5392. Resolved in release 1.33.0 (2023-02-06) > Support Snapshot in RelMdExpressionLineage >

[jira] [Closed] (CALCITE-5291) Make BigQuery lexical policy case insensitive

[ https://issues.apache.org/jira/browse/CALCITE-5291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5291. Resolved in release 1.33.0 (2023-02-06) > Make BigQuery lexical policy case insensitive >

[jira] [Closed] (CALCITE-5414) Use DateTimeUtils to correctly convert between java.sql types and Unix timestamps

[ https://issues.apache.org/jira/browse/CALCITE-5414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5414. Resolved in release 1.33.0 (2023-02-06) > Use DateTimeUtils to correctly convert between java.sql

[jira] [Closed] (CALCITE-5340) Tests should fail when actual and expected XML reference files are not identical

[ https://issues.apache.org/jira/browse/CALCITE-5340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5340. Resolved in release 1.33.0 (2023-02-06) > Tests should fail when actual and expected XML reference

[jira] [Closed] (CALCITE-5423) Implement TIMESTAMP_DIFF function (compatible with BigQuery)

[ https://issues.apache.org/jira/browse/CALCITE-5423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5423. Resolved in release 1.33.0 (2023-02-06) > Implement TIMESTAMP_DIFF function (compatible with

[jira] [Closed] (CALCITE-5475) Improve test coverage accuracy by aggregating modules

[ https://issues.apache.org/jira/browse/CALCITE-5475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5475. Resolved in release 1.33.0 (2023-02-06) > Improve test coverage accuracy by aggregating modules >

[jira] [Closed] (CALCITE-5430) Implement IFNULL() for BigQuery dialect

[ https://issues.apache.org/jira/browse/CALCITE-5430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5430. Resolved in release 1.33.0 (2023-02-06) > Implement IFNULL() for BigQuery dialect >

[jira] [Closed] (CALCITE-5305) Character literals with C-style escapes

[ https://issues.apache.org/jira/browse/CALCITE-5305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5305. Resolved in release 1.33.0 (2023-02-06) > Character literals with C-style escapes >

[jira] [Closed] (CALCITE-5374) Upgrade jackson version to 2.14.0

[ https://issues.apache.org/jira/browse/CALCITE-5374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5374. Resolved in release 1.33.0 (2023-02-06) > Upgrade jackson version to 2.14.0 >

[jira] [Updated] (CALCITE-4804) Support Snapshot operator serialization and deserialization

[ https://issues.apache.org/jira/browse/CALCITE-4804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-4804: - Summary: Support Snapshot operator serialization and deserialization (was: Support Snapshot

  1   2   >