db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: boolean type
Date Tue, 09 Aug 2005 21:18:35 GMT
This looks to me like an edge case. Rather than disable an entire 
datatype, I'd recommend logging bugs on these edge cases. Unless code 
archeology at IBM discloses some serious problem like data corruption, I 
would recommend re-enabling the BOOLEAN datatype.

-Rick

Lance J. Andersen wrote:

> ok, thanks for the clarification Satheesh
>
> -lance
>
> Satheesh Bandaram wrote:
>
>>Hi Lance,
>>
>>I was saying Derby's implementation of JDBC support is not complete
>>for Boolean... For example, it may not be possible to prepare a
>>statement like 'Select * from t where ?' and pass Boolean type
>>parameter. So, I was just saying enabling boolean types is more
>>involved.
>>
>>Satheesh
>>
>>On 8/9/05, Lance J. Andersen <Lance.Andersen@sun.com> wrote:
>>  
>>
>>>Satheesh,  can you provide an example WRT JDBC metadata as I do not see an
>>>issue there.
>>>
>>>more DB info:
>>>
>>>Sybase ASE and IAnywhere do not support boolean,  you can use bit.
>>>Pointbase supports  BOOLEAN
>>>Daffodil   supports BOOLEAN
>>>MySQL 4.1 and beyond supports BOOLEAN as a  TINYINT(1), that is it s a
>>>synonym
>>>
>>>
>>>Derby should have the support  externally visible.
>>>
>>>Regards
>>>Lance
>>>
>>>
>>>Satheesh Bandaram wrote:
>>>I don't think all the support is there... Like using them in expressions
>>>    
>>>
>>or
>>  
>>
>>>JDBC metadata to name some.
>>>    
>>>
>>
>>Dan has a good point in the second link
>>  
>>
>>>provided by Kathey. Here is the
>>>    
>>>
>>current status of BOOLEAN support in other
>>  
>>
>>>DBs, from that message:
>>>    
>>>
>>
>> IBM DB2 UDB 7/8 - not supported
>> Informix -
>>  
>>
>>>BOOLEAN supported
>>>    
>>>
>> MySQL 4.0 - not supported
>> Oracle 9/10 - not supported
>>  
>>
>>>Postgres 7.4 - BOOLEAN supported
>>>    
>>>
>> SQL Server 2000 - not
>>  
>>
>>>supported
>>>    
>>>
>>
>>Satheesh
>>
>>Francois Orsini wrote:
>>
>> 
>>  
>>
>>>Boolean column type is ANSI SQL-99 - if support is already there
>>>and
>>>    
>>>
>>assuming there is no known issues (none in JIRA at least), then it
>>would
>>  
>>
>>>be good to see it back from the grave. Just IMHO.
>>>    
>>>
>>
>>On 8/8/05, Kathey Marsden
>>  
>>
>>><kmarsdenderby@sbcglobal.net> wrote:
>>>    
>>>
>> 
>>
>> 
>>  
>>
>>>Rick Hillegas wrote:
>>>    
>>>
>>
>> 
>>
>> 
>>  
>>
>>>Hi Slavic,
>>>    
>>>
>>
>>Thanks for bringing up this issue. Derby internally supports
>>  
>>
>>>boolean
>>>    
>>>
>>types but does not let users declare boolean typed columns. I
>>  
>>
>>>have
>>>    
>>>
>>logged an enhancment request (499) to track this issue. For the
>>moment,
>>  
>>
>>>you can kludge around this problem by creating columns of type
>>>    
>>>
>>CHAR(1).
>> 
>>
>> 
>>  
>>
>>>Maybe SMALLINT would be a good option for use with getBoolean(). A
>>>    
>>>
>>value of
>>  
>>
>>>1 will return true.
>>>    
>>>
>>
>>Here are two relevant mails on this
>>  
>>
>>>issue:
>>>    
>>>
>>
>>http://mail-archives.apache.org/mod_mbox/db-derby-user/200412.mbox/%3c41C052AB.4050804@debrunners.com%3e
>>http://mail-archives.apache.org/mod_mbox/db-derby-user/200412.mbox/%3c41C05249.9060500@debrunners.com%3e
>>
>>  
>>
>>
>>
>> 
>>
>> 
>>  
>>
>> 
>>
>> 
>>  
>>
>>> 
>>>
>>>    
>>>



Mime
View raw message