DB manager does not remove Spatialite indexes and entry in "spatialite_hystory" after deleting a table

[qgib]

Author Name: Giovanni Manghi (@gioman) Original Redmine Issue: 7146 Affected QGIS version: 3.0.0 Redmine category:db_manager

---

The same issue seems to affect also the browser.

Add a ector to a SL datasource, and select to create also a spatial index.

Then remove the vector from the datasource, the tables idx_tablename_geom* are not removed, as it isn't the entry in the table "spatialite_hystory", so it not possible to re-add another vector with the same name.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• priority_id was changed from High to Normal

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• fixed_version_id was configured as Version 2.4

[qgib]

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

---

• fixed_version_id was changed from Version 2.4 to Future Release - High Priority

[qgib]

Author Name: Giuseppe Sucameli (@brushtyler)

---

The issue affects the importer feature (dataprovider).

---

• assigned_to_id was configured as Giuseppe Sucameli
• category_id was changed from DB Manager to Data Provider/SpatiaLite
• status_id was changed from Open to In Progress

[qgib]

Author Name: Giuseppe Sucameli (@brushtyler)

---

Similar issues are in both DBManager and SL dataprovider (importer), but the reported one occurs removing a vector table in DBManager. I'll file a new ticket for the importer (if not already there).

---

• category_id was changed from Data Provider/SpatiaLite to DB Manager

[qgib]

Author Name: Reinhard Reiterer (Reinhard Reiterer)

---

Here on Win7 creating a new table with a previously used table name works, but the features are not displayed properly on the canvas. In QspatiaLite it's possible to delete unused indices as a workaorund.

See also: http://gis.stackexchange.com/questions/38955/why-is-this-spatialite-polygon-layer-not-displayed-properly

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

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

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• version was changed from master to 3.0.0
• description was changed from The same issue seems to affect also the browser.

Add a ector to a SL datasource, and select to create also a spatial index.

Then remove the vector from the datasource, the tables idx_tablename_geom* are not removed, as it isn't the entry in the table "spatialite_hystory", so it not possible to re-add another vector with the same name. to The same issue seems to affect also the browser.

Add a ector to a SL datasource, and select to create also a spatial index.

Then remove the vector from the datasource, the tables idx_tablename_geom* are not removed, as it isn't the entry in the table "spatialite_hystory", so it not possible to re-add another vector with the same name.

• status_id was changed from In Progress to Open
• assigned_to_id removed Giuseppe Sucameli

[Pedro-Murteira]

Still valid on QGIS 3.22.3.