mysql 8 UUID_TO_BIN

[mohamedsharaf]

mysql 8 generate ordered uuid before passing it to be saved

does OrderedTimeCodec.php compatible with this function (do same arrangment)

[kubatek94]

According to https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html#function_uuid-to-bin

The swapping UUID_TO_BIN does is:

If swap_flag is 1, the format of the return value differs: The time-low and time-high parts (the first and third groups of hexadecimal digits, respectively) are swapped. This moves the more rapidly varying part to the right and can improve indexing efficiency if the result is stored in an indexed column.

The order in OrderedTimeCodec is
$optimized = [ $fields['time_hi_and_version'], $fields['time_mid'], $fields['time_low'], $fields['clock_seq_hi_and_reserved'], $fields['clock_seq_low'], $fields['node'], ];
which has the time_hi_and_version and time_low swapped indeed, so it seems to be compatible with MYSQL 8 implementation.