db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4704) Incorrect nullability when casting non-nullable VARCHAR to BOOLEAN
Date Fri, 18 Jun 2010 09:15:24 GMT

     [ 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.


Mime
View raw message