Version 4.5.0

Released on 2021-03-23.

Note

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

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

A rolling upgrade from 4.3.x to 4.5.0 is supported.

Before upgrading, you should back up your data.

Deprecations

• The table setting soft_deletes.enabled has been marked as deprecated and will be removed in a future version. Soft deletes will become mandatory in CrateDB 5.0.

Changes

Licensing

• Relicensed all enterprise features under the Apache License 2.0 and removed licensing related code. The SET LICENSE statement can still be used, but it won’t have any effect.

  Because of this, all users have now access to features like

  • User management.

  • Authentication and SSL/TLS support.

  • User defined function support.

  • All window functions.

  • JMX monitoring features.

  • The hyperloglog_distinct aggregation function.

Performance improvements

• Optimized how NULL values are stored, reducing the amount of disk space required. This can also improve the performance of value lookups on tables with a lot of null values.

SQL and PostgreSQL compatibility improvements

• Added the regclass data type for improved compatibility with PostgreSQL tools.

• Added an empty pg_tablespace table in the pg_catalog schema for improved support for PostgreSQL tools.

• Improved the error messages for cast errors for values of type object.

• Added support for the CREATE TABLE AS statement.

Administration and Operations

• Added support for restoring metadata and settings from snapshots. If ALL is used, everything (tables, settings, views, etc.) will be restored. On the other hand, using TABLES will only restore tables. In previous releases, only tables could be restored, even if ALL was used.

• Improved language selection, translations and general usability at the Admin UI.

• Updated the bundled JDK to 16+36

New scalar and window functions

• Added the gen_random_text_uuid() scalar function.

• Added the pg_postmaster_start_time() scalar function.

• Added CURDATE() and CURRENT_DATE scalar functions.