diff options
| author | drh <> | 2022-04-22 16:15:48 +0000 |
|---|---|---|
| committer | drh <> | 2022-04-22 16:15:48 +0000 |
| commit | 67f70bea06eea1e20124c4e97d2f545b3f10b473 (patch) | |
| tree | 6244e193f3ff28fe9e7732438f332294f91855ec /src/treeview.c | |
| parent | 9b843f0ce0bae9a6a62edd0a006bcec436622cdf (diff) | |
| download | sqlite-67f70bea06eea1e20124c4e97d2f545b3f10b473.tar.gz sqlite-67f70bea06eea1e20124c4e97d2f545b3f10b473.zip | |
Honor the MATERIALIZED keyword on a common table expression by not flattening
the CTE into an outer query.
FossilOrigin-Name: 8d631a6b9eb06b54b10eda595a4c588ca38f909b4afa653b24d1f720b55d72f7
Diffstat (limited to 'src/treeview.c')
| -rw-r--r-- | src/treeview.c | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/treeview.c b/src/treeview.c index 3ba8a63cd..db73943f0 100644 --- a/src/treeview.c +++ b/src/treeview.c @@ -115,6 +115,10 @@ void sqlite3TreeViewWith(TreeView *pView, const With *pWith, u8 moreToFollow){ } sqlite3_str_appendf(&x, ")"); } + if( pCte->eM10d!=M10d_Any ){ + sqlite3_str_appendf(&x, " %sMATERIALIZED", + pCte->eM10d==M10d_No ? "NOT " : ""); + } if( pCte->pUse ){ sqlite3_str_appendf(&x, " (pUse=0x%p, nUse=%d)", pCte->pUse, pCte->pUse->nUse); |