Bug report #19842

DB Manager does not load layer after a query

Added by matteo ghetta over 6 years ago. Updated over 6 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:DB Manager
Affected QGIS version:3.3(master) Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:fixed/implemented
Crashes QGIS or corrupts data:No Copied to github as #:27666

Description

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

History

#1 Updated by Giovanni Manghi over 6 years ago

  • Status changed from Open to Feedback

I just tested on 3.2 and seems working fine here.

#2 Updated by matteo ghetta over 6 years ago

  • Status changed from Feedback to Closed

Fresh compiled and seems working now. Thanks for checking

#3 Updated by Giovanni Manghi over 6 years ago

  • Resolution set to fixed/implemented

Also available in: Atom PDF