Overview
| Artifact ID: | e5e514c8661fefed98ad28ee9ef1bdac450079f6 |
|---|---|
| Ticket: | 1eacbf5ad9c039a1b618d08c54dd52ce78bf501b
Trace showing single delete multiple times |
| User & Date: | anonymous 2019-01-31 16:25:39 |
Changes
- foundin changed to: "1.0.109.0"
- icomment:
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?
- login: "anonymous"
- mimetype: "text/x-fossil-plain"
- private_contact changed to: "fbc2ee1fa0e39445eea94a09fc3b60f6148a1d3e"
- severity changed to: "Minor"
- status changed to: "Open"
- title changed to: "Trace showing single delete multiple times"
- type changed to: "Question"