Wedge

Public area => The Pub => Off-topic => Topic started by: Arantor on October 12th, 2010, 04:19 PM

Title: When you run out of ids...
Post by: Arantor on October 12th, 2010, 04:19 PM

We all know bad stuff happens when you run out of ids in a column. Sometimes it happens in unexpected ways.

Like http://www.theregister.co.uk/2010/10/12/bi_tagging/ for instance. That 2.1 billion limit just happens to be the upper limit on a signed INT column... (32 signed int, caps at 2,147,483,647)

Never let us forget the expected data size in any column!

Title: Re: When you run out of ids...
Post by: Nao on October 12th, 2010, 06:45 PM

:lol:

Title: Re: When you run out of ids...
Post by: live627 on October 12th, 2010, 09:39 PM

So true! So very true!