title_wip

[Edit this page](https://github.com/ClickHouse/clickhouse-docs/blob/main/docs/whats-new/changelog/2017.md)

### ClickHouse Release 1.1.54327, 2017-12-21[​](#clickhouse-release-1-1-54327-2017-12-21 "Direct link to ClickHouse Release 1.1.54327, 2017-12-21")

This release contains bug fixes for the previous release 1.1.54318:

- Fixed bug with possible race condition in replication that could lead to data loss. This issue affects versions 1.1.54310 and 1.1.54318. If you use one of these versions with Replicated tables, the update is strongly recommended. This issue shows in logs in Warning messages like `Part ... from own log does not exist.` The issue is relevant even if you do not see these messages in logs.

### ClickHouse Release 1.1.54318, 2017-11-30[​](#clickhouse-release-1-1-54318-2017-11-30 "Direct link to ClickHouse Release 1.1.54318, 2017-11-30")

This release contains bug fixes for the previous release 1.1.54310:

- Fixed incorrect row deletions during merges in the SummingMergeTree engine
- Fixed a memory leak in unreplicated MergeTree engines
- Fixed performance degradation with frequent inserts in MergeTree engines
- Fixed an issue that was causing the replication queue to stop running
- Fixed rotation and archiving of server logs

### ClickHouse Release 1.1.54310, 2017-11-01[​](#clickhouse-release-1-1-54310-2017-11-01 "Direct link to ClickHouse Release 1.1.54310, 2017-11-01")

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

- Custom partitioning key for the MergeTree family of table engines.
- [Kafka](/docs/engines/table-engines/integrations/kafka) table engine.
- Added support for loading [CatBoost](https://yandex.com/dev/catboost/) models and applying them to data stored in ClickHouse.
- Added support for time zones with non-integer offsets from UTC.
- Added support for arithmetic operations with time intervals.
- The range of values for the Date and DateTime types is extended to the year 2105.
- Added the `CREATE MATERIALIZED VIEW x TO y` query (specifies an existing table for storing the data of a materialized view).
- Added the `ATTACH TABLE` query without arguments.
- The processing logic for Nested columns with names ending in -Map in a SummingMergeTree table was extracted to the sumMap aggregate function. You can now specify such columns explicitly.
- Max size of the IP trie dictionary is increased to 128M entries.
- Added the getSizeOfEnumType function.
- Added the sumWithOverflow aggregate function.
- Added support for the Cap'n Proto input format.
- You can now customize compression level when using the zstd algorithm.

#### Backward Incompatible Changes:[​](#backward-incompatible-changes "Direct link to Backward Incompatible Changes:")

- Creation of temporary tables with an engine other than Memory is not allowed.
- Explicit creation of tables with the View or MaterializedView engine is not allowed.
- During table creation, a new check verifies that the sampling key expression is included in the primary key.

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

- Fixed hangups when synchronously inserting into a Distributed table.
- Fixed nonatomic adding and removing of parts in Replicated tables.
- Data inserted into a materialized view is not subjected to unnecessary deduplication.
- Executing a query to a Distributed table for which the local replica is lagging and remote replicas are unavailable does not result in an error anymore.
- Users do not need access permissions to the `default` database to create temporary tables anymore.
- Fixed crashing when specifying the Array type without arguments.
- Fixed hangups when the disk volume containing server logs is full.
- Fixed an overflow in the toRelativeWeekNum function for the first week of the Unix epoch.

#### Build Improvements:[​](#build-improvements "Direct link to Build Improvements:")

- Several third-party libraries (notably Poco) were updated and converted to git submodules.

### ClickHouse Release 1.1.54304, 2017-10-19[​](#clickhouse-release-1-1-54304-2017-10-19 "Direct link to ClickHouse Release 1.1.54304, 2017-10-19")

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

- TLS support in the native protocol (to enable, set `tcp_ssl_port` in `config.xml` ).

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

- `ALTER` for replicated tables now tries to start running as soon as possible.
- Fixed crashing when reading data with the setting `preferred_block_size_bytes=0.`
- Fixed crashes of `clickhouse-client` when pressing `Page Down`
- Correct interpretation of certain complex queries with `GLOBAL IN` and `UNION ALL`
- `FREEZE PARTITION` always works atomically now.
- Empty POST requests now return a response with code 411.
- Fixed interpretation errors for expressions like `CAST(1 AS Nullable(UInt8)).`
- Fixed an error when reading `Array(Nullable(String))` columns from `MergeTree` tables.
- Fixed crashing when parsing queries like `SELECT dummy AS dummy, dummy AS b`
- Users are updated correctly with invalid `users.xml`
- Correct handling when an executable dictionary returns a non-zero response code.

### ClickHouse Release 1.1.54292, 2017-09-20[​](#clickhouse-release-1-1-54292-2017-09-20 "Direct link to ClickHouse Release 1.1.54292, 2017-09-20")

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

- Added the `pointInPolygon` function for working with coordinates on a coordinate plane.
- Added the `sumMap` aggregate function for calculating the sum of arrays, similar to `SummingMergeTree`.
- Added the `trunc` function. Improved performance of the rounding functions (`round`, `floor`, `ceil`, `roundToExp2`) and corrected the logic of how they work. Changed the logic of the `roundToExp2` function for fractions and negative numbers.
- The ClickHouse executable file is now less dependent on the libc version. The same ClickHouse executable file can run on a wide variety of Linux systems. There is still a dependency when using compiled queries (with the setting `compile = 1` , which is not used by default).
- Reduced the time needed for dynamic compilation of queries.

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

- Fixed an error that sometimes produced `part ... intersects previous part` messages and weakened replica consistency.
- Fixed an error that caused the server to lock up if ZooKeeper was unavailable during shutdown.
- Removed excessive logging when restoring replicas.
- Fixed an error in the UNION ALL implementation.
- Fixed an error in the concat function that occurred if the first column in a block has the Array type.
- Progress is now displayed correctly in the system.merges table.

### ClickHouse Release 1.1.54289, 2017-09-13[​](#clickhouse-release-1-1-54289-2017-09-13 "Direct link to ClickHouse Release 1.1.54289, 2017-09-13")

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