[
https://issues.apache.org/jira/browse/DERBY-5451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mamta A. Satoor updated DERBY-5451:
-----------------------------------
Labels: cast conversion derby_triage10_10 sql syntax type typesystem (was:
cast conversion sql syntax type typesystem)
> Allow for casting numeric types to BOOLEAN
> ------------------------------------------
>
> Key: DERBY-5451
> URL: https://issues.apache.org/jira/browse/DERBY-5451
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 10.8.1.2
> Reporter: Lukas Eder
> Priority: Minor
> Labels: cast, conversion, derby_triage10_10, sql, syntax, type,
> typesystem
>
> According to the casting matrix:
> http://db.apache.org/derby/docs/10.8/ref/rrefsqlj33562.html
> it is currently not possible to write CAST(1 as BOOLEAN). At the same time,
> casting CHAR and VARCHAR as BOOLEAN is possible, e.g. CAST('1' as BOOLEAN),
> or CAST(CAST(1 as CHAR(1)) as BOOLEAN). This was recently implemented:
> https://issues.apache.org/jira/browse/DERBY-4658
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
