Corrected the sqlite float type so that it properly gets reflected as a SLFloat type. Fixes #1273.

3 files changed, 6 insertions, 2 deletions

diff --git a/CHANGES b/CHANGES
index 8d0987661..af211a990 100644
--- a/CHANGES
+++ b/CHANGES
@@ -64,6 +64,10 @@ CHANGES
       binary collation based database. Cleaned up information schema
       since it is only used by mssql now. [ticket:1343]
 
+- sqlite
+    - Corrected the float type so that it correctly maps to a
+      SLFloat type when being reflected. [ticket:1273]
+
 0.5.3
 =====
 - orm
diff --git a/lib/sqlalchemy/databases/sqlite.py b/lib/sqlalchemy/databases/sqlite.py
index e2156be97..4abbe80cd 100644
--- a/lib/sqlalchemy/databases/sqlite.py
+++ b/lib/sqlalchemy/databases/sqlite.py
@@ -329,7 +329,7 @@ ischema_names = {
     'DATE': SLDate,
     'DATETIME': SLDateTime,
     'DECIMAL': SLNumeric,
-    'FLOAT': SLNumeric,
+    'FLOAT': SLFloat,
     'INT': SLInteger,
     'INTEGER': SLInteger,
     'NUMERIC': SLNumeric,
diff --git a/test/dialect/sqlite.py b/test/dialect/sqlite.py
index 005fad66b..03e7ecdf3 100644
--- a/test/dialect/sqlite.py
+++ b/test/dialect/sqlite.py
@@ -73,7 +73,7 @@ class TestTypes(TestBase, AssertsExecutionResults):
                  ( Numeric(10, 2), sqlite.SLNumeric(10, 2), ),
                  ( DECIMAL, sqlite.SLNumeric(), ),
                  ( DECIMAL(10, 2), sqlite.SLNumeric(10, 2), ),
-                 ( Float, sqlite.SLNumeric(), ),
+                 ( Float, sqlite.SLFloat(), ),
                  ( sqlite.SLNumeric(), ),
                  ( INT, sqlite.SLInteger(), ),
                  ( Integer, sqlite.SLInteger(), ),