Icon Incident Reports Addressed in 4.21

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

Serious Problems

12051SQL INSERT Sub-Queries Produce Incorrect Data When Inserting From String to Memo ColumnsNo
12056ODBC Driver Not Retrieving Values from Large String Fields Correctly Using ODBC.NET Data ProviderNo
12061Optimized TEXTSEARCH Queries Returning Incorrect Results When Stop Words IncludedYes
12065ODBC Driver Not Handing Multi-Threading ProperlyNo
22068SQL DELETE Queries Can Produce Incorrect Record CountsNo
32070Using loPartialKey Option with an Optimized TDBISAMTable or TDBISAMQuery Locate Method FailsNo
32073Setting a BeforeDeleteTrigger Causes BLOB Handle Leak When Deleting RecordsNo
42074Change Detection Causing Index Corruption Due to Buffers Not Being Freed ProperlyNo
42075Setting TDBISAMTable.Filtered Property to False Results in a Record Count of 0Yes
52078Using the OnFilterRecord Event Handler Causes Incorrect Record Display in a GridNo
62082Delphi 5 and Delphi 6 Builds Not Built with Delphi 5 Update Pack 1 and Delphi 6 Update Pack 2No
72084SQL CASE Operator Causing Stack Overflow and Access ViolationsNo
72091ODBC Driver Causes "Another User Has Changed the Record" Error with BDE 5.01No
72092Filters Not Respecting Existing Ranges When ExecutingNo
82096Calling TDBISAMTable Refresh Method with OnFilterRecord Event Handler Does Not Filter All RecordsNo
82097BDE Transfer Utility Causes Error When Trying To Pump Data into Remote DatabaseNo
82099ALTER TABLE Not Working When Only LAST AUTOINC Value SpecifiedNo
92098Using a BeforeUpdateTrigger with the TDBISAMEngine Component Causes #9494 ErrorNo
102102OnFilterRecord Evaluated Too Many Times When Range and Expression Filter Set AlsoNo
112106Live Queries with No Order By Can Select the Incorrect Default Index for OrderingNo
11210915002 Uncompress Error Triggered When Leaving Table Open During Server ProcedureNo
112116TOP Clause Mixed with ORDER BY On Expression Column Causes Incorrect ResultsNo
112118Using an IN Expression within a LEFT OUTER JOIN Clause Causes Incorrect ResultsYes
112121Exceptions in the OnBeforeUpdate or OnBeforeDelete Trigger Events Can Cause Invalid ParameterNo
112125ODBC Driver Not Retrieving Data Properly When Used with Adobe Acrobat ADBC and JavascriptNo

Minor Problems

12040Emptying a Table and Then Setting a Filter Causes Incorrect RecordCount When Exclusive=TrueYes
12053Local Sessions Cause Trigger Events to Pass a Trigger Database with a Blank DatabaseName PropertyNo
12054Adding an AND TRUE Expression to a WHERE Clauses Forces Un-Optimized ResultNo
12057SQL IMPORT TABLE Example in Manual Contains Syntax ErrorNo
12058What's This Help Displays in Full Help Window for Utilities Compiled in Delphi 6 or 7No
12059TDBISAMSession.GetRemoteEngineVersion Not Returning Full Version NumberNo
32071DBISAM Design-Time Package Contains Unnecessary DBISAMUT Unit ReferenceNo
32072Total Connected Sessions Being Reported Improperly in Database Server After Removing SessionNo
42076Setting TDBISAMEngine.TableMaxReadLockCount to 0 Can Cause Divide By Zero ErrorsYes
52079Using the SQL STDDEV Aggregate Function with a HAVING Clause Causes Invalid Floating Point ExceptionNo
52080Adding a Descending Index Via TDBISAMTable.AddIndex Method Using Only ixDescending Option IncorrectYes
52081Locates that Use a Case-Sensitive Optimized Filter to Perform Search are Slower than NecessaryNo
72085Executing UNION ALL With Mixed Blob and Character Columns Causes an AVYes
72087OldValue Property Not Populated Correctly in TDBISAMEngine AfterUpdate Trigger EventYes
72088Compiling DBSYS Utility with Packages Results in Incorrect Reference to the .INI FileNo
72089SQL ALTER TABLE IF NOT EXISTS for a Column Still Attempts to Open Table ExclusivelyNo
72090Manual Refers to DBPwdDlg Unit Instead of Correct DBPwDlg UnitNo
72093Trying to Rebuild DBISAM Packages in Delphi 2005 Results In ErrorYes
112107Manual Missing Information that OnQueryProgress Doesn't Fire for Live Query ResultsNo
112108Incorrect Description in the Manual for the TDBISAMSession RemoteParamByName MethodNo
112110Using Boolean Custom Functions in Filters Causes Incorrect Record CountsYes
112111Using a Non-Existent Column in an SQL Query WHERE Clause Does Not Cause an ErrorYes
112112DBSRVR Project Shipped with Build 10 Improperly Includes a Pre-Defined Custom FunctionNo
112114SQL COALESCE Function Not Clearing Out Previous NULL Values from Other RowsNo
112117SQL ALTER TABLE Statement Requires the STOP WORDS Clause When Only Updating the SPACE CHARSYes
112119Using a Function with No Parameters in an SQL Join Causes ErrorNo
112120Need to Add Support for Using Aggregate Expressions in Single-Row Result SetsNo
112123Mixing Float and Integer Columns in Joins Can Cause Incorrect Results in Some CasesYes