Version 4.6.8

Released on 2022-03-09.


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

We recommend that you upgrade to the latest 4.3 release before moving to 4.6.8.

A rolling upgrade from 4.5.x to 4.6.8 is supported.

Before upgrading, you should back up your data.

Table of Contents

See the Version 4.6.0 release notes for a full list of changes in the 4.6 series.


  • Fixed an issue from COPY FROM that caused the tables’ default expressions to be evaluated only once, causing a single value to be used throughout the table instead of per row. This only affected non-deterministic functions such as gen_random_text_uuid(), random(), etc.

  • Fixed an issue that could lead to errors when reading translog files from CrateDB versions < 4.0.

  • Fixed an issue that could lead to an Couldn't create execution plan error when using a join condition referencing multiple other relations.

  • Fixed an issue that led to an Invalid query used in CREATE VIEW error if using a scalar subquery within the query part of a CREATE VIEW statement.

  • Fixed an issue that caused truncation of milliseconds in timezone scalar function.

  • Fixed an issue that caused a failure when a window function over a partition is not used in an upper query. For example: select x from (select x, ROW_NUMBER() OVER (PARTITION BY y) from t) t1

  • Fixed an incorrect optimization of comparison function arguments for explicit cast arguments resulting in a wrong result set. Example: WHERE strCol::bigint > 3