Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of francois.orsini@gmail.com
 designates 64.233.184.199 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=Nazeea5RaoI8t61Vf1AZt6uy/GGzvuIQLNGYWc2N78VKw5J4Wsy7b35p5UE57EHFEbs1yRYKni5lSgwl5HdB4CCczB+7xJXR4Hg+u4GiiB+f0AEZULBrsRRkbtxzkZK7no/503aFn6Gy5VOltRiUVwXfpCoQlBhn1WVgU+cnuVI=
Message-ID: <7921d3e405080818287c0b48a8@mail.gmail.com>
Date: Mon, 8 Aug 2005 18:28:17 -0700
From: Francois Orsini <francois.orsini@gmail.com>
To: Derby Development <derby-dev@db.apache.org>
Subject: Re: boolean type
In-Reply-To: <42F8013E.40200@Sourcery.Org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <42F77022.2030201@infologic.fr> <42F7AA66.60903@sun.com>
	 <42F7FABA.6020408@sbcglobal.net>
	 <7921d3e405080817524e92d31b@mail.gmail.com>
	 <42F8013E.40200@Sourcery.Org>

Several RDBMS rely on BIT datatype support when they don't have
intrinsic BOOLEAN support (of course 'bit' allows more than 'boolean',
operator and semantics-wise)- this includes Sybase - as I understand
DB2 UDB does not have support for either BIT or BOOLEAN at this
point...to emulate it in DB2, one would have to use SMALLINT NOT NULL
and have some insert/update trigger to enforce values of 0 or 1
only...

--francois

On 8/8/05, Satheesh Bandaram <satheesh@sourcery.org> wrote:
> I don't think all the support is there... Like using them in expressions
> or JDBC metadata to name some.
>=20
> 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:
>=20
>     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
>=20
> Satheesh
>=20
> Francois Orsini wrote:
>=20
> >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/%3c4=
1C052AB.4050804@debrunners.com%3e
> >>http://mail-archives.apache.org/mod_mbox/db-derby-user/200412.mbox/%3c4=
1C05249.9060500@debrunners.com%3e
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >
> >
>=20
>