You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Shreyas Kaushik (JIRA)" <de...@db.apache.org> on 2005/01/10 13:20:13 UTC
[jira] Commented: (DERBY-113) Comparison does not perform implicit type conversion
[ http://issues.apache.org/jira/browse/DERBY-113?page=comments#action_57461 ]
Shreyas Kaushik commented on DERBY-113:
---------------------------------------
Adding to my question below, what I meant by "more cases" was, cases other than those involving character and numeric ( ineteger, decimal, etc) comparisions where type escalation is needed.
> Comparison does not perform implicit type conversion
> ----------------------------------------------------
>
> Key: DERBY-113
> URL: http://issues.apache.org/jira/browse/DERBY-113
> Project: Derby
> Type: Bug
> Components: SQL
> Reporter: Jeremy Boynes
>
> The operands to a comparision operator are not implictly converted to the dominant type resulting in an unexpected exception:
> For example:
> ij> select * from dual where '1' = 1;
> ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
> fails whereas
> ij> select * from dual where cast('1' as int) = 1;
> DUM&
> ----
> X
> works. The type escalation should be implicit.
--
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
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira