fixed bug where Column with redefined "key" property wasnt getting

type conversion happening in the ResultProxy [ticket:207]

2 files changed, 3 insertions, 1 deletions

diff --git a/CHANGES b/CHANGES
index 6e4dfbd07..6e50343ab 100644
--- a/CHANGES
+++ b/CHANGES
@@ -5,6 +5,8 @@
 auto-foreignkey detection [ticket:151]
 - fixed bug where tables with schema names werent getting indexed in
 the MetaData object properly
+- fixed bug where Column with redefined "key" property wasnt getting
+type conversion happening in the ResultProxy [ticket:207]
 
 0.2.2
 - big improvements to polymorphic inheritance behavior, enabling it
diff --git a/lib/sqlalchemy/ansisql.py b/lib/sqlalchemy/ansisql.py
index f1030b835..cdd860440 100644
--- a/lib/sqlalchemy/ansisql.py
+++ b/lib/sqlalchemy/ansisql.py
@@ -168,7 +168,7 @@ class ANSICompiler(sql.Compiled):
         if len(self.select_stack):
             # if we are within a visit to a Select, set up the "typemap"
             # for this column which is used to translate result set values
-            self.typemap.setdefault(column.key.lower(), column.type)
+            self.typemap.setdefault(column.name.lower(), column.type)
         if column.table is None or not column.table.named_with_column():
             self.strings[column] = column.name
         else: