Bug report #13831

Save to Spatialite fails if input is from same DB

Added by Anita Graser about 8 years ago. Updated almost 5 years ago.

Assignee:René-Luc ReLuc
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


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.


#1 Updated by Alexander Bruy almost 8 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 over 6 years ago

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

#3 Updated by Arnaud Morvan almost 6 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 almost 5 years ago

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

Also available in: Atom PDF