bitmap_to_string

description

Syntax

VARCHAR BITMAP_TO_STRING(BITMAP input)

将一个bitmap转化成一个逗号分隔的字符串，字符串中包含所有设置的BIT位。输入是null的话会返回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