[DB Manager] Fix broken geometry type of GeoPackage based SQL Layers. F…

…ixes #33232
qgis · Dec 16, 2019 · dbdc397 · dbdc397
1 parent 0d84e35
commit dbdc397
Showing 1 changed file with 1 addition and 2 deletions.
diff --git a/python/plugins/db_manager/db_plugins/gpkg/plugin.py b/python/plugins/db_manager/db_plugins/gpkg/plugin.py
@@ -178,8 +178,7 @@ def uniqueIdFunction(self):
     def toSqlLayer(self, sql, geomCol, uniqueCol, layerName="QueryLayer", layerType=None, avoidSelectById=False, filter=""):
         from qgis.core import QgsVectorLayer
 
-        vl = QgsVectorLayer(self.uri().database(), layerName, 'ogr')
-        vl.setSubsetString(sql)
+        vl = QgsVectorLayer(self.uri().database() + '|subset=' + sql, layerName, 'ogr')
         return vl
 
     def supportsComment(self):