bitmap_has_all
Description
Syntax:
BOOLEAN BITMAP_HAS_ALL(BITMAP lhs, BITMAP rhs)
If the first bitmap contains all the elements of the second bitmap, this function will return true. If the second bitmap is empty, this function will also return true.
Example
mysql> select bitmap_has_all(bitmap_from_string("0, 1, 2"), bitmap_from_string("1, 2")) cnt;
+------+
| cnt |
+------+
| 1 |
+------+
mysql> select bitmap_has_all(bitmap_empty(), bitmap_from_string("1, 2")) cnt;
+------+
| cnt |
+------+
| 0 |
+------+Keywords
BITMAP_HAS_ALL,BITMAP