relationship comparisons to objects with None don't render IS NULL

Issue #3373 new
Mike Bayer repo owner created an issue

e.g.:

session.query(Address).filter(Address.user == User(id=None))

will produce:

SELECT address.id AS address_id, address.user_id AS address_user_id,
address.email_address AS address_email_address
FROM address WHERE ? = address.user_id
(None,)

This have to be fixed for all the relationship filter conditions, including filter() with both == and !=, with_parent(), etc.

see also #3371, which adds a warning for these.

Comments (2)

  1. Mike Bayer reporter
    • changed milestone to 1.4

    this is not a major use case, that the action warns is good for now, not a priority to support this.

  2. Log in to comment