Merge pull request #30712 from qgis/backport-30707-to-release-3_8

[Backport release-3_8] [Bugfix] DB Mananger: Fix in Oracle plugin the way to strip uniqueCol
qgis · Jul 15, 2019 · 893395d · 893395d
2 parents 5aa55b0 + f198ab2
commit 893395d
Showing 1 changed file with 5 additions and 1 deletion.
diff --git a/python/plugins/db_manager/db_plugins/oracle/plugin.py b/python/plugins/db_manager/db_plugins/oracle/plugin.py
@@ -203,8 +203,12 @@ def toSqlLayer(self, sql, geomCol, uniqueCol,
         uri = self.uri()
         con = self.database().connector
 
+        if uniqueCol is not None:
+            uniqueCol = uniqueCol.strip('"').replace('""', '"')
+
         uri.setDataSource(u"", u"({}\n)".format(
-            sql), geomCol, filter, uniqueCol.strip(u'"'))
+            sql), geomCol, filter, uniqueCol)
+
         if avoidSelectById:
             uri.disableSelectAtId(True)
         provider = self.dbplugin().providerName()