en Copyright 2015 Java http://172.16.0.5:8080/history/sqlite-3.40.0/test/tkt-31338dca7e.test#21172c4c Add an optimization that attempts to run a subquery as a coroutine ratherthan manifesting it into a temporary table.FossilOrigin-Name: 7af3acbbd49a2114fcdada9ec907c68ba9b053bd List of files: /sqlite-3.40.0/test/tkt-31338dca7e.test Tue, 30 Oct 2012 00:29:07 +0000 drh <drh@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/test/tkt-31338dca7e.test#88501779 When analyzing the right-hand side of IN operators to see if the IN operatorcan work with an index, be sure to decend into nested subqueries.Fix for ticket [1a1308d2538d7]FossilOrigin-Name: 0156f10e23daca0e2504cd293a67ed0233d254d0 List of files: /sqlite-3.40.0/test/tkt-31338dca7e.test Fri, 16 Sep 2011 17:43:06 +0000 drh <drh@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/test/tkt-31338dca7e.test#7157e8ea Further streamlining of the subquery materializer. New test cases forticket [002caede898a]FossilOrigin-Name: ff8b76b25b42497a7374de56c6a8f34cbe70cd6a List of files: /sqlite-3.40.0/test/tkt-31338dca7e.test Fri, 16 Sep 2011 16:00:51 +0000 drh <drh@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/test/tkt-31338dca7e.test#4327aeaa Adding test case for ticket [002caede898]FossilOrigin-Name: 62dfc51a495be017605cf315d72e2db91bfa28f7 List of files: /sqlite-3.40.0/test/tkt-31338dca7e.test Thu, 15 Sep 2011 19:39:42 +0000 drh <drh@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/test/tkt-31338dca7e.test#c01a3c17 Ensure WHERE clause terms involving tables on the right end of a joinare not prematurely evaluated when tables on the left end of the joinmake use of the OR-clause optimization. Fix for ticket [31338dca7e].FossilOrigin-Name: 2c2de252666662f5459904fc33a9f2956cbff23c List of files: /sqlite-3.40.0/test/tkt-31338dca7e.test Wed, 16 Dec 2009 22:10:49 +0000 drh <drh@noemail.net>