From 43ecc7a581c1df3807fb7ae9e17ae9ecca372c94 Mon Sep 17 00:00:00 2001 From: Michael Trier Date: Fri, 14 Nov 2008 03:56:55 +0000 Subject: [PATCH] The str(query) output is also correct on the mssql dialect. --- lib/sqlalchemy/databases/mssql.py | 3 ++- test/orm/query.py | 2 +- 2 files changed, 3 insertions(+), 2 deletions(-) diff --git a/lib/sqlalchemy/databases/mssql.py b/lib/sqlalchemy/databases/mssql.py index d806492c62..e23ed4104b 100644 --- a/lib/sqlalchemy/databases/mssql.py +++ b/lib/sqlalchemy/databases/mssql.py @@ -1017,7 +1017,8 @@ class MSSQLCompiler(compiler.DefaultCompiler): def visit_binary(self, binary, **kwargs): """Move bind parameters to the right-hand side of an operator, where possible.""" - + #import pdb + #pdb.set_trace() if isinstance(binary.left, expression._BindParamClause) and binary.operator == operator.eq \ and not isinstance(binary.right, expression._BindParamClause): return self.process(expression._BinaryExpression(binary.right, binary.left, binary.operator), **kwargs) diff --git a/test/orm/query.py b/test/orm/query.py index 72cb1d4aeb..5a113104c5 100644 --- a/test/orm/query.py +++ b/test/orm/query.py @@ -191,7 +191,7 @@ class GetTest(QueryTest): assert u.addresses[0].email_address == 'jack@bean.com' assert u.orders[1].items[2].description == 'item 5' - @testing.fails_on_everything_except('sqlite') + @testing.fails_on_everything_except('sqlite', 'mssql') def test_query_str(self): s = create_session() q = s.query(User).filter(User.id==1) -- 2.47.3