Advantage Developer Zone

 
 
 

Advantage Database Server 10.10.0.49 Service Update


Advantage Database Server 10.10.0.49 Service Update released including support for Delphi XE 4.

10.10.0.49 - Advantage Database Server


This Service Update of the Advantage Database Server addresses the following issues:
  1. Fixed a bug that caused crash dump being generated on the server when disconnecting a client. The problem surfaces after updating a table on a data dictionary link that has both trigger and RI.
  2. Fixed a 9077 error when a user is killed by the watch dog thread.
  3. Fixed a bug in the server that could result in a corrupt data dictionary index file (.ai) when encrypting the dictionary using AES encryption. The bug also affected AES encrypted tables that had read caching enabled (ADS_DD_TABLE_CACHING). After applying this update, it is possible to ensure that the .ai index file is rebuilt correctly simply be deleting it from disk. It is automatically rebuilt when the dictionary is opened.
  4. Fixed a bug in the server that could result in deadlock when using AES encryption.
  5. Fixed a bug in the server that caused replicated DBF records (from CDX/VFP tables) to be deleted at the target. The problem would occur if the update of a deleted dbf record was followed by the update of a non-deleted record. Both records would be deleted at the target rather than just the one that was deleted at the source.
  6. Fixed an issue that may lead to incorrect index ordering on 64-bit Linux servers running glibc 2.11 or later.
  7. Fixed a spurious 7001 error that can occur when evaluating certain filter expressions involving the string containment operator.
  8. Fixed a bug in the server that allowed a single index file to be opened by two different tables.
  9. Fixed a bug where using non-standard DBF table file could cause the server to crash.
  10. Modified the data dictionary to return the index file names of a table in the same order that the index file were added into the data dictionary.
  11. Fixed a bug that caused incorrect filter or SQL result being returned when the collation of the table or SQL statement is different from the collation of the index.
  12. Fixed a bug that could cause incorrect collation being use when using sp_createindex() or sp_createindex90() to index Unicode column.
  13. Fixed a bug that caused data dictionary to not maintain Unicode collation of the index on a column that was changed from non-Unicode to Unicode (restructuring of the table).
  14. Fixed a bug in the server could cause a database restore operation to fail with a 7128 error when the dictionary files were encrypted with AES.
  15. Updated the user rights checking logic to respect database roles in linked dictionaries. If, for example, a user is a member of DB:Admin in the linked dictionary and the link uses the current user's credentials, then the link to the other dictionary will respect that role membership.
  16. Fixed an access violation when a user performed an AdsDDFindNextObject on a linked data dictionary with no tables visible to the user.
  17. Fixed a 7103 error when doing a wild card CONTAINS on multiple Unicode fields.
  18. Fixed a bug that caused slow auto-creation of indexes when a connecting to the server using an IP address and port in the path.
  19. Fixed a bug that could cause incorrect index or filter operation on ANSI characters using local server when the default system code page is not 1252.
  20. Fixed a bug in the server that could result in a 9110 error when evaluating a filter expression.
  21. Fixed a bug that could result in ADT memo corruption when using encrypted free tables inside a transaction.
  22. Fixed a bug that prevented column/field property being read even though permission to the table had been granted to the DB:Public.
  23. Fixed bug that caused incorrect data being returned when the data stored in the table is encoded in one of the OEM code pages.
  24. Fixed a bug that caused 9016 error being logged and crash dump being generated by the server when a client connected using TCP protocol is disconnected abnormally.
  25. Fixed a bug in the server that could cause a 9111 error if a memo exceeding 64K was inserted into an FTS indexed memo field in an SQL statement while a transaction was active.
  26. Fixed a bug that could result in a failed online restore of a database if a table that was the parent in an RI relationship had a name exceeding 40 characters in length.
  27. Fixed a bug that could cause server crash when dynamic AOF is enabled and there are AOF involving Unicode characters.
  28. Fixed a crash when dealing with ADT tables that have a large number of fields.
  29. Fixed a bug that could cause 30XX error being returned from AdsBuildRawKey100() when the ADS_GET_PARTIAL_FULL_KEY_LENGTH option is used.
  30. Fixed an issue where the server could crash when disconnecting a client.
  31. Fixed a bug that could data dictionary corruption on a failed ALTER TABLE or AdsRestructureTable.
  32. Fixed a bug that caused 9124 error being logged by the server and crash dump being generated when restructuring OEM encoded DBF table that uses non-ASCII characters in the field name.
  33. Fixed a bug in the server that could result in a 9124 error when handling files with more than 2,147,483,647 records.
  34. Fix a bug in the online data dictionary restore operation that caused the memo block size of tables to not be maintained.
  35. 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.
  36. Updated Advantage Database Server to be able to replicate linked tables within transactions.
  37. Fixed a bug that could cause server crash when execute an SQL statement with expression that combines the unary positive operator and an aggregate function, such as "select +sum(val) from ...".
  38. Added support for national character string literals.
  39. Fixed an issue introduced in 10.10.0.28 where the exclusive requirement was removed when dropping #temp tables via a DROP TABLE statement. The exclusive requirement is now, once again, required when dropping #temp tables via a DROP TABLE statement.
  40. Fixed a bug in the SQL engine that caused 2237 error when the table name or path contains non-ASCII characters.
  41. Fixed an issue where an ORDER BY or DISTINCT could fail if the result set is larger than 4 GB.
  42. Fixed a bug in the SQL engine that caused a failure when a precision numeric value was used as the input parameter for the sqrt(), log(), log10, and atan2() scalars.
  43. Fixed an issue where REPLACE on an empty unicode field would return 1509
  44. Fixed an issue where a 5209 warning could be returned when executing an SQL statement that exceeded ~56k (including the size of parameter data) and the table had an index built with one of the dynamic collations. Both the server and ACE must be updated.
  45. Fixed a bug that may course imcomplete execution of the INSERT INTO statement. The bug would happen when the target of the INSERT is a DBF table in a linked data dictionary while the source table is an ADT with the same basename as the target.
  46. Fixed a bug where sp_GetSQLStatements could return a percent done greater than 100% or a negative number of seconds until finished.
  47. Fixed sp_Reindex to correctly handle encrypted free tables.
  48. Modified 64 bit server to have a larger stack limitation to accommodate the increased size of pointer parameters. Some SQL statement that executed successfully with 32 bit server was failing with either server crash or error code 2013.
  49. Fixed a bug that resulted in a 5005 error when using the REPLACE scalar with Unicode data.
  50. Fixed a bug that could cause server to crash when evaluating large boolean or algebraic expression in SQL statement.
  51. Fixed a bug where converting/casting binary data into SQL_WVARCHAR returned truncated result.
  52. no public description
  53. Fixed a bug that caused a server crash when an invalid SQL statement with a large number of unbalanced open parenthesis was executed.
  54. Fixed an inconsistency that caused VFP EMPTY fields to be returned as NULL when creating a static cursor.
  55. Fixed a bug that caused SQL statement to fail if there was a sub-select in the statement and the sub-select used explicit join condition that referenced table column in the parent query.
  56. Fixed a 2138 error NO_DATAFOUND when executing a MERGE statement that contained an empty sub-query in the ON clause.
  57. Fixed a bug that prevented '0000-00-00 00:00:00' from being used in an SQL statement as a literal.
  58. 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.
  59. 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.

10.10.0.49 - 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 in some situations could produce an incorrect search key involving composite (multi-segment) indexes on time, timestamp, or modtime fields. This could affect Delphi methods such as SetRange, GoToNearest, and Locate.
  2. Fixed an issue where an unoptimized query could return an incorrect record count.
  3. Fixed an issue that could corrupt the stack when a callback registered via AdsRegisterCallbackFunction101 was called.
  4. Fixed an issue that caused AdsGetVersionInfo to return incorrect minor version numbers.

10.10.0.49 - Advantage Crystal Reports Driver


This Service Update of the Advantage Crystal Reports Driver addresses the following issues:
  1. Added support for Crystal 2011.
  2. Fixed a bug in the Crystal Reports driver that caused NMEMO (Unicode memo) fields to be converted to ANSI. Depending on the characters, this could result in a 5211 error.

10.10.0.49 - Advantage Data Architect (ARC)


This Service Update of the Advantage Data Architect (ARC) addresses the following issues:
  1. Fixed a bug in ARC that resulted in 5125 errors when attempting to change the AES encryption type in the Data Dictionary properties dialog.
  2. Fixed a bug in ARC32 that prevented encrypting or decrypting DBF (CDX/VFG/NTX) tables. The 7016 error was always returned.
  3. Fixed a bug in ARC which would cause the UDF dialog to return an error " '' is not a valid integer value for field 'size' ".
  4. Fixed an issue where exporting MEMO fields to Excel using ARC would place squares between characters.

10.10.0.49 - Advantage JDBC Driver


This Service Update of the Advantage JDBC Driver addresses the following issues:
  1. Fixed a bug in the JDBC driver that caused incorrect character data to be returned when the JVM is configured to use a default charset (e.g., file.encoding=UTF-8) that is different from the server's ANSI encoding.
  2. Fixed a bug that caused 5403 error being reported by the JDBC driver after preparing and executing an SQL script that resulted in a cursor.

10.10.0.49 - Advantage TDataSet Descendant


This Service Update of the Advantage TDataSet Descendant addresses the following issues:
  1. Changed the handling of VFP timestamp fields to always round to the nearest second for consistency with Visual FoxPro.
  2. Fixed an issue that caused the TDataSet Descendant to treat zero-length NVarChar and VarCharFox fields tables as null.
  3. Fixed an Access Violation that occurs when a user clicks on the IndexFileNames property of the TAdsTable object at design-time.
  4. Fixed a bug that caused Delphi TDataset descendant's Locate() method to behave incorrectly when searching in Unicode column that was indexed.
  5. Fixed a bug in the Delphi components that caused a 5005 error to be returned when setting a filter with a length greater than 64K.
  6. Added Support for Delphi XE3.
  7. Fixed in issue in the TAdsEvent Component that could lead to an Access Violation in 32-bit applications.
  8. Resolved incorrect marking of Delphi XE2 and XE3 packages as "always build" instead of "never build".
  9. Fixed an issue that would cause TAdsQuery.VerifySQL to return spurious syntax errors when the SQL text contained lines beginning with the '[' character.
  10. Fixed an inconsistency in the Delphi TAdsTable.FindNearest method. When AdsPreserveSpaces is false (the default), FindNearest will now locate records with NULL values when an empty string is provided as one of the seek values.
  11. Added support for Delphi XE4.

10.10.0.49 - Advantage TDataSet Switch Utility


This Service Update of the Advantage TDataSet Switch Utility addresses the following issues:
  1. Improved TDataSet Switcher handling of 64-bit libraries for 64-bit capable Delphi IDEs.

10.10.0.49 - Advantage Visual Objects Driver


This Service Update of the Advantage Visual Objects Driver addresses the following issues:
  1. Fixed parameter support with the VO SQL RDDs.
  2. Fixed an issue with the Vulcan.NET driver where the seek method always failed with very large float values.
  3. Fixed an issue where the VO SQL RDD could take a long time to open a query that resulted in a static cursor.
  4. 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).
  5. Fixed an issue with the AdsSQLServer VO class where SQL parameters are preserved for subsequent calls.