Version 2.3.1

Released on 2018/01/22.


If you are upgrading a cluster, you must be running CrateDB Version 1.1.3 or higher before you upgrade to 2.3.1.

If you want to perform a rolling upgrade, your current CrateDB version number must be at least Version 2.3.0. Any upgrade from a version prior to this will require a full restart upgrade.


Before upgrading, you should back up your data.

Table of contents



  • In certain cases it’s no longer necessary to explicitly add generated columns that are part of a composite primary key to the WHERE clause in order to get an execution plan with real-time semantics.

  • Greatly improved performance of queries that uses scalar functions inside the WHERE clause.


  • Avoid downcasts in function expressions which could lead to reduced precision. For example

    SELECT round(float_col) + 1.1 would result in
      SELECT round(float_col) + 1
    but is now resolved to
      SELECT to_float(round(float_col)) + 1.1
  • Ensured natural order of configuration keys for Host Based Authentication.

  • Fixed encoding/decoding of Timestamp type for PostgreSQL wire protocol to support Golang psql drivers.

  • Fixed an Admin UI issue that caused the Cluster tab to not be loaded correctly.

  • Map the Tab key to insert spaces instead of a tab character in the query console of the Admin UI.

  • Fixed an issue that caused the user name to not be displayed in the Admin UI.