Named parameters that accepts collections and are used in nullness predicates, fail to bind the value breaking the generated SQL query.
For example
{noformat}from MarketValue where :codes is null{noformat}
Will be translated to
{noformat}select m1_0.id,m1_0.code from market_value m1_0 where{noformat}
If you bind an empty collectino to :codes
The expected translation would be:
{noformat}select m1_0.id,m1_0.code from market_value m1_0 where ? is null{noformat}
Attached is a minimal reproduction project |
|