============================================================================= Simba Phoenix ODBC Driver Release Notes ============================================================================= The release notes provide details of enhancements, features, and known issues in Simba Phoenix ODBC Driver 1.0.7, as well as the version history. 1.0.7 ======================================================================= Released 2017-04-28 Enhancements & New Features * Built on macOS 10.9 The macOS version of the driver is now built on the macOS 10.9 platform. Previously the driver had been built on macOS 10.8. Known Issues The following are known issues that you may encounter due to limitations in the data source, the driver, or an application. * NOT NULL is not supported in Phoenix DDL for non-primary-key columns. This is a limitation in Phoenix. * The UNION statement is not supported in Phoenix. This is a limitation in Phoenix. As a workaround, use UNION ALL, which is supported in Phoenix. * A subquery that aliases a fully-qualified column name to its own shortened name returns an error. This is a limitation in Phoenix. This limitation affects the Custom SQL feature in Tableau, as Custom SQL makes extensive use of aliased subqueries. * SELECT NOW() and SELECT CURRENT_DATE() return incorrect results when a table is not specified. This is a limitation in Phoenix. As a workaround, make sure to specify a table when using these functions. * The LIKE operator is not supported in parameterized statements. This is a limitation in Phoenix. * Decimal data must be smaller than the maximum FLOAT value, and larger than the minimum FLOAT value. This is a limitation in Phoenix. * Cannot ROUND to negative precision. The ROUND function ignores negative values for the precision argument. This is a limitation in Phoenix. * GROUP BY statements including a BOOLEAN and a number may cause an error. GROUP BY statements that include a BOOLEAN, a NUMBER type, and any other data type may cause an error if the data types are listed in one of the following orders: * GROUP BY NUMBER_TYPE, BOOLEAN, OTHER_TYPE * GROUP BY BOOLEAN, NUMBER_TYPE, OTHER_TYPE * GROUP BY BOOLEAN, OTHER_TYPE, NUMBER_TYPE This is a limitation in Phoenix. As a workaround, use a different order in the GROUP BY statement. * 'SUBSTRING' is not supported as a substring operator. This is a limitation in Phoenix. As a workaround, use 'SUBSTR' as a substring operator. * Phoenix does not return precision or scale for parameterized queries. As a workaround, use the 'Decimal Precision' and 'Decimal Scale' driver configuration options. * Parameterized UPSERT/DELETE statements do not provide an updated row count. This is a limitation in Phoenix. * Parameter 'signed' metadata is always returned as FALSE. This is a limitation in Phoenix. Version History ============================================================== 1.0.6 ------------------------------------------------------------------------ Released 2017-04-07 Enhancements & New Features * Support for hint syntax The driver now supports hints in SELECT statements. You can configure the Check Select Statement Hint Syntax option (the CheckSelectStmtHint property) to specify whether the driver parses hints in SELECT statements. In previous releases, the driver ignored hints by escaping the syntax. * Updated third-party library dependencies The driver has been updated to incorporate newer versions of the third- party library dependencies. Resolved Issues The following issue has been resolved in Hortonworks Phoenix ODBC Driver 1.0.6. * Segmentation fault in Driver Manager detection on Linux. 1.0.5 ------------------------------------------------------------------------ Released 2017-03-20 Enhancements & New Features * Updated third-party library dependencies The driver has been updated to incorporate newer versions of the third- party library dependencies. Resolved Issues The following issues were resolved in Simba Phoenix ODBC Driver 1.0.5. * Segmentation fault in Driver Manager detection on Linux. 1.0.4 ------------------------------------------------------------------------ Released 2017-03-16 Resolved Issues The following issue has been resolved in Simba Phoenix ODBC Driver 1.0.4. * Driver uses x-www-form-urlencoded to communicate with the server. This issue has been resolved. The driver now uses octet-stream to communicate with the server. 1.0.3 ------------------------------------------------------------------------ Released 2017-01-31 Enhancements & New Features * Upgraded OpenSSL library The driver now uses OpenSSL 1.0.2. Previously, the driver used OpenSSL 1.0.11. Resolved Issues The following issue was resolved in Simba Phoenix ODBC Driver 1.0.3. * When attempting to use the Windows trust store on Windows Server 2016, an access violation exception occurs. 1.0.2 ------------------------------------------------------------------------ Released 2016-12-29 Enhancements & New Features * 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. Resolved Issues The following issue was resolved in Simba Phoenix ODBC Driver 1.0.2. * Driver does not handle string concatenation. 1.0.1 ------------------------------------------------------------------------ Released 2016-09-26 Resolved Issues The following issue was resolved in Simba Phoenix ODBC Driver 1.0.1. * Driver does not handle different date-time SQL enums for ODBC 2 vs 3. 1.0.0 ------------------------------------------------------------------------ Released 2016-06-23 * Version 1.0.0 was the initial release of the Simba Phoenix ODBC Driver. ==============================================================================