Skip to main content
Skip to main content

bitmap_to_array

bitmap_to_array

description

Syntax

ARRAY_BIGINT bitmap_to_array(BITMAP input)

Convert a input BITMAP to Array. If input is null, return null.

example

mysql> select bitmap_to_array(null);
+------------------------+
| bitmap_to_array(NULL) |
+------------------------+
| NULL |
+------------------------+

mysql> select bitmap_to_array(bitmap_empty());
+---------------------------------+
| bitmap_to_array(bitmap_empty()) |
+---------------------------------+
| [] |
+---------------------------------+

mysql> select bitmap_to_array(to_bitmap(1));
+-------------------------------+
| bitmap_to_array(to_bitmap(1)) |
+-------------------------------+
| [1] |
+-------------------------------+

mysql> select bitmap_to_array(bitmap_from_string('1,2,3,4,5'));
+--------------------------------------------------+
| bitmap_to_array(bitmap_from_string('1,2,3,4,5')) |
+--------------------------------------------------+
| [1, 2, 3, 4, 5] |
+--------------------------------------------------

keywords

BITMAP_TO_ARRAY,BITMAP