bitmap_and_not_count

description

Syntax

BITMAP BITMAP_AND_NOT_COUNT(BITMAP lhs, BITMAP rhs)

Calculate the set after lhs minus intersection of two input bitmaps, return the new bitmap size.

example

  1. mysql> select bitmap_and_not_count(bitmap_from_string('1,2,3'),bitmap_from_string('3,4,5')) cnt;
  2. +------+
  3. | cnt  |
  4. +------+
  5. |    2 |
  6. +------+

keyword

  1. BITMAP_AND_NOT_COUNT,BITMAP