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.

BIN_TO_UUID

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