Version 6.4.4¶

Released on 2026-09-03.

Note

If you are upgrading a cluster, you must be running CrateDB 5.0.0 or higher before you upgrade to 6.4.4.

We recommend that you upgrade to the latest 6.3 release before moving to 6.4.4.

A rolling upgrade from >= 6.3.0 to 6.4.4 is supported. Before upgrading, you should back up your data.

Warning

Tables that were created before CrateDB 5.x will not function with 6.x and must be recreated before moving to 6.x.x.

You can recreate tables using COPY TO and COPY FROM or by inserting the data into a new table.

Table of contents

See the Version 6.4.0 release notes for a full list of changes in the 6.4 series.

Fixes ¶

Fixed an issue that caused CREATE VIEW statements to fail if their query contained a parameter placeholder (?) for a bit value with an error like:
```
Cannot cast `'B''0101'''` of type `text` to type `bit(4)`
```
Fixed an issue that could cause inserts to be routed to the wrong shards if writing to a table with more than one shard and a primary key column that has a default clause and omitting that column in the INSERT INTO statement. Those incorrectly routed records were then not found using SELECT statements containing a WHERE clause with an equal expression on the primary key column - which get optimized to do a primary key lookup.

Note that the fix doesn’t repair already incorrectly routed records. It prevents new records from being routed incorrectly.
Fixed command tags sent to PostgreSQL wire protocol clients when using the simple query mode to execute multiple statements at once. Previously the command tag was always based on the first statement, now each command tag is derived from the corresponding individual statement.
Fixed an issue that caused a UNION ALL inside a sub-select to return an additional column, or to fail with Index x out of bounds for length y, if the outer query used an ORDER BY on a column which was not selected and the sub-select contained further columns which were neither selected nor used by the ORDER BY. e.g:
```
SELECT c3 FROM (SELECT * FROM tbl UNION ALL SELECT * FROM tbl) x ORDER BY c1;
```
Fixed an issue that could return wrong results if a WHERE clause contained a non-deterministic function, like random(), and was applied on a virtual relation which uses window functions, GROUP BY or table functions. Prevent the push down for such filters, as they can produce different results than if applied after those operations as intended.
Fixed an issue that caused under-accounting of memory usage for queries using array_agg() aggregation function and aggregation queries using DISTINCT.
Fixed an issue that caused ~ and ~* regular expression operators to not match any rows when used in the WHERE clause of a query on column with INDEX OFF, e.g.:
```
SELECT * FROM tbl WHERE no_index_col ~ '[a-z]'
```
Fixed an issue where a node could still shut down when the cluster health wait timed out during decommissioning despite cluster.graceful_stop.force=false.
Improved the error message for queries involving an uncorrelated subquery in join condition. e.g:
```
SELECT * FROM t JOIN t AS t2 ON t.c = (select 1)
```
Fixed an issue that could cause a correlated subquery inside a join, to ignore a filter on a bare boolean column of the outer relation. As a consequence, it could return rows that should have been filtered out. e.g.:
```
SELECT (
    SELECT count(*)
    FROM t t1 CROSS JOIN t t2
    WHERE t1.col = t2.col AND q.flag
)
FROM t q;
```
In this example, the q.flag filter was dropped.
Fixed an issue that caused wrong results when array_agg() aggregation function was used with window functions with an explicit window frame, e.g.:
```
SELECT array_agg(x) OVER(
  ORDER BY x ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM tbl
```
Fixed an issue where ALL did not return TRUE when comparing NULL values against an empty array.
Fixed an issue that caused wrong accounting of memory usage for queries using string_agg() aggregation function.
Fixed an issue that caused wrong results when string_agg() aggregation function was used with window functions with a dynamic delimeter and an explicit window frame, e.g.:
```
SELECT string_agg(value, delimiter) OVER(
  ORDER BY value ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM tbl
```
Fixed an issue where ANY did not return FALSE when comparing NULL against an empty array.

Fixed an issue when using UNION ALL where types were not cast properly when the different union branches had different types, e.g:

SELECT count(*) AS cnt
FROM (
    SELECT 1::integer AS x
    UNION ALL
    SELECT 2147483648::bigint AS x
) AS u
WHERE x > 2147483647;

Fixed a regression introduced with Version 6.4.3, causing queries with aggregations to fail with false positive CircuitBreakerException.
Fixed an issue causing CREATE SNAPSHOT statements to get stuck.

Version 6.4.4¶

Fixes¶

Fixes ¶