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