diff options
| author | drh <> | 2025-06-02 18:34:17 +0000 |
|---|---|---|
| committer | drh <> | 2025-06-02 18:34:17 +0000 |
| commit | 342ef63e638e167ef16e8fff5bc109e2aa3de344 (patch) | |
| tree | 919267b137adde6511741fc14ed33399ce989216 /src/select.c | |
| parent | d84bbac8be02e81c32a52765c02dd17996ac3841 (diff) | |
| download | sqlite-342ef63e638e167ef16e8fff5bc109e2aa3de344.tar.gz sqlite-342ef63e638e167ef16e8fff5bc109e2aa3de344.zip | |
Improve the accuracy of affinity and collating sequence analysis for
NATURAL JOINs to the left of RIGHT JOINs where source tables are views
or subqueries. Initial problem report in
[forum:/forumpost/829306db47|forum post 829306db47].
FossilOrigin-Name: f184d1d236e47962658a4639d9533f67a525b74cfe0f06c93e9b85fdcd02a15f
Diffstat (limited to 'src/select.c')
| -rw-r--r-- | src/select.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/select.c b/src/select.c index 1525a4640..6c0e7c92d 100644 --- a/src/select.c +++ b/src/select.c @@ -631,7 +631,7 @@ static int sqlite3ProcessJoin(Parse *pParse, Select *p){ pFuncArgs = sqlite3ExprListAppend(pParse, pFuncArgs, pE1); pE1 = sqlite3ExprFunction(pParse, pFuncArgs, &tkCoalesce, 0); if( pE1 ){ - pE1->affExpr = sqlite3ExprAffinity(pFuncArgs->a[0].pExpr); + pE1->affExpr = SQLITE_AFF_DEFER; } } }else if( (pSrc->a[i+1].fg.jointype & JT_LEFT)!=0 && pParse->nErr==0 ){ |