2 files changed, 7 insertions, 3 deletions

diff --git a/lib/sqlalchemy/ansisql.py b/lib/sqlalchemy/ansisql.py
index a7359acfc..d7cce0ce2 100644
--- a/lib/sqlalchemy/ansisql.py
+++ b/lib/sqlalchemy/ansisql.py
@@ -147,7 +147,10 @@ class ANSICompiler(sql.Compiled):
         for c in select._raw_columns:
             for co in c.columns:
                 inner_columns.append(co)
-                self.typemap[co.label] = co.type
+                if select.use_labels:
+                    self.typemap[co.label] = co.type
+                else:
+                    self.typemap[co.key] = co.type
                 
         if select.use_labels:
             collist = string.join(["%s AS %s" % (c.fullname, c.label) for c in inner_columns], ', ')
diff --git a/test/query.py b/test/query.py
index 47e56ee16..7f452cd24 100644
--- a/test/query.py
+++ b/test/query.py
@@ -1,9 +1,10 @@
 from testbase import PersistTest
+import testbase
 import unittest, sys
 
 import sqlalchemy.databases.sqlite as sqllite
 
-db = sqllite.engine(':memory:', {}, echo = True)
+db = sqllite.engine(':memory:', {}, echo = testbase.echo)
 
 from sqlalchemy.sql import *
 from sqlalchemy.schema import *
@@ -11,7 +12,7 @@ from sqlalchemy.schema import *
 class QueryTest(PersistTest):
     
     def setUp(self):
-        self.users = Table('users', db,
+        self.users = Table('query_users', db,
             Column('user_id', INT, primary_key = True),
             Column('user_name', VARCHAR(20)),
             redefine = True