System.Data.SQLite
Ticket Change Details
Not logged in
Overview

Artifact ID: e5e514c8661fefed98ad28ee9ef1bdac450079f6
Ticket: 1eacbf5ad9c039a1b618d08c54dd52ce78bf501b
Trace showing single delete multiple times
User & Date: anonymous 2019-01-31 16:25:39
Changes

  1. Change foundin to "1.0.109.0"
  2. Change icomment to:
    I registered the Trace event of the SQLiteConnection. 
    For insert and update statements, it is triggered one time per statement.
    For delete, it is called multiple times.
    
    I found out that it seems to be related with foreign keys. If they are enabled, and another table has a foreign key reference to this table, the Trace is called multiple times, even if cascading does not delete anything in the other table. The statement shown in the TraceEventArgs is always the same (e.g. "DELETE FROM TableX WHERE ID = 1").
    
    I find this a bit confusing, especially since I did not find any documentation about this.
    Is this behaviour intended?
    
  3. Change login to "anonymous"
  4. Change mimetype to "text/x-fossil-plain"
  5. Change private_contact to "fbc2ee1fa0e39445eea94a09fc3b60f6148a1d3e"
  6. Change severity to "Minor"
  7. Change status to "Open"
  8. Change title to "Trace showing single delete multiple times"
  9. Change type to "Question"