[ 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
