<commit_before>======================
Changes for Crate Data
======================

Unreleased
==========

 - fix: pre-calculated count is now also used on partitioned tables

 - fix: trying to copy out of a non-existent partition now throws an
   appropriate exception

 - fix: some shard errors were not being raised and so the shard failed silently
   when some kind of errors, like an Out of memory error occured.

 - upgraded ES upstream to v1.3.4

 - Fix: allow subscript access on array literals and parameters as subscript
   indices

 - Fix: The ``>`` and ``<`` operators didn't behave correctly in some cases for
   string values if used on a system table or if both operands were literals.

 - fix: updating a partitioned table with a WHERE clause querying for a
   non existent column of for a non existent partition value led to
   updating all partitions of the queried table

 - fix: deleting on a partitioned table with a WHERE clause querying for a
   non existent column or for a non existent partition value led to
   deletion of all partitions of the queried table

 - Fix: Copy from using the PARTITION clause imported into a ``null`` partition
   instead of using the partition clause.

 - All scalar functions can now be used in the WHERE clause in SELECT
   statements and they may be nested without limitations. In addition it is now
   possible to compare one scalar function to another.

 - Added support to compare one column with another in the WHERE clause for
   SELECT statements.

 - Implemented regular expression scalar functions and query operator

 - Support for accessing items in an array. Please refer to the
   ``Crate SQL -> Querying Crate -> Retrieving Data -> Object Arrays``
   documentation section for details and limitations.

 - Renamed NullType to UndefinedType in order to avoid confusion
   about its usage

2014/09/26 0.44.2<commit_msg>updated changelog to reflect releases 0.44.6, 0.44.5 0.44.4, 0.43.5, 0.42.5, 0.44.3, 0.43.4, 0.42.4<commit_after>======================
Changes for Crate Data
======================

Unreleased
==========

 - All scalar functions can now be used in the WHERE clause in SELECT
   statements and they may be nested without limitations. In addition it is now
   possible to compare one scalar function to another.

 - Added support to compare one column with another in the WHERE clause for
   SELECT statements.

 - Implemented regular expression scalar functions and query operator

 - Support for accessing items in an array. Please refer to the
   ``Crate SQL -> Querying Crate -> Retrieving Data -> Object Arrays``
   documentation section for details and limitations.

 - Renamed NullType to UndefinedType in order to avoid confusion
   about its usage

2014/10/14 0.44.6
=================

 - fix: pre-calculated count is now also used on partitioned tables

2014/10/10 0.44.5
=================

 - fix: trying to copy out of a non-existent partition now throws an
   appropriate exception

 - fix: some shard errors were not being raised and so the shard failed silently
   when some kind of errors, like an Out of memory error occured.

 - upgraded ES upstream to v1.3.4

2014/10/04 0.44.4
2014/10/04 0.43.5
2014/10/04 0.42.5
=================

 - Fix: The ``>`` and ``<`` operators didn't behave correctly in some cases for
   string values if used on a system table or if both operands were literals.

 - fix: updating a partitioned table with a WHERE clause querying for a
   non existent column of for a non existent partition value led to
   updating all partitions of the queried table

2014/10/02 0.44.3
2014/10/02 0.43.4
2014/10/02 0.42.4
=================

 - fix: deleting on a partitioned table with a WHERE clause querying for a
   non existent column or for a non existent partition value led to
   deletion of all partitions of the queried table

 - Fix: Copy from using the PARTITION clause imported into a ``null`` partition
   instead of using the partition clause.

2014/09/26 0.44.2
{'fraction_non_alphanumeric': 0.09056792594445834, 'fraction_numerical': 0.03952964723542657, 'mean_word_length': 3.574370709382151, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 11, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7164879', 'n_tokens_mistral': 1154, 'n_tokens_neox': 1002, 'n_words': 567}