Peterson, John wrote: > Hello, > > It was reported to me that one of the reasons our software currently > doesn't work with Apache Derby is because of ERROR 42X89. One of the > engineering teams reported: "We found that there is a bug in Derby in > its support for the Case statement. There is a workaround but that will > require us to change the SQL generation code to specifically check if > we're connected to Derby and generate a different SQL syntax." After > inquiring after the specifics, I was provided with the following > example: > > ij>values case when 1=2 then 3 else NULL end; > ERROR 42X89: Types 'INTEGER' and 'CHAR' are not type compatible. > Neither type is assignable to the other type. > > Is this indeed a bug (that will be fixed in the future), or is Derby > behaving as it was intended?
I think this is DERBY-7 http://issues.apache.org/jira/browse/DERBY-7 which was fixed in the 10.1.3 release. Dan.
