bitmap_from_array

description

Syntax

BITMAP BITMAP_FROM_ARRAY(ARRAY input)

Convert a TINYINT/SMALLINT/INT/BIGINT array to a BITMAP When the input field is illegal, the result returns NULL

example

  1. mysql> select *, bitmap_to_string(bitmap_from_array(c_array)) from array_test;
  2. +------+-----------------------+------------------------------------------------+
  3. | id   | c_array               | bitmap_to_string(bitmap_from_array(`c_array`)) |
  4. +------+-----------------------+------------------------------------------------+
  5. |    1 | [NULL]                | NULL                                           |
  6. |    2 | [1, 2, 3, NULL]       | NULL                                           |
  7. |    2 | [1, 2, 3, -10]        | NULL                                           |
  8. |    3 | [1, 2, 3, 4, 5, 6, 7] | 1,2,3,4,5,6,7                                  |
  9. |    4 | [100, 200, 300, 300]  | 100,200,300                                    |
  10. +------+-----------------------+------------------------------------------------+
  11. 5 rows in set (0.02 sec)

keywords

  1. BITMAP_FROM_ARRAY,BITMAP