.. _version_2.1.7:

=============
Version 2.1.7
=============

Released on 2017/09/14.

.. 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.7.

    If you want to perform a `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 `full restart upgrade`_.

    Consult the upgrade notes for :ref:`Version 2.1.0
    <version_2.1.0_upgrade_notes>` when upgrading.

.. WARNING::

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

.. _rolling upgrade: https://crate.io/docs/crate/howtos/en/latest/admin/rolling-upgrade.html
.. _full restart upgrade: https://crate.io/docs/crate/howtos/en/latest/admin/full-restart-upgrade.html
.. _back up your data: https://crate.io/docs/crate/reference/en/latest/admin/snapshots.html

.. rubric:: Table of contents

.. contents::
   :local:

Changelog
=========

Fixes
-----

- Fixed an issue causing global aggregations with ``JOINs`` on virtual tables
  (:ref:`subselects <gloss-subquery>`) which contain ``LIMIT`` to return
  incorrect results. E.g.::

    SELECT COUNT(*) FROM
      (SELECT * FROM t1 ORDER BY a LIMIT 5) t1,
    JOIN
      t2
    ON t1.a = t2.b

- Fixed an issue that caused an error when trying to create a table with a
  :ref:`generated column expression <ddl-generated-columns-expressions>` of
  type array.

- Fixed an issue that caused the ``account_user``-column to be empty in the
  twitter tutorial plugin of the Admin UI.

- Fixed an issue when using ``GRANT``/``REVOKE``/``DENY`` statements on a
  table with a custom schema set. The statements would result in permission
  changed on the default ``doc`` schema.

- Fixed an issue with ``INNER`` and ``CROSS JOINS`` on more than 2 tables that
  could result in a ``Iterator is not on a row`` error.
