Skip to main content

IS_NOT_EMPTY_UUID

Checks whether an UUID is not empty.

Syntax​

IS_NOT_EMPTY_UUID( <uuid> )

Arguments​

ArgumentsDescription
<uuid>A UUID string.

Return Type​

If x is not empty, IS_NOT_EMPTY_UUID() returns 1, otherwise it returns 0.

Examples​

SELECT is_not_empty_uuid(gen_random_uuid());
+--------------------------------------+
| is_not_empty_uuid(gen_random_uuid()) |
+--------------------------------------+
|                                    1 |
+--------------------------------------+

SELECT is_not_empty_uuid(gen_zero_uuid());
+------------------------------------+
| is_not_empty_uuid(gen_zero_uuid()) |
+------------------------------------+
|                                  0 |
+------------------------------------+