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