db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Van Couvering (JIRA)" <derby-...@db.apache.org>
Subject [jira] Closed: (DERBY-1161) SQL State 42X89 should be SQL State 22005
Date Tue, 28 Mar 2006 23:30:22 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1161?page=all ]
David Van Couvering closed DERBY-1161:

    Resolution: Invalid

Per Dan's comment, this is not a bug, it has to do with type incompatibility, not data incompatibility.

> SQL State 42X89 should be SQL State 22005
> -----------------------------------------
>          Key: DERBY-1161
>          URL: http://issues.apache.org/jira/browse/DERBY-1161
>      Project: Derby
>         Type: Bug
>   Components: Services
>     Reporter: David Van Couvering
>     Priority: Minor

> The message for 42X89 is Types ''{0}'' and ''{1}'' are not type compatible. Neither type
is assignable to the other type. The SQL spec has a standard SQL State 22005 which means "data
exception - error in assignment".  It would appear this is exactly what is happening here.
> NOTE: This bug can not be fixed in a minor release, as it would change an existing SQL
State, which is a public, stable interface and can not change across minor releases.  The
earliest this can be fixed is 11.0

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message