bitmap_to_array

description

Syntax

ARRAY_BIGINT bitmap_to_array(BITMAP input)

将一个bitmap转化成一个array 数组。 输入是null的话会返回null。

example

1. mysql> select bitmap_to_array(null);
2. +------------------------+
3. | bitmap_to_array(NULL)  |
4. +------------------------+
5. | NULL                   |
6. +------------------------+

8. mysql> select bitmap_to_array(bitmap_empty());
9. +---------------------------------+
10. | bitmap_to_array(bitmap_empty()) |
11. +---------------------------------+
12. | []                              |
13. +---------------------------------+

15. mysql> select bitmap_to_array(to_bitmap(1));
16. +-------------------------------+
17. | bitmap_to_array(to_bitmap(1)) |
18. +-------------------------------+
19. | [1]                           |
20. +-------------------------------+

22. mysql> select bitmap_to_array(bitmap_from_string('1,2,3,4,5'));
23. +--------------------------------------------------+
24. | bitmap_to_array(bitmap_from_string('1,2,3,4,5')) |
25. +--------------------------------------------------+
26. | [1, 2, 3, 4, 5]                                  |
27. +--------------------------------------------------

keywords

1. BITMAP_TO_ARRAY,BITMAP