SQLite
Artifact Content
Not logged in

Artifact cabcf4a364788b08384123240aaf412db4493c93:

Ticket change [cabcf4a364] - Ticket [bfbf38e5e9956ac69f9491e5112636ff2ecef923|bfbf38e5e9] Segfault on a nested join status still Open with 1 other change by drh 2012-11-02 15:14:42.
D 2012-11-02T15:14:42.502
J +comment \n\n<hr><i>drh\sadded\son\s2012-11-02\s15:14:42:</i><br>\nAn\seven\ssimpler\sdemonstration\sthat\somits\sthe\ssubquery\sin\sthe\sFROM\sclause:\r\n\r\n<blockquote><pre>\r\nCREATE\sTABLE\st1(id1,\svalue1);\r\nINSERT\sINTO\st1\sVALUES(4469,2),(4469,1);\r\nCREATE\sTABLE\st2\s(value2);\r\nINSERT\sINTO\st2\sVALUES(1);\r\nSELECT\s(SELECT\ssum(value2=value1)\sFROM\st2),\smax(value1)\r\n\s\sFROM\st1\r\n\sGROUP\sBY\sid1;\r\n</pre></blockquote>
K bfbf38e5e9956ac69f9491e5112636ff2ecef923
U drh
Z 2e7e79479ef94f66e6f99003810a7a8f