From 3e855cd277aac8a71be31082cbc11927005f5b37 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 30 Aug 2017 12:23:31 -0400 Subject: Ignore SQL Server "heap" indexes Added a rule to SQL Server index reflection to ignore the so-called "heap" index that is implicitly present on a table that does not specify a clustered index. Tests are part of standard suite already (CI has been disabled) Change-Id: I593b95551c40ee5d95d54203611112cbff10856f Fixes: #4059 --- lib/sqlalchemy/dialects/mssql/base.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/sqlalchemy') diff --git a/lib/sqlalchemy/dialects/mssql/base.py b/lib/sqlalchemy/dialects/mssql/base.py index 05381d671..d526c685c 100644 --- a/lib/sqlalchemy/dialects/mssql/base.py +++ b/lib/sqlalchemy/dialects/mssql/base.py @@ -1939,7 +1939,7 @@ class MSDialect(default.DefaultDialect): "join sys.schemas as sch on sch.schema_id=tab.schema_id " "where tab.name = :tabname " "and sch.name=:schname " - "and ind.is_primary_key=0", + "and ind.is_primary_key=0 and ind.type != 0", bindparams=[ sql.bindparam('tabname', tablename, sqltypes.String(convert_unicode=True)), -- cgit v1.2.1