[db-manager] Allow multiline filters in sql window

elpaso · elpaso · commit 94ded32f4ee5 · 2018-09-27T08:01:40.000+02:00
Fixes #19956 - Update SQL layer results in invalid SQL expression
diff --git a/python/plugins/db_manager/dlg_sql_layer_window.py b/python/plugins/db_manager/dlg_sql_layer_window.py
@@ -145,11 +145,11 @@ def __init__(self, iface, layer, parent=None):
         # First the SQL from QgsDataSourceUri table
         sql = uri.table()
         if uri.keyColumn() == '_uid_':
-            match = re.search('^\(SELECT .+ AS _uid_,\* FROM \((.*)\) AS _subq_.+_\s*\)$', sql, re.S)
+            match = re.search(r'^\(SELECT .+ AS _uid_,\* FROM \((.*)\) AS _subq_.+_\s*\)$', sql, re.S | re.X)
             if match:
                 sql = match.group(1)
         else:
-            match = re.search('^\((SELECT .+ FROM .+)\)$', sql, re.S)
+            match = re.search(r'^\((SELECT .+ FROM .+)\)$', sql, re.S | re.X)
             if match:
                 sql = match.group(1)
         # Need to check on table() since the parentheses were removed by the regexp
