PTF4 Patch for SQLBase 8.5.00

This file contains information describing any functionality changes, which may be introduced by the code fixes contained in this PTF.

SQLBase 8.5.00 PTF4

The fix for defect 80233 affects SQL query behavior when the query uses columns containing null values. Let us presume a table, "tableA", with a column, "colB". There are eight rows in the table, and in three of the rows the value of colB is null, in four rows the value of colB is "P", and in one row the value of colB is "V". Looking at a couple of sample queries:
select * from tableA where colB like null
select * from tableA where colB not like "V%"
Prior to SQLBase 8.5 PTF4, the result set for the first query would contain three rows - the three with nulls in colB. The result set for the second query would contain seven rows - the three nulls, plus the four rows with "P". However, this is inconsistent with general SQL standards, which state that a null should not be considered a match in any comparison expression (except for the IS NULL clause). Therefore, in SQLBase 8.5 PTF4 and after, the first query will return zero rows, and the second query will return four rows.

SQLBase 8.5.00 PTF3

SQLBase 8.5.00 PTF2

There is no additional functionality added in this PTF.

SQLBase 8.5.00 PTF1

There is no additional functionality added in this PTF.

Copyright © Gupta Technologies LLC. GUPTA, the GUPTA logo, Centura, and all GUPTA products are licensed or registered trademarks of Gupta Technologies, LLC., All other products are trademarks or registered trademarks of their respective owners. Copyright © 2001-2005 Gupta Technologies