I'm trying to use composite column names to organize 10**8 records. Each record has a unique pair of UUIDs. The first UUID is often repeated, so I want to use column_start and column_finish to find all the records that have a given UUID as the first UUID in the pair.
I thought a simple way to get *all* of the columns would be to use
start = uuid.UUID(int=0) -> 00000000-0000-0000-0000-000000000000
finish = uuid.UUID(int=2**128-1) -> ffffffff-ffff-ffff-ffff-ffffffffffff
But strangely, this fails to find *any* of the columns, and it requires that column_reversed=True -- otherwise it raises an error about range finish not coming after start. If I use ints that are much larger/smaller than these extremes, then reversed is not required!
Can anyone explain why LexicalUUIDType() does not treat these extremal UUIDs like other UUIDs?