DB Manager does not load layer after a query

[qgib]

Author Name: matteo ghetta (@ghtmtt)
Original Redmine Issue: 19842
Affected QGIS version: 3.3(master)
Redmine category:db_manager

---

Loading a layer as result of a query, like:

SELECT a.id AS id_punto, b.provincia AS provincia, a.geom
 FROM punti a, province b
 WHERE ST_Within(a.geom, b.geom) IS TRUE;

and clicking on "Load as new layer", if the user choose an id column, the layer is not loaded. The only way is to close DB Manager, run the query again and don't touch anything in the "Load as new layer" tab. Then the resulting layer is loaded.

Happens with 2.18, 3.0, 3.2, 3.3

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

I just tested on 3.2 and seems working fine here.

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: matteo ghetta (@ghtmtt)

---

Fresh compiled and seems working now. Thanks for checking

---

• status_id was changed from Feedback to Closed

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• resolution was changed from to fixed/implemented