1. Mike Bayer Avatar Mike Bayer
  2. Untitled project
  3. sqlalchemy_old
  4. Issues

in_ clauses with no arguments

Issue #545 resolved
Mike Bayer repo owner created an issue

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)

  2. Former user 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 #620 for the unittests to pass correctly.

  4. Log in to comment
Assignee
–
Type
enhancement
Priority
major
Status
resolved
Component
sql
Milestone
–
Votes
0
Watchers
0
Jira: the preferred issue tracker for Bitbucket. Join the team!