Releases: ClickHouse/clickhouse-odbc
1.4.1.20250523
This version includes the changes from 1.3.4.20250417 BETA, specifically in how the new driver reports data to client applications. It also adds details about supported types that were missing in previous versions of the driver.
Additionally, the driver includes several fixes and improvements:
- Allow tilde (~) in passwords
- Implement SQLGetInfo(SQL_DBMV_VER) to get the version of the ClickHouse Server
- Fixes Int64 columns are loaded as binary columns in PowerBI
Note: Power BI caches data definitions. This means that even if you update the driver and try to load a table previously accessed with the older driver, Power BI may still use the data definitions it received from the older version. To prevent issues such as numeric columns being recognized as binary data, you need to reload the table definitions by clicking the small reload button in the upper-right corner. See #445 (comment) for details.
1.3.4.20250417 BETA
This beta version introduces significant changes under the hood. Specifically, we add more detailed information about supported data types that the driver shares with client applications. Instead of using general types such as VARCHAR or INTEGER, we now report the actual ClickHouse types and their properties. The change itself does not significantly affect visible behavior, and as far as we are aware, it only fixes one issue: Int64 columns are loaded as binary columns in PowerBI. However, it paves the way for future improvements that were not possible without this change.
Knowing that we cannot foresee how other applications rely on the way the driver reports the supported types, we are first releasing a beta version to collect feedback.
Technical details:
- The
SQLGetTypeInfofunction now returns native ClickHouse types, as advertised in the documentation. Specifically, instead of usingTINYINT,SMALLINT,INT,REAL,TEXT,TIMESTAMP, etc., it now returnsInt8,Int16,Int32,Float,String,DateTime64. - Many columns of the
SQLGetTypeInfofunction have been populated with relevant data, where previously they contained NULLs or simple placeholders. - Similar to
SQLGetTypeInfo,SQLColumnsnow also returns native type names and is populated with data that was previously missing. DateTime64now comes first when requesting type information forSQL_TYPE_TIMESTAMP. This allows using fractions of a second in theWHEREclause and is also compatible withDateTimeas long as the fraction of a second is set to zero.
1.3.3.20250317
1.3.2.20250227 BETA
This release attempts to address the [HY000] I/O error: Bad address error and possibly the [HY000] Incomplete input stream error in Power BI. However, since we have not been able to reproduce these errors in our environment, we are releasing this as a beta to gather feedback from users experiencing the issues.
Note: This is not a final fix but an effort to further diagnose the problem.
Only the Windows version of the driver is included in this release, as the error occur only on Windows, and the fix modifies Windows-specific code.
1.3.1.20250213
1.3.0.20241018
Improvements
Breaking changes
Contributors
Assets 5
Release 1.2.1.20220905
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
Building\Packaging
- CI/CD: Run CI/CD jobs every Monday at Midnight #397 by @Enmk
- CI/CD: Upload CI/CD build artifacts #399 by @filimonov
- CI/CD: MacOS CI/CD fixes #404 by @Enmk
- CI/CD: Window CI/CD fixes #405 by @Enmk
- CI/CD: Linux CI/CD simplification #406 by @Enmk
- CI/CD: building binaries on CentOS #408 by @Enmk
Other
Contributors
Assets 5
Release 1.1.10.20210822
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
Nullvalues andNothingtype (#356) - Fixed
DateTimetype asStringissues (#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
Release 1.1.9.20201226
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 requestissue when DSN does not have URL and have individual components instead (#306) - Fixed the behavior of
SQLGetDatafor cases when the size of the output buffer is0(#316) - Fixed compilation for recent versions of GCC/Clang/AppleClang (#320)
- Fixed
SQL_DESC_OCTET_LENGTHhandling for array-bound parameters (#325) - Fixed the issue of hanging connections in some client applications (#326)
- Implemented RPM packaging via CPack (#310)
Release 1.1.8.20200710
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
NULLparameters into prepared statements (#304) (potentially breaking change, ClickHouse server must contain the following modification: ClickHouse/ClickHouse#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