Artifact
0e79b53b9999d83332cdf4657481f286b9dca55ff154db9cf61e76286bd3703d:
Ticket change
[0e79b53b]
- New ticket
[47b2581a] Infinite loop on UPDATE.
by
drh
2018-01-16 12:54:28.
D 2018-01-16T12:54:28.263
J foundin 3.21.0
J icomment The\sUPDATE\sat\sthe\send\sof\sthe\sfollowing\ssequence\sof\sSQL\sstatements\senters\r\nan\sinfinite\sloop.\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(a,b);\r\nCREATE\sINDEX\st1b\sON\st1(a);\r\nCREATE\sINDEX\st1c\sON\st1(b);\r\nINSERT\sINTO\st1\sVALUES(1,2);\r\nUPDATE\st1\sSET\sa\s=\sa+2\sWHERE\sa>0\sOR\sb>0;\r\n</verbatim></blockquote>\r\n\r\nBisecting\sshows\sthat\sthis\sproblem\swas\sintroduced\sby\sthe\ssingle-pass\supdate\r\noptimization\sof\scheck-in\s[7ae6104a3e0d1d2]\son\s2017-01-11\sand\sfirst\sreleased\r\nwith\sversion\s3.17.0.\s\sThe\sproblem\swas\sdiscovered\sby\sHarald\sKlimach\sand\s\r\nreported\son\sthe\sSQLite\smailing\slist.
J login drh
J mimetype text/x-fossil-wiki
J severity Severe
J status Open
J title Infinite\sloop\son\sUPDATE
J type Code_Defect
K 47b2581aa9bfececa7d95b2ef2aa433418c7a583
U drh
Z 63766ba5f8ac6512eb40a7de17040620