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

[qgib]

Author Name: chris Mr (@chrismarx)
Original Redmine Issue: 16398
Affected QGIS version: 2.18.3
Redmine category:virtual_layers

---

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-

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

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

---

• description was changed from 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- to 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-

• priority_id was changed from Normal to High
• status_id was changed from Open to Feedback
• category_id was configured as Virtual Layers

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0
• regression was configured as 0

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Closing for lack of feedback.

---

• resolution was changed from to not reproducable
• status_id was changed from Feedback to Closed