Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Sun, 9 Oct 2011 10:40:31 +0000 (UTC)
From: "Lukas Eder (Created) (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: 
 <593405207.12552.1318156831012.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Created] (DERBY-5451) Allow for casting numeric types to
 BOOLEAN
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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