bitmap_and_not_count

Description

Syntax:

BITMAP BITMAP_AND_NOT_COUNT(BITMAP lhs, BITMAP rhs)

This function performs and_not operation on two input bitmaps and returns the size of the new bitmap.

Example

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

Keywords

BITMAP_AND_NOT_COUNT,BITMAP