- [feature] The "required" flag is set to

True by default, if not passed explicitly,
on bindparam() if the "value" or "callable"
parameters are not passed.
This will cause statement execution to check
for the parameter being present in the final
collection of bound parameters, rather than
implicitly assigning None. [ticket:2556]

1 files changed, 4 insertions, 2 deletions

diff --git a/test/orm/test_query.py b/test/orm/test_query.py
index a2f1ff1dc..04b62f8c9 100644
--- a/test/orm/test_query.py
+++ b/test/orm/test_query.py
@@ -947,7 +947,8 @@ class ExpressionTest(QueryTest, AssertsCompiledSQL):
 
         session = create_session()
 
-        q = session.query(User.id).filter(User.id==bindparam('foo')).params(foo=7).subquery()
+        q = session.query(User.id).filter(User.id == bindparam('foo')).\
+                            params(foo=7).subquery()
 
         q = session.query(User).filter(User.id.in_(q))
 
@@ -957,7 +958,8 @@ class ExpressionTest(QueryTest, AssertsCompiledSQL):
         User, Address = self.classes.User, self.classes.Address
 
         session = create_session()
-        s = session.query(User.id).join(User.addresses).group_by(User.id).having(func.count(Address.id) > 2)
+        s = session.query(User.id).join(User.addresses).group_by(User.id).\
+                                    having(func.count(Address.id) > 2)
         eq_(
             session.query(User).filter(User.id.in_(s)).all(),
             [User(id=8)]