c-treeACE V11.0 Release Notes

c-treeACE SQL Updates and Corrections

In this release, the SQL interface was the recipient of numerous improvements, which are listed in this section.

In This Chapter Critical Production Updates c-treeACE SQL APIs Multiple “Internal Error” Conditions Corrected Corrected Memory Leak When Error Occurs Creating Table with IDENTITY Field ALTER TABLE Now Checks REFERENCES Permissions When Adding Foreign Key Constraints SYSDATE Default Field Values Now Allowed With ALTER TABLE Unix Client Shared Memory Connections No Longer Leak Memory AIX Clients No Longer Drop Inactive Shared Memory Connections Avoid Connection Errors If First COMM_PROTOCOL Module Fails to Initialize Correct Error Messages Now Returned by fc_create_user Procedure Correct Return of LVARCHAR Data When Using CT_STRING Data Type Correct VARCHAR Data Now Returned in Complex Queries Proper NULL Values Now Returned for LVARCHAR Columns When Sorting for ORDER BY LONG VARBINARY Support Added for ORDER BY Clauses Query Speed Improved From Dynamic Index Usage Corrected TRUNCATE Scalar Function Result Corrected Rounding of Sub-Query Numeric Values Empty Column Names No Longer Returned When Column Length Is 64-characters Case-Insensitive CONTAINS Now Properly Matches Uppercase Data MAX Scalar Function on Field With Descending Index No Longer Returns MIN Value SUSER_NAME and USER_NAME Scalar Functions Improved Corrected GRANT of Column Permissions for non-DBA Users with Table Grant Permissions REVOKE GRANT OPTION Now Correctly Removes Column Permissions Corrected Index Creation for Selected Imported Tables Optimizer Improvements for Field Type Constraints Error -20134 No Longer Returned When Setting LONG Fields to NULL Error -20133 No Longer Improperly Returned When Setting UID in DEFAULT Clause Error -20142 No Longer Returned with UDF Execution After Table Import Corrected DH_REBUILD_SEL_CUTOFF Handling