Icon Incident Reports Addressed in 3.27

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

Serious Problems

11422SQL SELECT HAVING Clause Not Finding Having Expressions in Source Columns ProperlyYes
11431SQL CREATE and ALTER TABLE Statements Not Allowing Double-Quotes for Default, Min, or Max ValuesYes
11449Setting BLOB Columns to NULL Values in SQL UPDATE Statements Does Not Delete Blob DataYes
11450Executing a SELECT Statement with a False Constant Condition in the WHERE Clause Produces RecordsYes
11451Using CopyOnAppend with BLOB Fields Can Result in Invalid BLOB Handle Errors When PostingNo
11453Mixing Different Source Table Conditions in SQL SELECT WHERE Clause Causes Incorrect ResultsNo
11454SQL JOIN Conditions that Rely on Cartesian Products Confuse Query JOIN OptimizationYes
11455Using the DBISAMCT Unit in an Application Causes the Project Icon to Be ReplacedYes
11456SQL SELECT Performance Slower Than Necessary with Multiple Indexed AND Conditions in WHERE ClauseYes
11457ODBC Driver Not Returning Catalog Tables Correctly Under ODBC V3 ApplicationsNo

Minor Problems

11452DBSYS Table Browsing Window Shows the Password for Encrypted Tables without AsterisksNo