Version 5.7.0¶

Released on 2024-04-05.

Note

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

We recommend that you upgrade to the latest 5.6 release before moving to 5.7.0.

A rolling upgrade from 5.6.x to 5.7.0 is supported. Before upgrading, you should back up your data.

Warning

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

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

Table of contents

Breaking Changes ¶

Added CURRENT_ROLE as a reserved keyword. If you have a column or table named CURRENT_ROLE, you must escape it using double quotes.
Changed exp(number) to always return double type for its result, independently of the input type.

None

Allow shortcut one-char names for PostgreSQL style INTERVALs, e.g.:
```
SELECT '1y 2w 3d 4h 5m 6s'::INTERVAL
```
Added initial support for foreign data wrappers, including a jdbc foreign data wrapper.
Added the CURRENT_ROLE scalar function as an alias for CURRENT_USER.
Dhruv Patel added support for the ^ operator as syntax sugar for the power(a: number, b: number) scalar function. E.g.:
```
SELECT 5 ^ 2;
```

Removed the -1 to 1 value constraint from atan(number).
Added the reverse(text) scalar function.
rebdiaz added support for lower case yyyy format string to to_char scalar function, which behaves exactly the same as uppercase YYYY to match PostgreSQL behaviour.

Improved the performance for hash-joins when there is a large imbalance between the size of the tables with a lookup-join optimization. This optimization can be disabled if desired, with the session setting:
```
SET optimizer_equi_join_to_lookup_join = false
```
Note that this setting is experimental, and may change in the future.
Improved the performance of the ANALYZE statement. CrateDB now uses much less memory when collecting column statistics.

meteoiker added the ability to set a use_path_style_access for S3 repositories.
Herman Bergwerf added support for Google Cloud Storage repositories to write and restore snapshots on Google Cloud Storage.
Added jwt column to sys.users table which lists JWT authentication specific properties of the user.
Added support for JWT token authentication.