db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeremy Boynes (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-113) Comparison does not perform implicit type conversion
Date Tue, 18 Jan 2005 07:33:17 GMT
     [ http://issues.apache.org/jira/browse/DERBY-113?page=comments#action_57704 ]
     
Jeremy Boynes commented on DERBY-113:
-------------------------------------

Digging deeper, the specification does not imply any form of automatic promotion. Given that,
I don't think this is a really bug so Derby is correct in reporting this as an error.

> 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


Mime
View raw message