bitmap_and_not

Description

Syntax:

BITMAP BITMAP_AND_NOT(BITMAP lhs, BITMAP rhs)

This function performs AND_NOT operation on two input bitmaps and returns a new bitmap.

Example

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

Keywords

BITMAP_AND_NOT,BITMAP