diff options
| author | drh <> | 2022-04-13 12:34:54 +0000 |
|---|---|---|
| committer | drh <> | 2022-04-13 12:34:54 +0000 |
| commit | 94e615a6acf3a1519d98e85a6665c712edb5ea8a (patch) | |
| tree | e163e2a1f8ce85dbbcbe67a247b103f689c5f85d /src/treeview.c | |
| parent | 3b79f7580a30e7a49962e9a2538498c65227a4d7 (diff) | |
| parent | 12c35ec322dc2b394a3a6d8b3997ef60574414a0 (diff) | |
| download | sqlite-94e615a6acf3a1519d98e85a6665c712edb5ea8a.tar.gz sqlite-94e615a6acf3a1519d98e85a6665c712edb5ea8a.zip | |
Add support for RIGHT and FULL OUTER JOINs.
FossilOrigin-Name: fa9d206f904280e3eafc6f4ba6c0c7325948364c62eeeb9f0fdc5825d622ec35
Diffstat (limited to 'src/treeview.c')
| -rw-r--r-- | src/treeview.c | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/src/treeview.c b/src/treeview.c index c3ecdefef..459316190 100644 --- a/src/treeview.c +++ b/src/treeview.c @@ -144,11 +144,18 @@ void sqlite3TreeViewSrcList(TreeView *pView, const SrcList *pSrc){ sqlite3_str_appendf(&x, " tab=%Q nCol=%d ptr=%p used=%llx", pItem->pTab->zName, pItem->pTab->nCol, pItem->pTab, pItem->colUsed); } - if( pItem->fg.jointype & JT_LEFT ){ + if( (pItem->fg.jointype & (JT_LEFT|JT_RIGHT))==(JT_LEFT|JT_RIGHT) ){ + sqlite3_str_appendf(&x, " FULL-OUTER-JOIN"); + }else if( pItem->fg.jointype & JT_LEFT ){ sqlite3_str_appendf(&x, " LEFT-JOIN"); + }else if( pItem->fg.jointype & JT_RIGHT ){ + sqlite3_str_appendf(&x, " RIGHT-JOIN"); }else if( pItem->fg.jointype & JT_CROSS ){ sqlite3_str_appendf(&x, " CROSS-JOIN"); } + if( pItem->fg.jointype & JT_LTORJ ){ + sqlite3_str_appendf(&x, " LTORJ"); + } if( pItem->fg.fromDDL ){ sqlite3_str_appendf(&x, " DDL"); } |