4 ms·
The entire argument is DOUBLE instead of INT http://blackboxvoting.org/fraction-magic-3/ http://blackboxvoting.org/fraction-magic-3/ within some Access database
by huac 10y ago
The entire argument is DOUBLE instead of INT http://blackboxvoting.org/fraction-magic-3/ http://blackboxvoting.org/fraction-magic-3/ within some Access database.
- throwanem 10y agoAccess has a signed 32-bit long integer type, so it is odd to see a double used here. Still a hell of a lot of stew from one oyster.
- grzm 10y agoI'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.