2019 Changelog

### ClickHouse Release 19.7.3.9, 2019-05-30[​](#clickhouse-release-19-7-3-9-2019-05-30 "Direct link to ClickHouse Release 19.7.3.9, 2019-05-30")

#### New Features[​](#new-features-2 "Direct link to New Features")

- Allow to limit the range of a setting that can be specified by user.
  These constraints can be set up in user settings profile.
  [#4931](https://github.com/ClickHouse/ClickHouse/pull/4931) ([Vitaly
  Baranov](https://github.com/vitlibar))
- Add a second version of the function `groupUniqArray` with an optional
  `max_size` parameter that limits the size of the resulting array. This
  behavior is similar to `groupArray(max_size)(x)` function.
  [#5026](https://github.com/ClickHouse/ClickHouse/pull/5026) ([Guillaume
  Tassery](https://github.com/YiuRULE))
- For TSVWithNames/CSVWithNames input file formats, column order can now be
  determined from file header. This is controlled by
  `input_format_with_names_use_header` parameter.
  [#5081](https://github.com/ClickHouse/ClickHouse/pull/5081)
  ([Alexander](https://github.com/Akazz))

#### Bug Fixes[​](#bug-fixes-2 "Direct link to Bug Fixes")

- Crash with uncompressed\_cache + JOIN during merge (#5197)
  [#5133](https://github.com/ClickHouse/ClickHouse/pull/5133) ([Danila
  Kutenin](https://github.com/danlark1))
- Segmentation fault on a clickhouse-client query to system tables. #5066
  [#5127](https://github.com/ClickHouse/ClickHouse/pull/5127)
  ([Ivan](https://github.com/abyss7))
- Data loss on heavy load via KafkaEngine (#4736)
  [#5080](https://github.com/ClickHouse/ClickHouse/pull/5080)
  ([Ivan](https://github.com/abyss7))
- Fixed very rare data race condition that could happen when executing a query with UNION ALL involving at least two SELECTs from system.columns, system.tables, system.parts, system.parts\_tables or tables of Merge family and performing ALTER of columns of the related tables concurrently. [#5189](https://github.com/ClickHouse/ClickHouse/pull/5189) ([alexey-milovidov](https://github.com/alexey-milovidov))

#### Performance Improvements[​](#performance-improvements-1 "Direct link to Performance Improvements")

- Use radix sort for sorting by single numeric column in `ORDER BY` without
  `LIMIT`. [#5106](https://github.com/ClickHouse/ClickHouse/pull/5106),
  [#4439](https://github.com/ClickHouse/ClickHouse/pull/4439)
  ([Evgenii Pravda](https://github.com/kvinty),
  [alexey-milovidov](https://github.com/alexey-milovidov))

#### Documentation[​](#documentation-1 "Direct link to Documentation")

- Translate documentation for some table engines to Chinese.
  [#5107](https://github.com/ClickHouse/ClickHouse/pull/5107),
  [#5094](https://github.com/ClickHouse/ClickHouse/pull/5094),
  [#5087](https://github.com/ClickHouse/ClickHouse/pull/5087)
  ([张风啸](https://github.com/AlexZFX)),
  [#5068](https://github.com/ClickHouse/ClickHouse/pull/5068) ([never
  lee](https://github.com/neverlee))

#### Build/Testing/Packaging Improvements[​](#buildtestingpackaging-improvements-1 "Direct link to Build/Testing/Packaging Improvements")

- Print UTF-8 characters properly in `clickhouse-test`.
  [#5084](https://github.com/ClickHouse/ClickHouse/pull/5084)
  ([alexey-milovidov](https://github.com/alexey-milovidov))
- Add command line parameter for clickhouse-client to always load suggestion
  data. [#5102](https://github.com/ClickHouse/ClickHouse/pull/5102)
  ([alexey-milovidov](https://github.com/alexey-milovidov))
- Resolve some of PVS-Studio warnings.
  [#5082](https://github.com/ClickHouse/ClickHouse/pull/5082)
  ([alexey-milovidov](https://github.com/alexey-milovidov))
- Update LZ4 [#5040](https://github.com/ClickHouse/ClickHouse/pull/5040) ([Danila
  Kutenin](https://github.com/danlark1))
- Add gperf to build requirements for upcoming pull request #5030.
  [#5110](https://github.com/ClickHouse/ClickHouse/pull/5110)
  ([proller](https://github.com/proller))

## ClickHouse Release 19.6[​](#clickhouse-release-19-6 "Direct link to ClickHouse Release 19.6")

### ClickHouse Release 19.6.3.18, 2019-06-13[​](#clickhouse-release-19-6-3-18-2019-06-13 "Direct link to ClickHouse Release 19.6.3.18, 2019-06-13")

#### Bug Fixes[​](#bug-fixes-3 "Direct link to Bug Fixes")

- Fixed IN condition pushdown for queries from table functions `mysql` and `odbc` and corresponding table engines. This fixes #3540 and #2384. [#5313](https://github.com/ClickHouse/ClickHouse/pull/5313) ([alexey-milovidov](https://github.com/alexey-milovidov))
- Fix deadlock in Zookeeper. [#5297](https://github.com/ClickHouse/ClickHouse/pull/5297) ([github1youlc](https://github.com/github1youlc))
- Allow quoted decimals in CSV. [#5284](https://github.com/ClickHouse/ClickHouse/pull/5284) ([Artem Zuikov](https://github.com/4ertus2)
- Disallow conversion from float Inf/NaN into Decimals (throw exception). [#5282](https://github.com/ClickHouse/ClickHouse/pull/5282) ([Artem Zuikov](https://github.com/4ertus2))
- Fix data race in rename query. [#5247](https://github.com/ClickHouse/ClickHouse/pull/5247) ([Winter Zhang](https://github.com/zhang2014))
- Temporarily disable LFAlloc. Usage of LFAlloc might lead to a lot of MAP\_FAILED in allocating UncompressedCache and in a result to crashes of queries at high loaded servers. [cfdba93](https://github.com/ClickHouse/ClickHouse/commit/cfdba938ce22f16efeec504f7f90206a515b1280)([Danila Kutenin](https://github.com/danlark1))

### ClickHouse Release 19.6.2.11, 2019-05-13[​](#clickhouse-release-19-6-2-11-2019-05-13 "Direct link to ClickHouse Release 19.6.2.11, 2019-05-13")

#### New Features[​](#new-features-3 "Direct link to New Features")

- TTL expressions for columns and tables. [#4212](https://github.com/ClickHouse/ClickHouse/pull/4212) ([Anton Popov](https://github.com/CurtizJ))
- Added support for `brotli` compression for HTTP responses (Accept-Encoding: br) [#4388](https://github.com/ClickHouse/ClickHouse/pull/4388) ([Mikhail](https://github.com/fandyushin))
- Added new function `isValidUTF8` for checking whether a set of bytes is correctly utf-8 encoded. [#4934](https://github.com/ClickHouse/ClickHouse/pull/4934) ([Danila Kutenin](https://github.com/danlark1))
- Add new load balancing policy `first_or_random` which sends queries to the first specified host and if it's inaccessible send queries to random hosts of shard. Useful for cross-replication topology setups. [#5012](https://github.com/ClickHouse/ClickHouse/pull/5012) ([nvartolomei](https://github.com/nvartolomei))

#### Experimental Features[​](#experimental-features-1 "Direct link to Experimental Features")

- Add setting `index_granularity_bytes` (adaptive index granularity) for MergeTree\* tables family. [#4826](https://github.com/ClickHouse/ClickHouse/pull/4826) ([alesapin](https://github.com/alesapin))

#### Improvements[​](#improvements-1 "Direct link to Improvements")

- Added support for non-constant and negative size and length arguments for function `substringUTF8`. [#4989](https://github.com/ClickHouse/ClickHouse/pull/4989) ([alexey-milovidov](https://github.com/alexey-milovidov))
- Disable push-down to right table in left join, left table in right join, and both tables in full join. This fixes wrong JOIN results in some cases. [#4846](https://github.com/ClickHouse/ClickHouse/pull/4846) ([Ivan](https://github.com/abyss7))
- `clickhouse-copier`: auto upload task configuration from `--task-file` option [#4876](https://github.com/ClickHouse/ClickHouse/pull/4876) ([proller](https://github.com/proller))
- Added typos handler for storage factory and table functions factory. [#4891](https://github.com/ClickHouse/ClickHouse/pull/4891) ([Danila Kutenin](https://github.com/danlark1))
- Support asterisks and qualified asterisks for multiple joins without subqueries [#4898](https://github.com/ClickHouse/ClickHouse/pull/4898) ([Artem Zuikov](https://github.com/4ertus2))
- Make missing column error message more user friendly. [#4915](https://github.com/ClickHouse/ClickHouse/pull/4915) ([Artem Zuikov](https://github.com/4ertus2))

#### Performance Improvements[​](#performance-improvements-2 "Direct link to Performance Improvements")