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