Bit rot inside container_info table

This is related to https://bugs.launchpad.net/swift/+bug/1823785 where I originally reported it

sqlite will happily store whatever you tell it to store, so declaring datatypes is more of a hint to developers than anything else:

  $ sqlite3 test.db
  SQLite version 3.26.0 2018-12-01 12:34:55
  Enter ".help" for usage hints.
  sqlite> create table t(some_int int, some_date datetime);
  sqlite> insert into t (some_int, some_date) values ('foo', 'bar');
  sqlite> select * from t;
  foo|bar
  sqlite> .schema t
  CREATE TABLE t(some_int int, some_date datetime);

Even so, floating point representations can be problematic when it comes to round-tripping:

  >>> 99999999999.99999
  99999999999.99998

(Though admittedly that's an order of magnitude outside of the range at which we designed swift to work.)

I take it this means you've been seeing more instances of corruption since that initial report? If so, does it seem to be tied to the same disks? That is, is there any overlap in the set of disks that were responsible for the corrupted container back in April and those responsible for this one now? Hmm...

This is from an issue going back to May which could be related to the April issue but at this point I don't know if it is actively happening until we would do an audit which at this point is not planned due to the vast size of our installation.

Thanks for the sqlite test, that would mean we would have to look for improvements inside the code to not replicate corrupt databases etc so I will close this issue here and we can look at LP1823785