1 files changed, 4 insertions, 1 deletions
diff --git a/src/wherecode.c b/src/wherecode.c
index 7447fafb5..b9801407b 100644
--- a/src/wherecode.c
+++ b/src/wherecode.c
@@ -1903,8 +1903,11 @@ Bitmask sqlite3WhereCodeOneLoopStart(
         whereApplyPartialIndexConstraints(pIdx->pPartIdxWhere, iCur, pWC);
       }
     }else{
-      testcase( (pWInfo->wctrlFlags & WHERE_OR_SUBCLAUSE)==0 );
       testcase( pIdx->pPartIdxWhere );
+      /* The following assert() is not a requirement, merely an observation:
+      ** The OR-optimization doesn't work for the right hand table of
+      ** a LEFT JOIN: */
+      assert( (pWInfo->wctrlFlags & WHERE_OR_SUBCLAUSE)==0 );
     }
   
     /* Record the instruction used to terminate the loop. */