Query from DB Manager SQL window no longer loads as new layer

[qgib]

Author Name: José de Paula Rodrigues Neto Assis (@espinafre)
Original Redmine Issue: 21353
Affected QGIS version: 3.5(master)
Redmine category:db_manager
Assignee: Alessandro Pasotti

---

I've just installed qgis-3.6.0 from sources, built Debian packages (current Debian Sid) and installed them. I opened one of my projects, which uses layers from PostGIS. I issued an SQL query from the SQL Window of DB Manager that returns some lines with geometry columns; so far, so good. I then check the "Load as new layer" box, select the primary key field, choose the correct geometry column and click the "Load" button. Nothing happens. I've uninstalled this 3.6.0 qgis, installed my previous 3.4.4, and the same actions produce a new layer on my project called QueryLayer.

---

Related issue(s): #29227 (duplicates), #29251 (duplicates)
Redmine related issue(s): 21410, 21434

---

[qgib]

Author Name: José de Paula Rodrigues Neto Assis (@espinafre)

---

Forgot to say that I've started with a clean state in both cases (i.e., I've deleted my .local/share/QGIS before starting up either version to confirm the bug).

The following simple SQL query (requires PostGIS) shows the bug:

select 1 as id, st_geomfromtext('POINT(-47.8669271 -15.7992462)', 4326) as geom;

This result in a layer with a single point in QGIS-3.4.4, and nothing with QGIS-3.6.0.

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

• assigned_to_id was configured as Alessandro Pasotti

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

#9247

---

• easy_fix was changed from 0 to 1
• resolution was changed from to fixed/implemented
• pull_request_patch_supplied was changed from 0 to 1
• status_id was changed from Open to In Progress

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

Applied in changeset 74aa8ca.

---

• done_ratio was changed from 0 to 100
• status_id was changed from In Progress to Closed

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

• duplicated was configured as Load as new layer from DB Manager does not load into QGIS #29227

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

• duplicated was configured as Create SQL-Layer from DB-Manager #29251