[ http://issues.apache.org/jira/browse/DERBY-7?page=comments#action_12377889 ]
Myrna van Lunteren commented on DERBY-7: ---------------------------------------- Oops, at least one line in my previous comment is suffering from bad editing...I meant: "Can you please rework this section of resultset.java to use an encoding-safe mechanism? " > Bug in NULLIF Function > ---------------------- > > Key: DERBY-7 > URL: http://issues.apache.org/jira/browse/DERBY-7 > Project: Derby > Type: Bug > Components: SQL > Versions: 10.0.2.0 > Reporter: Tulika Agrawal > Assignee: Mamta A. Satoor > Priority: Minor > Fix For: 10.2.0.0, 10.1.3.0 > Attachments: Derby-7.txt, Derby7NullIf061005svndiff.txt, derby-nullif.patch, > derby7Nullif080205svndiff.txt > > 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.)" -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
