SQLite

Artifact [62ed131e]
Login

Artifact 62ed131e6031d3af5e1268334b5c97da52a2ed94:

Ticket change [62ed131e] - Ticket [bfbf38e5] Segfault on a nested join status still Open with 1 other change by drh 2012-11-02 14:43:51.
D 2012-11-02T14:43:51.662
J +comment \n\n<hr><i>drh\sadded\son\s2012-11-02\s14:43:51:</i><br>\nHere\sis\sanother\ssimplification\sof\sthe\sscript\sthat\savoids\sthe\suse\sof\sLEFT\sJOIN\sand\ssilly\sconstructs\slike\sa\sGROUP\sBY\son\sa\sPRIMARY\sKEY:\r\n\r\n<blockquote><pre>\r\nCREATE\sTABLE\st1\s(\r\n\s\sid1\sINTEGER,\r\n\s\svalue1\sINTEGER,\r\n\s\sx1\sINTEGER\r\n);\r\nINSERT\sINTO\st1\sVALUES(4469,2,98),(4469,1,99),(4469,3,97);\r\nCREATE\sTABLE\st2\s(\r\n\s\svalue2\sINTEGER\r\n);\r\nINSERT\sINTO\st2\sVALUES(1);\r\npragma\svdbe_listing=on;\spragma\svdbe_trace=on;\r\nSELECT\r\n\s(SELECT\ssum(value2==xyz)\sFROM\st2)\r\nFROM\r\n\s(SELECT\svalue1\sas\sxyz,\smax(x1)\sAS\spqr\r\n\s\s\s\sFROM\st1\r\n\s\s\sGROUP\sBY\sid1);\r\n</pre></blockquote>
K bfbf38e5e9956ac69f9491e5112636ff2ecef923
U drh
Z 0a90d9895f667eb85f46bf66e036d28d