Re: smallest/largest UUIDs for LexicalUUIDType

2013-06-07 Thread John R. Frank
Follow-up question: it seems that range queries on the *second* field of a CompositeType(UUIDType(), UUIDType()) do not work. If I concatenate the two UUID.hex values into a 32-character string instead of a CompositeType of two UUIDs, then range queries work correctly. This is illustrated b

Re: smallest/largest UUIDs for LexicalUUIDType

2013-06-06 Thread John R. Frank
I'll note that if you have the choice, you can use UUIDType rather than LexicalUUIDType. UUIDType fixes that behavior and use a proper lexical comparison for non-type-1 uuids (the other behavior of UUIDType is that for type 1 uuid, it compares them by time first, i.e. it is equivalent to TimeUU

Re: smallest/largest UUIDs for LexicalUUIDType

2013-06-06 Thread Sylvain Lebresne
> 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 simpl