Version 4.2.2¶
Released on 2020-07-28.
Note
If you are upgrading a cluster, you must be running CrateDB 4.0.2 or higher before you upgrade to 4.2.2.
We recommend that you upgrade to the latest 4.1 release before moving to 4.2.2.
A rolling upgrade from 4.1.7+ to 4.2.2 is supported.
Before upgrading, you should back up your data.
Table of Contents
See the Version 4.2.0 release notes for a full list of changes in the 4.2 series.
Fixes¶
- Fixed an issue that occasionally caused EXPLAIN ANALYZE to return invalid query breakdown results or fail with the index out of bound exception.
- Fixed a regression that caused
INSERT INTO
statements in tables with a nested CLUSTERED BY column to fail. - Fixed a regression introduced in 4.2.0 that caused subscript lookups on ignored object columns to raise an error instead of a null value if the key doesn’t exist.
- Fixed a performance regression introduced in 4.2.0 which caused queries with
a
ORDER BY
but withoutLIMIT
to execute slower than they used to. - Fixed an issue that prevented queries executed using a
query-then-fetch
strategy from being labelled correctly in the sys.jobs_metrics and sys.jobs_log tables. - Fixed a regression introduced in 4.2.0 which caused queries including a
virtual table, and both a
ORDER BY
andLIMIT
clause to fail. - Fixed a regression introduced in 4.2.0 that resulted in
NULL
values being returned for partition columns instead of the actual values. - Allow all users to execute
DISCARD
andSET TRANSACTION
statement. These are session local statements and shouldn’t require special privileges. - Updated the bundled JDK to 14.0.2-12
- Increased the default interval for stats.service.interval <stats.service.interval> from one hour to 24 hours because invoking it every hour caused significant extra load on a cluster.
- Fixed an issue that caused
SHOW CREATE TABLE
to print columns of typeVARCHAR(n)
asTEXT
, leading to a loss of the length information when using theSHOW CREATE TABLE
statement to re-create a table. - Fixed an issue that prevented
ALTER TABLE .. ADD COLUMN
statements from working on tables containing aPRIMARY KEY
column with aINDEX OFF
definition.