Initial implementation of LEFT OUTER JOIN including the expanded SQL92 join

syntax. The basic functionality is there but there is still a lot of testing
to do. (CVS 587)

FossilOrigin-Name: 99bd1f5b9a1a20bfeefe15c00d96a34a5f40923e

1 files changed, 4 insertions, 11 deletions

diff --git a/src/trigger.c b/src/trigger.c
index d53dff219..48e7ecf79 100644
--- a/src/trigger.c
+++ b/src/trigger.c
@@ -388,18 +388,11 @@ void sqliteDropTrigger(Parse *pParse, Token *pName, int nested)
 ** if there is no match.
 */
 static int checkColumnOverLap(IdList *pIdList, ExprList *pEList){
-  int i, e;
-  if( !pIdList )return 1;
-  if( !pEList )return 1;
-
-  for(i = 0; i < pIdList->nId; i++){ 
-    for(e = 0; e < pEList->nExpr; e++){ 
-      if( !sqliteStrICmp(pIdList->a[i].zName, pEList->a[e].zName) ){
-        return 1;
-      }
-    }
+  int e;
+  if( !pIdList || !pEList ) return 1;
+  for(e=0; e<pEList->nExpr; e++){
+    if( sqliteIdListIndex(pIdList, pEList->a[e].zName)>=0 ) return 1;
   }
-
   return 0; 
 }