3 CASSANDRA
============================================================================== Magnitude Simba Cassandra ODBC Data Connector Release Notes ==============================================================================
The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Cassandra ODBC Connector 2.6.12, as well as the version history.
2.6.12 =======================================================================
Released 2022-09-27
Enhancements & New Features
[CASSO-886] Internal connector improvements
The connector has been updated with the following internal improvements:
- Resolved NullReferenceException during multi-threading
- Resolved newly traced memory leaks
Known Issues The following are known issues that you may encounter due to limitations in the data source, the connector, or an application.
INSERT statement fails when inserting multiple rows and binding the DEFAULT value in the first row.
When inserting multiple rows in a single SQL statement and binding the DEFAULT value in the first row, the INSERT statement fails. As a workaround, use NULL instead of DEFAULT.
Non-key virtual table columns are not nullable.
Cassandra does not support null values in collections. The connector reports non-key columns in virtual tables as not nullable.
On Cassandra 2.1.x, the connector returns incorrect values for VARINT (SQL_NUMERIC) columns.
This is due to a limitation in the Datastax cpp-driver. For more information, see the following link: https://datastax-oss.atlassian.net/browse/CPP-419
If a user-defined type is the primary key of a table, none of the primary key’s fields can be null when it is used in an INSERT statement.
A column name collision occurs if a map contains two user-defined types with identical field names, that is, if the map’s key and value are the same user-defined type.
[CASSO-752] Attempting to perform INSERT or UPDATE queries on tables with columns of type TUPLE or UDT (when ReturnUdtAsString is enabled) results in the connector returning an error.
Workflow Changes =============================================================
The following changes may disrupt established workflows for the connector.
2.6.7 ————————————————————————
[CASSO-650] Support for earlier versions of Windows removed
Beginning with this release, the connector no longer supports the following versions of Windows:
- Windows 7
- Windows Server 2008
- Windows Server 2008r2
For a list of supported Windows versions, see the Installation and Configuration Guide.
[CASSO-703] Support for macOS 10.12 and earlier removed
Beginning with this release, the connector no longer supports the following versions of macOS:
- macOS 10.12
- macOS 10.11
- macOS 10.10
- macOS 10.9
For a list of supported macOS versions, see the Installation and Configuration Guide.
[CASSO-670] Support for CentOS 6 and RHEL 6 removed
Beginning with this release, the connector no longer supports the following versions of Linux:
- CentOS 6
- Red Hat Enterprise Linux (RHEL) 6
For a list of supported Linux versions, see the Installation and Configuration Guide.
2.6.6 ————————————————————————
Support for Visual Studio 2013 removed
Beginning with this release, the connector no longer supports Visual Studio
- For a list of supported Visual Studio versions, see the Installation and Configuration Guide.
2.6.0 ————————————————————————
Support for Apache Cassandra 2.0 removed
Beginning with this release, the connector no longer supports Apache Cassandra 2.0. For a list of supported Cassandra versions, see the Installation and Configuration Guide.
Version History ==============================================================
2.6.11 ———————————————————————–
Released 2022-09-06
Enhancements & New Features
[CASSO-857] Updated Ubuntu Support
The connector now supports Ubuntu 20.04. For a list of supported Linux versions, see the Installation and Configuration Guide.
[CASSO-880][CASSO-881] Updated third-party libraries
The connector now uses the following third-party libraries:
- Expat version 2.4.6 (previously 2.2.9)
- OpenSSL 1.1.1q (previously 1.1.1n)
Resolved Issues The following issue has been resolved in Simba Cassandra ODBC Connector 2.6.11.
[CASSO-727] When executing a query containing a JSON column, the connector returns an error.
[CASSO-728] When retrieving a sub-type from a case sensitive, user-defined type, and retrieving metadata from a column, the connector returns an error.
2.6.10 ———————————————————————–
Released 2022-04-22
Enhancements & New Features
[CASSO-850] Forced passdown
You can now force the passdown of IN predicate to the server. To do this, set the ForceInPredPassdown property to 1. For more information, see the Installation and Configuration Guide.
[CASSO-851][CASSO-852] Updated OpenSSL support
The connector now uses OpenSSL 1.1.1n for encryption of data. Previously the connector used OpenSSL 1.1.1k.
2.6.9 ————————————————————————
Released 2021-08-23
Resolved Issues The following issue has been resolved in Simba Cassandra ODBC Connector 2.6.9.
- [CASSO-838] If the connector attempts to insert a NULL value into a column, it terminates unexpectedly.
2.6.8 ————————————————————————
Released 2021-06-18
Resolved Issues The following issue has been resolved in Simba Cassandra ODBC Connector 2.6.8.
- [CASSO-829] If the connector attempts to insert a NULL value into a column, it terminates unexpectedly.
2.6.7 ————————————————————————
Released 2021-04-16
[CASSO-813] Support for frozen complex values in collections
The default ODBC source type for frozen collections is now SQL_VARCHAR, which supports complex values.
[CASSO-766] Updated OpenSSL support
The connector now uses OpenSSL 1.1.1k for encryption of data. Previously the connector used OpenSSL 1.1.1g.
Resolved Issues The following issue has been resolved in Simba Cassandra ODBC Connector 2.6.7.
- [CASSO-779] The connector does not support nested frozen data types.
2.6.6 ————————————————————————
Released 2021-03-26
Enhancements & New Features
[CASSO-803] Updated Cassandra CPP
The connector now uses Cassandra CPP 2.16.0. Previously, the connector used Cassandra CPP 2.15.3.
2.6.5 ————————————————————————
Released 2020-10-30
Enhancements & New Features
[CASSO-761] Support for solr_query
The driver now supports solr_query in SQL mode.
[CASSO-766] Updated OpenSSL support
The driver now uses OpenSSL 1.1.1g for encryption of data. Previously, the driver used OpenSSL 1.1.1d.
Resolved Issues The following issues have been resolved in Simba Cassandra ODBC Driver 2.6.5.
- [CASSO-732][CASSO-771] When the query mode is CQL, or when the query mode is SQL With CQL Fallback and the query falls back to CQL mode, the driver returns an error.
2.6.4 ————————————————————————
Released 2020-09-02
Enhancements & New Features
[CASSO-729] UDT handling
You can configure how the driver handles UDT columns. To do this, set the ReturnUdtAsString property to 1. For more information, see the Installation and Configuration Guide.
[CASSO-739][CASSO-751] Updated third-party libraries
The driver now uses the following third-party libraries:
- Cassandra CPP 2.15.3 (previously 2.14.0)
- libuv 1.38.1 (previously 1.33.1)
2.6.3 ————————————————————————
Released 2020-08-07
Enhancements & New Features
[CASSO-721] Updated Boost library
The driver now uses Boost version 1.64.0. Previously, the driver used Boost version 1.57.0.
[CASSO-730] Compress data internally
You can now compress data internally for the current connection. To do this, set the EnableCompressSwapFile property to 1. For more information, see the Installation and Configuration Guide.
2.6.2 ————————————————————————
Released 2020-04-17
Enhancements & New Features
[CASSO-665] Notarization for macOS
The driver now supports notarization on macOS systems, enabling it to be run on macOS versions 10.14.6 and later.
[CASSO-666] Support for code signing
The driver now supports code signing on Windows and macOS systems.
[CASSO-699][CASSO-714] Support for additional operating systems
The driver now supports the following operating systems:
- macOS 10.15 “Catalina”
- Windows Server 2019
Resolved Issues The following issues have been resolved in Simba Cassandra ODBC Driver 2.6.2.
[CASSO-646] When attempting to perform a test connection without a DID file present in the DLL folder, the driver terminates unexpectedly.
[CASSO-664] The driver terminates unexpectedly when both of the following occur:
- Multiple database drivers are loaded to the same process.
- One driver unloads and calls ICU’s u_cleanup() function, while another driver continues to run and attempts to access the memory space that has been cleaned up.
[CASSO-680] When attempting to read an empty value in the column of type INET, the driver returns an error.
[CASSO-707][CASSO-710] When attempting to delete a row where the column of type DATE is in the PRIMARY KEY (PARTITION or CLUSTERING KEY) and the value is of the form ‘2000-01-01 00:00:00.000000000’, the driver returns an error.
==============================================================================