commit c8f8b632c321f93cdf78f40b26fc98bb02ad32e3
author drh <drh@noemail.net> Mon Sep 30 12:36:26 2002 +0000
committer drh <drh@noemail.net> Mon Sep 30 12:36:26 2002 +0000
tree fb15bbbf2dc1fdfde944eb4b3eaadfff3987b9e7
parent 294fb92b502ba097ad52098b8e8ee0ccc9e1876d

Fix a bug in the left outer join logic. (CVS 758)

FossilOrigin-Name: 6c0f44bd6374010f7a4a091e585eb36e0665f96f

src/where.c

diff --git a/src/where.c b/src/where.c
index 96d476e..0e893a1 100644
--- a/src/where.c
+++ b/src/where.c
@@ -13,7 +13,7 @@
 ** the WHERE clause of SQL statements.  Also found here are subroutines
 ** to generate VDBE code to evaluate expressions.
 **
-** $Id: where.c,v 1.64 2002/08/28 03:01:01 drh Exp $
+** $Id: where.c,v 1.65 2002/09/30 12:36:26 drh Exp $
 */
 #include "sqliteInt.h"
 
@@ -425,6 +425,7 @@
     ** form ROWID<expr or ROWID<=expr set iDirectLt[i] to the term index.
     ** For terms like ROWID>expr or ROWID>=expr set iDirectGt[i].
     */
+    pWInfo->a[i].iCur = -1;
     iDirectEq[i] = -1;
     iDirectLt[i] = -1;
     iDirectGt[i] = -1;
@@ -577,8 +578,6 @@
     if( pBestIdx ){
       pWInfo->a[i].iCur = pParse->nTab++;
       pWInfo->peakNTab = pParse->nTab;
-    }else{
-      pWInfo->a[i].iCur = -1;
     }
   }