Icon Incident Reports Addressed in 4.19

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

Serious Problems

1651Using a Numeric in SQL BETWEEN that is Greater Than the Range of a SmallInt Causes Incorrect ResultsYes
11994Application of Cached Updates Causing 8708 ErrorNo
12001#9217 Duplicate Key Exceptions Causing #10030 Invalid Blob Handle When Triggers Access BLOB ColumnsNo
12002Using the SQL AVG() Aggregate Function On Word Fields Causes Incorrect ResultsYes
12003Optimized Partial-Length Searches Using the LIKE Operator Not Returning Correct ResultsYes
12005SQL DISTINCT Clause Not Working Properly with BCD FieldsNo

Minor Problems

11998CASE Operator Still Listed As UnSupported SQL in ManualNo
11999Mouse Movements Not Updating Column and Row Indicators in DBSYS SQL WindowYes
12000Un-Optimized TEXTSEARCH() Returning Incorrect Results with NULL Values in BLOB ColumnsYes
12004Using Double Quotes Instead of Single Quotes in Constant Expressions Can Cause AVYes