encukou/test-1 — Issue #54: ID column gaps throw random lookup off
Author: encukou
Created: 2011-11-03 19:47:01+00:00
State: open
Labels: involved, low-priority

**Reported by [Zhorken](http://bugs.veekun.com/users/8) on 2011/02/09 22:40:39 +0000 · Migrated from [Redmine issue 550](http://bugs.veekun.com/issues/550)**

---

For example, in the `moves` table, regular moves have IDs 1 to 559, and Shadow moves start at 10001. Random lookup sees that there are 577 moves total, though, and picks an ID from 1 to 577—so once in a while, it tries to look up a move that doesn’t exist.

Other tables with this problem: `pokemon` (alternate forms), `types` (??? and Shadow), `items` (667 does not exist because it was a duplicate live caster), `locations` (a handful of IDs are skipped for some reason).

Redmine metadata:
Updated on: 2011/02/10 06:49:08 +0000
Start date: 2011/02/09

---

**Comment by [Eevee](http://bugs.veekun.com/users/1) from 2011/02/09 23:37:50 +0000**

Location ids are skipped because several locations were merged or removed as junk.

---

**Comment by [Zhorken](http://bugs.veekun.com/users/8) from 2011/02/10 06:49:08 +0000**

Project: veekun ⇨ pokedex