Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Wed, 23 Nov 2005 10:35:58 -0800
From: Rick Hillegas <Richard.Hillegas@Sun.COM>
Subject: Re: [jira] Commented: (DERBY-499) Expose BOOLEAN datatype to end
 users
In-reply-to: <1360806205.1132769196879.JavaMail.jira@ajax.apache.org>
To: derby-dev@db.apache.org
Message-id: <4384B68E.80102@sun.com>
MIME-version: 1.0
Content-type: text/plain; charset=UTF-8; format=flowed
Content-transfer-encoding: 7BIT
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
References: <1360806205.1132769196879.JavaMail.jira@ajax.apache.org>

Thanks, Kathey. I will address these issues in the next rev of the spec.

Cheers,
-Rick

Kathey Marsden (JIRA) wrote:

>    [ http://issues.apache.org/jira/browse/DERBY-499?page=comments#action_12358399 ] 
>
>Kathey Marsden commented on DERBY-499:
>--------------------------------------
>
>
>It would be good to document  the value that BOOLEAN true/false will return when returned as SMALLINT to   pre 10.2  drda clients,  and non-Derby clients.  Clarification of getXXX, setXXX and metadata would be good too and is being discussed on this thread.
>http://www.nabble.com/Re%3A-jira-Updated%3A-%28DERBY-499%29-Expose-BOOLEAN-datatype-to-end-users-t593782.html
>
>
>  
>
>>Expose BOOLEAN datatype to end users
>>------------------------------------
>>
>>         Key: DERBY-499
>>         URL: http://issues.apache.org/jira/browse/DERBY-499
>>     Project: Derby
>>        Type: New Feature
>>  Components: SQL
>>    Versions: 10.1.1.0
>>    Reporter: Rick Hillegas
>>    Assignee: Rick Hillegas
>> Attachments: BooleanFS.html
>>
>>Veaceslav Chicu started an email thread on 8 August 2005 titled "boolean type". He was disappointed that Derby doesn't support the ansi BOOLEAN datatype. On closer inspection, Derby does internally support this type but does not expose this support to end users.
>>Derby should let users declare table columns of type BOOLEAN. This should be an indexable datatype.
>>    
>>
>
>  
>