Expand description
Tests for IN/NOT IN list filters.
On PostgreSQL the engine rewrites expr IN (...) to expr = ANY($1) and
expr NOT IN (...) to expr <> ALL($1), binding the list as a single
array parameter. Other SQL drivers continue to expand the list into one
parameter per item. These tests cover both code paths via a single
Item scenario, with each test exercising a different element type or
list shape.
Assertions on the issued driver op are gated on bind_list_param + predicate_match_any: when both are on (PostgreSQL) a single
Value::List param typed List(elem) is expected; otherwise N scalar
params each typed elem.