From 954f7b289bcbe05dfffb765d66b04411693e7d31 Mon Sep 17 00:00:00 2001 From: Paul Johnston Date: Sun, 25 Nov 2007 23:17:02 +0000 Subject: [PATCH] Fix: MSSQL concatenate operator is + not || [ticket:879] --- lib/sqlalchemy/databases/mssql.py | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/lib/sqlalchemy/databases/mssql.py b/lib/sqlalchemy/databases/mssql.py index 242389cfd9..a1cefb0193 100644 --- a/lib/sqlalchemy/databases/mssql.py +++ b/lib/sqlalchemy/databases/mssql.py @@ -40,7 +40,7 @@ Known issues / TODO: import datetime, random, warnings, re, sys, operator from sqlalchemy import sql, schema, exceptions, util -from sqlalchemy.sql import compiler, expression +from sqlalchemy.sql import compiler, expression, operators as sqlops from sqlalchemy.engine import default, base from sqlalchemy import types as sqltypes @@ -848,6 +848,9 @@ dialect_mapping = { class MSSQLCompiler(compiler.DefaultCompiler): + operators = compiler.OPERATORS.copy() + operators[sqlops.concat_op] = '+' + def __init__(self, *args, **kwargs): super(MSSQLCompiler, self).__init__(*args, **kwargs) self.tablealiases = {} -- 2.47.2