Bug report #19921

SpatiaLite Execute SQL not working

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

Status:Rejected
Priority:Normal
Assignee:Nyall Dawson
Category:Processing/Core
Affected QGIS version:3.3(master) Regression?:Yes
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:invalid
Crashes QGIS or corrupts data:No Copied to github as #:27745

Description

SpatiaLite Execute SQL returns `{}`.

Here the simple query example:

SELECT * FROM regioni

or

SELECT * FROM regioni
WHERE reg_name = 'Piemonte'

db is > 5MB and cannot attach it, so here the link were to download it: https://drive.google.com/open?id=12LhL1hWPLUCoa_R0ExtbOrf2h70ts8EI

History

#1 Updated by Nyall Dawson over 2 years ago

  • Assignee set to Nyall Dawson
  • Status changed from Open to In Progress

#2 Updated by Nyall Dawson over 2 years ago

  • Resolution set to invalid
  • Status changed from In Progress to Rejected

This is expected behavior from this algorithm -- it executes SQL only, it does not load the result. We need an equivalent of the "Postgres execute and load SQL" algorithm for the desired behaviour here.

#3 Updated by matteo ghetta over 2 years ago

ok thanks for the feedback. Actually I'm missing what this algorithm can be used for :)

Also available in: Atom PDF