Version:          
    11.10.0.24
Notes:    11.10.0.24 - Advantage Database Server
This Service Update of the Advantage Database Server addresses the following issues:
- Upgraded ADS FIPS Module based on OpenSSL 0.9.8zg to cover security vulnerabilities
- 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:
- Security Enhancement #1: Upgraded FIPS-compliant OpenSSL libraries, header files to OpenSLL version 0.9.8zb to incorporate recent security fixes.
- Security Enhancement #2: Disabled SSLv3 (and SSLv2) for communication between server and ACE to cover POODLE attack vulnerability.
- 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.
- 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.
- Server failure caused during execution of SHOW PLAN on a statement with IN operator and a subquery in it.
- 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:
- 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.
- 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.
- 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.
- Updated Advantage Database Server to be able to replicate linked tables within transactions.
- Fixed an issue that could cause an internal server error if a table involved in referential integrity is online packed and then updated.
- Fixed a bug that prevented single password in the connection string for all free table to work when executing SQL query.
- Fixed a bug that could cause a connection to remain in server forever if a TCP client is terminated abnormally.
- 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.
- Fixed a bug that could result in a 9005 or 9111 error if a single connection attempted to obtain more than 65534 work areas.
- 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.
- Fixed a race condition when multiple users delete and create the same UDF.
- Added configuration option COMPRESS_DUMP_FILES to provide the capability to disable compression of crash dump files.
- 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.
- 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.
- Fixed a bug when altering a table would not correctly re-index an ADT.
- Fixed a performance problem in the server where concurrent skip operations through a CDX index with compatibility locking could be very slow.
- Fixed a bug that caused server crash when updating a free DBF table that has trigger associated with it in a database.
- 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.
- Fixed a bug that can cause the Linux server to stop communicating with clients.
- Fixed an issue that can cause a 9019 error when calling AdsSetIndexDirection on an index tag with a tag number >= 56.
- 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.
- 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.
- Fixed a bug that prevented '0000-00-00 00:00:00' from being used in an SQL statement as a literal.
- 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.
- 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.
- 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.
- Fixed an issue where a data dictionary default path that has no trailing slash caused invalid paths in the SQL engine.
- Optimized execution of SQL MERGE statements when the target table is empty.
- 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.
- 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:
- Implemented auto-creation of table and index files when the table is referenced on a linked data dictionary.
- Fixed a bug that prevented column/field property being read even though permission to the table had been granted to the DB:Public.
- Fixed bug that caused incorrect data being returned when the data stored in the table is encoded in one of the OEM code pages.
- Fixed issue where an online pack of a view or temporary table could cause an internal server error.
- 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.
- 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.
- 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.
- Fixed a bug that would cause auto-creation of index file with dynamic VFP collation to fail.
- Fixed an issue with alter and online pack where the new table would be fragmented if it had a memo file.
- Fixed a bug that could cause server crash when dynamic AOF is enabled and there are AOF involving Unicode characters.
- Fixed a crash when dealing with ADT tables that have a large number of fields.
- Fixed an issue where an FTS index in a non-compound index can cause an internal error in the server.
- Fixed a bug that could cause 30XX error being returned from AdsBuildRawKey100() when the ADS_GET_PARTIAL_FULL_KEY_LENGTH option is used.
- Fixed an issue where the server could crash when disconnecting a client.
- 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.
- Fixed a bug that caused a 5133 error when retrieving views created by older (v6.1 and older) versions of Advantage.
- Fixed a 3111 error when setting an AOF that on a timestamp field of the following form field = ''.
- Fixed a bug that could data dictionary corruption on a failed ALTER TABLE or AdsRestructureTable.
- 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.
- 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.
- Fixed a bug in the server that could result in a 9124 error when handling files with more than 2,147,483,647 records.
- Fix a bug in the online data dictionary restore operation that caused the memo block size of tables to not be maintained.
- Fixed a bug in the server that could cause a server crash when using the R&R report writer with a corrupt table.
- 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.
- Fixed a bug that can cause 9058 error when mixing transaction command in SQL and ACE API.
- Fixed a bug that caused erroneous 2154 error being returned when executing a SQL statement that has parameter enclosed in parenthesis.
- 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.
- Fixed a server crash when an SQL statement of the follwoing form is ran SELECT * FROM test WHERE field1 = field2 AND field2 = 1 + 2;
- Fixed a 5132 error that could be returned from system.functions.
- Fixed a 2138 error NO_DATAFOUND when executing a MERGE statement that contained an empty sub-query in the ON clause.
- 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:
- 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.
- 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.
- Fixed a bug where the detail error message from a failed trigger could be lost.
- Updated AdsMgGetLockOwner, sp_mgGetLockOwner, sp_mgGetTableUsers, and sp_mgGetIndexUsers to return the Application ID.
- Fixed a bug in the server that could result in a 9110 error when evaluating a filter expression.
- Improved the error message returned when enabling query logging against a table with an incompatible schema.
- Fixed an issue where temporary tables could be created in an incorrect temp path for data dictionary connections.
- Fixed a bug that could result in ADT memo corruption when using encrypted free tables inside a transaction.
- Fixed a bug in the server that incorrectly resulted in 7058 errors being returned from the server during skip operations in index order.
- Fixed an issue where VO AEPs could cause an exception in the GetInterfaceVersion function.
- Fixed an issue where 2129 or 2239 may be returned when calling sp_EnableQueryLogging.
- Fixed a bug that resulted in a 5005 error when using the REPLACE scalar with Unicode data.
- 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.
- Fixed an issue that resulted in a 2136 error when executing a stored procedure with an input parameter of the type MONEY.
- Fixed a bug that caused a server crash when an invalid SQL statement with a large number of unbalanced open parenthesis was executed.
- Fixed an inconsistency that caused VFP EMPTY fields to be returned as NULL when creating a static cursor.