Important

Self-managed SingleStore will soon transition from version 9.1 RC to version 10. This new semantic versioning scheme will provide SingleStore with finer control over engine and feature releases that were not possible with the current versioning scheme.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10 prior to its general availability. Ahead of this transition, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 10.

UUID_TO_BIN

Syntax

SQL

UUID_TO_BIN(string_uuid, swap_time)

Arguments

string_uuid: A string UUID value.

swap_time: A flag value that can be 0 or 1.

Return Type

VARBINARY(16)

Remarks

If the argument is an invalid UUID value, it returns SQL NULL.
UUID_TO_BIN can take one or two arguments.
- If swap_time is 0, UUID_TO_BIN is a one-argument function that returns the binary format in the same order as the string value.
- If swap_time is 1, UUID_TO_BIN is a two-argument function that returns the binary format in different order as the string value. It swaps the time-low(first) and time-high(third) groups of hexadecimal characters.

Examples

Converts the UUID in binary format and returns the binary format in hexadecimal format.

SQL

SELECT HEX(UUID_TO_BIN('d93f9a83-e032-4e25-80a6-d67235e68399'))
AS result;

+----------------------------------+
| result                           |
+----------------------------------+
| D93F9A83E0324E2580A6D67235E68399 |
+----------------------------------+

Converts the UUID to binary format and returns it in hexadecimal format after swapping the time part.

SQL

SELECT HEX(UUID_TO_BIN('d93f9a83-e032-4e25-80a6-d67235e68399', 1))
AS result;

+-----------------------------------+
| result                            |
+-----------------------------------+
| 4E25E032D93F9A8380A6D67235E683999 |
+-----------------------------------+