Summary
The in containment operator returns empty results in the vector runtime when searching for complex values recursively. The SAM runtime correctly finds matching records, but the vector runtime produces no output.
Reproduction
echo '{s:"foo"} {s:"foo",t:"bar"} {a:{s:"foo"}} [1,{s:"foo"},2]' | super -z -c 'where {s:"foo"} in this' -
Expected:
{s:"foo"}
{a:{s:"foo"}}
[1,{s:"foo"},2]
Actual (vector): Empty output (no records returned)
Test reference
book/src/super-sql/expressions/containment.md:67
Discovered via make test-heavy which runs documentation examples through the vector runtime.
Summary
The
incontainment operator returns empty results in the vector runtime when searching for complex values recursively. The SAM runtime correctly finds matching records, but the vector runtime produces no output.Reproduction
Expected:
Actual (vector): Empty output (no records returned)
Test reference
book/src/super-sql/expressions/containment.md:67Discovered via
make test-heavywhich runs documentation examples through the vector runtime.