added a hook in for 'binary operator', so sqlite can exchange

'+' for '||' for a binary clause on a string

1 files changed, 4 insertions, 1 deletions

diff --git a/lib/sqlalchemy/ansisql.py b/lib/sqlalchemy/ansisql.py
index a4cbb4358..a06abe598 100644
--- a/lib/sqlalchemy/ansisql.py
+++ b/lib/sqlalchemy/ansisql.py
@@ -209,12 +209,15 @@ class ANSICompiler(sql.Compiled):
     def visit_binary(self, binary):
         result = self.get_str(binary.left)
         if binary.operator is not None:
-            result += " " + binary.operator
+            result += " " + self.binary_operator_string(binary)
         result += " " + self.get_str(binary.right)
         if binary.parens:
             result = "(" + result + ")"
         self.strings[binary] = result
 
+    def binary_operator_string(self, binary):
+        return binary.operator
+
     def visit_bindparam(self, bindparam):
         if bindparam.shortname != bindparam.key:
             self.binds[bindparam.shortname] = bindparam