1 files changed, 1 insertions, 0 deletions
diff --git a/src/delete.c b/src/delete.c
index c83ea9897..01a130d65 100644
--- a/src/delete.c
+++ b/src/delete.c
@@ -112,6 +112,7 @@ void sqlite3MaterializeView(
       sqlite3SelectDelete(db, pDup);
     }
     pDup = sqlite3SelectNew(pParse, 0, pFrom, pWhere, 0, 0, 0, 0, 0, 0);
+    if( pDup ) pDup->selFlags |= SF_Materialize;
   }
   sqlite3SelectDestInit(&dest, SRT_EphemTab, iCur);
   sqlite3Select(pParse, pDup, &dest);