When you run out of ids...

Arantor

  • As powerful as possible, as complex as necessary.
  • Posts: 14,278
When you run out of ids...
« 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!
When we unite against a common enemy that attacks our ethos, it nurtures group solidarity. Trolls are sensational, yes, but we keep everyone honest. | Game Memorial

Nao

  • Dadman with a boy
  • Posts: 16,079

live627

  • Should five per cent appear too small / Be thankful I don't take it all / 'Cause I'm the taxman, yeah I'm the taxman
  • Posts: 1,670
A confident man keeps quiet.whereas a frightened man keeps talking, hiding his fear.