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

Unreleased
==========

 - updated crash to 0.9.10 which includes following changes:

    - NULL values are now handled correctly.

    - fix: increased precision of float formatting

    - crash renders complex types as json now instead of python representation

    - print -1 for rowcount if rowcount is unknown

 - fix: display nested columns correctly in ``information_schema.table_partitions.values``

 - implemented ``LIKE`` and ``NOT LIKE`` operators on string arrays and sets::

        SELECT * from <table> WHERE 'pattern%' [NOT] LIKE (<column>)

 - fix: `date_trunc` will now accept literals of type long or string and
   attempt to convert them to a timestamp.

 - fix: ``count(*)`` on a table which has unavailable records will now result
   in a failure instead of returning only the available records

 - fix: insert statements with a large number of multi-values didn't insert all
   rows if the internal threading queues run full.

 - fix: fix npe in partition clause analysis with null value

 - improved error messages

 - arithmetic operators now also work with timestamps

 - added arithmetic operators

 - implemented partition support for ``copy`` statements

    - added ``copy my_table PARTITION (<columnName> = <value> [, ...]) to ... ``
      to export single partitions of partitioned tables

    - added ``copy my_table PARTITION (<columnName> = <value> [, ...]) from ...``
      to import all data into a single partition

 - implemented alter table to operate on single partitions

 - implemented object and array literals

 - changed refresh table for partitioned tables.
   Instead of::

        refresh table my_table PARTITION ident

   it is now::

        refresh table my_table PARITION (<columnName> = <value> [, ... ])

 - the ordering of null values can now be influenced using the ``NULLS { FIRST
   | LAST }`` keywords.

2014/05/23 0.38.2
=================

 - updated crash to 0.9.7 which includes following changes:

    - return exit code 1 if the execution of a single command fails<commit_msg>prepare release 0.38.3<commit_after>======================
Changes for Crate Data
======================

Unreleased
==========

 - implemented ``LIKE`` and ``NOT LIKE`` operators on string arrays and sets::

        SELECT * from <table> WHERE 'pattern%' [NOT] LIKE (<column>)

 - improved error messages

 - added arithmetic operators

 - implemented partition support for ``copy`` statements

    - added ``copy my_table PARTITION (<columnName> = <value> [, ...]) to ... ``
      to export single partitions of partitioned tables

    - added ``copy my_table PARTITION (<columnName> = <value> [, ...]) from ...``
      to import all data into a single partition

 - implemented alter table to operate on single partitions

 - implemented object and array literals

 - changed refresh table for partitioned tables.
   Instead of::

        refresh table my_table PARTITION ident

   it is now::

        refresh table my_table PARITION (<columnName> = <value> [, ... ])

 - the ordering of null values can now be influenced using the ``NULLS { FIRST
   | LAST }`` keywords.

2014/06/03 0.38.3
=================

 - updated crash to 0.9.10 which includes following changes:

    - NULL values are handled correctly

    - fix: increased precision of float formatting

    - crash renders complex types as json instead of their python representation

    - return -1 for rowcount if rowcount is unknown

 - fix: `date_trunc` will now accept literals of type long or string and
   attempt to convert them to a timestamp.

 - fix: ``count(*)`` on a table which has unavailable records will now result
   in a failure instead of returning only the available records

 - fix: insert statements with a large number of multi-values didn't insert all
   rows if the internal threading queues run full.

 - fix: display nested columns correctly in ``information_schema.table_partitions.values``

 - fix: id generation on import via `COPY FROM` were wrong if multiple
   primary key constraints and clustered-by were used.
   WARNING: records must be re-imported otherwise queries with filter
   on primary key columns will not match any record

2014/05/23 0.38.2
=================

 - updated crash to 0.9.7 which includes following changes:

    - return exit code 1 if the execution of a single command fails
{'fraction_non_alphanumeric': 0.10817524841915085, 'fraction_numerical': 0.013098464317976514, 'mean_word_length': 3.380811078140455, 'pattern_counts': {'":': 0, '<': 19, '<?xml version=': 0, '>': 19, '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': '2516453', 'n_tokens_mistral': 1184, 'n_tokens_neox': 1042, 'n_words': 546}