Create SQL-Layer from DB-Manager

[qgib]

Author Name: Michael Otto (Michael Otto)
Original Redmine Issue: 21434
Affected QGIS version: 3.6.0
Redmine category:python_plugins

---

I will create a new Layer of a Oracle-Spatial DB by using a SQL-Command in DB-Manager.
The query works. Results are shown in the table.
But when i check "add as new layer" with id and geometry rows defined nothing will happens.
No layer is created and the following error appears on the python-log.

2019-03-01T08:52:39 WARNING Traceback (most recent call last):
File "C:/PROGRA1/QGIS31.6/apps/qgis/./python/plugins\db_manager\dlg_sql_window.py", line 434, in loadSqlLayer
layer = self._getSqlLayer(self.filter)
File "C:/PROGRA1/QGIS31.6/apps/qgis/./python/plugins\db_manager\dlg_sql_window.py", line 396, in _getSqlLayer
query = self._getSqlExecutableQuery()
AttributeError: 'DlgSqlWindow' object has no attribute '_getSqlExecutableQuery'

2019-03-01T08:52:56 WARNING Traceback (most recent call last):
File "C:/PROGRA1/QGIS31.6/apps/qgis/./python/plugins\db_manager\dlg_sql_window.py", line 628, in setFilter
layer = self._getSqlLayer("")
File "C:/PROGRA1/QGIS31.6/apps/qgis/./python/plugins\db_manager\dlg_sql_window.py", line 396, in _getSqlLayer
query = self._getSqlExecutableQuery()
AttributeError: 'DlgSqlWindow' object has no attribute '_getSqlExecutableQuery'

---

Related issue(s): #29171 (duplicates)
Redmine related issue(s): 21353

---

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

• duplicates was configured as Query from DB Manager SQL window no longer loads as new layer #29171

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

• resolution was changed from to duplicate
• status_id was changed from Open to Closed