1 files changed, 4 insertions, 0 deletions
diff --git a/src/delete.c b/src/delete.c
index 1a5edb59d..1d3162223 100644
--- a/src/delete.c
+++ b/src/delete.c
@@ -873,6 +873,10 @@ int sqlite3GenerateIndexKey(
   }
   if( regOut ){
     sqlite3VdbeAddOp3(v, OP_MakeRecord, regBase, nCol, regOut);
+    if( pIdx->pTable->pSelect ){
+      const char *zAff = sqlite3IndexAffinityStr(pParse->db, pIdx);
+      sqlite3VdbeChangeP4(v, -1, zAff, P4_TRANSIENT);
+    }
   }
   sqlite3ReleaseTempRange(pParse, regBase, nCol);
   return regBase;