You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Version 2.5.0 changed the whereIn() implementation for composite keys from
using OR/WHERE clauses to tuple syntax. This breaks queries when NULL values
are involved because SQL tuple comparisons don't handle NULL correctly.
Example:
New (2.5.x): (col1, col2, col3) IN ((1, 2, NULL)) → returns 0 rows (broken)
Old (2.4.x): col1 = 1 AND col2 = 2 AND col3 IS NULL → returns correct rows (works)
Affected: All composite key relationships with nullable columns