Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

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, while SingleStore 9.0 is recommended for production workloads.

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 |
+-----------------------------------+