commit 21172c4cc01c6b1fb34a1fa08e3ae8c6dfaae23a
author drh <drh@noemail.net> Tue Oct 30 00:29:07 2012 +0000
committer drh <drh@noemail.net> Tue Oct 30 00:29:07 2012 +0000
tree faa6b9e80bae102364b35477103f908999ba9315
parent 6e227bf3e0641c6eace29e5b198f82cf9344ed48

Add an optimization that attempts to run a subquery as a coroutine rather
than manifesting it into a temporary table.

FossilOrigin-Name: 7af3acbbd49a2114fcdada9ec907c68ba9b053bd

src/expr.c

diff --git a/src/expr.c b/src/expr.c
index 04216b1..3eee3c6 100644
--- a/src/expr.c
+++ b/src/expr.c
@@ -939,6 +939,7 @@
     pNewItem->addrFillSub = pOldItem->addrFillSub;
     pNewItem->regReturn = pOldItem->regReturn;
     pNewItem->isCorrelated = pOldItem->isCorrelated;
+    pNewItem->viaCoroutine = pOldItem->viaCoroutine;
     pNewItem->zIndex = sqlite3DbStrDup(db, pOldItem->zIndex);
     pNewItem->notIndexed = pOldItem->notIndexed;
     pNewItem->pIndex = pOldItem->pIndex;