rubenada commented on code in PR #3768:
URL: https://github.com/apache/calcite/pull/3768#discussion_r1575792952
##########
site/_docs/history.md:
##########
@@ -56,19 +146,299 @@ other software versions as specified in gradle.properties.
#### New features
{: #new-features-1-37-0}
+* Supporting new functions
+ * [<a
href="https://issues.apache.org/jira/browse/CALCITE-6314";>CALCITE-6314</a>]
+ Add `RANDOM` function (enabled in Postgres library)
+ * [<a
href="https://issues.apache.org/jira/browse/CALCITE-6315";>CALCITE-6315</a>]
+ Support PostgreSQL `TO_CHAR`, `TO_DATE`, `TO_TIMESTAMP`
+ * [<a
href="https://issues.apache.org/jira/browse/CALCITE-6309";>CALCITE-6309</a>]
+ Add `REGEXP_LIKE` function (enabled in MySQL, Oracle, PostgreSQL and Spark
libraries)
+ * [<a
href="https://issues.apache.org/jira/browse/CALCITE-6116";>CALCITE-6116</a>]
+ Add `EXISTS` function (enabled in Spark library)
+ * [<a
href="https://issues.apache.org/jira/browse/CALCITE-6182";>CALCITE-6182</a>]
+ Add `LENGTH`/`LEN` functions (enabled in Snowflake library)
+ * [<a
href="https://issues.apache.org/jira/browse/CALCITE-6278";>CALCITE-6278</a>]
+ Add `REGEXP`, `REGEXP_LIKE` function (enabled in Spark library)
+ * [<a
href="https://issues.apache.org/jira/browse/CALCITE-6224";>CALCITE-6224</a>]
+ Add `LOG2` function (enabled in MySQL, Spark library)
+ * [<a
href="https://issues.apache.org/jira/browse/CALCITE-6223";>CALCITE-6223</a>]
+ Add `MAP_CONTAINS_KEY` function (enabled in Spark library)
+ * [<a
href="https://issues.apache.org/jira/browse/CALCITE-6205";>CALCITE-6205</a>]
+ Add `BITAND_AGG`, `BITOR_AGG` functions (enabled in Snowflake library)
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6268";>CALCITE-6268</a>]
+ Support implementing custom `JdbcSchema`
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6255";>CALCITE-6255</a>]
+ Support BigQuery-style `JSON_OBJECT` invocation syntax
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6219";>CALCITE-6219</a>]
+ 'Must-filter' columns
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-2980";>CALCITE-2980</a>]
+ Implement the `FORMAT` clause of the `CAST` operator
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-3679";>CALCITE-3679</a>]
+ Allow lambda expressions in SQL queries
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-3329";>CALCITE-3329</a>]
+ Implement osquery for OS adapter
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-2040";>CALCITE-2040</a>]
+ Create adapter for Apache Arrow
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6257";>CALCITE-6257</a>]
+ StarRocks dialect implementation
#### Dependency version upgrade
{: #dependency-1-37-0}
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6124";>CALCITE-6124</a>]
+ Bump json-path from 2.7.0 to 2.8.0
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6229";>CALCITE-6229</a>]
+ Bump json-path from 2.8.0 to 2.9.0
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6378";>CALCITE-6378</a>]
+ Bump Redis Docker image from 2.8.19 to 7.2.4
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6356";>CALCITE-6356</a>]
+ Upgrade Calcite to Avatica 1.25.0
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6243";>CALCITE-6243</a>]
+ Upgrade Cassandra to 4.1.3 and DataStax driver for Cassandra to 4.17.0
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6181";>CALCITE-6181</a>]
+ Upgrade Janino from 3.1.9 to 3.1.11
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6119";>CALCITE-6119</a>]
+ Upgrade testcontainers to 1.19.3
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6359";>CALCITE-6359</a>]
+ Update GitHub Actions workflows to use docker compose v2
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6156";>CALCITE-6156</a>]
+ Add `ENDSWITH`, `STARTSWITH` functions (enabled in Postgres, Snowflake
libraries)
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6081";>CALCITE-6081</a>]
+ Remove bouncycastle dependency
#### Bug-fixes, API changes and minor enhancements
{: #fixes-1-37-0}
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6355";>CALCITE-6355</a>]
+ `RelToSqlConverter[ORDER BY]` generates an incorrect order by when `NULLS
LAST` is used in non-projected field
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6210";>CALCITE-6210</a>]
+ Cast to `VARBINARY` causes an assertion failure
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-5289";>CALCITE-5289</a>]
+ Assertion failure in `MultiJoinOptimizeBushyRule`
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6345";>CALCITE-6345</a>]
+ Intervals with more than 100 years are not supported
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6265";>CALCITE-6265</a>]
+ Type coercion is failing for numeric values in prepared statements Address
some issues on the original patch
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6248";>CALCITE-6248</a>]
+ Illegal dates are accepted by casts
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6282";>CALCITE-6282</a>]
+ Avatica ignores time precision when returning `TIME` results
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6338";>CALCITE-6338</a>]
+ `RelMdCollation#project` can return an incomplete list of collations in the
presence of aliasing
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-5976";>CALCITE-5976</a>]
+ Function `ARRAY_PREPEND`/`ARRAY_APPEND`/`ARRAY_INSERT` gives exception when
inserted element type not equals array component type
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6349";>CALCITE-6349</a>]
+ `CoreRules.PROJECT_REDUCE_EXPRESSIONS` crashes on expressions with
`ARRAY_REPEAT`
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6333";>CALCITE-6333</a>]
+ `NullPointerException` in `AggregateExpandDistinctAggregatesRule.doRewrite`
when rewriting filtered distinct aggregation
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6285";>CALCITE-6285</a>]
+ Function `ARRAY_INSERT` produces an incorrect result for negative indices
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6015";>CALCITE-6015</a>]
+ AssertionError during optimization of `EXTRACT` expression
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6138";>CALCITE-6138</a>]
+ Parser does not accept `TIMESTAMP WITH TIME ZONE` as a data type
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6317";>CALCITE-6317</a>]
+ Incorrect constant replacement when group keys are `NULL`
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6348";>CALCITE-6348</a>]
+ `ARRAY_OVERLAP` with a `NULL` argument crashes the compiler
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6347";>CALCITE-6347</a>]
+ `ARRAY_REPEAT` with a string argument causes a compiler crash
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6127";>CALCITE-6127</a>]
+ The spark array function gives `NullPointerException` when element is row type
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6074";>CALCITE-6074</a>]
+ The size of `REAL`, `DOUBLE`, and `FLOAT` is not consistent
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6115";>CALCITE-6115</a>]
+ Interval type specifier with zero fractional second precision does not pass
validation
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-5955";>CALCITE-5955</a>]
+ BigQuery `PERCENTILE` functions are unparsed incorrectly
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6048";>CALCITE-6048</a>]
+ `ServerTest#testTruncateTable` fails intermittently due to method not found
exception
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-5811";>CALCITE-5811</a>]
+ Error messages produced for constant out-of-bounds arguments are confusing
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6128";>CALCITE-6128</a>]
+ `RelBuilder.limit` should apply offset and fetch to previous Sort operator,
if possible
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6118";>CALCITE-6118</a>]
+ Missing empty `ARRAY` function usage in reference doc
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6121";>CALCITE-6121</a>]
+ Invalid unparse for `TIMESTAMP` with SparkSqlDialect
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6109";>CALCITE-6109</a>]
+ Linq4j `OptimizeShuttle` should not create new instances of
`TernaryExpression` if it does not do any optimization
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6095";>CALCITE-6095</a>]
+ Arithmetic expression with `VARBINARY` value causes AssertionFailure
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6150";>CALCITE-6150</a>]
+ JDBC adapter for ClickHouse generates incorrect SQL for certain units in the
`EXTRACT` function
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6117";>CALCITE-6117</a>]
+ Converting `SAFE_CAST` from RexCall to SqlCall fails to add the type as an
argument
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6211";>CALCITE-6211</a>]
+ `SUBSTRING` with `Integer.MIN_VALUE` as a second parameter raise unexpected
exception
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6222";>CALCITE-6222</a>]
+ Mysql does not have to_char function
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6213";>CALCITE-6213</a>]
+ The default behavior of `NullCollation` in Presto is `LAST`
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6227";>CALCITE-6227</a>]
+ `ELEMENT`(`NULL`) causes an assertion failure
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6168";>CALCITE-6168</a>]
+ `RexExecutor` can throw during compilation
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6118";>CALCITE-6118</a>]
+ Missing empty `ARRAY` function usage in reference doc
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-5130";>CALCITE-5130</a>]
+ `AssertionError`: "Conversion to relational algebra failed to preserve
datatypes" when union `VARCHAR` literal and `CAST(null AS INTEGER)`
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6180";>CALCITE-6180</a>]
+ Append possibility to escape backslash in `LIKE` with `ESCAPE` operator
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6178";>CALCITE-6178</a>]
+ `WITH RECURSIVE` query when cloned using `SqlShuttle` looses `RECURSIVE`
property
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6332";>CALCITE-6332</a>]
+ Optimization `CoreRules.AGGREGATE_EXPAND_DISTINCT_AGGREGATES_TO_JOIN`
produces incorrect results for aggregates with groupSets
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6353";>CALCITE-6353</a>]
+ Optimization `CoreRules.PROJECT_REDUCE_EXPRESSIONS` crashes while optimizing
`ARRAY_CONCAT` expression
+* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6265";>CALCITE-6265</a>]
Review Comment:
`CALCITE-6265` appears two times in the list, one should be removed
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@calcite.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
