List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:August 28 2007 12:30am
Subject:RE: BUG: DATE_ADD 99999 fails, but 9999 works.
View as plain text  
 

> -----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
> >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_.

Thread
BUG: DATE_ADD 99999 fails, but 9999 works.Daevid Vincent28 Aug
  • Re: BUG: DATE_ADD 99999 fails, but 9999 works.Paul DuBois28 Aug
    • RE: BUG: DATE_ADD 99999 fails, but 9999 works.Daevid Vincent28 Aug
  • Re: BUG: DATE_ADD 99999 fails, but 9999 works.Chris28 Aug
    • RE: BUG: DATE_ADD 99999 fails, but 9999 works.Daevid Vincent28 Aug
      • Re: BUG: DATE_ADD 99999 fails, but 9999 works.Kirk Friggstad28 Aug
      • RE: BUG: DATE_ADD 99999 fails, but 9999 works.Daevid Vincent31 Aug
    • Re: BUG: DATE_ADD 99999 fails, but 9999 works.Paul DuBois28 Aug