MAP_CONTAINS_VALUE
Description
Determines whether a given map
contains a specific value value
Syntax
MAP_CONTAINS_VALUE(<map>, <value>)
Parameters
<map>
MAP
type, the input map content.<value>
supports multiple types, the value to be searched.
Return Value
Determines whether a given map
contains a specific value value
. Returns 1 if exists, 0 if not exists.
Usage Notes
- If parameter
<map>
is NULL, returns NULL. <value>
can be NULL. The comparison for NULL isnull-safe-equal
, which means NULL is considered equal to NULL.
Examples
- Regular parameters
select map_contains_value(map(1, "100", 0.1, 2), 100), map_contains_value(map(1, "100", 0.1, 2), 101);
+------------------------------------------------+------------------------------------------------+
| map_contains_value(map(1, "100", 0.1, 2), 100) | map_contains_value(map(1, "100", 0.1, 2), 101) |
+------------------------------------------------+------------------------------------------------+
| 1 | 0 |
+------------------------------------------------+------------------------------------------------+ - NULL parameters
select map_contains_value(NULL, 100);
+-------------------------------+
| map_contains_value(NULL, 100) |
+-------------------------------+
| NULL |
+-------------------------------+select map_contains_value(map(null, null), null), map_contains_value(map(null, 100), null);
+-------------------------------------------+------------------------------------------+
| map_contains_value(map(null, null), null) | map_contains_value(map(null, 100), null) |
+-------------------------------------------+------------------------------------------+
| 1 | 0 |
+-------------------------------------------+------------------------------------------+