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 "Mamta A. Satoor (JIRA)" <ji...@apache.org> on 2012/09/28 06:09:07 UTC
[jira] [Updated] (DERBY-5451) Allow for casting numeric types to
BOOLEAN
[ 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