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
Is your feature request related to a problem? Please describe.
Currently an empty whereIn clause will render as empty list which results in a MySQL error.
Describe the solution you'd like
An empty whereIn clause should render as 1 = 2 or some other false statement in order to replicate the expected behavior of WHERE x IN ()
Describe alternatives you've considered
Excluding the statement is another option but that's dangerous as sensitive data might be exposed that otherwise would have been filtered by the IN clause and doesn't really match the expected behavior of does the set () include element x.
Activity
Implemented #35 (render empty IN as 1=2)
JanHolger commentedon May 1, 2022
Fixed in 1.0.2