Artifact ef08d208efffd5eca35ee3d747f3a2cf6c6638d293f05576a1a482ffc9770c15:

Ticket change [ef08d208ef] - New ticket [256741a16be70df9|256741a16b] <i>null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...)</i>. by dan 2019-08-15 13:51:16.

---

D 2019-08-15T13:51:16.884
J icomment The\sfollowing\sscript:\r\n\r\n<verbatim>\r\n\s\sCREATE\sTABLE\st0(c0);\r\n\s\sINSERT\sINTO\st0(c0)\sVALUES\s(0);\r\n\s\sSELECT\s*\sFROM\st0\sWHERE\sEXISTS\s(SELECT\sMIN(c0)\s\sOVER\s(),\sCUME_DIST()\r\n\s\sOVER\s()\sFROM\st0)\sBETWEEN\s1\sAND\s1;\r\n</verbatim>\r\n\r\ncauses\sa\snull\spointer\sdereference.\r\n\r\nThis\sbug\swas\sdiscovered\sand\sreported\sby\sManuel\sRigger\s(user\smrigger).
J login dan
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title null\spointer\sdereference\scaused\sby\swindow\sfunctions\sin\sresult-set\sof\sEXISTS(SELECT\s...)
J type Code_Defect
K 256741a16be70df9c8d71f83f630592ee3879162
U dan
Z 2fa185c2e622df6bd3df6f0556d43672