============================================================================= Simba Couchbase ODBC Driver with SQL Connector Release Notes ============================================================================= The release notes provide details of enhancements, features, and known issues in Simba Couchbase ODBC Driver 2.0.6, as well as the version history. 2.0.6 ======================================================================= Released 2018-09-14 Enhancements & New Features * [COUCHO-457] Updated Schema Editor JRE The Schema Editor now uses Java Runtime Environment version v8u181. Resolved Issues The following issue has been resolved in Simba Couchbase ODBC Driver 2.0.6. * [COUCHO-455] Hidden columns are displayed in result sets. Known Issues The following are known issues that you may encounter due to limitations in the data source, the driver, or an application. * Driver cannot write timestamp data with time zone information. The driver can read timestamp data that includes time zone information, but cannot write that data. * Schema definitions that were created using Simba Couchbase ODBC Driver 1.1.2 or earlier are not supported. You must recreate the schema definition using either a later version of the driver, or version 3.0 or later of the Schema Editor application. For information about using driver configuration options to work with schema definitions, see the Installation and Configuration Guide. For information about using the Schema Editor, see the Schema Editor User Guide. If you connect to a Couchbase data store without specifying a schema definition, but the data store contains an unsupported schema definition, the driver will attempt to load it and then return an error. * Driver cannot execute UNION queries written in N1QL. When executing queries in N1QL, the driver does not support UNION queries. * Couchbase Server error occurs if the bucket does not have a primary index. If a query is made on a bucket that does not have a primary index, then Couchbase Server returns an error. As a workaround, make sure that all buckets have a primary index. * Documents that are themselves an array are not supported. The driver cannot read a Couchbase document that is an array. The document must be a JSON object containing data (such as arrays). * In specific cases, the SQL SUBSTRING scalar function does not work as expected when translated to N1QL. The SQL SUBSTRING scalar function, when translated to N1QL, will return NULL instead of an empty string if the requested start position or character count reaches beyond the end of the input string. * The SQL CONVERT function is not supported. The driver does not support the SQL CONVERT function. If you try to execute a query containing this function, an error will occur. * SQL LOCATE functions containing three arguments are not supported. The driver does not support SQL LOCATE functions that contain three arguments. If you try to execute a query containing a SQL LOCATE function with three arguments, an error will occur. * The driver returns a syntax error if your query contains a FROM TABLE clause but does not specify a column, or contains function calls. If your query contains a FROM TABLE clause, you must specify a column. * IFNULL on number and string returns null instead of value. When you execute an IFNULL function in which the first argument is a number and the second argument is a string, IFNULL returns a null instead of the correct argument. * In N1QL, if two rows have different schemas, columns that are not in the first row are not displayed. * Couchbase Server requires at least three nodes in a cluster for failover to take effect. This is a limitation in Couchbase Server. Workflow Changes ============================================================ The following changes may disrupt workflows from earlier versions. 2.0.5 ------------------------------------------------------------------------ * Minimum TLS Version Beginning with this release, the driver requires a minimum version of TLS for encrypting the data store connection. By default, the driver requires TLS version 1.2. This requirement may cause existing DSNs and connection strings to stop working, if they are used to connect to data stores that use a TLS version earlier than 1.2. To resolve this, in your DSN or connection string, set the Minimum TLS option (the Min_TLS property) to the appropriate version of TLS for your server. For more information, see the Installation and Configuration Guide. Version History ============================================================== 2.0.5 ------------------------------------------------------------------------ Released 2018-08-10 Enhancements & New Features * [COUCHO-451] Minimum TLS support You can now specify the minimum version of TLS the driver accepts when authenticating the connection to the data source. * [COUCHO-452] Standardized log file names When logging is enabled, the driver now produces the following log files: - A simbacouchbaseodbcdriver.log file that logs driver activity that is not specific to a connection. - A simbacouchbaseodbcdriver_connection_[Number].log for each connection made to the database, where [Number] is a number that identifies each log file. This file logs driver activity that is specific to the connection. * [COUCHO-453] More informative SSL error messages The driver now provides more detailed error messages for TLS/SSL errors. * [COUCHO-443] Updated third-party dependencies The driver now uses libcURL 7.60.0 and zlib 1.2.11. As a result, several security features in the driver have been improved. Resolved Issues The following issue has been resolved in Simba Couchbase ODBC Driver 2.0.5. * [COUCHO-432][COUCHO-433] If authentication is enabled and an incorrect password is provided, the connection is still successful. * [COUCHO-438] Timestamp data with time zone information is not supported. This issue has been partially resolved. The driver can now read timestamp data that contains time zone information, but cannot write that data. * [COUCHO-448] The driver logs plain text user credentials in the logs as part of each SELECT query. This issue has been resolved. Now, by default, logs for the libcURL layer do not appear in the driver connection logs. This ensures that sensitive information such as user credentials is not logged. 2.0.4 ------------------------------------------------------------------------ Released 2018-03-02 Enhancements & New Features * Couchbase Server 5.1 support You can now use the driver to connect to Couchbase Server 5.1 instances. * More descriptive value returned for SQL_DBMS_NAME When SQLGetInfo is called, the driver now returns "Couchbase" as the SQL_DBMS_NAME value. Previously, the driver returned "TEXT". * Updated value for SQL_DRIVER_NAME When SQLGetInfo is called, the driver now returns the name of the driver library file instead of the name of the driver. 2.0.3 ------------------------------------------------------------------------ Released 2017-05-05 Enhancements & New Features * Updated macOS and Linux environment variable The name of the simba.couchbasodbc.ini file environment variable, previously SIMBACOUCHBASEODBC, has been updated to SIMBA_COUCHBASE_ODBC_INI. Resolved Issues The following issues were resolved in Simba Couchbase ODBC Driver 2.0.3. * Memory corruption issue. 2.0.2 ------------------------------------------------------------------------ Released 2017-03-24 Resolved Issues The following issues were resolved in Simba Couchbase ODBC Driver 2.0.2. * Segmentation fault in Driver Manager detection on Linux. 2.0.1 ------------------------------------------------------------------------ Released 2017-03-15 Enhancements & New Features * Updated third-party library dependencies The driver has been updated to incorporate newer versions of the third- party library dependencies. 2.0.0 ------------------------------------------------------------------------ Released 2017-02-10 Enhancements & New Features * Schema Editor 3.0 The driver now includes Schema Editor 3.0, which features improved data sampling and schema modification capabilities as well as a redesigned user interface. For more information, see the Schema Editor User Guide located in the installation directory of the driver. * Use Windows Trust Store to verify connection The driver can now verify the connection to the data store with an SSL certificate stored in the Windows Trust Store. To use the Windows Trust Store, select the Use System Trust Store check box or set the UseSystemTrustStore option to 1. For more details on using the Windows Trust Store, see the Simba Couchbase ODBC Driver Install and Configuration Guide. * Windows SSL updates On Windows, the SSL configuration options are now in a separate SSL Options dialog box. This dialog box can be accessed from the DSN Configuration dialog box, by clicking SSL Options. * Upgraded OpenSSL library The driver now uses OpenSSL 1.0.2. Previously, the driver used OpenSSL 1.0.1l. Resolved Issues The following issues were resolved in Simba Couchbase ODBC Driver 2.0.0. * Type names with the same name as a bucket are not supported. * Driver cannot perform certain DELETE and UPDATE operations on virtual tables. * In some cases, memory leaks occur during query execution. ==============================================================================