Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

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

BIN_TO_UUID

On this page

Syntax

Arguments

Return Type

Remarks

Examples

Was this article helpful?

On this page

Was this article helpful?