bitmap_has_all

description

Syntax

B00LEAN BITMAP_HAS_ALL(BITMAP lhs, BITMAP rhs)

Returns true if the first bitmap contains all the elements of the second bitmap. Returns true if the second bitmap contains an empty element.

example

1. mysql> select bitmap_has_all(bitmap_from_string("0, 1, 2"), bitmap_from_string("1, 2")) cnt;
2. +------+
3. | cnt  |
4. +------+
5. |    1 |
6. +------+

8. mysql> select bitmap_has_all(bitmap_empty(), bitmap_from_string("1, 2")) cnt;
9. +------+
10. | cnt  |
11. +------+
12. |    0 |
13. +------+

keyword

1. BITMAP_HAS_ALL,BITMAP