TIL: Number column stores using float, even for ints

I was trying to store a 63-bit pseudorandom integer in a Number column, as a unique ID. It didn’t seem to work. Every number came out even, when at least 50% (on average) should have been odd.

It started to work, though, when I reduced it from 63 bits to 52. Then I remembered, floating-point numbers have about that many significant mantissa bits…