db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christian d'Heureuse" <c...@inventec.ch>
Subject Bug in NULLIF Function
Date Thu, 26 Aug 2004 22:00:00 GMT
The NULLIF built-in function of Cloudscape beta seems to accept
only string values.


 values nullif('a','b');
 --> OK

 values nullif(1,2);
 --> Error message: "ERROR 42X89: Types 'CHAR' and
     'INTEGER' are not type compatible. (Neither type
     is assignable to the other type.)"


View raw message