From 703908caadfc2cb763e2838e4886074aef32c294 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Sun, 12 Feb 2006 06:29:57 +0000
Subject: [PATCH] slight glitch when the same clause is compiled repeatedly and
 contains redundant bind parameters...this fix prevents the binds from
 stepping on each other....

---
 lib/sqlalchemy/ansisql.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/sqlalchemy/ansisql.py b/lib/sqlalchemy/ansisql.py
index 3eaed0bc1d..a300dc6392 100644
--- a/lib/sqlalchemy/ansisql.py
+++ b/lib/sqlalchemy/ansisql.py
@@ -222,7 +222,7 @@ class ANSICompiler(sql.Compiled):
 
     def visit_bindparam(self, bindparam):
         if bindparam.shortname != bindparam.key:
-            self.binds[bindparam.shortname] = bindparam
+            self.binds.setdefault(bindparam.shortname, bindparam)
         count = 1
         key = bindparam.key
 
-- 
2.47.2