More aggressive optimization of addrHalt for RIGHT JOIN.

FossilOrigin-Name: 5e51d1c0dfcafef9e71c99de3f626dee157c935724b84c6e0c630299a880446f

1 files changed, 0 insertions, 11 deletions

diff --git a/src/wherecode.c b/src/wherecode.c
index c5fa7a213..cc672aa83 100644
--- a/src/wherecode.c
+++ b/src/wherecode.c
@@ -1545,17 +1545,6 @@ Bitmask sqlite3WhereCodeOneLoopStart(
     VdbeComment((v, "init LEFT JOIN match flag"));
   }
 
-#ifdef SQLITE_DEBUG
-  /* Re-compute the address to jump to if we discover that the table for
-  ** this loop is empty and can never contribute content.  Verify that the
-  ** computation here agrees with the one in sqlite3WhereBegin(). */
-  for(j=iLevel; j>0; j--){
-    if( pWInfo->a[j].iLeftJoin ) break;
-    if( pWInfo->a[j].pRJ ) break;
-  }
-  assert( pWInfo->a[j].addrBrk==pLevel->addrHalt );
-#endif
-
   /* Special case of a FROM clause subquery implemented as a co-routine */
   if( pTabItem->fg.viaCoroutine ){
     int regYield;