Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 78916 invoked from network); 14 Nov 2005 22:34:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 14 Nov 2005 22:34:03 -0000 Received: (qmail 72231 invoked by uid 500); 14 Nov 2005 22:33:57 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 72191 invoked by uid 500); 14 Nov 2005 22:33:57 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 72178 invoked by uid 99); 14 Nov 2005 22:33:57 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Nov 2005 14:33:57 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [32.97.182.141] (HELO e1.ny.us.ibm.com) (32.97.182.141) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Nov 2005 14:33:48 -0800 Received: from d01relay02.pok.ibm.com (d01relay02.pok.ibm.com [9.56.227.234]) by e1.ny.us.ibm.com (8.12.11/8.12.11) with ESMTP id jAEMXYvi028099 for ; Mon, 14 Nov 2005 17:33:34 -0500 Received: from d01av03.pok.ibm.com (d01av03.pok.ibm.com [9.56.224.217]) by d01relay02.pok.ibm.com (8.12.10/NCO/VERS6.8) with ESMTP id jAEMXY6k110810 for ; Mon, 14 Nov 2005 17:33:34 -0500 Received: from d01av03.pok.ibm.com (loopback [127.0.0.1]) by d01av03.pok.ibm.com (8.12.11/8.13.3) with ESMTP id jAEMXY5K021181 for ; Mon, 14 Nov 2005 17:33:34 -0500 Received: from [127.0.0.1] (sig-9-48-109-231.mts.ibm.com [9.48.109.231]) by d01av03.pok.ibm.com (8.12.11/8.12.11) with ESMTP id jAEMXO6i020860 for ; Mon, 14 Nov 2005 17:33:31 -0500 Message-ID: <437910B1.3000600@debrunners.com> Date: Mon, 14 Nov 2005 14:33:21 -0800 From: Daniel John Debrunner User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: de, en-us, en MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: Re: [jira] Commented: (DERBY-695) Re-enable the TINYINT datatype References: <339690920.1131577505091.JavaMail.jira@ajax.apache.org> <43728B6F.1080300@sun.com> <43728D62.80300@debrunners.com> <437292F3.1070504@sun.com> <4374CC3D.5050007@debrunners.com> <43752683.1060903@sun.com> <43753562.50406@sun.com> <4375547A.4060306@debrunners.com> <4375E4F1.2050403@sun.com> <7921d3e40511121606l567eaf1sf12514a475e2f0ba@mail.gmail.com> <4378E678.9000507@sun.com> <4378F717.2030503@debrunners.com> <43790D06.2070000@sun.com> In-Reply-To: <43790D06.2070000@sun.com> X-Enigmail-Version: 0.90.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Rick Hillegas wrote: > You can also implement NOT NULL as a check contraint. Most databases > consider that to be an inefficiency which it's worth optimizing with > custom logic. "Custom" logic that's defined by the SQL Standard. :-) Dan.