Advantage Product Download

Version:          Download
    11.10.0.24

Notes:
    11.10.0.24 - Advantage Database Server

This Service Update of the Advantage Database Server addresses the following issues:

1. Upgraded ADS FIPS Module based on OpenSSL 0.9.8zg to cover security vulnerabilities


2. Fixed the regression in handling autoinc field and value 0 (zero)

11.10.0.22 - Advantage Database Server

This Service Update of the Advantage Database Server addresses the following issues:

1. Security Enhancement #1: Upgraded FIPS-compliant OpenSSL libraries, header files to OpenSLL version 0.9.8zb to incorporate recent security fixes.



2. Security Enhancement #2: Disabled SSLv3 (and SSLv2) for communication between server and ACE to cover POODLE attack vulnerability.



3. Fixed an issue where a non-adssys user would recieve a 7087 error opening a Data Dictionary Link and the CheckFreeTablesAccess connection string was set to TRUE.



4. Incorrect logic that could result in a 9111 error when using FETCH_UNKNOWN OR FETCH_REVERSE as a fetch direction of a ResultSet using JDBC driver.



5. Server failure caused during execution of SHOW PLAN on a statement with IN operator and a subquery in it.
   



6. Bug in server logic which resulted in a 2146 error when executing a query twice that includes a WHERE and ORDER BY clause with numeric fields and with indexes created in particular order.




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.10 - Advantage Database Server

This Service Update of the Advantage Database Server addresses the following issues:



1. Implemented auto-creation of table and index files when the table is referenced on a linked data dictionary.



2. Fixed a bug that prevented column/field property being read even though permission to the table had been granted to the DB:Public.



3. Fixed bug that caused incorrect data being returned when the data stored in the table is encoded in one of the OEM code pages.



4. Fixed issue where an online pack of a view or temporary table could cause an internal server error.



5. 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.



6. 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.



7. 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.



8. Fixed a bug that would cause auto-creation of index file with dynamic VFP collation to fail.



9. Fixed an issue with alter and online pack where the new table would be fragmented if it had a memo file.



10. Fixed a bug that could cause server crash when dynamic AOF is enabled and there are AOF involving Unicode characters.



11. Fixed a crash when dealing with ADT tables that have a large number of fields.



12. Fixed an issue where an FTS index in a non-compound index can cause an internal error in the server.



13. Fixed a bug that could cause 30XX error being returned from AdsBuildRawKey100() when the ADS_GET_PARTIAL_FULL_KEY_LENGTH option is used.



14. Fixed an issue where the server could crash when disconnecting a client.



15. Fixed a bug that caused Advantage Database Server to count two connections from the same terminal services session as two different users when mixing pre 11.x clients and 11.x clients.



16. Fixed a bug that caused a 5133 error when retrieving views created by older (v6.1 and older) versions of Advantage.



17. Fixed a 3111 error when setting an AOF that on a timestamp field of the following form field = ''.



18. Fixed a bug that could data dictionary corruption on a failed ALTER TABLE or AdsRestructureTable.



19. 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.



20. Fixed a bug in the server that caused ALTER ONLINE to not rename memo files correctly if the altered table contained a memo file and the original did not.



21. Fixed a bug in the server that could result in a 9124 error when handling files with more than 2,147,483,647 records.



22. Fix a bug in the online data dictionary restore operation that caused the memo block size of tables to not be maintained.



23. Fixed a bug in the server that could cause a server crash when using the R&R report writer with a corrupt table.



24. 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.



25. Fixed a bug that can cause 9058 error when mixing transaction command in SQL and ACE API.



26. Fixed a bug that caused erroneous 2154 error being returned when executing a SQL statement that has parameter enclosed in parenthesis.



27. 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.



28. Fixed a server crash when an SQL statement of the follwoing form is ran SELECT * FROM test WHERE field1 = field2 AND field2 = 1 + 2;



29. Fixed a 5132 error that could be returned from system.functions.



30. Fixed a 2138 error NO_DATAFOUND when executing a MERGE statement that contained an empty sub-query in the ON clause.



31. Fixed startup script for Linux server to improve compatibility with certain Novell Linux distributions.





11.10.0.0 - Advantage Database Server

This Service Update of the Advantage Database Server addresses the following issues:



1. Updated the permissions checking of SERVER:Admin and SERVER:Monitor roles on system procedures called from within user-defined stored procedures. With this change, it is possible, for example, to call sp_mgGetInstallInfo inside a user-defined procedure without the calling user being a member of SERVER:Monitor.



2. Fix a bug that caused a 9092 error to be returned when executing a stored procedure with varying cursor output that resulted in a live cursor.



3. Fixed a bug where the detail error message from a failed trigger could be lost.



4. Updated AdsMgGetLockOwner, sp_mgGetLockOwner, sp_mgGetTableUsers, and sp_mgGetIndexUsers to return the Application ID.



5. Fixed a bug in the server that could result in a 9110 error when evaluating a filter expression.



6. Improved the error message returned when enabling query logging against a table with an incompatible schema.



7. Fixed an issue where temporary tables could be created in an incorrect temp path for data dictionary connections.



8. Fixed a bug that could result in ADT memo corruption when using encrypted free tables inside a transaction.



9. Fixed a bug in the server that incorrectly resulted in 7058 errors being returned from the server during skip operations in index order.



10. Fixed an issue where VO AEPs could cause an exception in the GetInterfaceVersion function.



11. Fixed an issue where 2129 or 2239 may be returned when calling sp_EnableQueryLogging.



12. Fixed a bug that resulted in a 5005 error when using the REPLACE scalar with Unicode data.



13. Fixed an issue where a spurious 2229 (ambiguous identifier) error was returned when executing a scripted stored procedure that inserts or updates a table that has column names beginning with the _ (underscore) character.



14. Fixed an issue that resulted in a 2136 error when executing a stored procedure with an input parameter of the type MONEY.



15. Fixed a bug that caused a server crash when an invalid SQL statement with a large number of unbalanced open parenthesis was executed.



16. Fixed an inconsistency that caused VFP EMPTY fields to be returned as NULL when creating a static cursor.