Merge pull request #36823 from elpaso/bugfix-gh-36205-dbmanager-strip…

…-semicolon DB Manager: remove semicolon from SQL window queries
qgis · May 29, 2020 · 81abbbb · 81abbbb
2 parents da21127 + dc2ff12
commit 81abbbb
Showing 1 changed file with 3 additions and 1 deletion.
diff --git a/python/plugins/db_manager/dlg_sql_window.py b/python/plugins/db_manager/dlg_sql_window.py
@@ -653,7 +653,9 @@ def _getSqlQuery(self):
         return sql
 
     def _getExecutableSqlQuery(self):
-        sql = self._getSqlQuery()
+        sql = self._getSqlQuery().strip()
+        if sql.endswith(';'):
+            sql = sql[:-1]
 
         uncommented_sql = check_comments_in_sql(sql)
         return uncommented_sql