[jira] Closed: (DERBY-1161) SQL State 42X89 should be SQL State 22005

["David Van Couvering (JIRA)" <de...@db.apache.org>]

     [ 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:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira