Correct the implicit casting of other types to BOOLEAN
------------------------------------------------------
Key: DERBY-4684
URL: https://issues.apache.org/jira/browse/DERBY-4684
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.6.1.0
Reporter: Rick Hillegas
Via a UNION query, it is possible to implicitly cast non-BOOLEAN types to
BOOLEAN today. These implicit casts do not obey the SQL Standard rules defined
in part 2, section 6.12 (<cast specification>). Derby should support the
Standard rules.
The following query shows how you can implicitly cast a non-BOOLEAN data type
to BOOLEAN today:
select isindex from sys.sysconglomerates where conglomeratename = 'foo'
union
values ( 1 )
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
