Who's using int(10)? DBMail has been using bigint(21) since forever. Call me when you have more than 2 billion messages in one mailbox and we'll work on updating IMAP to handle 64 bit message sequence numbers ;-)
Aaron On Tue, Dec 19, 2006, Jorge Bastos <[EMAIL PROTECTED]> said: > Yes, i mean when that limit is reached > for an int(10) > 9999999999 > > it goes BUM ? :P > > ----- Original Message ----- > From: "Dmitri" <[EMAIL PROTECTED]> > To: "DBMail mailinglist" <[email protected]> > Sent: Tuesday, December 19, 2006 11:34 PM > Subject: Re: [Dbmail] Max messages questions > > >> Jorge Bastos wrote: >> >>> Hi, >>> >>> My question may be dumb so prepare :-) >>> >>> X-DBMail-PhysMessage-ID: 375180 >>> >>> This in the email's header is the message number in the table, the >>> autoincrement i think, imagine that this value has reached the limit >>> on the table, that is suposed to happen? (this, for my case i think >>> wouln't be reached for the next 5 years). >>> I'm just curious about it. >>> >>> Jorge >>> >>>------------------------------------------------------------------------ >>> >>>_______________________________________________ >>>DBmail mailing list >>>[email protected] >>>https://mailman.fastxs.nl/mailman/listinfo/dbmail >>> >>> >> There is a limit for auto increment counter? >> I thought the limit was determined by the size of the int(), so int(10) >> would be a highest 10-digits number. >> >> _______________________________________________ >> DBmail mailing list >> [email protected] >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
