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] Created: (DERBY-4704) Incorrect nullability when casting non-nullable VARCHAR to BOOLEAN
Date Fri, 18 Jun 2010 09:05:41 GMT
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