Description
Reporting for Christian d'Heureuse, filed on derby-dev list.
The NULLIF built-in function of Cloudscape 10.0.1.0 beta seems to accept
only string values.
Examples:
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.)"
Attachments
Attachments
Issue Links
- relates to
-
DERBY-1967 UNION (ALL) contraint violation problem
-
- Closed
-