diff options
| author | drh <drh@noemail.net> | 2013-05-16 01:02:45 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2013-05-16 01:02:45 +0000 |
| commit | 58a450c04105bd9d9126e9f80d706ee0a366821a (patch) | |
| tree | 87fa9b575001c7cc7ce8c225355b9ce7c8a01de2 /src/resolve.c | |
| parent | 06006633466be537deb9d6a4edc927e72a0e7bc4 (diff) | |
| download | sqlite-58a450c04105bd9d9126e9f80d706ee0a366821a.tar.gz sqlite-58a450c04105bd9d9126e9f80d706ee0a366821a.zip | |
Treat identifiers in the HAVING clause the same as in the WHERE clause.
Only consider AS names from the result set to match if there are no other
matches. Continuation of the fix for [2500cdb9be05]. This check-in
fixes a bug found by [http://www.sqlite.org/sqllogictest/ | SqlLogicTest]
during release testing for version 3.7.17.
FossilOrigin-Name: 9ffff3d05226bbd01a0745dd0a511776358253c0
Diffstat (limited to 'src/resolve.c')
| -rw-r--r-- | src/resolve.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/resolve.c b/src/resolve.c index a8e196926..91efcaa1a 100644 --- a/src/resolve.c +++ b/src/resolve.c @@ -1159,8 +1159,8 @@ static int resolveSelectStep(Walker *pWalker, Select *p){ ** re-evaluated for each reference to it. */ sNC.pEList = p->pEList; - if( sqlite3ResolveExprNames(&sNC, p->pHaving) ) return WRC_Abort; sNC.ncFlags |= NC_AsMaybe; + if( sqlite3ResolveExprNames(&sNC, p->pHaving) ) return WRC_Abort; if( sqlite3ResolveExprNames(&sNC, p->pWhere) ) return WRC_Abort; sNC.ncFlags &= ~NC_AsMaybe; |