Advantage Developer Zone

 
 
 

Advantage Product Download







Advantage Database Server Release 10.1 for Windows x86 32-bit

This release is unsupported. Downloads provided as a courtesy.

Version:          
    10.10.0.49

Notes:
    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.28 - Advantage Database Server

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

  1. Improved detection of ADM memo file free list corruption.


  2. Fixed a bug that caused comparisons using the LIKE operator to fail when the pattern for the match contained non-ASCII or Unicode characters, or when the source text to be matched was Unicode.


  3. Fixed a bug in the server that could incorrectly reject Clipper client connections with a 7166 error.


  4. Fixed a bug that caused an internal error to be returned when executing an SQL query with an ORDER BY clause containing mixed CHAR and NCHAR data, and when the CHAR data in the ORDER BY was designated with DESC (descending order).


  5. Fixed a bug where a 9055 error was produced when rolling back a transaction to a savepoint.


  6. Fixed an issue that caused sp_GetTables to return "#" for a table name after deleting / dropping a #TEMP table.


  7. Fixed a performance issue with disabled triggers. When triggers were disabled for a user (sp_DisableTriggers), implicit transactions were needlessly started.


  8. Updated ARC to show, by default, the current replication record in the replication queue. If replication stops, this makes it simpler to see the record that caused the replication failure.


  9. Updated the Visual Studio AEP and Trigger template projects to include code to dispose of IDbCommand objects prior to exiting the external function.


  10. Changed a 9046 error into a 5072 error produced when a differential backup destination table or dictionary is read-only.


  11. Fixed an issue that could result in a 9124 error in rare situations in the cache system when a delayed write of a file failed.


  12. Fixed an issue where a FIPS enabled dictionary could not be opened by two processes at the same time using local server.


  13. Fixed a bug that could cause a server crash or dump file to be generated when there are multiple independent RI graphs in the database.


  14. Fixed a bug that could cause a server crash if a 7001 error (memory allocation failure) occurred during the update of a table involved in RI.


  15. Fixed a bug that could cause broken referential integrity relationships. The bug requires an RI cascade update that triggers an update in a table that is in another independent RI graph. In such a case, the RI verification was not done on the table updated by the trigger.


  16. Fixed an issue where the error string for a 2206 error contained "%s" instead of the table name.


  17. Fixed a bug where creating a VFP table with a primary key in SQL could fail if the table name was longer than seven characters.


  18. Fixed a bug where the UPPER and LOWER scalar functions could return an insufficient buffer error if the argument contained certain unicode characters.


  19. Changed the SQL engine to conform to the SQL standard to not require the GROUP BY clause when there is a HAVING clause. An implicit GROUP BY on an empyt set is now assumed when there is no GROUP BY clause.


  20. Fixed a bug that led to an incorrect number of rows being returned for SQL statements of the form "SELECT TOP x PERCENT 'abc' FROM ...". The problem occurred when the select list had only constant or literal values.


  21. Fixed a bug in the SQL engine that caused an incorrect result to be returned when a non-correlated subquery was used as the join predicate of a LEFT OUTER JOIN.


  22. Fixed a 3107 error in the server when a client older than 10.0 executed a query containing WEEK, QUARTER, DAYOFYEAR, DAYOFWEEK, HOUR, MINUTE, SECOND, DAYNAME, or MONTHNAME.


  23. Fixed a bug that could cause a server crash when executing an SQL statement of the form "INSERT INTO ... SELECT ... FROM ( EXECUTE PROCEDURE ... ) t"


  24. Fixed a bug that caused an UPDATE statement on a linked table with a table alias to return a 7041 error.


  25. Fixed a bug that caused trigger variables to evaluate incorrectly. The bug could lead to incorrect execution of trigger.




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 installer that prevented installation on Windows 2000.




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

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

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



10.10.0.6 - Advantage Database Server

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

  1. Updated the server to not log the 7160 code on startup. This was an information message logged if the server could not load the libraries required for strong encryption support.


  2. Update the server to return a 7069 error when a pre v10.1 client connects to a data dictionary using AES encryption instead of the misleading 6423 error.


  3. Improved the code that looks for the TLS (SSL) certificate for TLS communications. The server configuration parameter TLS_KEY_FILE and the client connection option TLSCertificate can specify the certificate files without path information if the file is located in the Advantage search path (e.g., in the folder containing the Advantage binaries).


  4. Fixed an issue that would result in a 7060 (ERR_INVALID_PASSWORD) when decrypting a Dictionary-bound encrypted table when the dictionary's Table Encryption password was 20 bytes in length.


  5. Fixed a bug that could cause server to crash when opening a DBF table with incorrect table header information.


  6. Fixed a bug in the server that could result in an access violation in the server if some rare conditions were met and the sp_mgKillUser or AdsMgKillUser APIs were used while a connection was in progress.


  7. Fixed a bug in the server that could result in record locks being held indefinitely after a record with RowVersion or ModTime fields was inserted in a transaction.


  8. Fixed a bug that caused incorrect SQL progress information being returned when "CREATE INDEX ..." statement is part of the SQL script. This bug may lead to an "Invalid floating point operation" error when the SQL script is very large.


  9. Fixed a bug in the server that could result in a 9021 error when online backup was used on connections with AES encryption specified. The error could occur on tables that were not encrypted.


  10. Fixed a bug in the server that could result in possible index corruption and possible 7017 errors on tables encrypted with AES.


  11. Fixed an issue where the server can crash if a corrupted index is automatically rebuilt after a crash.


  12. Fixed a bug in the server that caused sp_SetDDEncryptionType to produce an invalid .ai file when a Visual FoxPro collation was in use.


  13. Update the online help to include a search box on the index tab.


  14. Fix a bug in the server that could result in a crash when using online backup functionality on a data dictionary that is using 128-bit AES encryption.


  15. Fixed a bug that could result in a corrupt free table when using AES encryption. If a table is decrypted and then immediately encrypted again with a different password and without closing the table between the operations, the resulting table was encrypted with incorrect encryption information and could not be recovered.


  16. Changed the install to propagate the LAN_IP_ADDRESS setting during an upgrade from 9.x to 10.10.x


  17. Fixed a bug in the server that would result in an access violation when creating a data dictionary link when using AES encryption.


  18. Fixed a bug in the server that resulted in possible ADM memo file bloat when using AES encryption.


  19. Fix a bug in the server that could result in triggers causing 5073 errors if the encryption type of the table did not match the connection's encryption type.


  20. Fixed a bug that caused the restructuring of VFP tables encrypted with AES to fail with a 5097 error when the ENCRYPT_TABLE_PASSWORD property was set on the dictionary.


  21. Fixed a bug that can lead to partially optimized AOF when full optimization is possible. The problem occurs when a Unicode field is part of the filter expression and the Unicode field is not the first segment of a multi-segment index.


  22. Updated the server to log error information for replication failures directly to the replication queue table to make it easier to find the reason for the failure. If the replication queue already exists, it will not be updated with the new error information until the queue table is deleted from the dictionary.


  23. Fixed a bug in the Linux server that could result in users being timed out incorrectly. This could result in 7020 errors being logged and possibly 7209 errors being returned to the client.


  24. Fixed a bug in the server that could result in unexpected 5041 errors and possibly a server crash when running triggers on many threads concurrently.


  25. Fixed a bug in the server that could cause a fully cached VFP table encrypted with AES to produce a 9124 error.


  26. Fixed a 9094 error when executing a stored procedure in a loop using UDP on a network that has packet loss issues.


  27. Fixed a 9066 error caused by canceling an SQL statement that caused an auto-create of an index inside of a transaction.


  28. Enhanced the query engine to not hold table open after executing "DROP INDEX ..." or "CREATE INDEX ..." statements.


  29. Fixed a bug that caused CREATE TABLE SQL statement to fail when a Unicode column (NCHAR or NVARCHAR) was designated as the primary key for the table.


  30. Fixed a bug that caused the SQL command EXECUTE IMMEDIATE to fail with 5211 error when there were NON-ASCII characters in the value expression that were to be executed.


  31. Fixed an error that caused certain queries involving the negation of a comparison expression to be unoptimized.


  32. Fixed a bug that could cause 2111, "Out of range", error being returned when the CAST() scalar is used to convert a value into SQL_BINARY or SQL_VARBINARY type without specifying the precision of the result.


  33. Fixed a bug that can cause crash dump being generated when executing a SQL statement that has a comparison involving a column from a subquery and another subquery. The crash dump would be generated when the subquery in the comparison returns zero rows, however the query execution would still complete with correct result.


  34. Fixed a bug that caused incorrect result to be returned when "SELECT COUNT(*) FROM __input WHERE SomeCondition" is executed inside a stored procedure.


  35. Fixed an issue where setting FTS properties via sp_ModifyDatabase fails with an older than 10.0 version of the client (ARC or ACE) and a 10.0 or newer server.


  36. Fixed a bug that caused MEMO data type to be returned for a column that is derived from a string variable. In previous release the data type was VARCHARFOX.


  37. Fixed a bug that could cause more or less than expected rows being inserted when executing an "INSERT INTO ... SELECT ..." type of query. The problem occurs when the SELECT is a complex subquery with join or subquery.


  38. Fixed a bug that caused incorrect number of rows to be inserted when an SQL statement of this form is executed: INSERT INTO ... SELECT TOP x PERCENT ... FROM ...


  39. Fixed a bug that caused 2111 (OUT OF RANGE) error or server crash when executing SQL statement that used CASE expression with both SQL_LONGVARBINAR (Blob) data and SQL_BINARY (Raw) data as possible result.


  40. During a silent install the Advantage Database Server is now stopped without prompting.


  41. Fixed a bug where 9.10 files could be left behind when upgrading to 10.x.



10.10.0.0 - Advantage Database Server

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

  1. Fixed an issue that prevented adsstamp from stamping the OEM language into a Linux server on some 64-bit distributions.


  2. Fixed a bug in the configuration utility (ads_cfg.exe) that caused server operation counts over 2,147,483,648 to display as negative values.


  3. Changed the DBF header date to be compatible with 3rd party utilities.


  4. Fixed an issue where the server could fire incorrect trigger types if the client had the SHOW DELETED setting on, deleted records existed, and updates were being performed on deleted records.


  5. Fixed an issue where indexes built prior to 9.10.0.21 or 10.0.0.3 but used with aforementioned versions or newer caused 4004 errors.


  6. Fixed a bug that caused the server to crash when an SQL statement was executed twice.

    Fixed a bug that could cause a query to be sorted in the incorrect order if there were Unicode character columns in the ORDER BY clause, and there was an existing index matching the ORDER BY clause but with a different Unicode collation.


  7. Fixed a bug where the ROWID returned from the same table has a different prefix depending on the case of the table name specified in the SQL statement.


  8. Fixed a bug in the server that could result in query elements being leaked on the server by calls to sp_WaitForEvent and sp_WaitForAnyEvent. This could result in access violations and 9003 errors when used with .NET clients.


  9. Fixed an issue where NMemo fields in __new and __old tables would only contain the first character of the Unicode string.


  10. Fixed an issue where triggers on tables with one or more NVarChar fields would produce a 5073 error when updated.


  11. Fixed a bug that would cause an AIS connection to hang when the client and server switched to SMC communication after doing server discovery using TCP/IP.


  12. Fixed a bug that caused the YEAR AOF function to be incorrectly optimized when not testing for equality.


  13. Fixed a bug that caused an incorrect optimization to be performed when evaluating filters (such as in SQL WHERE clauses). These filters were incorrect when they were of the form "FieldA < FieldB and FieldA > constant". If an index existed on FieldA, it was possible for the index to incorrectly be used to optimize the full expression. This could result in incorrect result sets.


  14. Fixed a bug that caused a 5133 error to be returned when creating stored procedures using a Unicode string, such as when creating a stored procedure in ARC.


  15. Fixed a bug that could cause a trigger script to fail if the last statement executed in the script was a SELECT statement.


  16. Fixed a bug in the query engine that caused comparison involving NULL values to fail when the column is a Unicode column in a CDX or NTX table.


  17. Fixed a bug that caused 2119 or 2159 errors to be returned when a simple CASE expression uses a subquery as the input value.


  18. Fixed a 7041 error when dropping a temporary table after dropping an index from the table.


  19. Fixed a bug in the SQL query engine that caused poor query performance when a view or subquery was used as part of a multi-table join.


  20. Fixed a bug that caused poor SQL query performance when the join condition was only partially optimized.


  21. Fixed a bug where potential Unicode parameters in the SQL statement could cause the server to crash, or cause a variety of other errors.


  22. Fixed an issue where an INSERT statement with a SELECT DISTINCT subquery that used a date literal would lead to a server crash or a 2203 (ERR_FILE_READ_ERROR) error.


  23. Fixed a bug that prevented cartesian joins in SQL from being canceled.


  24. Fixed a bug that caused SQL queries to fail when no precision value was specified for the resultant data type when using the CAST() or CONVERT() scalars.


  25. Fixed a bug with the ROWNUM function in SQL when used as part of an INSERT INTO SELECT FROM statement.


  26. Fixed a bug that caused an unexpected failure when using EXECUTE PROCEDURE as a table expression in a SELECT statement. The failure occurred after an exception was raised in the stored procedure and caught. However, subsequent execution of the same SELECT statement would continue to fail even when no exception was raised in the stored procedure.


  27. Fixed a bug that caused a 2136 error when using ARC to create a User Defined Function that has a Double type as an input parameter or return value.


  28. Fixed a bug where the error 5005 could be returned when executing an SQL query using AdsExecuteSQLW, such as when executing a query in the ARC SQL window. The error was returned when the query being executed used a UDF, and there are string literals containing non-ASCII character in the UDF.


  29. Fixed a bug that caused incorrect UDF description being stored in the data dictionary.