Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1615294.76201276852524603.JavaMail.jira@thor>
Date: Fri, 18 Jun 2010 05:15:24 -0400 (EDT)
From: "Knut Anders Hatlen (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-4704) Incorrect nullability when casting
 non-nullable VARCHAR to BOOLEAN
In-Reply-To: <20206798.76131276851941352.JavaMail.jira@thor>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Knut Anders Hatlen updated DERBY-4704:
--------------------------------------

    Bug behavior facts: [Wrong query result]

Marking as "Wrong query result" since the client driver returns the wrong value for unknown (false instead of null) because of this. It also raises an error, but that's not until after it has returned the wrong value.

ij> SELECT X, CAST(X AS BOOLEAN) FROM T;
X         |2    
----------------
true      |true 
false     |false
unknown   |false
JAVA ERROR: java.lang.ArrayIndexOutOfBoundsException: 123

> Incorrect nullability when casting non-nullable VARCHAR to BOOLEAN
> ------------------------------------------------------------------
>
>                 Key: DERBY-4704
>                 URL: https://issues.apache.org/jira/browse/DERBY-4704
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.7.0.0
>            Reporter: Knut Anders Hatlen
>
> With the following table definition and query
> CREATE TABLE T (X VARCHAR(10) NOT NULL);
> INSERT INTO T VALUES 'true', 'false', 'unknown';
> SELECT CAST(X AS BOOLEAN) FROM T;
> the meta-data for the returned result will say that the column is not nullable, although it will contain a NULL value in the third row.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.