db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lukas Eder (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5451) Allow for casting numeric types to BOOLEAN
Date Sun, 09 Oct 2011 10:40:31 GMT
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

According to the casting matrix:


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:


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