Clickhouse Odbc Versions Save

WARNING: Before upgrading to a new version of the driver, make sure you read the release notes of all intermediate versions!

Changes compared to 1.1.10.20210822

Features

• Added session_id to connection https://github.com/ClickHouse/clickhouse-odbc/pull/398 by @Enmk

Building\Packaging

• CI/CD: Run CI/CD jobs every Monday at Midnight https://github.com/ClickHouse/clickhouse-odbc/pull/397 by @Enmk
• CI/CD: Upload CI/CD build artifacts https://github.com/ClickHouse/clickhouse-odbc/pull/399 by @filimonov
• CI/CD: MacOS CI/CD fixes https://github.com/ClickHouse/clickhouse-odbc/pull/404 by @Enmk
• CI/CD: Window CI/CD fixes https://github.com/ClickHouse/clickhouse-odbc/pull/405 by @Enmk
• CI/CD: Linux CI/CD simplification https://github.com/ClickHouse/clickhouse-odbc/pull/406 by @Enmk
• CI/CD: building binaries on CentOS https://github.com/ClickHouse/clickhouse-odbc/pull/408 by @Enmk

Other

• Logging: https://github.com/ClickHouse/clickhouse-odbc/pull/375 - by @MinimaJack
• Docs: https://github.com/ClickHouse/clickhouse-odbc/commit/860b06f934d850e9db711f4922600c41d2a9498c by @traceon
• Docs: https://github.com/ClickHouse/clickhouse-odbc/commit/860b06f934d850e9db711f4922600c41d2a9498c by @traceon

WARNING: Before upgrading to a new version of the driver, make sure you read the release notes of all intermediate versions!

• Fixed compilation for recent versions of GCC/Clang/AppleClang (#356)
• Fixed handling of Null values and Nothing type (#356)
• Fixed DateTime type as String issues (#356)
• Implemented parametrized early connection/credential error detection (#356)
• Implemented parametrized big integer types handling as strings (#356)
• Various lesser fixes for ClickHouse ODBC-based Tableau connector

WARNING: Before upgrading to a new version of the driver, make sure you read the release notes of all intermediate versions!

• Fixed HTTP 400 Bad request issue when DSN does not have URL and have individual components instead (#306)
• Fixed the behavior of SQLGetData for cases when the size of the output buffer is 0 (#316)
• Fixed compilation for recent versions of GCC/Clang/AppleClang (#320)
• Fixed SQL_DESC_OCTET_LENGTH handling for array-bound parameters (#325)
• Fixed the issue of hanging connections in some client applications (#326)
• Implemented RPM packaging via CPack (#310)

WARNING: Before upgrading to a new version of the driver, make sure you read the release notes of all intermediate versions!

• The baseline version of ClickHouse server used for tests and feature support is set to 20.3 (#304)
• Implemented array binding/bulk fetch support (#302)
• Fixed row and column binding issues (#302)
• Fixed SSL/TLS connection issues in Windows (#305)
• Fixed passing NULL parameters into prepared statements (#304) (potentially breaking change, ClickHouse server must contain the following modification: https://github.com/ClickHouse/ClickHouse/pull/8517)
• Fixed the issue when closing a cursor leaves the statement in an unprepared state
• Fixed the issue when binding columns was not allowed on an unprepared statement

• Fixed parsing of escape sequences (#283, #284)
• Made ICU the default Unicode conversion back end in Unix builds (#278)
  • Warning 1 (for Unix only): only the system ICU packages are supported right now, which means, that 1) you will need to make sure that the corresponding run-time dependency is installed in your system, 2) system ICU may bring some other run-time dependencies and load additional (system) shared libraries like libstdc++.so and others. If this is not acceptable, you will need to build the driver with ICU disabled, using -DCH_ODBC_USE_ICU=OFF cmake switch.
  • Warning 2 (for Unix only): the pre-built Linux package listed below is built on CentOS 7, and it depends on the default system version of ICU, which is ICU 50. If you plan to use it in any other Linux distribution, you have to make sure, that this exact version of ICU is available at run-time there. Otherwise, you will need to build the driver manually for your system so that it links with its ICU version. The process is trivial, follow the instructions at "Building from sources" section from README.md.

• Store and pass stateful converters in conversion contexts (#280) - increases performance of Unicode string conversion in Windows

• Fixed treating unknown types as Strings in ODBCDriver2 format (#276)

• Added RowBinaryWithNamesAndTypes format support, see README.md#url-query-string on how to enable and use it. #242 (PR: #255)
• Fixed display size reporting. #261 (PR #264)
• Applied various performance optimizations. (PR #272 #270)
• Linux package is linked with C++ runtime statically, all internal symbols are hidden now. (PR #267)
• Fixed build issues on some platforms (Ubuntu 18.04, Alpine Linux). #263 #12 (PR #267)

• Added sample Tableau Datasource Customisation (.tdc) file for better driver capability detection
• Fixed catalog functions behaviour (affects SSIS)
• Fixed buffer filling (affects SSIS, Tableau, others)

Note for Windows users: If you have issues with using the driver (error 126) you need to install fresh Microsoft Visual C++ Redistributable manually. [#251]

2020-02-06 Update: Windows builds were reuploaded, now it should work properly w/o installing Microsoft Visual C++ Redistributable too.

• Fixes in DSN/connection string attributes handling
• SSLMode now must be set to "allow" to tolerate self-signed certificates
• Various fixes that improve the overall experience when working with Excel and Power BI