> -----Original Message-----
> From: Paul DuBois [mailto:paul@stripped]
> Sent: Monday, August 27, 2007 5:04 PM
> To: Daevid Vincent; 'MySQL General'
> Subject: Re: BUG: DATE_ADD 99999 fails, but 9999 works.
> At 4:56 PM -0700 8/27/07, Daevid Vincent wrote:
> >using 99999 as the DATE_ADD interval value will result in
> 000-00-00 but
> >one less 9 will work.
> >root# mysql --version
> >mysql Ver 14.12 Distrib 5.0.41, for pc-linux-gnu (i686)
> using EditLine
> >CREATE TABLE `Users` (
> > `CoreID` int(10) unsigned NOT NULL auto_increment,
> > `Username` varchar(155) default NULL,
> > `Password` varchar(64) default NULL,
> > `password_expire` timestamp NOT NULL default '0000-00-00
> > PRIMARY KEY (`CoreID`)
> >) ENGINE=InnoDB DEFAULT CHARSET=utf8;
> >UPDATE Users SET password_expire =
> DATE_ADD(CURRENT_DATE(),INTERVAL 9999
> >DAY) WHERE CoreID = 1 LIMIT 1;
> >UPDATE Users SET password_expire = DATE_ADD(CURRENT_DATE(),INTERVAL
> >99999 DAY) WHERE CoreID = 1 LIMIT 1;
> >Added as bug:
> >Added as a tip:
> >BTW, it's extremely obnoxious that when I enter in a comment on that
> >page, then choose "bug" from the select box, it throws me to another
> >page that says, "Sorry, but this is not the correct place to report
> >bugs. You need to report bugs using our online bug reporting
> system. You
> >can start filling out a bug report with the text you have already
> >entered by clicking the following button:" ... Well why the
> heck did you
> >let me choose that option then! UGH!
> Why do you consider this extremely obnoxious? Also, I'm curious why
> you tried to use the user comment page to report a bug, given that
> the page says: "If you've found a bug or wish to request a
> feature MySQL
> is missing, please use the bug system. When doing this, please perform
> a search first in order not to report a bug or request a
> feature that's
> already in that system."
> The option is there to let you know that the user comment system
> isn't for reporting bugs *and* to let you know the correct place
> to report them. It's there as extra reinforcement for people who
> ignore or overlook the statement that I mentioned in the preceding
> Paul DuBois, MySQL Documentation Team
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com
Because it's also a "tip" as your form has an option for, so some poor
sucker doesn't spend hours trying to figure out why their passwords are
all expired and nobody can log into their $40,000 appliance and a shit
storm comes down upon their head because some dumb user thought they'd
_try_ to put 99999 in so their password wouldn't expire for 274 years.
Plus I did do a bug search and found nothing for DATE_ADD.
Not everyone peruses the 6 million bugs in your system, trying every
possible keyword... It is more useful to have something listed at the
bottom there (as I did), so someone that was doing a search on that page
for DATE_ADD would then see this _tip_.