- attached empty_in.patch
in_ clauses with no arguments
Issue #545
resolved
we'd like to define the behavior for in_()
with a list of length zero. IN ()
is invalid on most databases and we'd like to substitute an expression that evaluates to False, while accomodating the left side of the comparison's appropriate behavior (like a stored procedure or such).
Comments (3)
-
Account Deleted -
Account Deleted The correct behaviour for empty in is null when left side is null else false. i.e. CASE WHEN (leftside IS NULL) THEN NULL ELSE 0 END = 1. The comparison of 0 to 1 is to have a portable boolean false.
The added patch depends on
#620for the unittests to pass correctly. -
reporter - changed status to resolved
- Log in to comment
Patch for empty in clauses