Skip to main content

IS_EMPTY_UUID

Checks whether an UUID is empty.

Syntax

IS_EMPTY_UUID( <uuid> )

Arguments

ArgumentsDescription
<uuid>A UUID string.

Return Type

If uuid is empty, IS_EMPTY_UUID() returns 1, otherwise it returns 0.

Examples

SELECT is_empty_uuid(gen_random_uuid());
+----------------------------------+
| is_empty_uuid(gen_random_uuid()) |
+----------------------------------+
| 0 |
+----------------------------------+

SELECT is_empty_uuid(gen_zero_uuid());
+--------------------------------+
| is_empty_uuid(gen_zero_uuid()) |
+--------------------------------+
| 1 |
+--------------------------------+