db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lukas Eder (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5451) Allow for casting numeric types to BOOLEAN
Date Sat, 15 Oct 2011 13:55:11 GMT

    [ 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:
>            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


View raw message