From owner-freebsd-hubs Mon Sep 10 13:12: 0 2001 Delivered-To: freebsd-hubs@freebsd.org Received: from wall.polstra.com (rtrwan160.accessone.com [206.213.115.74]) by hub.freebsd.org (Postfix) with ESMTP id 86D0B37B409 for ; Mon, 10 Sep 2001 13:11:57 -0700 (PDT) Received: from vashon.polstra.com (vashon.polstra.com [206.213.73.13]) by wall.polstra.com (8.11.3/8.11.3) with ESMTP id f8AKBYg01072; Mon, 10 Sep 2001 13:11:34 -0700 (PDT) (envelope-from jdp@wall.polstra.com) Received: (from jdp@localhost) by vashon.polstra.com (8.11.6/8.11.0) id f8AKBWJ51615; Mon, 10 Sep 2001 13:11:32 -0700 (PDT) (envelope-from jdp) Date: Mon, 10 Sep 2001 13:11:32 -0700 (PDT) Message-Id: <200109102011.f8AKBWJ51615@vashon.polstra.com> To: hubs@freebsd.org From: John Polstra Cc: roam@ringlet.net Subject: Re: CVSup upgrade to fix the timestamp bug In-Reply-To: <20010910112417.C2053@ringworld.oblivion.bg> References: <20010909123920.G45219-100000@oahu.WURLDLINK.NET> <200109092255.f89Mtws48647@vashon.polstra.com> <20010909175836.M30764@curie.physics.purdue.edu> <20010910112417.C2053@ringworld.oblivion.bg> Organization: Polstra & Co., Seattle, WA Sender: owner-freebsd-hubs@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org In article <20010910112417.C2053@ringworld.oblivion.bg>, Peter Pentchev wrote: > Well, there was a Bugtraq post today about a S1G bug in MySQL > (and quite possibly other SQL servers as well) and keeping Unix > timestamps in (var)?char fields :) (not that I really understand why > anyone would want to keep a Unix timestamp in a character field..) What's frustrating about the CVSup bug is that it was only "accidentally" an S1G bug. The broken code didn't deal with specifically with dates or timestamps or anything like that. It was a simple text scanning routine, and the bug was a typo in which I typed the name of one variable when I meant to type the name of a different variable. By "luck" (bad luck, that is) this happened to cause no problems until the decimal representation of the date gained a digit. John -- John Polstra jdp@polstra.com John D. Polstra & Co., Inc. Seattle, Washington USA "Disappointment is a good sign of basic intelligence." -- Chögyam Trungpa To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hubs" in the body of the message