System.Data.SQLite
Artifact Content
Not logged in

Artifact e5e514c8661fefed98ad28ee9ef1bdac450079f6:

Ticket change [e5e514c866] - New ticket [1eacbf5ad9] Trace showing single delete multiple times. by anonymous 2019-01-31 16:25:39.
D 2019-01-31T16:25:39.546
J foundin 1.0.109.0
J icomment I\sregistered\sthe\sTrace\sevent\sof\sthe\sSQLiteConnection.\s\r\nFor\sinsert\sand\supdate\sstatements,\sit\sis\striggered\sone\stime\sper\sstatement.\r\nFor\sdelete,\sit\sis\scalled\smultiple\stimes.\r\n\r\nI\sfound\sout\sthat\sit\sseems\sto\sbe\srelated\swith\sforeign\skeys.\sIf\sthey\sare\senabled,\sand\sanother\stable\shas\sa\sforeign\skey\sreference\sto\sthis\stable,\sthe\sTrace\sis\scalled\smultiple\stimes,\seven\sif\scascading\sdoes\snot\sdelete\sanything\sin\sthe\sother\stable.\sThe\sstatement\sshown\sin\sthe\sTraceEventArgs\sis\salways\sthe\ssame\s(e.g.\s"DELETE\sFROM\sTableX\sWHERE\sID\s=\s1").\r\n\r\nI\sfind\sthis\sa\sbit\sconfusing,\sespecially\ssince\sI\sdid\snot\sfind\sany\sdocumentation\sabout\sthis.\r\nIs\sthis\sbehaviour\sintended?
J login anonymous
J mimetype text/x-fossil-plain
J private_contact fbc2ee1fa0e39445eea94a09fc3b60f6148a1d3e
J severity Minor
J status Open
J title Trace\sshowing\ssingle\sdelete\smultiple\stimes
J type Question
K 1eacbf5ad9c039a1b618d08c54dd52ce78bf501b
U anonymous
Z 63f058627ea45d375c829fb370c47c25