This is an automated email from the ASF dual-hosted git repository.
asf-ci-deploy pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/calcite-site.git
The following commit(s) were added to refs/heads/main by this push:
new 1db6b46ec Website deployed from
calcite@1a938f1e7b0014d7c2f80966b5ff1d9c6e67adea
1db6b46ec is described below
commit 1db6b46ecffd322cae4c280bb294f2d6ed146502
Author: zabetak <[email protected]>
AuthorDate: Sun May 31 13:56:00 2026 +0000
Website deployed from calcite@1a938f1e7b0014d7c2f80966b5ff1d9c6e67adea
---
docs/history.html | 486 +++++++++++++++++++++++++++++++++++++++++---
docs/howto.html | 4 +-
img/avatars/Zhiqiang-He.png | Bin 9109 -> 9110 bytes
3 files changed, 461 insertions(+), 29 deletions(-)
diff --git a/docs/history.html b/docs/history.html
index b6b336904..2ab7cd5e1 100644
--- a/docs/history.html
+++ b/docs/history.html
@@ -101,10 +101,10 @@ Downloads are available on the
<!--
-## <a
href="https://github.com/apache/calcite/releases/tag/calcite-1.42.0";>1.42.0</a>
/ YYYY-MM-DD
-{: #v1-42-0}
+## <a
href="https://github.com/apache/calcite/releases/tag/calcite-1.43.0";>1.43.0</a>
/ YYYY-MM-DD
+{: #v1-43-0}
-This release comes x months after [1.41.0](#v1-41-0),
+This release comes x months after [1.42.0](#v1-42-0),
contains contributions from x contributors, and resolves x issues.
Contributors to this release:
@@ -113,48 +113,480 @@ y (release manager),
z.
Compatibility: This release is tested on Linux, macOS, Microsoft Windows;
-using JDK/OpenJDK versions 8 to 23;
+using JDK/OpenJDK versions 8 to 24;
Guava versions 21.0 to 33.4.8-jre;
other software versions as specified in gradle.properties.
#### Breaking Changes
-{: #breaking-1-42-0}
+{: #breaking-1-43-0}
-* [<a
href="https://issues.apache.org/jira/browse/CALCITE-7410";>CALCITE-7410</a>]
- Changes the type of the `WINDOW_START` and `WINDOW_END` columns for
- the table functions `HOP`, `TUMBLE`, `SESSION` to match the original
- type of the timestamp column. These types used to be hardwired to
- `TIMESTAMP(3)`.
+#### New features
+{: #new-features-1-43-0}
-* [<a
href="https://issues.apache.org/jira/browse/CALCITE-7393";>CALCITE-7393</a>]
-`RelDataTypeImpl.digest` is deprecated. We recommend using
`RelDataTypeImpl.innerDigest` instead.
-See system property
`CalciteSystemProperty.DISABLE_GENERATE_REL_DATA_TYPE_DIGEST_STRING`.
+Below some rough guidelines on what to put into this section.
-* [<a
href="https://issues.apache.org/jira/browse/CALCITE-7301";>CALCITE-7301</a>]
-Prior to this change, most `SqlNode`s in the `org.apache.calcite.sql.ddl`
package could not be unparsed
-when created with `SqlOperator#createCall`. To fix this, those `SqlNode`s now
implement their own `SqlOperator`.
-`SqlNode#getOperandList()` now returns all operands required by these
operators; the number and order may differ from before.
-The same applies to `SqlBabelCreateTable` and `SqlUnpivot`.
+1. Changes that introduce new:
+rules, SQL functions, data types, SQL syntax extensions, simplifications,
+metadata APIs (BuiltInMetadata), SQL dialects.
-* [<a
href="https://issues.apache.org/jira/browse/CALCITE-6942";>CALCITE-6942</a>]
-Rename the method `decorrelateFetchOneSort` to `decorrelateSortWithRowNumber`.
-
-#### New features
-{: #new-features-1-42-0}
+2. Big performance improvements.
#### Dependency version upgrade
-{: #dependency-1-42-0}
+{: #dependency-1-43-0}
#### Bug-fixes, API changes and minor enhancements
-{: #fixes-1-42-0}
+{: #fixes-1-43-0}
#### Build and test suite
-{: #build-1-42-0}
+{: #build-1-43-0}
#### Web site and documentation
-{: #site-1-42-0}
+{: #site-1-43-0}
-->
+<h2 id="v1-42-0">
+<a
href="https://github.com/apache/calcite/releases/tag/calcite-1.42.0";>1.42.0</a>
/ 2026-06-01</h2>
+
+<p>This release comes 7 months after <a href="#v1-41-0">1.41.0</a>,
+contains contributions from 39 contributors, and resolves 241 issues.</p>
+
+<p>Contributors to this release:
+Alessandro Solimando,
+Alexis Cubilla,
+big face cat,
+Cancai Cai,
+Darpan Lunagariya,
+Diveyam Mishra,
+Dmitry Sysolyatin,
+Dongsheng He,
+Heng Qian,
+Hongyu Guo,
+Ian Bertolacci,
+Issac Garcia,
+Jinkun Liu,
+Joseph Grogan,
+Julian Hyde,
+Keshav Katkar,
+khanhkhanhlele,
+krooswu,
+Lincoln Lee,
+Mihai Budiu,
+Niels Pardon,
+Ruben Quesada Lopez,
+Sean Broeder,
+Sergey Nuyanzin,
+Silun Dong,
+Soumyakanti Das,
+Stamatis Zampetakis (Release Manager),
+Tamas Mate,
+Terran,
+Thomas Rebele,
+TJ Banghart,
+Weihua Zhang,
+Wenzhuang Zhu,
+Xiong Duan,
+Yash Limbad,
+Yu Xu,
+Zhen Chen,
+Zhen Wang,
+zhuyufeng0809,
+zzwqqq.</p>
+
+<p>Compatibility: This release is tested on Linux, macOS, Microsoft Windows;
+using JDK/OpenJDK versions 8 to 24;
+Guava versions 21.0 to 33.4.8-jre;
+other software versions as specified in gradle.properties.</p>
+
+<h4 id="breaking-1-42-0">Breaking Changes</h4>
+
+<ul>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6942";>CALCITE-6942</a>]
+Rename the method <code class="language-plaintext
highlighter-rouge">decorrelateFetchOneSort</code> to <code
class="language-plaintext
highlighter-rouge">decorrelateSortWithRowNumber</code>.</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7301";>CALCITE-7301</a>]
+Prior to this change, most <code class="language-plaintext
highlighter-rouge">SqlNode</code>s in the <code class="language-plaintext
highlighter-rouge">org.apache.calcite.sql.ddl</code> package could not be
unparsed
+when created with <code class="language-plaintext
highlighter-rouge">SqlOperator#createCall</code>. To fix this, those <code
class="language-plaintext highlighter-rouge">SqlNode</code>s now implement
their own <code class="language-plaintext highlighter-rouge">SqlOperator</code>.
+<code class="language-plaintext
highlighter-rouge">SqlNode#getOperandList()</code> now returns all operands
required by these operators; the number and order may differ from before.
+The same applies to <code class="language-plaintext
highlighter-rouge">SqlBabelCreateTable</code> and <code
class="language-plaintext highlighter-rouge">SqlUnpivot</code>.</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7351";>CALCITE-7351</a>]
Make <code class="language-plaintext
highlighter-rouge">getMaxNumericScale()</code> and <code
class="language-plaintext highlighter-rouge">getMaxNumericPrecision()</code>
final</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7393";>CALCITE-7393</a>]
+<code class="language-plaintext
highlighter-rouge">RelDataTypeImpl.digest</code> is deprecated. We recommend
using <code class="language-plaintext
highlighter-rouge">RelDataTypeImpl.innerDigest</code> instead.
+See system property <code class="language-plaintext
highlighter-rouge">CalciteSystemProperty.DISABLE_GENERATE_REL_DATA_TYPE_DIGEST_STRING</code>.</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7410";>CALCITE-7410</a>]
+Changes the type of the <code class="language-plaintext
highlighter-rouge">WINDOW_START</code> and <code class="language-plaintext
highlighter-rouge">WINDOW_END</code> columns for
+the table functions <code class="language-plaintext
highlighter-rouge">HOP</code>, <code class="language-plaintext
highlighter-rouge">TUMBLE</code>, <code class="language-plaintext
highlighter-rouge">SESSION</code> to match the original
+type of the timestamp column. These types used to be hardwired to
+<code class="language-plaintext highlighter-rouge">TIMESTAMP(3)</code>.</li>
+</ul>
+
+<h4 id="new-features-1-42-0">New features</h4>
+
+<ul>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-4460";>CALCITE-4460</a>]
Support custom delimiter when parsing CSV tables</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-5347";>CALCITE-5347</a>] Add
<code class="language-plaintext highlighter-rouge">SELECT ... BY</code>, a
syntax extension that is shorthand for <code class="language-plaintext
highlighter-rouge">GROUP BY</code> and <code class="language-plaintext
highlighter-rouge">ORDER BY</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-5733";>CALCITE-5733</a>]
Simplify <code class="language-plaintext highlighter-rouge">a = ARRAY[1,2] AND
a = ARRAY[2,3]</code> to <code class="language-plaintext
highlighter-rouge">false</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-5740";>CALCITE-5740</a>] Add
<code class="language-plaintext highlighter-rouge">AggToSemiJoinRule</code> to
transform aggregate to semijoin</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-5787";>CALCITE-5787</a>] New
<code class="language-plaintext highlighter-rouge">RelMdInputFieldsUsed</code>
API to track the usage of input fields</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6066";>CALCITE-6066</a>] Add
<code class="language-plaintext highlighter-rouge">HYPOT</code> function
(enabled in Spark library)</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7031";>CALCITE-7031</a>]
Implement the general decorrelation algorithm (Neumann & Kemper)</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7295";>CALCITE-7295</a>]
<code class="language-plaintext highlighter-rouge">RexSimplify</code> should
simplify a division with a <code class="language-plaintext
highlighter-rouge">NULL</code> argument</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7310";>CALCITE-7310</a>]
Support the syntax <code class="language-plaintext highlighter-rouge">SELECT *
EXCLUDE(columns)</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7311";>CALCITE-7311</a>]
Support the syntax <code class="language-plaintext
highlighter-rouge">ROW(*)</code> to create a nested <code
class="language-plaintext highlighter-rouge">ROW</code> type with all
columns</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7337";>CALCITE-7337</a>] Add
<code class="language-plaintext highlighter-rouge">AGE</code> function (enabled
in PostgreSQL library)</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7362";>CALCITE-7362</a>] Add
rule to transform <code class="language-plaintext
highlighter-rouge">WHERE</code> clauses into filtered aggregates</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7406";>CALCITE-7406</a>] Add
<code class="language-plaintext highlighter-rouge">ABS</code> function (enabled
in MongoDB library)</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7413";>CALCITE-7413</a>] Add
<code class="language-plaintext highlighter-rouge">CONCAT</code> and <code
class="language-plaintext highlighter-rouge">SUBSTRING</code> function (enabled
in MongoDB library)</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7422";>CALCITE-7422</a>]
Support large plan optimization mode for HepPlanner</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7428";>CALCITE-7428</a>]
Support <code class="language-plaintext highlighter-rouge">REGEXP</code>
function in Hive library</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7448";>CALCITE-7448</a>] Add
support for ‘:’ variant path access syntax</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7498";>CALCITE-7498</a>]
Enhance parser to allow hints with assignments mixing literals and
identifiers</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7523";>CALCITE-7523</a>]
Support the syntax <code class="language-plaintext highlighter-rouge">SELECT *
REPLACE(expr as column)</code>
+</li>
+</ul>
+
+<h4 id="dependency-1-42-0">Dependency version upgrade</h4>
+
+<ul>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7259";>CALCITE-7259</a>]
Drop commons-lang3 dependency</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7290";>CALCITE-7290</a>]
Update json-path to 2.10.0</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7307";>CALCITE-7307</a>]
joou-java6-0.9.4 dependency conflicts with Java 9+ and JPMS</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7458";>CALCITE-7458</a>]
Upgrade Jackson to 2.18.6 due to CVE</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7521";>CALCITE-7521</a>]
Upgrade Avatica 1.28.0</li>
+</ul>
+
+<h4 id="fixes-1-42-0">Bug-fixes, API changes and minor enhancements</h4>
+
+<ul>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-2152";>CALCITE-2152</a>] SQL
parser unable to parse SQL with nested joins produced by <code
class="language-plaintext highlighter-rouge">RelToSqlConverter</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-2274";>CALCITE-2274</a>]
Filter predicates aren’t inferred while using dynamic star in subquery</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-3128";>CALCITE-3128</a>]
Joining two tables producing only <code class="language-plaintext
highlighter-rouge">NULLs</code> will return 0 rows</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-4525";>CALCITE-4525</a>]
Pull up predicate will lose some predicates when project contains same <code
class="language-plaintext highlighter-rouge">RexInputRef</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-4645";>CALCITE-4645</a>] In
Elasticsearch adapter, a range predicate should be translated to a range
query</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-4765";>CALCITE-4765</a>]
Complex correlated <code class="language-plaintext
highlighter-rouge">EXISTS</code> sub-queries used as scalar subqueries can
return wrong results</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-4813";>CALCITE-4813</a>]
<code class="language-plaintext highlighter-rouge">ANY_VALUE</code> assumes
that arguments should be comparable</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-4868";>CALCITE-4868</a>]
Elasticsearch adapter fails if <code class="language-plaintext
highlighter-rouge">GROUP BY</code> is followed by <code
class="language-plaintext highlighter-rouge">ORDER BY</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-5093";>CALCITE-5093</a>]
Quantified comparison operators (e.g. <code class="language-plaintext
highlighter-rouge">ANY</code>) should support <code class="language-plaintext
highlighter-rouge">ARRAY</code> arguments</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-5132";>CALCITE-5132</a>]
Scalar <code class="language-plaintext highlighter-rouge">IN</code> subquery
returns <code class="language-plaintext highlighter-rouge">UNKNOWN</code>
instead of <code class="language-plaintext highlighter-rouge">FALSE</code> when
key is partially <code class="language-plaintext highlighter-rouge">NULL</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-5223";>CALCITE-5223</a>]
<code class="language-plaintext
highlighter-rouge">AdjustProjectForCountAggregateRule</code> throws <code
class="language-plaintext
highlighter-rouge">ArrayIndexOutOfBoundsException</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-5390";>CALCITE-5390</a>]
<code class="language-plaintext highlighter-rouge">RelDecorrelator</code>
throws <code class="language-plaintext
highlighter-rouge">NullPointerException</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-5465";>CALCITE-5465</a>]
Rule of <code class="language-plaintext
highlighter-rouge">AGGREGATE_EXPAND_DISTINCT_AGGREGATES</code> produces an
incorrect plan when SQL has distinct agg-call with <code
class="language-plaintext highlighter-rouge">ROLLUP</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-5597";>CALCITE-5597</a>]
<code class="language-plaintext highlighter-rouge">SqlToRelConverter</code>
generates wrong plan for <code class="language-plaintext
highlighter-rouge">SELECT DISTINCT</code> query with <code
class="language-plaintext highlighter-rouge">ORDER BY</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-5832";>CALCITE-5832</a>]
<code class="language-plaintext
highlighter-rouge">CyclicMetadataException</code> thrown in complex <code
class="language-plaintext highlighter-rouge">JOIN</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6176";>CALCITE-6176</a>]
<code class="language-plaintext
highlighter-rouge">JOIN_SUB_QUERY_TO_CORRELATE</code> rule incorrectly handles
<code class="language-plaintext highlighter-rouge">EXISTS</code> in <code
class="language-plaintext highlighter-rouge">LEFT JOIN ON</code> clause</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6291";>CALCITE-6291</a>]
Support converting <code class="language-plaintext
highlighter-rouge">ArrowTable</code> to <code class="language-plaintext
highlighter-rouge">Queryable</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6298";>CALCITE-6298</a>]
Support <code class="language-plaintext highlighter-rouge">UNION</code> in
Arrow adapter</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6300";>CALCITE-6300</a>]
Function <code class="language-plaintext
highlighter-rouge">MAP_VALUES/MAP_KEYS</code> gives exception when <code
class="language-plaintext highlighter-rouge">mapValueType</code> and <code
class="language-plaintext highlighter-rouge">mapKeyType</code> not equals map
Biggest mapKeytype or mapValueType</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6636";>CALCITE-6636</a>]
Support CNF condition in Arrow adapter</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6646";>CALCITE-6646</a>]
Support <code class="language-plaintext highlighter-rouge">TIMESTAMP</code>
data type in Arrow adapter</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6681";>CALCITE-6681</a>]
<code class="language-plaintext highlighter-rouge">NullPointerException</code>
in <code class="language-plaintext
highlighter-rouge">ProjectCorrelateTransposeRule</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6757";>CALCITE-6757</a>]
Elasticsearch adapter returns wrong result when aggregating sub-query with
aggregation</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6829";>CALCITE-6829</a>]
<code class="language-plaintext highlighter-rouge">MSSQL</code> dialect
incorrectly translates of <code class="language-plaintext
highlighter-rouge">SELECT TRUE</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6942";>CALCITE-6942</a>]
Decorrelate sub-queries with <code class="language-plaintext
highlighter-rouge">LIMIT 1</code> and <code class="language-plaintext
highlighter-rouge">OFFSET</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6963";>CALCITE-6963</a>]
<code class="language-plaintext highlighter-rouge">SqlToRelConverter</code>
fails when subquery is in join on clause</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6968";>CALCITE-6968</a>]
<code class="language-plaintext
highlighter-rouge">SqlUpdate#getOperandList</code> omits sourceSelect
operand</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7057";>CALCITE-7057</a>]
<code class="language-plaintext highlighter-rouge">NPE</code> when
decorrelating query containing nested correlated subqueries</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7085";>CALCITE-7085</a>]
<code class="language-plaintext highlighter-rouge">JOIN USING</code> with
unqualified common column fails in a conformance where <code
class="language-plaintext highlighter-rouge">allowQualifyingCommonColumn</code>
is false (e.g. Oracle, Presto)</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7087";>CALCITE-7087</a>]
SQLite does not support <code class="language-plaintext
highlighter-rouge">RIGHT/FULL JOIN</code> until version 3.39.0</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7145";>CALCITE-7145</a>]
<code class="language-plaintext highlighter-rouge">RexSimplify</code> should
not simplify <code class="language-plaintext highlighter-rouge">IS
NULL(10/0)</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7187";>CALCITE-7187</a>]
Java UDF byte arrays cannot be mapped to <code class="language-plaintext
highlighter-rouge">VARBINARY</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7196";>CALCITE-7196</a>]
Create an optimization pass which can convert some cases of <code
class="language-plaintext highlighter-rouge">Correlate</code> + <code
class="language-plaintext highlighter-rouge">Unnest</code> to <code
class="language-plaintext highlighter-rouge">Unnest</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7207";>CALCITE-7207</a>]
Semi Join <code class="language-plaintext highlighter-rouge">RelNode</code>
cannot be translated into correct <code class="language-plaintext
highlighter-rouge">MySQL</code> SQL</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7208";>CALCITE-7208</a>]
Allow downstream projects implement <code class="language-plaintext
highlighter-rouge">CREATE OR ALTER</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7251";>CALCITE-7251</a>]
<code class="language-plaintext highlighter-rouge">SEARCH</code> and <code
class="language-plaintext highlighter-rouge">WINDOW</code> calls should carry
source position information</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7254";>CALCITE-7254</a>] Add
rule for sharing trivially equivalent RelNodes within Combine</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7256";>CALCITE-7256</a>]
Make the fields of <code class="language-plaintext
highlighter-rouge">SqlTableRef</code> public</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7257";>CALCITE-7257</a>]
Subqueries cannot be decorrelated if join condition contains <code
class="language-plaintext highlighter-rouge">RexFieldAccess</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7258";>CALCITE-7258</a>]
<code class="language-plaintext highlighter-rouge">RelBuilder.filter</code>
should throw if the condition is not <code class="language-plaintext
highlighter-rouge">BOOLEAN</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7266";>CALCITE-7266</a>]
Optimize the “well-known count bug” correction</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7268";>CALCITE-7268</a>]
<code class="language-plaintext highlighter-rouge">SqlToRelConverter</code>
throws exception if lambda contains <code class="language-plaintext
highlighter-rouge">IN</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7272";>CALCITE-7272</a>]
Subqueries cannot be decorrelated if have set op</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7273";>CALCITE-7273</a>]
<code class="language-plaintext
highlighter-rouge">CoreRules.JOIN_REDUCE_EXPRESSIONS</code> throws when applied
to an <code class="language-plaintext highlighter-rouge">ASOF JOIN</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7274";>CALCITE-7274</a>]
<code class="language-plaintext highlighter-rouge">RexFieldAccess</code> has
wrong index when use trim unused fields</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7276";>CALCITE-7276</a>]
<code class="language-plaintext highlighter-rouge">SqlToRelConverter</code>
throws exception for <code class="language-plaintext
highlighter-rouge">UPDATE</code> if identifier expansion disabled</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7279";>CALCITE-7279</a>]
<code class="language-plaintext highlighter-rouge">ClickHouse</code> dialect
should wrap nested joins with explicit column aliases</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7281";>CALCITE-7281</a>]
Deprecate <code class="language-plaintext
highlighter-rouge">NullPolicy.ANY</code> in favor of <code
class="language-plaintext highlighter-rouge">NullPolicy.SEMI_STRICT</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7287";>CALCITE-7287</a>] In
<code class="language-plaintext highlighter-rouge">simplifyLike</code>, the
<code class="language-plaintext highlighter-rouge">makeLiteral</code> call does
not preserve the <code class="language-plaintext
highlighter-rouge">RelDataType</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7289";>CALCITE-7289</a>]
<code class="language-plaintext highlighter-rouge">SELECT NULL</code> sub-query
throwing exception</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7291";>CALCITE-7291</a>]
Verify that the same exception is thrown for the original and simplified
expression in <code class="language-plaintext
highlighter-rouge">RexSimplify#verify</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7293";>CALCITE-7293</a>]
<code class="language-plaintext highlighter-rouge">MAP</code> constructor
cannot handle <code class="language-plaintext highlighter-rouge">VARIANT</code>
values that need casts</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7296";>CALCITE-7296</a>]
<code class="language-plaintext highlighter-rouge">RexSimplify</code> should
not simplify <code class="language-plaintext highlighter-rouge">IS
NULL(CAST(10/0 AS BIGINT))</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7297";>CALCITE-7297</a>] The
result is incorrect when the <code class="language-plaintext
highlighter-rouge">GROUP BY</code> key in a subquery is a <code
class="language-plaintext highlighter-rouge">RexFieldAccess</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7302";>CALCITE-7302</a>]
Infinite loop with <code class="language-plaintext
highlighter-rouge">JoinPushTransitivePredicatesRule</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7303";>CALCITE-7303</a>]
Sub-queries cannot be decorrelated if filter condition have multi <code
class="language-plaintext highlighter-rouge">CorrelationId</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7305";>CALCITE-7305</a>]
Subqueries in <code class="language-plaintext highlighter-rouge">ASOF JOIN
MATCH_CONDITION</code> cause an assertion failure</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7309";>CALCITE-7309</a>]
Position is unparsed incorrectly for <code class="language-plaintext
highlighter-rouge">ClickHouseSqlDialect</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7312";>CALCITE-7312</a>]
Alias is not auto generated for <code class="language-plaintext
highlighter-rouge">LATERAL TABLE</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7315";>CALCITE-7315</a>]
Support <code class="language-plaintext highlighter-rouge">LEFT_MARK</code>
type for hash join in enumerable convention</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7316";>CALCITE-7316</a>] The
<code class="language-plaintext highlighter-rouge">POSITION</code> function in
SQLite is missing the <code class="language-plaintext
highlighter-rouge">FROM</code> clause</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7317";>CALCITE-7317</a>]
<code class="language-plaintext highlighter-rouge">SubQueryRemoveRule</code>
should skip NULL-safety checks for <code class="language-plaintext
highlighter-rouge">IN</code> subqueries when both the keys and the subquery
columns are <code class="language-plaintext highlighter-rouge">NOT NULL</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7318";>CALCITE-7318</a>]
Execution fails when the <code class="language-plaintext
highlighter-rouge">JOIN ON</code> condition contains references to columns from
both the left and right sides</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7319";>CALCITE-7319</a>]
<code class="language-plaintext highlighter-rouge">FILTER_INTO_JOIN</code> rule
loses correlation variable context in HepPlanner</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7319";>CALCITE-7319</a>]
<code class="language-plaintext highlighter-rouge">FILTER_INTO_JOIN</code> rule
loses correlation variable context in HepPlanner</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7320";>CALCITE-7320</a>]
<code class="language-plaintext
highlighter-rouge">AggregateProjectMergeRule</code> throws <code
class="language-plaintext highlighter-rouge">AssertionError</code> when <code
class="language-plaintext highlighter-rouge">Project</code> maps multiple
grouping keys to the same field</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7321";>CALCITE-7321</a>]
<code class="language-plaintext highlighter-rouge">FilesTableFunction</code>
throws <code class="language-plaintext
highlighter-rouge">NumberFormatException</code> on macOS with GNU stat
installed</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7322";>CALCITE-7322</a>] The
<code class="language-plaintext highlighter-rouge">POSITION</code> function in
<code class="language-plaintext highlighter-rouge">MySQL</code> is missing the
<code class="language-plaintext highlighter-rouge">FROM</code> clause</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7323";>CALCITE-7323</a>]
Result of cast <code class="language-plaintext highlighter-rouge">Number</code>
to <code class="language-plaintext highlighter-rouge">Boolean</code> is not
correct</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7325";>CALCITE-7325</a>]
Incorrect <code class="language-plaintext highlighter-rouge">VARIANT</code>
signatures in <code class="language-plaintext
highlighter-rouge">SqlItemOperator</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7326";>CALCITE-7326</a>]
<code class="language-plaintext highlighter-rouge">FILTER_CORRELATE</code> rule
loses correlation variable context in HepPlanner</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7327";>CALCITE-7327</a>]
Support <code class="language-plaintext highlighter-rouge">IS NOT DISTINCT
FROM</code> as equi condition of hash join</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7330";>CALCITE-7330</a>]
<code class="language-plaintext
highlighter-rouge">AggregateCaseToFilterRule</code> should not be applied on
aggregate functions that don’t skip <code class="language-plaintext
highlighter-rouge">NULL</code> inputs</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7331";>CALCITE-7331</a>]
Support the alias form <code class="language-plaintext
highlighter-rouge">SELECT * EXCEPT</code> for <code class="language-plaintext
highlighter-rouge">SELECT * EXCLUDE</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7332";>CALCITE-7332</a>]
<code class="language-plaintext highlighter-rouge">SELECT * EXCLUDE</code> list
should error when it excludes all columns</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7335";>CALCITE-7335</a>]
<code class="language-plaintext highlighter-rouge">RelToSqlConverter</code>
generate sql containing Scala sub-queries includes redundant parentheses</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7336";>CALCITE-7336</a>]
<code class="language-plaintext highlighter-rouge">RelFieldTrimmer</code>
generates an incorrect plan when handling correlated sub-query within <code
class="language-plaintext highlighter-rouge">Filter</code> or <code
class="language-plaintext highlighter-rouge">Join</code> condition</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7338";>CALCITE-7338</a>]
Window hints are not propagated to window rel nodes</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7339";>CALCITE-7339</a>]
Most classes in <code class="language-plaintext
highlighter-rouge">SqlDdlNodes</code> use an incorrect <code
class="language-plaintext highlighter-rouge">SqlCallFactory</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7343";>CALCITE-7343</a>]
<code class="language-plaintext highlighter-rouge">RelToSqlConverter</code>
generate wrong SQL when scalar correlated sub-query in <code
class="language-plaintext highlighter-rouge">Project</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7346";>CALCITE-7346</a>]
Prevent overflow in metadata row-count when <code class="language-plaintext
highlighter-rouge">LIMIT/OFFSET</code> literal exceeds <code
class="language-plaintext highlighter-rouge">Long</code> range</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7347";>CALCITE-7347</a>]
<code class="language-plaintext highlighter-rouge">UNKNOWN</code> type inferred
for array element type</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7348";>CALCITE-7348</a>]
Remove redundant extraction correlation variables when Trim <code
class="language-plaintext highlighter-rouge">Project</code> fields</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7349";>CALCITE-7349</a>]
Upgrade the types of <code class="language-plaintext
highlighter-rouge">FETCH</code> and <code class="language-plaintext
highlighter-rouge">OFFSET</code> in <code class="language-plaintext
highlighter-rouge">Sort</code> to <code class="language-plaintext
highlighter-rouge">BigDecimal</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7350";>CALCITE-7350</a>]
Missing <code class="language-plaintext
highlighter-rouge">allowEmptyOutputFromRewrite</code> parameter in <code
class="language-plaintext
highlighter-rouge">TopDownGeneralDecorrelator.unnestInternal</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7352";>CALCITE-7352</a>]
Incorrect <code class="language-plaintext highlighter-rouge">SqlLibrary</code>
enum value used in ClickHouse SQL test</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7355";>CALCITE-7355</a>]
<code class="language-plaintext highlighter-rouge">RelToSqlConverter</code>
throws exception when the join condition contains a correlated subquery</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7356";>CALCITE-7356</a>] The
<code class="language-plaintext highlighter-rouge">MARK JOIN</code> generated
by <code class="language-plaintext
highlighter-rouge">TopDownGeneralDecorrelator</code> needs to be adapted to
<code class="language-plaintext highlighter-rouge">RelFieldTrimmer</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7357";>CALCITE-7357</a>] Add
runtime implementation for <code class="language-plaintext
highlighter-rouge">IS DISTINCT FROM</code> operator</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7358";>CALCITE-7358</a>]
Casts involving <code class="language-plaintext highlighter-rouge">MAP</code>
and <code class="language-plaintext highlighter-rouge">ROW</code> types cause
compile-time exceptions</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7359";>CALCITE-7359</a>]
Incorrect result for array comparison with <code class="language-plaintext
highlighter-rouge">ANY</code> operator</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7360";>CALCITE-7360</a>] The
meaning of negation for unsigned numbers is not defined</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7363";>CALCITE-7363</a>]
Improve error message for <code class="language-plaintext
highlighter-rouge">ASOF JOIN</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7365";>CALCITE-7365</a>]
<code class="language-plaintext highlighter-rouge">RelMdRowCount</code> ignores
<code class="language-plaintext highlighter-rouge">estimateRowCoun</code>
overrides in <code class="language-plaintext
highlighter-rouge">SingleRel</code> subclasses</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7366";>CALCITE-7366</a>]
<code class="language-plaintext highlighter-rouge">AssertionError</code> in
<code class="language-plaintext
highlighter-rouge">RexLiteral.valueMatchesType</code> for <code
class="language-plaintext highlighter-rouge">CAST</code> to <code
class="language-plaintext highlighter-rouge">MAP</code> type</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7367";>CALCITE-7367</a>]
<code class="language-plaintext highlighter-rouge">NULLS FIRST</code> throws
<code class="language-plaintext highlighter-rouge">ClassCastException</code>
when sorting arrays</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7368";>CALCITE-7368</a>]
Validator accepts <code class="language-plaintext highlighter-rouge">CAST(INT
TO BINARY)</code>, but the runtime does not implement them</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7369";>CALCITE-7369</a>]
<code class="language-plaintext highlighter-rouge">ProjectToWindowRule</code>
loses column alias when optimizing <code class="language-plaintext
highlighter-rouge">OVER</code> window queries</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7370";>CALCITE-7370</a>]
Trailing dot is not removed when normalizing timestamp strings</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7372";>CALCITE-7372</a>]
<code class="language-plaintext
highlighter-rouge">TopDownGeneralDecorrelator</code> generates invalid SQL when
the JOIN condition has correlation</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7373";>CALCITE-7373</a>]
<code class="language-plaintext highlighter-rouge">FILTER_INTO_JOIN</code>
should not push <code class="language-plaintext
highlighter-rouge">Filter</code> into a <code class="language-plaintext
highlighter-rouge">Join</code> when the <code class="language-plaintext
highlighter-rouge">Filter</code> contains non-deterministic function</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7374";>CALCITE-7374</a>]
<code class="language-plaintext highlighter-rouge">NULLS LAST</code> throws
<code class="language-plaintext highlighter-rouge">ClassCastException</code>
when sorting arrays</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7375";>CALCITE-7375</a>]
<code class="language-plaintext
highlighter-rouge">ProjectWindowTransposeRule</code> does not correctly adjust
column indices in window bounds</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7377";>CALCITE-7377</a>]
Validator should reject a <code class="language-plaintext
highlighter-rouge">DESCRIPTOR</code> in a table function when it is not an
identifier</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7378";>CALCITE-7378</a>]
<code class="language-plaintext highlighter-rouge">RelToSqlConverter</code>
generates incorrect column reference when <code class="language-plaintext
highlighter-rouge">hasImplicitTableAlias</code> is true</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7379";>CALCITE-7379</a>] LHS
correlated variables are shadowed by nullable RHS outputs in <code
class="language-plaintext highlighter-rouge">LEFT JOIN</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7382";>CALCITE-7382</a>]
Wrong results when using <code class="language-plaintext
highlighter-rouge">TopDownGeneralDecorrelator</code> with <code
class="language-plaintext highlighter-rouge">LIMIT 1</code> sub-query</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7385";>CALCITE-7385</a>]
Support <code class="language-plaintext highlighter-rouge">LEFT_MARK</code>
type for nested loop join in enumerable convention</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7386";>CALCITE-7386</a>]
Wrong results after decorrelating query with <code class="language-plaintext
highlighter-rouge">MEASURE</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7388";>CALCITE-7388</a>]
Redis Adapter operand config should not support empty string</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7389";>CALCITE-7389</a>]
<code class="language-plaintext highlighter-rouge">PruneJoinSingleValue</code>
rule causes type mismatch in <code class="language-plaintext
highlighter-rouge">EXISTS</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7391";>CALCITE-7391</a>]
<code class="language-plaintext highlighter-rouge">AssertionError</code> when
applying <code class="language-plaintext
highlighter-rouge">FILTER_REDUCE_EXPRESSIONS</code> on expression <code
class="language-plaintext highlighter-rouge">WHERE 123 IN (SELECT NULL FROM
emps)</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7392";>CALCITE-7392</a>]
Unable to implement <code class="language-plaintext
highlighter-rouge">EnumerableCollect</code> for SQL queries with <code
class="language-plaintext highlighter-rouge">UNNEST</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7393";>CALCITE-7393</a>] Use
<code class="language-plaintext highlighter-rouge">RelDataTypeDigest</code> in
composite types to improve memory footprint and computational latency</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7394";>CALCITE-7394</a>]
Nested sub-query with multiple levels of correlation returns incorrect
results</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7395";>CALCITE-7395</a>]
<code class="language-plaintext highlighter-rouge">ProjectMergeRule</code>
incorrectly merges projects with correlation variables</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7396";>CALCITE-7396</a>]
<code class="language-plaintext highlighter-rouge">PruneEmptyRules</code> does
not support <code class="language-plaintext highlighter-rouge">LEFT_MARK
JOIN</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7397";>CALCITE-7397</a>]
<code class="language-plaintext highlighter-rouge">AssertionError</code> in
simplifying join condition when creating <code class="language-plaintext
highlighter-rouge">LEFT MARK JOIN</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7398";>CALCITE-7398</a>]
Incorrect int <code class="language-plaintext highlighter-rouge">CAST</code> in
<code class="language-plaintext highlighter-rouge">VariantNonNull#cast</code>
for <code class="language-plaintext highlighter-rouge">BIGINT</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7400";>CALCITE-7400</a>]
<code class="language-plaintext highlighter-rouge">PruneJoinSingleValue</code>
rule causes type mismatch in <code class="language-plaintext
highlighter-rouge">IN</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7401";>CALCITE-7401</a>]
Multi-level correlated subqueries cause an out-of-range error in the <code
class="language-plaintext highlighter-rouge">TopDownGeneralDecorrelator</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7402";>CALCITE-7402</a>]
<code class="language-plaintext highlighter-rouge">AssertionError</code> type
mismatch when using <code class="language-plaintext
highlighter-rouge">TopDownGeneralDecorrelator</code> with nested correlated
sub-query</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7403";>CALCITE-7403</a>]
Missing <code class="language-plaintext highlighter-rouge">ENUMERABLE</code>
Convention for <code class="language-plaintext
highlighter-rouge">LogicalConditionalCorrelate</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7404";>CALCITE-7404</a>]
Syntax error in MongoDB adapter due to incorrect field alias</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7408";>CALCITE-7408</a>]
<code class="language-plaintext highlighter-rouge">URL_ENCODE/URL_DECODE</code>
is unparsed incorrectly for <code class="language-plaintext
highlighter-rouge">ClickHouseSqlDialect</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7409";>CALCITE-7409</a>]
Merge <code class="language-plaintext highlighter-rouge">JOIN</code> condition
cannot contain <code class="language-plaintext highlighter-rouge">IS NOT
DISTINCT FROM</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7410";>CALCITE-7410</a>]
<code class="language-plaintext highlighter-rouge">TIMESTAMP</code> type for
<code class="language-plaintext highlighter-rouge">TUMBLE</code> and <code
class="language-plaintext highlighter-rouge">HOP</code> is hardwired to <code
class="language-plaintext highlighter-rouge">TIMESTAMP(3)</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7411";>CALCITE-7411</a>]
When a <code class="language-plaintext highlighter-rouge">SCALAR_QUERY</code>
in <code class="language-plaintext highlighter-rouge">PROJECT</code> contains
correlated variables execution fails using <code class="language-plaintext
highlighter-rouge">TopDownGeneralDecorrelator</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7412";>CALCITE-7412</a>]
Redis test failed on higher versions of macOS</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7414";>CALCITE-7414</a>]
Incorrect mapping of <code class="language-plaintext
highlighter-rouge">CorDef</code> after decorrelating a <code
class="language-plaintext highlighter-rouge">Join</code> in <code
class="language-plaintext highlighter-rouge">TopDownGeneralDecorrelator</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7415";>CALCITE-7415</a>]
<code class="language-plaintext
highlighter-rouge">CalciteCatalogReader.lookupOperatorOverloads</code> keeps
original function identifier casing instead of resolved schema-path casing</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7416";>CALCITE-7416</a>] Add
<code class="language-plaintext highlighter-rouge">firedRulesCache</code> for
<code class="language-plaintext highlighter-rouge">HepPlanner</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7417";>CALCITE-7417</a>] Add
a large plan benchmark for <code class="language-plaintext
highlighter-rouge">HepPlanner</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7418";>CALCITE-7418</a>]
<code class="language-plaintext highlighter-rouge">SqlOverlapsOperator</code>
does not reject some illegal comparisons (e.g., <code class="language-plaintext
highlighter-rouge">TIME</code> vs <code class="language-plaintext
highlighter-rouge">DATE</code>)</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7423";>CALCITE-7423</a>]
<code class="language-plaintext highlighter-rouge">Setop</code> subquery
without correlated variables triggers <code class="language-plaintext
highlighter-rouge">NullPointerException</code> during decorrelation</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7425";>CALCITE-7425</a>]
Correct the logical inverse of <code class="language-plaintext
highlighter-rouge">SqlBetweenOperator</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7427";>CALCITE-7427</a>]
Query with <code class="language-plaintext highlighter-rouge">ORDER BY
NULL</code> throws <code class="language-plaintext
highlighter-rouge">NoSuchMethodException: compareNullsLast</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7429";>CALCITE-7429</a>]
Unable to implement <code class="language-plaintext
highlighter-rouge">EnumerableMinus</code> for SQL queries with <code
class="language-plaintext highlighter-rouge">EXCEPT</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7431";>CALCITE-7431</a>]
<code class="language-plaintext highlighter-rouge">RelTraitSet#getTrait</code>
mishandles <code class="language-plaintext
highlighter-rouge">RelCompositeTrait</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7432";>CALCITE-7432</a>]
<code class="language-plaintext highlighter-rouge">NumberFormatException</code>
when convert <code class="language-plaintext highlighter-rouge">NaN</code>
literal to SQL</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7433";>CALCITE-7433</a>]
Invalid unparse for <code class="language-plaintext
highlighter-rouge">CAST</code> to <code class="language-plaintext
highlighter-rouge">MAP</code> type in Spark</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7434";>CALCITE-7434</a>]
<code class="language-plaintext highlighter-rouge">AssertionError</code> in new
decorrelation algorithm caused by <code class="language-plaintext
highlighter-rouge">FilterJoinRule</code> omitting <code
class="language-plaintext highlighter-rouge">variablesSet</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7435";>CALCITE-7435</a>]
Window functions should allow <code class="language-plaintext
highlighter-rouge">ORDER BY</code> fields of type <code
class="language-plaintext highlighter-rouge">INTERVAL</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7437";>CALCITE-7437</a>]
Type coercion for quantifier operators is incomplete</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7441";>CALCITE-7441</a>]
<code class="language-plaintext
highlighter-rouge">AggregateFilterToFilteredAggregateRule</code> fails when
<code class="language-plaintext highlighter-rouge">WHERE</code> condition is
nullable</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7442";>CALCITE-7442</a>]
Correlated variable has wrong index inside subquery</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7443";>CALCITE-7443</a>]
Incorrect simplification for large interval</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7447";>CALCITE-7447</a>]
<code class="language-plaintext highlighter-rouge">RelRoot.project</code> adds
<code class="language-plaintext highlighter-rouge">Project</code> for DDL
nodes</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7450";>CALCITE-7450</a>]
<code class="language-plaintext highlighter-rouge">ValuesReduceRule</code>
incorrectly drops tuples when filter condition is irreducible</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7456";>CALCITE-7456</a>]
Enable the <code class="language-plaintext highlighter-rouge">TRY_CAST</code>
function to support the MSSQL dialect</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7457";>CALCITE-7457</a>]
<code class="language-plaintext highlighter-rouge">VALUES</code> and <code
class="language-plaintext highlighter-rouge">SELECT</code> produce different
validation results for the same expression</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7461";>CALCITE-7461</a>] Add
<code class="language-plaintext highlighter-rouge">@Strict</code> to <code
class="language-plaintext highlighter-rouge">ByteArrayFunction</code> and <code
class="language-plaintext highlighter-rouge">ByteArrayLengthFunction</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7465";>CALCITE-7465</a>]
Make <code class="language-plaintext highlighter-rouge">MATCH_RECOGNIZE</code>
tolerant to <code class="language-plaintext highlighter-rouge">FINAL</code> and
<code class="language-plaintext highlighter-rouge">RUNNING</code> non function
<code class="language-plaintext highlighter-rouge">MEASURES</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7466";>CALCITE-7466</a>]
Unparse of <code class="language-plaintext
highlighter-rouge">MATCH_RECOGNIZE</code> produces duplicate aliases</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7467";>CALCITE-7467</a>]
<code class="language-plaintext highlighter-rouge">MATCH_RECOGNIZE</code> does
not support aliases for tableRef</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7468";>CALCITE-7468</a>] The
<code class="language-plaintext highlighter-rouge">SPLIT_PART</code>
implementation is incorrect for regex patterns</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7470";>CALCITE-7470</a>]
Unparse of <code class="language-plaintext highlighter-rouge">DEFINE</code> in
<code class="language-plaintext highlighter-rouge">MATCH_RECOGNIZE</code> leads
to incorrect SQL</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7471";>CALCITE-7471</a>]
Alias is not auto generated for <code class="language-plaintext
highlighter-rouge">MATCH_RECOGNIZE</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7472";>CALCITE-7472</a>]
Arrow adapter should support <code class="language-plaintext
highlighter-rouge">LIKE</code> operator push down</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7474";>CALCITE-7474</a>]
<code class="language-plaintext highlighter-rouge">LAST</code> in <code
class="language-plaintext highlighter-rouge">MATCH_RECOGNIZE</code> might
return wrong result</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7475";>CALCITE-7475</a>]
Babel parser allows postfix access after PostgreSQL-style <code
class="language-plaintext highlighter-rouge">::</code> infix cast</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7477";>CALCITE-7477</a>]
Push schema pattern filter into sub-schema map lookup to avoid loading all
schemas</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7479";>CALCITE-7479</a>]
Remove redundant aggregate group keys with FD</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7480";>CALCITE-7480</a>]
Unparse of <code class="language-plaintext
highlighter-rouge">MATCH_RECOGNIZE</code> with <code class="language-plaintext
highlighter-rouge">PARTITION BY</code> or <code class="language-plaintext
highlighter-rouge">ORDER BY</code> produces invalid SQL</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7482";>CALCITE-7482</a>]
Wrong variablesSet used when rewriting subquery in <code
class="language-plaintext highlighter-rouge">JOIN ON</code> clause</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7483";>CALCITE-7483</a>]
<code class="language-plaintext highlighter-rouge">RelToSqlConverter</code>
generates <code class="language-plaintext highlighter-rouge">SELECT *</code>
despite <code class="language-plaintext
highlighter-rouge">supportGenerateSelectStar</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7484";>CALCITE-7484</a>] Add
a rule to eliminate redundant aggregates functions over <code
class="language-plaintext highlighter-rouge">GROUP BY</code> keys</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7485";>CALCITE-7485</a>]
<code class="language-plaintext
highlighter-rouge">FIRST_VALUE/LAST_VALUE</code> should only be defined for
window aggregates</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7486";>CALCITE-7486</a>]
Operators in <code class="language-plaintext
highlighter-rouge">MATCH_RECOGNIZE</code> don’t support <code
class="language-plaintext highlighter-rouge">SqlLiterals</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7490";>CALCITE-7490</a>]
<code class="language-plaintext highlighter-rouge">PruneEmptyRules</code> is
ineffective for window statements</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7491";>CALCITE-7491</a>]
Literals of type <code class="language-plaintext highlighter-rouge">TIMESTAMP
WITH TIME ZONE</code> cause crashes</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7492";>CALCITE-7492</a>]
Support expression that has a constant value within the group involving only
<code class="language-plaintext highlighter-rouge">GROUP BY</code> keys as
aggregate arguments</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7496";>CALCITE-7496</a>]
OS-adapter usability</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7497";>CALCITE-7497</a>]
Support constant folding in Lambda expressions</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7499";>CALCITE-7499</a>]
<code class="language-plaintext highlighter-rouge">COALESCE</code> with args of
different types might be incorrectly simplified</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7501";>CALCITE-7501</a>]
<code class="language-plaintext highlighter-rouge">AssertionError</code> in
alias expansion for <code class="language-plaintext highlighter-rouge">LEFT
JOIN USING</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7502";>CALCITE-7502</a>]
<code class="language-plaintext highlighter-rouge">RelToSqlConverter</code>
creates invalid sql when converting nested window contains <code
class="language-plaintext highlighter-rouge">SqlCaseWhen</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7503";>CALCITE-7503</a>]
Hint validation does not have access to source position</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7504";>CALCITE-7504</a>] Use
lazy logging in Hypergraph code</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7506";>CALCITE-7506</a>]
<code class="language-plaintext highlighter-rouge">RelWriterImpl</code> does
not output hints</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7514";>CALCITE-7514</a>]
<code class="language-plaintext
highlighter-rouge">MultiJoinOptimizeBushyRule</code> throws <code
class="language-plaintext highlighter-rouge">AssertionError</code> when a join
condition references 3 or more factors</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7522";>CALCITE-7522</a>]
Allow <code class="language-plaintext highlighter-rouge">EXTRACT(interval FROM
tz)</code> to operate on <code class="language-plaintext
highlighter-rouge">TIMESTAMP WITH TIME ZONE</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7524";>CALCITE-7524</a>]
<code class="language-plaintext highlighter-rouge">JdbcSchema</code> throws
exception for <code class="language-plaintext highlighter-rouge">DECIMAL</code>
columns with precision 0 in JDBC metadata</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7526";>CALCITE-7526</a>]
Incorrect <code class="language-plaintext highlighter-rouge">TIMESTAMP WITH
TIME ZONE</code> produces wrong error message</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7527";>CALCITE-7527</a>]
<code class="language-plaintext
highlighter-rouge">SqlParserUtil.parseTimestampTzLiteral</code> does not
validate timezone</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7530";>CALCITE-7530</a>]
<code class="language-plaintext highlighter-rouge">FOR SYSTEM_TIME AS OF</code>
on CTE causes NPE while validation</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7531";>CALCITE-7531</a>] Add
to <code class="language-plaintext highlighter-rouge">BasicSqlType</code>
constructor accepting precision, scale and nullability</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7532";>CALCITE-7532</a>]
Model usability</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7533";>CALCITE-7533</a>]
Parser rejects parenthesized query as the body of a <code
class="language-plaintext highlighter-rouge">WITH</code> clause</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7537";>CALCITE-7537</a>]
Invalid Postgres SQL generated for right-deep comma join trees</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7538";>CALCITE-7538</a>]
<code class="language-plaintext highlighter-rouge">SqlValidatorImpl</code>
should reject <code class="language-plaintext
highlighter-rouge">MATCH_RECOGNIZE</code> with duplicate <code
class="language-plaintext highlighter-rouge">MEASURE</code> alias</li>
+ <li>Add debug log for query plan after decorrelation completion</li>
+ <li>Carry source position information through more code rewrites</li>
+ <li>Make SqlValidatorImpl#maybeCast protected to allow using it by child
classes</li>
+</ul>
+
+<h4 id="build-1-42-0">Build and test suite</h4>
+
+<ul>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-4947";>CALCITE-4947</a>]
Checkstyle fails on classes generated by Intellij when using option “build and
run [tests] using Intellij IDEA”</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7020";>CALCITE-7020</a>]
Upgrade gradle from 8.7 to 8.14.4</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7261";>CALCITE-7261</a>]
<code class="language-plaintext highlighter-rouge">DiffRepository</code>
generation xml does not respect alphabetical order</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7265";>CALCITE-7265</a>]
Allow <code class="language-plaintext
highlighter-rouge">RelOptFixture.relFn</code> to be used with
VolcanoPlanner</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7292";>CALCITE-7292</a>]
Replace <code class="language-plaintext highlighter-rouge">case when true then
deptno else null end</code> with a non-simplifiable expression in
RelOptRulesTest</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7342";>CALCITE-7342</a>]
Quidem test support for <code class="language-plaintext
highlighter-rouge">TopDownGeneralDecorrelator</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7345";>CALCITE-7345</a>]
Quidem test support for <code class="language-plaintext
highlighter-rouge">Field Trimmer</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7381";>CALCITE-7381</a>]
Parameters modified by <code class="language-plaintext
highlighter-rouge">!set</code> must be restored to their default values in
Quidem test</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7424";>CALCITE-7424</a>] In
Lint, support sort specifications</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7426";>CALCITE-7426</a>] Add
a PR submission template to Calcite</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7473";>CALCITE-7473</a>]
Better IntelliJ and VSCode .gitignore</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7481";>CALCITE-7481</a>]
Support jdk24 in CI</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7507";>CALCITE-7507</a>] NPE
in <code class="language-plaintext
highlighter-rouge">ReleaseExtension.<init></code> when building from
sources</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-7561";>CALCITE-7561</a>]
Upgrade OWASP plugin from 6.1.6 to 12.2.2</li>
+ <li>Add sub-query, some, misc, scalar iq files in <code
class="language-plaintext highlighter-rouge">CoreQuidemTest2</code>
+</li>
+ <li>Move ExpandDisjunctionForJoinInputsRule test from planner.iq to
hep.iq</li>
+ <li>Replace <code class="language-plaintext
highlighter-rouge">replace</code> with <code class="language-plaintext
highlighter-rouge">toLinux</code> in <code class="language-plaintext
highlighter-rouge">RelMetadataTest</code>
+</li>
+ <li>Test cases for:
+ <ul>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-2359";>CALCITE-2359</a>]
Inconsistent behavior when casting interval literals to integer</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-3366";>CALCITE-3366</a>]
<code class="language-plaintext highlighter-rouge">RelDecorrelator</code>
supports <code class="language-plaintext highlighter-rouge">Union</code>
+</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-4232";>CALCITE-4232</a>]
Elasticsearch <code class="language-plaintext highlighter-rouge">IN</code>
Query is not supported</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-5124";>CALCITE-5124</a>]
<code class="language-plaintext highlighter-rouge">LIMIT</code> won’t work when
<code class="language-plaintext highlighter-rouge">GROUP BY</code> two or more
columns in Elasticsearch Adapter</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-5161";>CALCITE-5161</a>]
<code class="language-plaintext highlighter-rouge">NPE</code> when inserting a
null value into a decimal column</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-5578";>CALCITE-5578</a>]
RelOptRulesTest testAggregateCaseToFilter optimized plan not semantically
equivalent to the original one after conversion</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6282";>CALCITE-6282</a>]
Avatica ignores time precision when returning TIME results</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6299";>CALCITE-6299</a>]
Support <code class="language-plaintext highlighter-rouge">JOIN</code> in Arrow
adapter</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6452";>CALCITE-6452</a>]
Scalar sub-query that uses <code class="language-plaintext
highlighter-rouge">IS NOT DISTINCT FROM</code> returns incorrect result</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/CALCITE-6985";>CALCITE-6985</a>] Add
rule to transform <code class="language-plaintext
highlighter-rouge">MIN/MAX</code> with <code class="language-plaintext
highlighter-rouge">ORDER BY</code> and <code class="language-plaintext
highlighter-rouge">LIMIT 1</code>
+</li>
+ <li>
+<code class="language-plaintext highlighter-rouge">SetOpToFilterRule</code> to
verify that PROJECT containing non-deterministic expressions and subqueries are
not merged</li>
+ </ul>
+ </li>
+</ul>
+
+<h4 id="site-1-42-0">Web site and documentation</h4>
+
+<ul>
+ <li>Document how PMC members add JIRA users to project roles</li>
+ <li>Add Feldera to ‘powered by Calcite’ page</li>
+ <li>Site: Add Zhen Chen as PMC</li>
+ <li>Site: Add Weihua Zhang as committer</li>
+ <li>Site: Add Thomas Rebele as committer</li>
+ <li>Site: Add Yu Xu as committer</li>
+ <li>Site: Add Silun Dong as committer</li>
+ <li>Site: Update Ruben QL info</li>
+ <li>Bump addressable from 2.8.7 to 2.9.0 in /site</li>
+ <li>Bump nokogiri from 1.18.9 to 1.19.3 in /site</li>
+</ul>
+
+<p>–></p>
+
<h2 id="v1-41-0">
<a
href="https://github.com/apache/calcite/releases/tag/calcite-1.41.0";>1.41.0</a>
/ 2025-11-01</h2>
diff --git a/docs/howto.html b/docs/howto.html
index eba09c045..2150157c5 100644
--- a/docs/howto.html
+++ b/docs/howto.html
@@ -178,8 +178,8 @@ and Gradle (version 8.14.4) on your path.</p>
<code class="language-plaintext highlighter-rouge">cd</code> to the root
directory of the unpacked source,
then build using Gradle:</p>
-<figure class="highlight"><pre><code class="language-bash"
data-lang="bash"><span class="nv">$ </span><span class="nb">tar </span>xvfz
apache-calcite-1.41.0-src.tar.gz
-<span class="nv">$ </span><span class="nb">cd </span>apache-calcite-1.41.0-src
+<figure class="highlight"><pre><code class="language-bash"
data-lang="bash"><span class="nv">$ </span><span class="nb">tar </span>xvfz
apache-calcite-1.42.0-src.tar.gz
+<span class="nv">$ </span><span class="nb">cd </span>apache-calcite-1.42.0-src
<span class="nv">$ </span>gradle build</code></pre></figure>
<p><a href="#running-tests">Running tests</a> describes how to run more or
fewer
diff --git a/img/avatars/Zhiqiang-He.png b/img/avatars/Zhiqiang-He.png
index 2583187ff..a5a86cbce 100644
Binary files a/img/avatars/Zhiqiang-He.png and b/img/avatars/Zhiqiang-He.png
differ
