BIN_TO_UUID

Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

Syntax

SQL

BIN_TO_UUID(binary_uuid, swap_time)

Arguments

binary_uuid: A binary UUID value.

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

Return Type

VARCHAR(36)

Remarks

If the argument is an invalid UUID value, it returns SQL NULL.
BIN_TO_UUID can take one or two arguments.
- If swap_time is 0, BIN_TO_UUID is a one-argument function that returns the string format in the same order as the binary value.
- If swap_time is 1, BIN_TO_UUID is a two-argument function that returns the string format in a different order than the binary value. It assumes that the time-part swapping is already done and swaps the time-low (first) and time-high (third) groups back to their original positions.

Examples

Returns the UUID in string format.

SQL

SELECT BIN_TO_UUID(SYS_GUID()) AS string_uuid_value;

+--------------------------------------+
| string_uuid_value                    |
+--------------------------------------+
| c591b267-59a8-4d8c-89de-f16c5951bf31 |
+--------------------------------------+

SYS_GUID() returns a new GUID in every call, the output may differ if called multiple times.

Returns the UUID in string format before and after swapping the time-part.

SQL

SELECT UUID() INTO @uuid;
SELECT @uuid;

+--------------------------------------+
| @uuid                                |
+--------------------------------------+
| 08f2a3da-4561-4880-a528-0ac0bf15c52d |
+--------------------------------------+

SQL

SELECT UUID_TO_BIN(@uuid,0) INTO @binary_uuid;
SELECT UUID_TO_BIN(@uuid,1) INTO @binary_uuid_swap;
SELECT BIN_TO_UUID(@binary_uuid,0) AS result;

+--------------------------------------+
| result                               |
+--------------------------------------+
| 08f2a3da-4561-4880-a528-0ac0bf15c52d |
+--------------------------------------+

SQL

SELECT BIN_TO_UUID(@binary_uuid,1) AS result;

+--------------------------------------+
| result                               |
+--------------------------------------+
| 45614880-a3da-08f2-a528-0ac0bf15c52d |
+--------------------------------------+

SQL

SELECT BIN_TO_UUID(@binary_uuid_swap,0) AS result;

+--------------------------------------+
| result                               |
+--------------------------------------+
| 48804561-08f2-a3da-a528-0ac0bf15c52d |
+--------------------------------------+

SQL

SELECT BIN_TO_UUID(@binary_uuid_swap,1) AS result;

+--------------------------------------+
| result                               |
+--------------------------------------+
| 08f2a3da-4561-4880-a528-0ac0bf15c52d |
+--------------------------------------+