- A TypeDecorator of Integer can be used with a primary key

  column, and the "autoincrement" feature of various dialects
  as well as the "sqlite_autoincrement" flag will honor
  the underlying database type as being Integer-based.
 [ticket:2005]

- Result-row processors are applied to pre-executed SQL
  defaults, as well as cursor.lastrowid, when determining
  the contents of result.inserted_primary_key.
  [ticket:2006]

- Bind parameters present in the "columns clause" of a select
  are now auto-labeled like other "anonymous" clauses,
  which among other things allows their "type" to be meaningful
  when the row is fetched, as in result row processors.

- TypeDecorator is present in the "sqlalchemy" import space.

1 files changed, 4 insertions, 3 deletions

diff --git a/lib/sqlalchemy/schema.py b/lib/sqlalchemy/schema.py
index f4b214061..a81874500 100644
--- a/lib/sqlalchemy/schema.py
+++ b/lib/sqlalchemy/schema.py
@@ -323,9 +323,10 @@ class Table(SchemaItem, expression.TableClause):
     def _autoincrement_column(self):
         for col in self.primary_key:
             if col.autoincrement and \
-                isinstance(col.type, types.Integer) and \
+                issubclass(col.type._type_affinity, types.Integer) and \
                 not col.foreign_keys and \
-                isinstance(col.default, (type(None), Sequence)):
+                isinstance(col.default, (type(None), Sequence)) and \
+                col.server_default is None:
 
                 return col
 
@@ -544,7 +545,7 @@ class Column(SchemaItem, expression.ColumnClause):
 
           The setting *only* has an effect for columns which are:
 
-          * Integer derived (i.e. INT, SMALLINT, BIGINT)
+          * Integer derived (i.e. INT, SMALLINT, BIGINT).
 
           * Part of the primary key