[
https://issues.apache.org/jira/browse/DERBY-5451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13128191#comment-13128191
]
Lukas Eder commented on DERBY-5451:
-----------------------------------
Also, most RDBMS also allow for treating '1' and '0' as booleans when casting:
CAST('1' as boolean) = CAST('true' as boolean)
CAST('0' as boolean) = CAST('false' as boolean)
Some databases go even further, e.g. Postgres:
CAST('y' as boolean) = CAST('true' as boolean)
CAST('yes' as boolean) = CAST('true' as boolean)
CAST('on' as boolean) = CAST('true' as boolean)
etc. See the documentation here:
http://www.postgresql.org/docs/9.0/static/datatype-boolean.html
None of these values are currently supported in Derby
> 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, 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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
