.. _version_2.1.8:

=============
Version 2.1.8
=============

Released on 2017/10/12.

.. NOTE::

   If you are upgrading a cluster, you must be running CrateDB
   :ref:`version_1.1.3` or higher before you upgrade to 2.1.8.

   If you want to perform a :ref:`rolling_upgrade`, your current CrateDB
   version number must be :ref:`version_2.1.0`.  If you want to upgrade from a
   version prior to this, the upgrade will introduce all of the breaking
   changes listed for :ref:`version_2.1.0`, and will require a
   :ref:`full_restart_upgrade`.

   Consult the :ref:`version_2.1.0_upgrade_notes` for ``2.1.0`` when upgrading.

.. WARNING::

   Before upgrading, you should `back up your data`_.

.. _back up your data: https://crate.io/a/backing-up-and-restoring-crate/

Changelog
=========

Fixes
-----

- Fixed an issue that caused ``INSERT`` statements using a subquery on the
  ``sys.shards`` system table to fail.

- Fixed an issue that caused wrong results for ``JOIN`` queries on 3 or more
  tables when ``ORDER BY`` clause contains columns from more than one table.

- Fixed a bug that caused incorrect results to be returned for JOIN queries
  when the table stats indicated that the left table of a join is smaller
  than the right.

- Fixed passing arguments that contain spaces in the crate shell script.

- Fixed an issue that caused a table that is not part of the "doc" schema to
  be unavailable/hidden if it gets closed using ``ALTER TABLE``.

- Fixed an issue where the query circuit breaker would be tripped after
  running several queries due to incorrect memory tracking. Subsequent
  operations would have failed due to the lack of circuit breaker cleanup.