I'm wondering what is the behaviour of qgis when you work on spatialite layers.
For instance what I've discovered so far is that when you split a geometry in two. One remain the original (same id, same attributes) and the other is a duplicata (negative id but still same attributes) that can be modified before the commit. After you save changes there is an insert for the new feature but is there an update for the original feature because it's geometry changed ?
And furthermore, when you merge features i've noticed that no DELETE is emitted to the database.
I'll be glad if someone points me toward some doc about it.