You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2010/06/18 11:15:24 UTC
[jira] Updated: (DERBY-4704) Incorrect nullability when casting
non-nullable VARCHAR to BOOLEAN
[ 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.