3 CASSANDRA

============================================================================== Simba Cassandra ODBC Driver with SQL Connector Release Notes ==============================================================================

The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Cassandra ODBC Driver 2.6.5, as well as the version history.

For information about upcoming support deprecations or removals, see the Workflow Changes section. Deprecated features will not receive any updates, but will continue to be usable in their current state until support is removed in a future release.

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.

Known Issues The following are known issues that you may encounter due to limitations in the data source, the driver, 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 driver reports non-key columns in virtual tables as not nullable.

  • On Cassandra 2.1.x, the driver 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 driver returning an error.

Workflow Changes =============================================================

The following changes may disrupt established workflows for the driver.

In addition to changes that are already implemented in the current version of the driver, this section describes potentially disruptive changes that will be implemented in a future version of the driver, so that you can plan accordingly.

Upcoming ---------------------------------------------------------------------

  • [CASSO-644] Removing support for earlier versions of Windows

As early as November 2020, the driver will no longer support the following versions of Windows: - Windows 7 - Windows Server 2008 - Windows Server 2008r2

In addition, as early as November 2020, the driver will no longer support Visual Studio 2013.

For a list of supported Windows and Visual Studio versions, see the Installation and Configuration Guide.

  • [CASSO-644] Removing support for macOS 10.12 and earlier

As early as November 2020, the driver will no longer support 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-644] Removing support for CentOS 6

As early as November 2020, the driver will no longer support CentOS 6.

For a list of supported Linux versions, see the Installation and Configuration Guide.

2.6.0 ------------------------------------------------------------------------

  • Support for Apache Cassandra 2.0 removed

Beginning with this release, the driver no longer supports Apache Cassandra 2.0. For a list of supported Cassandra versions, see the Installation and Configuration Guide.

Version History ==============================================================

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.

2.6.1 ------------------------------------------------------------------------

Released 2019-12-31

Enhancements & New Features

  • [CASSO-637] Support for DataStax Astra

You can now use the driver to connect to Cassandra databases that are hosted on the cloud as DataStax Astra databases. For information about how to configure a connection to Astra, see the Installation and Configuration Guide.

For more information about Astra, refer to the product page on the DataStax website: https://www.datastax.com/cloud/datastax-astra.

  • [CASSO-619] Support for certain frozen UDT types

The driver now supports the use of frozen user-defined types that contain the following Cassandra-native types: - DATE - TIME - SMALLINT - TINYINT

  • [CASSO-631][CASSO-632][CASSO-635][CASSO-640] Updated third-party libraries

The driver now uses the following third-party libraries: - DataStax C/C++ Driver for Apache Cassandra 2.14.0 (previously 2.12.0) - Expat 2.2.9 (previously 2.2.0) - libuv 1.33.1 (previously 1.28.0) - OpenSSL 1.1.1d (previously 1.1.0j) - zlib 1.2.11 (not previously used)

Resolved Issues The following issue has been resolved in Simba Cassandra ODBC Driver 2.6.1.

  • [CASSO-618] In some situations, retrieving data of Cassandra type BLOB and converting it to a string might cause the client application to unexpectedly terminate.

2.6.0 ------------------------------------------------------------------------

Released 2019-09-27

Enhancements & New Features

  • [CASSO-550] Updated support for Debian installation

The Linux driver now includes installation packages specific to Debian systems. For more information, see the Installation and Configuration Guide.

  • [CASSO-523][CASSO-554][CASSO-556][CASSO-562] Updated third-party libraries

The driver now uses the following third-party libraries: - DataStax C/C++ Driver for Apache Cassandra 2.12.0 - Expat 2.2.0 - ICU 58.2.x - libuv 1.28.0 - OpenSSL 1.1.0

Resolved Issues The following issues have been resolved in Simba Cassandra ODBC Driver 2.6.0.

  • [CASSO-543] On macOS, when the simba.cassandraodbc.ini configuration file contains an entry for the ODBCInstLib property, the driver does not connect.

This issue has been resolved. The simba.cassandraodbc.ini configuration file no longer contains an entry for the ODBCInstLib property.

  • [CASSO-544] When EnableJoins is set to 0, the driver can still perform joins on two tables that are associated to the same source table.

==============================================================================

Installation and Configuration Guide

Installation and Configuration Guide