db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andy Gumbrecht (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-6223) Columns of type 'SMALLINT' cannot hold values of type 'BOOLEAN'
Date Mon, 13 May 2013 12:25:22 GMT
Andy Gumbrecht created DERBY-6223:
-------------------------------------

             Summary: Columns of type 'SMALLINT' cannot hold values of type 'BOOLEAN'
                 Key: DERBY-6223
                 URL: https://issues.apache.org/jira/browse/DERBY-6223
             Project: Derby
          Issue Type: Improvement
          Components: Store
    Affects Versions: 10.10.1.1
         Environment: NA
            Reporter: Andy Gumbrecht
            Priority: Minor
             Fix For: 10.10.1.2


This minor issue is in relation to a bug at Liquibase (https://liquibase.jira.com/browse/CORE-1088)
that occurred due to the addition of the boolean type.

Prior to the boolean type I am assuming that just about everyone would resort to using smallint.Older
databases that may have been machine created based on meta-data are not going to be compatible
with future code that will now assume boolean is the norm.

The improvement I am suggesting is that when smallint columns are fed a boolean value that
'1' is accepted as 'true' and anything else 'false'  (0 would be a good idea), and likewise
for retrieval. Although technically correct, throwing an exception seems to be a touch aggressive
here as smallint is more than capable of storing a bit.

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

Mime
View raw message