MESSAGE
| DATE | 2003-04-01 |
| FROM | Ruben Safir
|
| SUBJECT | Subject: [hangout] Enum Columns
|
From owner-hangout-desteny-at-mrbrklyn.com Tue Apr 1 16:20:59 2003 Received: from www2.mrbrklyn.com (LOCALHOST [127.0.0.1]) by mrbrklyn.com (8.12.3/8.11.2/SuSE Linux 8.11.1-0.5) with ESMTP id h31LKxc1014815 for ; Tue, 1 Apr 2003 16:20:59 -0500 Received: (from mdom-at-localhost) by www2.mrbrklyn.com (8.12.3/8.12.3/Submit) id h31LKxY0014814 for hangout-desteny; Tue, 1 Apr 2003 16:20:59 -0500 X-Authentication-Warning: www2.mrbrklyn.com: mdom set sender to owner-hangout-at-www2.mrbrklyn.com using -f Received: from www2.mrbrklyn.com (LOCALHOST [127.0.0.1]) by mrbrklyn.com (8.12.3/8.11.2/SuSE Linux 8.11.1-0.5) with ESMTP id h31LKMc1014806; Tue, 1 Apr 2003 16:20:22 -0500 Received: (from ruben-at-localhost) by www2.mrbrklyn.com (8.12.3/8.12.3/Submit) id h31LKMek014805; Tue, 1 Apr 2003 16:20:22 -0500 Date: Tue, 1 Apr 2003 16:20:22 -0500 From: Ruben Safir To: hangout-at-nylxs.com Cc: MySQL Subject: [hangout] Enum Columns Message-ID: <20030401212022.GA14732-at-www2.mrbrklyn.com> References: <20030401210459.39190.qmail-at-web41213.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030401210459.39190.qmail-at-web41213.mail.yahoo.com> User-Agent: Mutt/1.3.27i Sender: owner-hangout-at-mrbrklyn.com Precedence: bulk Reply-To: Ruben Safir List: New Yorkers Linux Scene Admin: To unsubscribe send unsubscribename-at-domian.com to hangout-request-at-www2.mrbrklyn.com X-Evolution: 000000dd-0000 X-Keywords: X-UID: 11179 Status: RO Content-Length: 943 Lines: 30
I has a column defined as enum not null (percent,absolute) default value percent (in psuedocode) and I was able to update a record which filled it either with a NULL or an empty string.
How does this happen? the value should be either percent or absolute, or the update should just fail.
Ruben
-- __________________________ Brooklyn Linux Solutions __________________________ DRM is THEFT - We are the STAKEHOLDERS http://fairuse.nylxs.com
http://www.mrbrklyn.com - Consulting http://www.inns.net <-- Happy Clients http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from around the net http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn....
1-718-382-0585 ____________________________ NYLXS: New Yorker Free Software Users Scene Fair Use - because it's either fair use or useless.... NYLXS is a trademark of NYLXS, Inc
|
|