Bug report #13831

Save to Spatialite fails if input is from same DB

Added by Anita Graser over 4 years ago. Updated about 1 year ago.

Status:Closed
Priority:Normal
Assignee:René-Luc ReLuc
Category:Processing/Core
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:end of life
Crashes QGIS or corrupts data:No Copied to github as #:21855

Description

To reproduce, import e.g. the airports.shp from our sample data into a Spatialite DB. Then try to buffer it while writing the results in the same Spatialite. The resulting table will be empty.

If the original Shapefile is used as input, everything works fine.

History

#1 Updated by Alexander Bruy about 4 years ago

  • Assignee changed from Victor Olaya to René-Luc ReLuc

I suspect this is caused by fact that SQLite allows only single connection to database

#2 Updated by Giovanni Manghi almost 3 years ago

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

#3 Updated by Arnaud Morvan about 2 years ago

  • Description updated (diff)

Note that when you create a spatialite file as output, it is not supported to add tables to an existing spatialite database using this method. When you select an existing sqlite file as output, you're asked for a confirmation to overwrite the entire sqlite file.
So if you select your source sqlite database as output, you overwrite your source file before starting to read it.

#4 Updated by Giovanni Manghi about 1 year ago

  • Resolution set to end of life
  • Status changed from Open to Closed

Also available in: Atom PDF