diff options
| author | drh <> | 2022-04-22 17:36:10 +0000 |
|---|---|---|
| committer | drh <> | 2022-04-22 17:36:10 +0000 |
| commit | da653b897db2b7cc9cb636a5089860fa1520bf12 (patch) | |
| tree | 353077d457648fb182b590bfe328ee1bc68a6d1c /src/select.c | |
| parent | 67f70bea06eea1e20124c4e97d2f545b3f10b473 (diff) | |
| download | sqlite-da653b897db2b7cc9cb636a5089860fa1520bf12.tar.gz sqlite-da653b897db2b7cc9cb636a5089860fa1520bf12.zip | |
Improve EXPLAIN QUERY PLAN output and comments on bytecode listings by
distinguishing between "subquery" and "join" and using consistent names
across EQP and bytecode.
FossilOrigin-Name: a2d3ee92420ec564e31eb0005367cf7ff3d00bfaed5a98ffdbe17c91c95d9d97
Diffstat (limited to 'src/select.c')
| -rw-r--r-- | src/select.c | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/select.c b/src/select.c index 26a3172ae..5f2465da0 100644 --- a/src/select.c +++ b/src/select.c @@ -5555,8 +5555,10 @@ int sqlite3ExpandSubquery(Parse *pParse, SrcItem *pFrom){ pTab->nTabRef = 1; if( pFrom->zAlias ){ pTab->zName = sqlite3DbStrDup(pParse->db, pFrom->zAlias); + }else if( pSel->selFlags & SF_NestedFrom ){ + pTab->zName = sqlite3MPrintf(pParse->db, "(join-%u)", pSel->selId); }else{ - pTab->zName = sqlite3MPrintf(pParse->db, "subquery_%u", pSel->selId); + pTab->zName = sqlite3MPrintf(pParse->db, "(subquery-%u)", pSel->selId); } while( pSel->pPrior ){ pSel = pSel->pPrior; } sqlite3ColumnsFromExprList(pParse, pSel->pEList,&pTab->nCol,&pTab->aCol); |