Crash on SQL queries - virtual layers

[qgib]

Author Name: Bugmi Gnott (Bugmi Gnott)
Original Redmine Issue: 19271
Affected QGIS version: 3.2
Redmine category:db_manager

---

Steps to reproduce:

• New project

• New temporary vector (name "asd", geometry: LineString)

• Draw a line

• Menu Database -> DB Manager, click on Virtual Layers -> QGIS layer -> asd, open the SQL window

• Run query: "SELECT * FROM asd;", query should run OK

• Run query: "SELECT geometry FROM asd;", query should run OK

• Run query: "SELECT GLength(geometry) FROM asd;", query should run OK

• Run query: "SELECT *", crash occurs

• Run query: "SELECT geometry_n FROM asd;", crash occurs

• Run query: "SELECT NoSuchFunction(geometry) FROM asd;", crash occurs

See attached file for stack trace

---

• crash.txt (Bugmi Gnott)

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• subject was changed from QGIS 3.2.0 - Crash on SQL queries to Crash on SQL queries

[qgib]

Author Name: Stephen Knox (Stephen Knox)

---

I can't reproduce a crash on the queries flagged, although they don't work, but that isn't surprising since they don't seem to be valid SQL. Perhaps a close candidate as time has moved on?

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Regis Haubourg (@haubourg)

---

Tested here with latest nightlies.

I get "database error" messages in a popup but no QGIS crash.

For sure the error message are not really informative but this would be more a feature request to improve that part of DBmanager (would be really nice to have verbose messages from spatialite / SQLITE)

Please reopen if the crash still occurs

---

• status_id was changed from Feedback to Closed
• resolution was changed from to not reproducable
• priority_id was changed from High to Normal

[qgib]

Author Name: Regis Haubourg (@haubourg)

---

• subject was changed from Crash on SQL queries to Crash on SQL queries - virtual layers