3 ms·
I've seen all kinds of data type mismatches in databases. Unfortunately, I don't find this all that surprising.
by grzm 10y ago
I've seen all kinds of data type mismatches in databases. Unfortunately, I don't find this all that surprising.
- int_19h 10y ago"Harris found the “DOUBLE” setting in all GEMS databases from all states for version 1.18 forward. Looking at older GEMS databases, version 1.17 and before, votes were instead configured as whole numbers (LONG INTEGER)." On top of that, they claim that there's also specific functionality to deal with rounding in the output results - why would anyone do it if they honestly thought that votes are always integer. In fact, they even present an email discussing the implementation of this, so it wasn't exactly under the radar.