Advantage Developer Zone

 
 
 

Advantage Database Server 10.1 Update (10.10.0.17 and 10.10.0.18) available


Advantage 10.1 service updates, version 10.10.0.17 and 10.10.0.18 have been posted to the Developer's Zone at http://devzone.advantagedatabase.com/dz/content.aspx?key=31

Updates include:

10.10.0.17 - Advantage Database Server This Service Update of the Advantage Database Server addresses the following issues:
  1. Fixed a bug in the replication engine that caused invalid connections to be kept in the connection pool. When a connection receives a 6000 class error, it typically cannot be used any more, but the replication engine kept such connections in the pool until they were timed out.
  2. Fixed an issue that can cause a server crash when closing an index on a #temp table.
  3. Fixed a bug in the server that could cause a fully cached VFP table encrypted with AES to produce a 9124 error.
  4. Fixed a 7028 error when modifying a view statement involving tables opened with compatibility locking.
  5. Fixed a bug in the Linux server that could result in a corrupt data dictionary index (.ai) file when using sp_SetDDEncryptionType.
  6. Fixed a bug in the Linux server that could result in deadlock when deleting records when using AES encryption on an ADT table with a memo file.
  7. Fixed an issue where the server could crash if another process (virus scanner, for example) locked a temporary .pck file during a pack operation.
  8. Fixed an access violation when restoring a data dictionary with the incorrect password.
  9. Fixed an issue where an abnormal TCP socket closure would cause a 9058 error (Transaction command out of sequence) if the user had an active transaction.
  10. Fixed a 7078 error when restoring a database with a different password than the current connection to the database uses.
  11. Fixed a bug that caused various transaction failures when the TPS log file reached 4GB in size.
  12. Fixed an issue with the $ operator when used with an ANSI string literal and unicode fields.
  13. Fixed an issue where AdsConnection.UserGroups or AdsDDGetUserProperty( , , ADS_DD_USER_GROUP_MEMBERSHIP, ) can return bad data.
  14. Fixed an issue where large blob transfers via the TCP protocol could result in 6412 errors on the client, or could cause the server to log a 10055 error and the client to hang.
  15. Fixed performance problem when performing updates that have referential integrity constraints. The performance of the update was affected by a disconnecting user (i.e. closing tables) or other user's updates that had referential integrity constraints.
  16. Fixed an issue where AEPs that used memo fields in the __input or __output tables could get corrupted data.
  17. Fixed a bug in the server that could cause 10035 and 8004 errors to be logged and ultimately a crash dump from a 9003 error when using TCP/IP communications.
  18. Fixed a spurious 5068 error when creating referential integrity rules.
  19. Fixed a bug that caused a 7008 error to be returned when trying to remove a replication subscription from the database. The server could not delete the subscription queue table if it had been used.
  20. Fixed a bug that caused Unicode FTS indexes' maximum word length to be tripled each time the table was restructured. This bug eventually leads to a 5019 error when trying to restructure the table.
  21. Fixed a 9005 error that was caused by killing a user with an open cursor produced by a SELECT ... FROM ( EXECUTE PROCEDURE .. ) statement.
  22. Fixed an issue where a malformed UDP login packet could cause the server to crash. This vulnerability could be used in a denial of service attack against Advantage servers. The loss of data or any form of data corruption is not likely. Execution of malicious code is not possible.
  23. Fixed an issue that could cause the server to crash if it was given a filter expression that compares a string value and a non-string value.
  24. Fixed an issue where the management utility in ARC or the AdsMgGetLocks ACE API could return the same lock multiple times.
  25. Fixed a bug that caused comparison using LIKE operator to fail when the pattern for the match contains non-ASCII or Unicode characters, or when the source text to be matched is Unicode.
  26. Fixed an issue that could lead to a server crash when executing an SQL statement whose WHERE clause included thousands of conditions combined with the OR operator.
  27. Fixed an issue where if calling the CONTAINS scalar searching a binary field, and the search requires a brute force evaluation, a 2159 error was returned.
  28. Fixed a bug that caused incorrect results to be returned for SQL statements that use a simple aggregate statement with a WHERE clause comparing a character column with a string literal containing non-ASCII characters. For example, SELECT count(*) FROM mytable WHERE CharColumn = 'NonÄSCIILiteral'.
  29. Fixed a bug that caused incorrect results to be returned when executing SQL statements that use a parameter in the LIKE comparison.
  30. Fixed a bug where an incorrect result could be returned to an expression that used a subquery. The problem affected expressions that were evaluated multiple times and that used only system (virtual) tables in the subquery.
  31. Fixed an issue in the SQL parser that caused Django CREATE TABLE statements to fail.
  32. Fixed a bug that caused a division by zero exception in applications built using Delphi. The exception occurred when executing an SQL statement in the form of "INSERT ... INTO ... SELECT ... FROM ..." when the subquery returned zero rows.
  33. Fixed an issue where the IN or NOT IN operator can return incorrect results with unicode values and static cursors.
10.10.0.17 - Advantage Client Engine (ACE) This Service Update of the Advantage Client Engine (ACE) addresses the following issues:
  1. Fixed a bug in local server that may cause an exception when executing the sp_ReindexTable() command.
  2. Fixed an issue where replication on Linux or the Linux comm layer in general can fail with error code 4 (EINTR).
  3. Fixed an issue that would cause an incorrect value for the required data size when a 5005 (Insufficient Buffer) error was returned when non-unicode data was retrieved using a Unicode data retrieval API (AdsGetStringW, AdsGetFieldW).
10.10.0.17 - Advantage Communication Layer This Service Update of the Advantage Communication Layer addresses the following issues:
  1. Updated the client TCP/IP communications layer to not wait infinitely for a response from the server. If, for example, a firewall closes a TCP connection without notifying the client, the client could wait forever for a response that will not arrive. This issue can affect applications using TCP/IP and it can also cause replication operations over TCP/IP to hang and require the server to be restarted in order to continue replication.
  2. Fixed a bug in the client communications layer that could result in a 9026 error being logged by the server when shared memory communications were used.
10.10.0.17 - Advantage Crystal Reports Driver This Service Update of the Advantage Crystal Reports Driver addresses the following issues:
  1. Fixed a bug where only compatibility locking would be used if the LockingMode property was added to a per-alias section.
10.10.0.17 - Advantage Data Architect (ARC) This Service Update of the Advantage Data Architect (ARC) addresses the following issues:
  1. Fixed an issue where ARC could crash when importing a CSV file.
  2. Fixed an issue in ARC where a dictionary compare against a NetWare server could either fail silently, or raise an "invalid typecast" exception.
  3. Changed Advantage Data Architect to respect the disable trigger checkbox when creating triggers.
  4. Fixed a bug in Advantage Data Architect that prevented loading of saved queries in the Query Builder utility.
  5. Fixed a bug where ARC would truncate view and trigger SQL statements greater than 32k.
10.10.0.17 - Advantage JDBC Driver This Service Update of the Advantage JDBC Driver addresses the following issues:
  1. Fixed a bug in the JDBC driver that could cause a connection error when the same Properties object was used by the DriverManager.getConnections() method in multiple threads.
10.10.0.17 - Advantage ODBC Driver This Service Update of the Advantage ODBC Driver addresses the following issues:
  1. Fixed an issue that would cause the ODBC driver to return blank memo data.
10.10.0.17 - Advantage TDataSet Descendant This Service Update of the Advantage TDataSet Descendant addresses the following issues:
  1. Fixed an issue where building the Advantage trigger template project in C++Builder XE would report two include path warnings.
  2. Fixed a bug that caused the Delphi method TAdsTable.RestructureTable to return a 5027 error if one of the VFP collations was specified as the table type on a free table.
10.10.0.17 - Advantage Visual Objects Driver This Service Update of the Advantage Visual Objects Driver addresses the following issues:
  1. Fixed an issue with the Vulcan.NET RDD where double and curdouble field values were not returned correctly.
10.10.0.18 - Advantage Database Server This Service Update of the Advantage Database Server addresses the following issues:
  1. Fixed a bug in the server install that prevented installation on Windows 2000.
10.10.0.18 - Advantage .NET Data Provider This Service Update of the Advantage .NET Data Provider addresses the following issues:
  1. Fixed a bug in the Advantage .NET Data Provider that caused the "Update Database from Model" functionality in an ADO.NET Entity Data Model to not maintain the existing entities (tables) in the data model.
10.10.0.18 - Advantage Client Engine (ACE) This Service Update of the Advantage Client Engine (ACE) addresses the following issues:
  1. A cached copy of the environment variable adsini_path is no longer used when searching the ads.ini fiile.
10.10.0.18 - Advantage Data Architect (ARC) This Service Update of the Advantage Data Architect (ARC) addresses the following issues:
  1. Fixed a bug that prevent AFTER triggers from being saved.