Message: A new issue has been created in JIRA.
--------------------------------------------------------------------- View the issue: http://issues.apache.org/jira/browse/DERBY-7 Here is an overview of the issue: --------------------------------------------------------------------- Key: DERBY-7 Summary: Bug in NULLIF Function Type: Bug Status: Unassigned Priority: Minor Project: Derby Components: SQL Versions: 10.0.2.0 Assignee: Reporter: Tulika Agrawal Created: Mon, 27 Sep 2004 5:44 PM Updated: Mon, 27 Sep 2004 5:44 PM 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.)" --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
