diff options
| author | drh <> | 2023-10-18 19:44:59 +0000 |
|---|---|---|
| committer | drh <> | 2023-10-18 19:44:59 +0000 |
| commit | 49dc1be96f76ce01325cdb2d8b475f25a51f3605 (patch) | |
| tree | 488c0dd1555a67a1378cfddb26874a764c8eef71 /src/expr.c | |
| parent | 0021079ceb4f0583ae66d66bac510cb1644ff149 (diff) | |
| download | sqlite-49dc1be96f76ce01325cdb2d8b475f25a51f3605.tar.gz sqlite-49dc1be96f76ce01325cdb2d8b475f25a51f3605.zip | |
Basic test cases.
FossilOrigin-Name: 6cccf86c362631ada0c6cbaf661520648f8bbf7ae2b137b3d7d959647387e5c2
Diffstat (limited to 'src/expr.c')
| -rw-r--r-- | src/expr.c | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/src/expr.c b/src/expr.c index dd543a98d..26f0b4c5c 100644 --- a/src/expr.c +++ b/src/expr.c @@ -6723,7 +6723,11 @@ static int analyzeAggregate(Walker *pWalker, Expr *pExpr){ pItem->pFunc = sqlite3FindFunction(pParse->db, pExpr->u.zToken, nArg, enc, 0); assert( pItem->bOBUnique==0 ); - if( pExpr->pLeft ){ + if( pExpr->pLeft + && (pItem->pFunc->funcFlags & SQLITE_FUNC_NEEDCOLL)==0 + ){ + /* The NEEDCOLL test above causes any ORDER BY clause on + ** aggregate min() or max() to be ignored. */ ExprList *pOBList; assert( nArg>0 ); assert( pExpr->pLeft->op==TK_ORDER ); |