Version 1.0.2

    Note

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

    If you want to perform a rolling upgrade, your current CrateDB version number must be or higher. If you want to upgrade from a version prior to this, the upgrade will introduce all of the breaking changes listed for Version 1.0.0, and will require a .

    Warning

    Before upgrading, you should back up your data.

    • It is not possible any more to circumvent NOT NULL column constraint by omitting the column in the INSERT statement.

    Fixes

    • Fixed a NPE when using a percentile aggregation in a multi-node environment.

    • Fixed INDEX constraint validation. Defining it on complex data types like e.g. was silently ignored instead of throwing an error.

    • Fixed an issue that causes UnsupportedFeatureException for operations on a table where array access is used inside generated columns. e.g.:

    • Fixed an issue that causes hanging queries if a data node disconnects from the cluster.

    • Fixed an issue that causes UnhandledServerException on joins when WHERE clause contains conditions on columns of array type of both tables which are separated with the . e.g.:

    • Scalar functions longitude and latitude no longer show misleading results.

    • Fixed an issue that causes ClassCastException on outer joins when WHERE clause contains a condition that prevents null values on the relation that may produce nulls. e.g.:

    • Fixed an issue that causes an error to be thrown if nested method calls are used in clause. e.g.: