bitmap_to_string

description

Syntax

VARCHAR BITMAP_TO_STRING(BITMAP input)

Convert a input BITMAP to a string. The string is a separated string, contains all set bits in Bitmap. If input is null, return null.

example

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

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

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

22. mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2)));
23. +---------------------------------------------------------+
24. | bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2))) |
25. +---------------------------------------------------------+
26. |  1,2                                                    |
27. +---------------------------------------------------------+

keyword

1. BITMAP_TO_STRING,BITMAP