Bug report #16398

QGIS hangs when creating or testing a virtual layer when the sql is wrong

Added by chris Mr over 6 years ago. Updated over 6 years ago.

Category:Virtual Layers
Affected QGIS version:2.18.3 Regression?:No
Operating System:MacOS Easy fix?:No
Pull Request or Patch supplied:No Resolution:not reproducable
Crashes QGIS or corrupts data:Yes Copied to github as #:24307


If you go to add a virtual layer, and the add sql like this:

select gid as kml_key, sa.*
from service_areas

but forget to include the column alias for service_areas, QGIS just hangs without error, and the
QGIS process remains at 99% cpu too-


#1 Updated by Giovanni Manghi over 6 years ago

  • Description updated (diff)
  • Priority changed from Normal to High
  • Status changed from Open to Feedback
  • Category set to Virtual Layers

Or I cannot replicate or I don't understand completely the description. Can you attach a small dataset?

#2 Updated by Giovanni Manghi over 6 years ago

  • Easy fix? set to No
  • Regression? set to No

#3 Updated by Giovanni Manghi over 6 years ago

  • Resolution set to not reproducable
  • Status changed from Feedback to Closed

Closing for lack of feedback.

Also available in: Atom PDF