Hi,
did you think about creating a class for UUID field?
This would work in such way, that according to : https://www.percona.com/blog/2014/12/19/store-uuid-optimized-way/
ordered_uuid(uuid) = 58e0a7d7-eebc-11d8-9669-0800200c9a66 => 11d8eebc58e0a7d796690800200c9a66
it would insert value as UNHEX(ordered_uuid(uuid)), and select as SELECT HEX(uuid) as uuid from table
Cheers.
Hi,
did you think about creating a class for UUID field?
This would work in such way, that according to : https://www.percona.com/blog/2014/12/19/store-uuid-optimized-way/
ordered_uuid(uuid) = 58e0a7d7-eebc-11d8-9669-0800200c9a66 => 11d8eebc58e0a7d796690800200c9a66
it would insert value as UNHEX(ordered_uuid(uuid)), and select as SELECT HEX(uuid) as
uuidfrom tableCheers.