Through the Freedom of Information Act we are able to obtain database dumps from the Washington State BioTrack database. Here’s a small anomaly we’ve noticed on this one. Keep in mind, this is a system that is supposed to guarantee unique identifiers for all plants and inventory and provide robust tracking. select id from inventory group by id having count(id) > 1;<br /> 0214523902408153<br /> Everyone knows that quality database systems don’t enforce unique indexes on their system.

Categories: Technology