From a76ac88af86bb5a3753b7fec6c86bfcfaf64f439 Mon Sep 17 00:00:00 2001
From: drh <>
Date: Fri, 8 Apr 2022 19:20:12 +0000
Subject: Preliminary code to support RIGHT JOIN. Everything seems to work,
 except that the code to compute the unmatched rows for the RIGHT JOIN has not
 yet been added, so the result of a RIGHT JOIN is currently the same as an
 INNER JOIN.

FossilOrigin-Name: 415abd6731b8e8a605adabfa6066c8a852a8531c300df41325d5f7e75cae5a70
---
 src/treeview.c | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

(limited to 'src/treeview.c')

diff --git a/src/treeview.c b/src/treeview.c
index 91aff8ddf..f32064cd8 100644
--- a/src/treeview.c
+++ b/src/treeview.c
@@ -144,8 +144,12 @@ 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");
     }
-- 
cgit v1.2.3


From 8a28ce7bc217871f58e0ce71aa207bbcaf1b338e Mon Sep 17 00:00:00 2001
From: drh <>
Date: Mon, 11 Apr 2022 00:54:30 +0000
Subject: Show the JT_LTORJ flag in TreeView debugging output.

FossilOrigin-Name: 21eb44919f38abad30b75181ca8aec38b453b94dba2815caf7e946e07faa40d7
---
 src/treeview.c | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'src/treeview.c')

diff --git a/src/treeview.c b/src/treeview.c
index f32064cd8..d2ccb545b 100644
--- a/src/treeview.c
+++ b/src/treeview.c
@@ -153,6 +153,9 @@ void sqlite3TreeViewSrcList(TreeView *pView, const SrcList *pSrc){
     }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");
     }
-- 
cgit v1.2.3