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


Mime
View raw message