Subject: | SQLA -value arguments degraded on search |
SQLA supports binding array literals via the -value "operator". This works as you would expect in DBIC:
my $search_on_array = $rs->search({ array_col => { '@>' => { -value => [ 1,2,3 ] } } })
However, if you then chain another search off of that:
my $degraded = $search_on_array->search({ id => 9001 })
Then the -value gets degraded into a normal arrayref, and is made into an OR of the array values, which is not what's expected (and breaks horribly on array operators).