> -----Original Message----- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > 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 > >wrapper > > > >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 > >00: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: > >http://bugs.mysql.com/bug.php?id=30656 > > > >Added as a tip: > >http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html > > > >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 > paragraph. > > -- > 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_. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]