bitmap_from_array

description

Syntax

BITMAP BITMAP_FROM_ARRAY(ARRAY input)

Convert a TINYINT/SMALLINT/INT/BIGINT array to a BITMAP When the input field is illegal, the result returns NULL

example

1. mysql> select *, bitmap_to_string(bitmap_from_array(c_array)) from array_test;
2. +------+-----------------------+------------------------------------------------+
3. | id   | c_array               | bitmap_to_string(bitmap_from_array(`c_array`)) |
4. +------+-----------------------+------------------------------------------------+
5. |    1 | [NULL]                | NULL                                           |
6. |    2 | [1, 2, 3, NULL]       | NULL                                           |
7. |    2 | [1, 2, 3, -10]        | NULL                                           |
8. |    3 | [1, 2, 3, 4, 5, 6, 7] | 1,2,3,4,5,6,7                                  |
9. |    4 | [100, 200, 300, 300]  | 100,200,300                                    |
10. +------+-----------------------+------------------------------------------------+
11. 5 rows in set (0.02 sec)

keywords

1. BITMAP_FROM_ARRAY,BITMAP