commit 6cbb4c936c39acceb7a2181037f2d6e33badc32e
author drh <drh@noemail.net> Tue Jul 10 06:47:07 2018 +0000
committer drh <drh@noemail.net> Tue Jul 10 06:47:07 2018 +0000
tree cc0b9fb5a2f5f3d695bb0cc3ac935cbf792b4d68
parent a1fd4b520b11d19f93be6f3cd9dca6137486c0d0

Enhance the sqlite3ExprCompare() routine so that it knows to compare the
OVER clause of window functions.

FossilOrigin-Name: 0a7649afebc9349bf44a0e3588e81ab595ea85be1c70de08859ea76a7b271f62

src/expr.c

diff --git a/src/expr.c b/src/expr.c
index 24d1cb4..10a1dc6 100644
--- a/src/expr.c
+++ b/src/expr.c
@@ -4951,6 +4951,14 @@
       if( pA->iTable!=pB->iTable 
        && (pA->iTable!=iTab || NEVER(pB->iTable>=0)) ) return 2;
     }
+#ifndef SQLITE_OMIT_WINDOWFUNC
+    if( pA->pWin!=0 ){
+      if( pB->pWin==0 ) return 2;
+      if( sqlite3WindowCompare(pParse,pA->pWin,pB->pWin)!=0 ) return 2;
+    }else if( pB->pWin!=0 ){
+      return 2;
+    }
+#endif
   }
   return 0;
 }