Commits

Michael Manfre committed b007ebc

Don't alter empty UPDATE sql

Comments (0)

Files changed (1)

sqlserver_ado/compiler.py

 class SQLUpdateCompiler(compiler.SQLUpdateCompiler, SQLCompiler):
     def as_sql(self):
         sql, params = super(SQLUpdateCompiler, self).as_sql()
-        # Need the NOCOUNT OFF so UPDATE returns a count, instead of -1
-        sql = 'SET NOCOUNT OFF; {0}; SET NOCOUNT ON'.format(sql)
+        if sql:
+            # Need the NOCOUNT OFF so UPDATE returns a count, instead of -1
+            sql = 'SET NOCOUNT OFF; {0}; SET NOCOUNT ON'.format(sql)
         return sql, params
 
 class SQLAggregateCompiler(compiler.SQLAggregateCompiler, SQLCompiler):
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.