bitmap_and_not_count,bitmap_andnot_count

description

Syntax

BITMAP BITMAP_AND_NOT_COUNT(BITMAP lhs, BITMAP rhs)

将两个bitmap进行与非操作并返回计算返回的大小.

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. +------+

keywords

1. BITMAP_AND_NOT_COUNT,BITMAP_ANDNOT_COUNT,BITMAP