D 2012-11-02T13:51:11.251
J +comment \n\n<hr><i>drh\sadded\son\s2012-11-02\s13:51:11:</i><br>\nSimplified\stest\scase:\r\n\r\n<blockquote><pre>\r\nCREATE\sTABLE\st1\s(\r\n\s\sid1\sINTEGER\sPRIMARY\sKEY\sAUTOINCREMENT,\r\n\s\svalue1\sINTEGER\r\n);\r\nINSERT\sINTO\st1\sVALUES(4469,2),(4476,1);\r\nCREATE\sTABLE\st2\s(\r\n\s\sid2\sINTEGER\sPRIMARY\sKEY\sAUTOINCREMENT,\r\n\s\svalue2\sINTEGER\r\n);\r\nINSERT\sINTO\st2\sVALUES(0,1),(2,2);\r\nSELECT\r\n\s(SELECT\ssum(value2==xyz)\sFROM\st2)\r\nFROM\r\n\s(SELECT\scurr.value1\sas\sxyz\r\n\s\s\s\sFROM\st1\sAS\scurr\sLEFT\sJOIN\st1\sAS\sother\r\n\s\s\sGROUP\sBY\scurr.id1);\r\n</pre></blockquote>
K bfbf38e5e9956ac69f9491e5112636ff2ecef923
U drh
Z c5b79f91340a2d9160763d4d58f42d2f
|