/ Artifact [614870a83e]
Login

Artifact 614870a83e6b79cb97462eb5cea293864999a071db7c893a9ffeb07164720b9b:

Ticket change [614870a83e] - New ticket [510cde277783b5fb|510cde2777] <i>Endless loop on a query with window functions, ORDER BY, and LIMIT</i>. by drh 2018-09-17 14:28:12.
D 2018-09-17T14:28:12.461
J foundin 3.25.0
J icomment The\sfollowing\squery\shits\san\sassert()\sin\sthe\sbyte-code\sengine,\sor\sif\sassert()s\r\nare\sdisabled,\sgoes\sinto\san\sendless\sloop\sin\sthe\sbyte\scode.\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(id,\sb,\sc);\r\nINSERT\sINTO\st1\sVALUES(1,\s'A',\s'one');\r\nINSERT\sINTO\st1\sVALUES(2,\s'B',\s'two');\r\nINSERT\sINTO\st1\sVALUES(3,\s'C',\s'three');\r\nINSERT\sINTO\st1\sVALUES(4,\s'D',\s'one');\r\nINSERT\sINTO\st1\sVALUES(5,\s'E',\s'two');\r\nSELECT\sid,\sb,\slead(c,1)\sOVER(ORDER\sBY\sc)\sAS\sx\sFROM\st1\sWHERE\sid>1\sORDER\sBY\sb\sLIMIT\s1;\r\n</verbatim></blockquote>\r\n\r\nThis\sproblem\sappears\sto\shave\sbeen\sintroduced\sby\scheck-in\r\n[206720129ed2fa8875a2]\swhich\swas\sa\sfix\sfor\sticket\r\n[9936b2fa443fec03ff25]\swhich\swas\sthe\sprevious\sproblem\sof\san\r\nendless\sloop\sdue\sto\sthe\sORDER\sBY\sLIMIT\soptimization.
J login drh
J mimetype text/x-fossil-wiki
J severity Severe
J status Open
J title Endless\sloop\son\sa\squery\swith\swindow\sfunctions,\sORDER\sBY,\sand\sLIMIT
J type Code_Defect
K 510cde277783b5fb5de628393959849dff377eb3
U drh
Z 3b91c4f9f32482e2f065f6ba3e5fc152