Icon New Incident Reports for 2.03

The following is a list of the new incidents reported for version 2.03. Click on the incident # in order to view the details of the incident report.

Serious Problems

13068LOAD UPDATES Fails with "Column Not Found" Error When Loading Empty BLOB UpdateNo
13070Possible AV When Querying on a Table During Multi-User UpdatingNo
23071Opening the Tables Information Schema Table Can Cause Conversion Error for Published TablesNo
33075INSERT INTO SELECT Statements Incorrectly Including Deleted RowsNo
43084Exporting an Updateable View Causes All Rows to Be Exported from the Base TableNo
43085Sensitive Query Result Sets Show Incorrect Results for Generated Columns in Base TableNo
43086Attempting to Repair or Optimize More than One Table in a Row Causes Temporary Table ErrorNo
43088Floating-Point Numbers Cannot Be Entered Properly When Windows Locale is set to SpanishNo
43089ALTER TABLE ALTER COLUMN..MOVE Clause Can Cause Data Loss Errors When Moving ColumnsNo
43090Dead Sessions on the EDB Server Containing Updateable Views Can Cause Lock ErrorsNo
43091Bookmarks Not Being Set Properly for Navigation of UNIQUE Constraint IndexesNo
43092RIGHT OUTER JOINs Not Working Properly When Not Referring to Immediately Prior TableYes
53093Derived Tables Can Cause AV During Destruction of Owning Query or ViewNo
53095ALTER TABLE Statements That Encounter Errors Can Cause Error About a Non-Existent Temporary TableNo
53097VARBYTE Columns Assignments Causing an AV in Delphi/C++Builder ApplicationsNo
63103ElevateDB Incorrectly Re-Writing LEFT OUTER JOINs that Don't Contain Join ConditionsYes
63104Executing UPDATE Statements Against Tables with Nested Foreign Key Constraints Can Cause AVNo
63106Progress, Status, and Log Messages Not Being Triggered for Remote SessionsNo
63107Running the ElevateDB Server under Windows 98 or Earlier Causes AVNo
63109Self-Referencing Foreign Keys Causing Improper ExceptionsNo
63110GotoCurrent Not Working Correctly with Remote SessionsNo
63111Aggregate Queries with HAVING Clause Used as Sub-Select with IN Clause Can Return Incorrect ResultsYes
63112Using QUOTE CHAR #0 with IMPORT TABLE Statement Does Not Work ProperlyNo
63113CAST Function Not Truncating VARCHAR Columns ProperlyNo
63115Index Statistics Being Calculated Improperly for Tables and Causing Query Optimizer to Make MistakesNo
63117Query Optimizer Making Bad Decisions with Certain Join Re-OrderingsYes
63118Trying to Reconnect a Remote Session After a Timeout Event Causes Server to Not Respond to ConnectsNo
63119Joins Taking Too Much Time and CPU when Executed on Very Large TablesNo
63124Creating a Generated Expression Column with NOT NULL Constraint Causes Parsing ErrorYes
73131Large Keys In Indexes Can Cause CorruptionNo
73132IMPORT TABLE Not Parsing Unicode Characters ProperlyNo
73134Deleting Rows with an Active Filter or Range Can Cause #100 "Buffers Corrupt" ErrorNo
73135Using ALTER TABLE to Move Columns that are Referenced in Triggers Can Cause AVNo
73136Altering a Table Several Times and Trying to Drop a Second FK Constraint Causes Error #401No
73139Setting a Range Can Cause an AVNo
73142Altering a Database to Point to a New Empty Path Can Cause Existing Catalog to Be Copied to New PathNo
83144Cannot Rename an Indexed Column without First Dropping IndexNo
83146Large Column Sizes in ORDER BY Can Cause Infinite Loop When Navigating Result SetNo
83147Modifying the Privileges of the Logged-On User Requires Session RestartYes
83148Altering an INTEGER Column as a Generated Column Does Not Change Column ValuesYes
83150Using Expressions with Sensitive Result Sets and Remote Sessions Can Cause Memory Leak on ClientNo
83151TemporaryTables Information Schema Table Not Reflecting CREATE and DROP Statements AccuratelyNo
83152Queries/filters Not Refreshing on Empty Table After Inserting First RowNo
83153CopyOnAppend Not Copying BLOB Column Values CorrectlyNo
83156Mixing Column References From Multiple Tables in a Function Causes Incorrect ResultsNo
83157Query Optimizer Re-Ordering Joins Improperly When Joins Are Already in the Correct OrderNo
93172Creating or Dropping Tables Can Cause #901 Errors in Functions Used in TriggersNo
93173RENAME TABLE Statement Can Cause AV Later During ExecutionNo
93174Query Optimizer May Re-Order Joins in a Way that Invalidates the Query ResultYes
93176Joins On Tables that are also Referenced in the WHERE Clause Can Cause Performance IssuesNo
93177Transaction Timeout Parameter Not Working for Remote SessionsNo
93178Stored Procedures Not Properly Setting RowsAffected Property in .NET EDBCommand ClassNo
93179IN Operator Not Working ProperlyNo
93181Mixing Column References with Aggregate Functions Causes #700 ErrorYes
93182Using a Tab (#9) Character with the IMPORT TABLE Statement Can Cause ErrorYes
93183Computed Columns Not Evaluating ProperlyNo
93184Using IN Operator with Sub-Query Containing Only Aggregate Function Causes ErrorNo
103185Using ALTER TABLE To Change the Encrypted Status or Index Page Size Can Corrupt TableNo
103186Using ALTER TABLE to Add a Primary Key to an Existing Table with No Primary Key Can Cause CorruptionNo
113187CONTAINS Searches Using More than One Wildcard in Search Words Return Incorrect ResultsYes
113188Parameterized Derived Tables Ignoring ParametersNo
113189Cannot DROP a Column Used in a Constraint that is also DROPed in the Same ALTER TABLE StatementNo
113190Constraint Indexes Can be Dropped Using DROP INDEX StatementYes
113191Using ALTER TABLE to Add IDENTITY Column Causes Column to be Populated with 1 ValuesNo
113192#601 Error When Altering a Table and Adding a New Primary KeyNo
113193#601 Error When Altering a Table and Dropping a ColumnNo
113194Using ALTER TABLE to Alter an Indexed Column on a Large Table Can Cause #601 ErrorNo
123195Temporary Tables Created by DLLs Can Conflict with Temporary Tables Created in Main ExecutableYes
123196CONTAINS/NOT CONTAINS with Wildcards Not Respecting Case-Sensitivity of Indexed Column CollationNo
123197ALTER TABLE Adding/Dropping BLOB Columns Can Cause Blob Corruption in Other BLOB ColumnsNo
123198Tables or Derived Tables That Contain 0 Rows Confusing Query Join OptimizerNo
123199NULL Parameters Incorrectly Returning Rows with = OperatorYes
133204Attempting to Execute RENAME TABLE Statement Against Temporary Tables Cause Access Denied ErrorNo
133205Using IMPORT TABLE to Import a Text File Containing Large CLOB Columns Can Cause Memory ExhaustionNo
133206Executing RENAME TABLE on a Newly-Created Table Can Cause File Manager ErrorYes
133207Cannot Define Recursive Functions Directly and Recursive Functions Cause AV When ExecutedNo
133208INNER JOINs Combined with LEFT OUTER JOINs Not Producing Correct ResultsNo
133209Derived Tables with Parameters Not Executing Properly On Second and Subsequent ExecutionsNo
133212Restoring a Database with Different Table Structures Can Cause Rename Error When Adding BLOB ColumnsNo
133213ODBC Driver Returning Incorrect Column Name for SELECT Expression Columns with Correlation NamesNo
133216Row Pointer Not Re-Positioning Correctly After DeletesNo
133217ElevateDB Server Can Deadlock with Frequent Updates to the Configuration or Database CatalogsNo
133218Using LIKE Operator with a Trailing Single-Character Wildcard (_) Causes Incorrect ResultsNo
143220Connect Errors Cause Access Violation on Windows CE/Mobile with Lazarus/FreePascalNo
143221CONTAINS Operator Not Returning Correct Results When Specifying Multiple Search WordsNo
143222FreePascal/Lazarus Alignment Error When Referencing TDateTimeFieldsNo
143223NexusDB Migrator Converting Non-Unique Indexes to Primary KeysNo
143224Trigger NEWROW and OLDROW Values NULL After Execution of DDL StatementsNo
143225Reverse-Engineering Generating Incorrect Schema Update CodeYes
143226Using COMPUTED Columns Causes AV with Remote SessionsNo
143227Disconnecting and Reconnecting a Remote Session with a Filtered Table Can Cause ErrorNo
143228Changing the Global Delphi/C++Builder/FreePascal DecimalSeparator Variable Can Cause ErrorsNo
143229Parameters Not Working Correctly in Correlated Sub-QueriesNo
143230Cached Updates Not Working Properly When Used with Primary Keys Containing IDENTITY ColumnsNo
143240TableAdapter Fill Method Causing NullReferenceException under Visual StudioNo
153232Running Script in the ElevateDB Manage Debugger Can Cause Invalid Request Error with Remote SessionsNo
153234IDENTITY Columns Not Assigning Values When Inserting Rows with Cached Updates OnNo
153236Removal of Dead Sessions with Open Query Result Sets Can Cause AV in ServerNo
153237Cached Updates Duplicating Rows During Application with Remote SessionsNo
153238Remote Stores Incorrectly Working Like Local StoresNo
153242Recursive Functions Can Incorrectly Cause Stack OverflowYes
163241Deleting the Last Row in a Ranged Dataset Can Cause Incorrect Positioning of Row PointerNo
163243Database Catalog Table Structure Checksums Calculating IncorrectlyNo
173244Random AVs Can Occur When Altering Tables in ElevateDB Manager in a Way that Affects DependenciesNo
173245Altering a GENERATED Column Does Not Update the Row/Index Keys ProperlyYes
173246Internal Temporary Tables Being Included in ServerSessionLocks Information Schema TableNo
173247Manual Row Locks Can Cause AV During Dead Session RemovalNo
173248Attempting to Open a Table that References a Missing External Procedure Module Can Cause AVYes
173249Partial Locates Using Certain Collations Causes Incorrect ResultsNo
173253Queries that Return Sensitive Result Sets Not Matching Ascending/Descending ORDER BY ProperlyYes
173254Certain Collations Not Working Correctly with Text IndexingNo
173255Altering VARCHAR/CHAR Columns Involved in a Key Constraint Can Cause #601 ErrorNo
173256OnFilterRecord Not Being Respected with FindKey/LocateYes
173261Manually Copying a File from a Local Store to a Remote Store Using a Remote Session Causes HangNo
173273AV Can Occur When Configuration Updated After External Module LoadedNo
183262ElevateDB Manager Not Picking Up Changes to Procedure/Function ParametersNo
183263Requesting an Execution Plan for UPDATE Statements Can Cause AVYes
183264Script Debugger in ElevateDB Manager Locks Up When Hitting Exception or BreakpointNo
183265Multi-Threading Issue with the DECIMAL/FLOAT Conversion to/from Strings in EDBNo
183266A Failed Lookup Call Causing Subsequent Locate Calls to Improperly FailNo
183267Performing a Locate After an Insert Can Cause Invalid Records to Appear in Attached GridsNo
183268ORDER BY Sorting Not Correct When Only Descending Index Present and RequestSensitive=TrueYes
183269NOT LIKE Operator that Peforms Partial-Length Search Causing AVNo
193274ElevateDB Manager Script Debugger Can Cause Deadlock with Remote SessionsYes
203277Placing a RETURN Statement Inside of a Nested SQL/PSM Block Causes AVYes
203282ALTER INDEX Allowed on System-Generated Constraint IndexesYes
203284Very Large BLOBs Can Take Excessive Amounts of Time to ReadNo
203285Remote Login Can Cause Session Lock Error If User Name and Password Not Specified During ConnectionYes
203287Adding Months to a DATE/TIMESTAMP Across Year Boundaries Causes Index/Range Check ErrorNo
213316Manually Unlocking All Rows After a Previous Row was Manually Locked and Deleted Causes ErrorNo
213317Locates Can Cause Dangling Read LockNo
213318Large Insert Operations Can Cause Unbounded Growth in Index BuffersNo
213319Non-Updateable Views Can Cause AV When RefreshedNo
213320Dropping a Column and Altering a Constraint in Same ALTER TABLE Statement Can Corrupt TablesNo
213321Sessions that Timeout on the Server Can Cause AV When Remote Session ReconnectsNo
223329Exclusively-Opened Tables Can Cause Excessive Memory ConsumptionNo
223330.NET Data Provider Returns Error When Using Table AdaptersNo
223331ElevateDB Manager Raises AV Exception When Opening Any TableNo
223333Trying to Load Updates For a Database with Circular RI Can Cause HangNo

Minor Problems

13069Closing a Database Does Not Cause All Temporary Table .OLD Files To Be DeletedNo
33072Migrating a Paradox Table with Paradox OLE Fields Causes ErrorNo
33073ElevateDB Templates Not Installing Properly Into the RAD Studio 2009 IDENo
43087Starting Cached Updates on the Same Base Table Multiple Times Causes ErrorNo
63105Can Delete a Function that is Referenced in a TriggerYes
63108Low Disk Space Not Being Handled GracefullyNo
63114Internal TDataSet InitRecord Method Not Handling Remote Session Connection Errors ProperlyNo
63120Renaming a Procedure Does Not Also Rename the Internal SQL in the Procedures Catalog TableNo
63122Using the Same Parameter Name with Two Different Column Expressions Can Cause Truncation ErrorsYes
63123Delphi 2010 Documentation Missing Section on Tutorial ApplicationNo
73133Certain Filters and Ranges Can Cause Inserted Rows to Be Excluded Improperly from the SetNo
73138Parameters Are Incorrectly Being Allowed in CREATE VIEW StatementsNo
83145ElevateDB Manager Reverse-Engineering Incorrect For Databases without TablesNo
83149Altering a Trigger in the ElevateDB Manager Causes List of Triggers to DisappearYes
83154Double-Clicking on the Tables Node in the ElevateDB Manager Causes Unrelated Table to OpenNo
83155ElevateDB Manager Not Reflecting Disabled/Enabled Triggers ProperlyNo
93171Maximizing and Then Restoring the Main ElevateDB Manager Window Can Cause Properties To DisappearYes
93175ElevateDB Manager Can Raise Exception if an SQL Window is Opened with No Active DatabaseYes
93180ElevateDB Manager Not Showing Constraint DescriptionsNo
133211Trying to Delete a Row that is in the Process of Being Edited Can Cause Table Corruption ErrorNo
133215ServerSessionLocks Table Not Showing Transaction Locks on Un-Opened TablesNo
143219Accessing ElevateDB Manager Preferences Dialog Causes ExceptionNo
153231Dependencies View Not Showing All Dependencies in ElevateDB ManagerNo
153235Parameter Names with Spaces Not Working CorrectlyYes
173250Dependency Support in ElevateDB Manager Causes Major Slowdown with Remote WAN ConnectionNo
173251SQL Execution Plan Hints Showing Incorrectly for Certain ConditionsNo
173252Date/Time Formats for CAST and IMPORT/EXPORT TABLE Not Working Correctly without SeparatorsNo
183260New Warning for Missing Table Files Being Triggered During Database RestoreNo
193275ElevateDB Manager Reverse-Engineering Not Wrapping Large Binary Literals ProperlyNo
193276DBISAM Migrators Not Converting Hexadecimal Integer Values ProperlyNo
203278ElevateDB Manager Table Dialog Not Showing DECIMAL Column Scale Values Properly after Column AlteredNo
203279Column SQL in ElevateDB Manager Generated with DECIMAL Precision of 20 Instead of 19No
203280Column Name Case Not Consistent in ElevateDB Manager Treeview and SQL View after Column AlterationNo
203281Column Properties Do Not Update After Answering No to Table Dialog Prompt in ElevateDB ManagerNo
203283CASTing a BLOB to a VARCHAR Causes First 3 Characters to Be TruncatedYes
203286Double-Clicking on Procedure/Function Dependency in ElevateDB Manager Causes AVNo
213322Freeing a TDataSet Descendant Without Closing Can Cause Dangling Row LocksYes
223332Opening the Same Database Name in Two Different Sessions in ElevateDB Manager Can Cause ErrorNo