[ http://issues.apache.org/jira/browse/DERBY-1161?page=comments#action_12372164 ]
Daniel John Debrunner commented on DERBY-1161: ---------------------------------------------- Also comment on the NOTE about it not being fixed until 11.0. Derby has not defined any policy on such an issue so it's premature to be putting such "rules" in place. > 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
