db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: ERROR 42X89: Types 'INTEGER' and 'CHAR' are not type compatible. Neither type is assignable to the other type.
Date Thu, 27 Jul 2006 20:19:34 GMT
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.


Mime
View raw message