Advantage Developer Zone

 
 
 

Advantage Database Server 11.10.0.20 Service Update


The Advantage Database Server update for 11.10.0.20 has been released inculding support for Delphi XE6

Downloads available here: Advantage Release 11.1


11.10.0.20 - Advantage Client Engine (ACE) This Service Update of the Advantage Client Engine (ACE) addresses the following issues:
  1. Fixed a bug in the Advantage Client Engine that did not apply the default free table password from the connection string property EncryptionPassword to live cursor results.
  2. Fixed a performance issue when using the Sequenced property of the TAdsQuery on a query with a ORDER BY clause.
  3. Fixed issue with AdsGetKeyColumn where it was returning rowversion columns from static cursors, where they cannot be guaranteed unique.
11.10.0.20 - Advantage Data Architect (ARC) This Service Update of the Advantage Data Architect (ARC) addresses the following issues:
  1. Fixed an access violation in the dictionary differentiator.
11.10.0.20 - Advantage Database Server This Service Update of the Advantage Database Server addresses the following issues:
  1. Fixed a bug in the server that resulted in a 9073 error when performing an ALTER ONLINE TABLE of a dictionary bound VFP table that contained nullable fields.
  2. Fix a bug that could result in a server crash when performing an AppendFrom operation from a Clipper client when using non-compound index files.
  3. Fixed a bug in the query engine that could result in incorrect ordering of results when the following conditions are met: 1) Table type is one of the DBF types. 2) Multiple columns are included in the ORDER BY clause. 3) At least one of the columns is of a numeric type. And, 4) The numeric column contains 2 or more negative values in the result set.
  4. Updated Advantage Database Server to be able to replicate linked tables within transactions.
  5. Fixed an issue that could cause an internal server error if a table involved in referential integrity is online packed and then updated.
  6. Fixed a bug that prevented single password in the connection string for all free table to work when executing SQL query.
  7. Fixed a bug that could cause a connection to remain in server forever if a TCP client is terminated abnormally.
  8. Fixed a bug in the server that could result in 7033 errors if the connection table size was configured to a number greater than 65535.
  9. Fixed a bug that could result in a 9005 or 9111 error if a single connection attempted to obtain more than 65534 work areas.
  10. Fixed a bug in the server that caused sp_GetTables and related system procedures to not work on free table connections for servers running on some flavors of Ubuntu and Debian Linux.
  11. Fixed a race condition when multiple users delete and create the same UDF.
  12. Added configuration option COMPRESS_DUMP_FILES to provide the capability to disable compression of crash dump files.
  13. Fixed a bug that could result in an access violation in the server due to a very rare race condition when dynamically resizing connection storage.
  14. Fixed an issue in with sp_ReindexOnline and sp_PackTableOnline where updating an FTS index after a pack or reindex would cause a 9123 error.
  15. Fixed a bug when altering a table would not correctly re-index an ADT.
  16. Fixed a performance problem in the server where concurrent skip operations through a CDX index with compatibility locking could be very slow.
  17. Fixed a bug that caused server crash when updating a free DBF table that has trigger associated with it in a database.
  18. Fixed an access violation in the server when the number of columns in a table did not match the number of columns in the data dictionary.
  19. Fixed a bug that can cause the Linux server to stop communicating with clients.
  20. Fixed an issue that can cause a 9019 error when calling AdsSetIndexDirection on an index tag with a tag number >= 56.
  21. Fixed an issue in the server that could cause it to hang or crash when performing an online ALTER on a table that is being replicated.
  22. Fixed a bug that could result in an access violation or 9111 error in the server in a rare circumstance due to a corrupt .ai (data dictionary index) file.
  23. Fixed a bug that prevented '0000-00-00 00:00:00' from being used in an SQL statement as a literal.
  24. Fixed a bug that could cause poor SQL performance when joining very large tables that have no available index to fully optimizes the join condition.
  25. Fixed a bug in the server that could result in memory overruns when certain scalar functions were passed data via a parameterized value that exceeded 1K in length.
  26. Fixed a bug that could cause 3109 error being returned when executing a SQL statement that contains an expression using an NMEMO column as a parameter of a scalar function.
  27. Fixed an issue where a data dictionary default path that has no trailing slash caused invalid paths in the SQL engine.
  28. Optimized execution of SQL MERGE statements when the target table is empty.
  29. Fixed an issue that could lead to a 9084 when certain SQL statements containing a large number of columns in the ORDER BY clause were executed.
  30. Fixed a bug that caused the Active flag in the sp_GetSQLStatements result to not be correct for some queries involving views and user defined stored procedures.
11.10.0.20 - Advantage ODBC Driver This Service Update of the Advantage ODBC Driver addresses the following issues:
  1. Fix a bug in the ODBC driver that caused SQLGetData to return a 2004 error when the TrimTrailingSpaces flag was set.
  2. Fixed an issue where the ADS ODBC Setup dialog may return a File In Use error when browsing for a Data Dictionary.
11.10.0.20 - Advantage PHP Extension This Service Update of the Advantage PHP Extension addresses the following issues:
  1. Fixed an issue in the Advantage PHP PDO driver that would prevent a prepared SELECT statement from being executed twice.
  2. Fixed an issue in which the PHP PDO driver would fail to load ACE when PHP was loaded by Apache as an ISAPI DLL.
11.10.0.20 - Advantage TDataSet Descendant This Service Update of the Advantage TDataSet Descendant addresses the following issues:
  1. Fixed a bug that could cause Unicode fields to overwrite values of adjacent fields.
  2. Fixed a bug in the 64-bit Delphi client that could result in an access violation when editing a record.
  3. Added Support for Delphi XE6 to TDataSet Components.
11.10.0.20 - Advantage TDataSet Switch Utility This Service Update of the Advantage TDataSet Switch Utility addresses the following issues:
  1. Fixed an issue that could lead to an EConvertError exception in the TDataSet Switcher.
11.10.0.20 - Advantage Visual Objects Driver This Service Update of the Advantage Visual Objects Driver addresses the following issues:
  1. Fixed a problem when updating a record with the VO SQL RDD on a DBF cursor that has a filter set can cause a record lock required error (1122).
  2. Fixed an issue with the AdsSQLServer VO class where SQL parameters are preserved for subsequent calls.
  3. Fixed issue with the VO SQL RDD where the Refresh method would fail if the previous query returned zero records.
11.10.0.20 - Advantage Web Platform This Service Update of the Advantage Web Platform addresses the following issues:
  1. Fixed an issue where the SQL Utility of the Web Config Utility displays FALSE boolean values as empty or blank fields.
  2. Fixed an issue with the ADS Web Platform server where all users of the same location used the same cached list of stored procedures.