commit 094b2bbfc73f6e1847c0266cd4e6384e4b3e3607
author drh <drh@noemail.net> Wed Mar 13 18:54:07 2002 +0000
committer drh <drh@noemail.net> Wed Mar 13 18:54:07 2002 +0000
tree 2ad0acfd217ed739ad400f651c31efbc6f284f75
parent 56c0e926f15d826ad8f30398e1d5df2994b7c32b

Fix bug in anonymous subquery in a join.  Parser requires a semicolon or
end-of-input before executing. (CVS 429)

FossilOrigin-Name: c0e3f1c592f583a0659901743a368aff1927f1cb

src/expr.c

diff --git a/src/expr.c b/src/expr.c
index 58ed85a..793a44e 100644
--- a/src/expr.c
+++ b/src/expr.c
@@ -12,7 +12,7 @@
 ** This file contains routines used for analyzing expressions and
 ** for generating VDBE code that evaluates expressions in SQLite.
 **
-** $Id: expr.c,v 1.55 2002/03/06 03:08:26 drh Exp $
+** $Id: expr.c,v 1.56 2002/03/13 18:54:07 drh Exp $
 */
 #include "sqliteInt.h"
 
@@ -466,7 +466,7 @@
         }else{
           zTab = pTab->zName;
         }
-        if( sqliteStrICmp(zTab, zLeft)!=0 ) continue;
+        if( zTab==0 || sqliteStrICmp(zTab, zLeft)!=0 ) continue;
         if( 0==(cntTab++) ) pExpr->iTable = i + base;
         for(j=0; j<pTab->nCol; j++){
           if( sqliteStrICmp(pTab->aCol[j].zName, zRight)==0 ){