Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Fri, 28 Sep 2012 15:09:07 +1100 (NCT)
From: "Mamta A. Satoor (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <633916115.137526.1348805347593.JavaMail.jiratomcat@arcas>
In-Reply-To: 
 <593405207.12552.1318156831012.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Updated] (DERBY-5451) Allow for casting numeric types to
 BOOLEAN
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DERBY-5451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mamta A. Satoor updated DERBY-5451:
-----------------------------------

    Labels: cast conversion derby_triage10_10 sql syntax type typesystem  (was: cast conversion sql syntax type typesystem)
    
> 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, derby_triage10_10, 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
For more information on JIRA, see: http://www.atlassian.com/software/jira