Icon New Incident Reports for 4.14

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

Serious Problems

11885IN Sub-SELECTs That Reference the Same Table as the Main SQL Query Not Working ProperlyNo
11886SQL RUNSUM Function Not Working Correctly With NULL Values in Column Being SummedYes
11888Delphi 6 and 7 Are Not Correctly Creating GUID Fields When Specified During Table CreationNo
11893Files with Archive Attribute Not Set Being Reported as Non-Existent Under WindowsNo
11896Nested INNER JOINs in LEFT OUTER JOINs Can Cause Incorrect Results If First Row Produces NULLYes
11899Large Tables Causing Integer Overflows in SQL Optimization Cost CalculationsNo
11900LEFT and REPEAT Functions Not Handling Nested Functions ProperlyNo
11902SQL Joins on any Expressions or Columns Whose Data Types Do Not Match Causes Incorrect ResultsNo
11903LASTAUTOINC SQL Function Causes AV When Used in a Sub-SELECT INSERT StatementYes
11904LASTAUTOINC and IDENT_CURRENT SQL Functions Returning Incorrect ResultYes
11906Scheduled Events Configured for Hourly Interval Not Firing Properly in Database ServerNo
11909Triggering the Change Detection within the Same Session Can Cause Index CorruptionNo

Minor Problems

11894SQL TOP Clause Not Working Properly with Sub-SELECTsNo
11895Joins on Query Result Sets are Slower than NecessaryYes
11897Maximum Connections Setting in Database Server Off by 1 When Enforcing RestrictionYes
11898Triggers Resetting the TDBISAMSession.OnPassword Event HandlerYes
11901Manual Examples for FindKey, FindNearest, GotoKey, and GotoNearest IncorrectYes
11905UNION Operator Sometimes Causes IDE Duplicate Key ExceptionNo
11907Filters with the Asterisk (*) Wildcard as the Only String Constant Return No RecordsYes