From e3735bf466b8220d126ae7be4b4fc3482a997fdd Mon Sep 17 00:00:00 2001
From: dan <dan@noemail.net>
Date: Fri, 27 Dec 2019 19:46:07 +0000
Subject: Fix a problem involving window function aliases being referenced from
 sub-selects.

FossilOrigin-Name: e3b5fc05c00fc58be7a7c94ce1d97a5b05113f39aba03df64aab08364f85616b
---
 src/resolve.c | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'src/resolve.c')

diff --git a/src/resolve.c b/src/resolve.c
index ea8f00244..a0f9c0f22 100644
--- a/src/resolve.c
+++ b/src/resolve.c
@@ -459,7 +459,9 @@ static int lookupName(
             sqlite3ErrorMsg(pParse, "misuse of aliased aggregate %s", zAs);
             return WRC_Abort;
           }
-          if( (pNC->ncFlags&NC_AllowWin)==0 && ExprHasProperty(pOrig, EP_Win) ){
+          if( ExprHasProperty(pOrig, EP_Win)
+           && ((pNC->ncFlags&NC_AllowWin)==0 || pNC!=pTopNC )
+          ){
             sqlite3ErrorMsg(pParse, "misuse of aliased window function %s",zAs);
             return WRC_Abort;
           }
-- 
cgit v1.2.3