db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1161) SQL State 42X89 should be SQL State 22005
Date Tue, 28 Mar 2006 23:15:19 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1161?page=comments#action_12372162 ] 

Daniel John Debrunner commented on DERBY-1161:

In this specific case '22' is a data exception, some exception raised
due to the value of the data. '42' is a compile time error, in this case
raised because the types are not assignable to each other, not because
the specific data values are not assignable to each other.

I'm not sure this bug is valid.

> 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