/* Copy this SQL into DBSYS */

DROP TABLE IF EXISTS MEMORY "Temp";

CREATE TABLE MEMORY "Temp"
(
   ANumber INTEGER
);

INSERT INTO MEMORY "Temp" (ANumber) VALUES (1);
INSERT INTO MEMORY "Temp" (ANumber) VALUES (2);
INSERT INTO MEMORY "Temp" (ANumber) VALUES (3);
INSERT INTO MEMORY "Temp" (ANumber) VALUES (4);
INSERT INTO MEMORY "Temp" (ANumber) VALUES (5);
INSERT INTO MEMORY "Temp" (ANumber) VALUES (6);

/*
This works as expected (remove comments to see)...
SELECT *, CAST(NULL AS BOOLEAN) AS NullBoolField FROM MEMORY Temp;
*/

/*
This returns FALSE rather than NULL values...
*/
SELECT *, IF (ANumber>10 THEN true ELSE CAST(NULL AS BOOLEAN)) AS 
NullBoolField FROM MEMORY Temp;