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: 10.8.1.2
            Reporter: Lukas Eder
            Priority: Minor


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

        

Mime
View raw message