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. +------+
  7. mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(1))) cnt;
  8. +------+
  9. | cnt |
  10. +------+
  11. | 1 |
  12. +------+

keyword

  1. BITMAP_OR,BITMAP