[Sqlalchemy-tickets] Issue #3147: query works in 0.7.10 and not 0.8.7 (zzzeek/sqlalchemy)

[Mike B. <iss...@bi...>]

New issue 3147: query works in 0.7.10 and not 0.8.7
https://bitbucket.org/zzzeek/sqlalchemy/issue/3147/query-works-in-0710-and-not-087

Mike Bernson:

The query works in 0.7.10 but not 0.8.7.

Code

```
#!python
from sqlalchemy import create_engine, Column, Date, Integer
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

from datetime import date


Base = declarative_base()


class Test(Base):
    __tablename__ = 'test'
    id = Column(Integer, primary_key=True)
    start_date = Column(Date)

engine = create_engine('sqlite:///')

session = sessionmaker()
session.configure(bind=engine)

Base.metadata.create_all(engine)

s = session()
s.query(Test).filter(date(2010, 1, 1) <= Test.start_date <= date(2010, 12, 31))
```

output when running:

```

Traceback (most recent call last):
  File "test.py", line 24, in <module>
    s.query(Test).filter(date(2010, 1, 1) <= Test.start_date <= date(2010, 12, 31))
  File "build/bdist.linux-x86_64/egg/sqlalchemy/sql/expression.py", line 4479, in __nonzero__
TypeError: Boolean value of this clause is not defined
Traceback (most recent call last):
  File "test.py", line 24, in <module>
    s.query(Test).filter(date(2010, 1, 1) <= Test.start_date <= date(2010, 12, 31))
  File "build/bdist.linux-x86_64/egg/sqlalchemy/sql/expression.py", line 4479, in __nonzero__
TypeError: Boolean value of this clause is not defined