[Sqlalchemy-tickets] Issue #3033: WHERE 0 = 1 silently generated (zzzeek/sqlalchemy)
Brought to you by:
zzzeek
|
From: Jefffrey <iss...@bi...> - 2014-04-24 16:53:52
|
New issue 3033: WHERE 0 = 1 silently generated https://bitbucket.org/zzzeek/sqlalchemy/issue/3033/where-0-1-silently-generated Jefffrey: Running: ``` #!python query = session.query(A).filter( and_( A.id == string_a , A.b.key == string_b ) ) ``` where: ``` #!python class A(Base): __tablename__ = 'a_table' id = Column(Integer, primary_key = True) # ... class B(Base): __tablename__ = 'b_table' id = Column(Integer, primary_key = True) # ... a_id = Column(Integer, ForeignKey('a_table.id'), nullable = False) a = relationship("A", backref = backref("b", uselist = False)) ``` produces a query like: ``` #!sql SELECT ... FROM a_table WHERE 0 = 1 ``` |