Icon Incident Reports Addressed in 2.05

The following is a list of the incident reports addressed in version 2.05. Click on the incident # in order to view the details of the incident report.

Serious Problems

13337VCL Components Can Raise "Session Already Destroyed" in Delphi XE During Form/Data Module DestructorNo
13338ElevateDB Manager Can Raise "Database name already exists" Error When Opening DatabaseNo
13340Trying to Load Updates into Database with Circular Foreign Key/Primary Key Dependencies Causes HangNo
13341REPAIR TABLE Statement Can Cause AV When Repairing Damaged IndexesNo
13342DELETE Statement Can Cause AV When Comparing Row Values in WHERE ClauseNo
13343Enclosing WHERE Clause Row Value Comparisons in Parentheses Causes Parse ErrorNo
13344Using ALTER TABLE on a Table Containing GENERATED or COMPUTED Expression Columns Can Cause AVNo
13345ElevateDB Server Not Sending Modified Flags for Default Column Values Back to Remote SessionsNo
13346ElevateDB Manager Row Deletion Dialogs Not Working Properly When Escape Key HitNo
13347PUBLISH DATABASE Can Cause Catalog Corruption If Referenced Table(s) Cannot Be Opened ExclusivelyNo
13348Cascading Triggers Can Cause Invalid Old Row Values to be Passed into a TriggerNo
13349Inserting Rows From a Derived Table with ORDER BY and RANGE Causes Incorrect Inserted RowsNo
13350Cannot Use HAVING Clause Without GROUP BY in SELECT StatementNo
13351Adding Expression Filter to a Sensitive Query Result Set with RANGE Clause Causes Incorrect ResultsNo
13352Invalid Internal Expression Columns Appearing in Sensitive Query Result SetsNo
13354Executing a Query That Uses a UDF and Returns a Sensitive Result Set Can Cause Invalid Request ErrorNo
13356Row Value Comparisons Not Working Properly If Row Values Contain NULLsNo
13358Using Locate with OnFilterRecord Can Cause Rows to Not Be Found ProperlyNo
13359Updates on Sensitive Result Set Cursors with ORDER BY Can Take Longer Than NecessaryNo
13360ElevateDB .NET Data Provider Not Triggering Progress/Status/Log Events ProperlyNo
13361Using RIGHT OUTER JOIN Can Cause AV If ElevateDB Tries to Flip Join for OptimizationYes
13362JOINing a Derived Table with a RANGE Clause Can Cause Incorrect ResultsNo
23364ODBC Driver Not Binding VARCHAR Parameters Properly with Certain Front-EndsNo
23366ALL Triggers Incorrectly Raising Error Message When NEWROW Columns ModifiedYes
23369Loading Updates Using LOAD UPDATES Statement Can Cause AVNo
23370Restoring a Backup Created Using EXCLUDE PUBLISHED UPDATES Clause Causes ErrorYes
23371Parameters Not Working Correctly When Used in CAST FunctionsNo
33372Replication Not Handling BLOB/CLOB Column Values for Inserted Rows CorrectlyNo
33375INOUT Parameters Not Working Properly with Recursive ProceduresYes
33376C++Builder Trial Versions Are Missing HPP Header FilesNo
33377Trying to Update a Published Table That Is Being Loaded Can Cause HangNo
43381Loading Information Tables with Many Descriptions Takes Too LongNo
43382Cannot Recompile Servers or Utilities Due to Missing UnitsNo
43384VERIFY/REPAIR Functionality Not Verifying Header Information ProperlyNo
43385Altering a Foreign Key Column Via ALTER TABLE Can Cause #601 Corruption ErrorNo
43386EDB Incorrectly Allowing Configuration Objects to be Renamed to an Existing ObjectNo
43387Recursive Procedures Still Not Working CorrectlyYes
43388Unknown Parameter Types Not Being Assigned Properly from Passed Parameter ValuesNo
43389Jobs Scheduled for Monthly Execution Incorrectly Execute Every MinuteNo
43390Altering INTEGER Columns to IDENTITY Columns Can Cause Incorrect Last Identity Seed Value in TableNo
43391ERROR Triggers Consuming Exceptions Even When WHEN Clause Evaluates to FalseNo
43392ODBC Driver Can Cause Issue with Client Applications Using Fixed Buffers for Connection StringsNo
53405LIKE Operator Not Working Correctly Both With and Without Escape CharactersNo
53410EXPORT TABLE Not Working Correctly with ViewsNo
53411Using REPAIR TABLE to Fix Indexes After Word Generator Changes Causes ErrorNo
53413Assigning a DECIMAL Column with a Larger Scale to a Column in a Routine Can Cause Rounding IssueNo
53414LIST Aggregate Function Ignoring Empty StringsNo
53415Self-Referencing Foreign Key Constraints Not Checked for Current Row During UpdatesNo
53416Calling RETRY From an ERROR Trigger Has No EffectNo
53417Unicode Migrators Not Converting Memo Fields to Unicode ProperlyNo
53420Using Constant Array Version of TEDBDatabase.StartTransaction Method Causes Error on Commit/RollbackYes
53421ElevateDB Server Allowing Remote Sessions to Improperly Reconnect to SessionsNo
53422Opening and Closing Tables with Foreign Key Constraints in Certain Orders Can Cause an AVNo
63423Creating a Database with Many Foreign Key Definitions Can Cause Exclusive Lock ErrorNo
63425Tables Containing Many Foreign Key Dependencies Taking Too Long to OpenNo
73426Sensitive Query Results with SELECT Statements that Contain Expressions Can Cause AVNo
73427ElevateDB Server Not Cleaning Up Dead Sessions ProperlyNo
73428Sensitive Queries with Nested Derived Tables Can Cause AVYes
73432Dropping Foreign Key Constraints Can Cause #401 Error with Database CatalogNo
73434Dependency Checks Done When Dropping Users/Roles Can Cause Invalid Error MessageNo
73437Using NULL Constant in CASE Operator Can Cause Compilation ErrorNo
73438UPDATE Statements that Use Sub-Selects with Multiple Columns Can Cause AVNo
83442Table Files Not Updated Properly if Old Catalog File Cannot Be Overwritten During ALTER TABLENo
83443Updates to a Table Can Cause Next/Prior Operations on a Table Cursor to Skip RowsNo
83444Missing Error Codes in the ElevateDB ManualsNo
83449Trying to Alter a Table That is Opened Via a Foreign Key from Another Table Can Cause Locking ErrorsNo
83450ODBC Driver Can Experience AV When Accessing any Tables Containing Column Without Default ExpressionNo
83452Unicode DBISAM 2.x Migrator Causes Various Errors During MigrationNo
83453Insertions Into an Updateable View Are Not Reflected in the DatasetNo
83455Parameterized INSERTs Causing Errors in ElevateDB .NET Data ProviderNo
93456Altering a Table Can Result in Error #100No
103339ElevateDB Unicode ODBC Driver Truncating CLOB Columns When Read from Microsoft WordNo
103466Executing Queries Against the ServerSessions Configuration Information Table Can Cause AVNo
103469ElevateDB Manager Allows Alteration of Outdated SQL Triggers, Procedures, Functions, and JobsNo
103470Queries with Nested Derived Tables Can Experience Slowdowns with IN/NOT IN OperationsNo
103472Error Triggers Not Re-Raising Exceptions Properly with RAISE StatementNo
103474Custom Error Codes/Messages For Columns Can Cause an AV with a Remote SessionNo
103477Session Connection Interruptions During Table Opens Can Cause "Error Creating Table Handle" ErrorsNo
113479INNER JOINs On Row Values That Contain Constants Can Cause Incorrect ResultsYes
113486Renaming a Job to an Invalid Name Is Improperly Being Allowed to OccurNo
113487INTERSECT Queries Can Cause Result Set Error When DECIMAL Columns Use Different ScalesNo
113488LENGTH() Function Returning Incorrect Results for Compressed CLOB/BLOB ColumnsNo
113489Trying to Refresh Multiple Data Connections in Excel with ODBC Driver Causes ErrorYes
113490Altering a Table with Computed Columns Can Cause Invalid Floating Point OperationNo
113491Closing Down a Connection In Response to a "Connection Lost" Error Does Not Work with Active FiltersNo
113492Importing an Export File Created Using ElevateDB Can Cause Quote Characters To Be RemovedNo
113493ODBC Driver Causing Single Character to Be Removed from CLOB Columns During RetrievalNo
113495DBISAM 1.x Migrator Causing AV and Application Shutdown with Certain BCD ValuesNo
113496Using a DISTINCT Query with a UNION ALL Operation Can Cause Improper BLOB Column ErrorYes
113499Using CAST() With LIST() Aggregate Function Causes Incorrect Results.No

Minor Problems

13353External Module Template Projects Not Correct for Delphi 2007No
13355Pasting Text with Embedded Tabs Causes Display Issues in SQL Editor of ElevateDB ManagerNo
13357Trying to Drop an Administrator that Has Granted Roles/Privileges Can Cause Dependency ErrorYes
23365Adding a File DSN and Not Specifying a User Name/Password in the DSN Configuration Can Cause CrashNo
33373EXECUTE IMMEDIATE USING Clause Not Allowing ERROR Functions in ERROR TriggersYes
33374Cannot Use a DATE Expression in a Default Expression for a TIMESTAMP ColumnYes
43378Cannot Execute ALTER TABLE Statements Against Temporary TablesYes
43380CAST with DATE FORMAT Clause Not Working Correctly without Date DelimitersNo
43383Duplicate Users Can Appear in the ElevateDB Manager When Renaming a UserNo
53409UPDATE Statements Using Correlated Sub-Queries that Reference Outer Statement Columns Can Cause AVYes
53412Ctrl+Tab Not Always Working for Moving Between Tabs in the ElevateDB ManagerNo
53418Inline CASE Operator Not Performing Type Promotion Properly on Returned ValuesYes
53419Grid Columns Not Reflecting ALTER TABLE Modifications in ElevateDB ManagerNo
73429Modules Can Be Dropped When They Are Still In Use by Functions/ProceduresNo
73430Ctrl+N Shortcut Keys Causing Deletion of Selected Text in ElevateDB Manager SQL EditorNo
73431ANSI ElevateDB Manager Not Remembering BIGINT Parameters Between ExecutionsNo
73433Cannot Change Statement Terminator Properly in the Preferences Dialog of the ElevateDB ManagerNo
73435ElevateDB Manager Does Not Insert Statement Terminator When Dragging/Dropping SQLNo
73436Improper Text Not Found Error When Searching and Replacing Text in ElevateDB ManagerNo
83445Using Original Table Names Instead of Table Correlation Names Causes Exception with INSERT QueryNo
83447Breaking Up Multi-Word SQL Statement Keywords Can Cause SQL Execution to Not OccurNo
83448Trigger Error Messages Have the Table Name and Trigger Names ReversedNo
83451Altering Tables Causes Generated Expression Columns to Appear as Identity ColumnsNo
83454Not Passing All Parameters to a Stored Procedure Can Cause an AVYes
103462LargeInt Parameter Assignment Not Working Properly in ElevateDB ManagerNo
103464Migration of DBISAM Database Not Creating Text Indexes as Case-InsensitiveNo
103467Dropping a User with Granted Database Privileges Can Cause ErrorYes
103468Including shlobj.h Header File with C++Builder Project Can Cause Compilation ErrorNo
103471ElevateDB Manager Statement Selection Not Working Properly in Generic ScriptsNo
103473Creating a Copy of a Session in the ElevateDB Manager Can Cause an AVNo
103475Importing Comma-Delimited Text Files with Missing Last CRLF Can Cause AVNo
103476Template Installation Into Repository Does Not Work Properly When Shared Repository SetNo
113485ElevateDB Manager Re-Preparing Queries Between Executions When Query Text Has Not ChangedNo
113494Conversion Error Occurring When Assigning Short Integers to ParametersNo