bitmap_or

description

Syntax

BITMAP BITMAP_OR(BITMAP lhs, BITMAP rhs, ...)

计算两个及以上的输入bitmap的并集，返回新的bitmap.

example

  1. mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(2))) cnt;
  2. +------+
  3. | cnt  |
  4. +------+
  5. |    2 |
  6. +------+
  8. mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(1))) cnt;
  9. +------+
  10. | cnt  |
  11. +------+
  12. |    1 |
  13. +------+
  15. MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2)));
  16. +---------------------------------------------------------+
  17. | bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2))) |
  18. +---------------------------------------------------------+
  19. | 1,2                                                     |
  20. +---------------------------------------------------------+
  22. MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2), to_bitmap(10), to_bitmap(0), NULL));
  23. +--------------------------------------------------------------------------------------------+
  24. | bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2), to_bitmap(10), to_bitmap(0), NULL)) |
  25. +--------------------------------------------------------------------------------------------+
  26. | NULL                                                                                       |
  27. +--------------------------------------------------------------------------------------------+
  29. MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2), to_bitmap(10), to_bitmap(0), bitmap_empty()));
  30. +------------------------------------------------------------------------------------------------------+
  31. | bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2), to_bitmap(10), to_bitmap(0), bitmap_empty())) |
  32. +------------------------------------------------------------------------------------------------------+
  33. | 0,1,2,10                                                                                             |
  34. +------------------------------------------------------------------------------------------------------+
  36. MySQL> select bitmap_to_string(bitmap_or(to_bitmap(10), bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5')));
  37. +--------------------------------------------------------------------------------------------------------+
  38. | bitmap_to_string(bitmap_or(to_bitmap(10), bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'))) |
  39. +--------------------------------------------------------------------------------------------------------+
  40. | 1,2,3,4,5,10                                                                                           |
  41. +--------------------------------------------------------------------------------------------------------+

keyword

  1. BITMAP_OR,BITMAP