SQLite: Check-in [1ae70ad2]

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview

Comment:	Show the pointer address for Window objects in the TreeView display.
Downloads:	Tarball \| ZIP archive \| SQL archive
Timelines:	family \| ancestors \| descendants \| both \| trunk
Files:	files \| file ages \| folders
SHA3-256:	1ae70ad2ffd36c27b154940126c5e3ed00c05c0d8761d9320a65a03b1b4e4dc6
User & Date:	drh 2019-03-28 13:53:12

Context

2019-03-28
16:15		Prevent aliases of window functions expressions from being used as arguments to aggregate or other window functions. (check-in: 1e16d3e8 user: dan tags: trunk)
13:53		Show the pointer address for Window objects in the TreeView display. (check-in: 1ae70ad2 user: drh tags: trunk)
13:35		More improvements to TreeView output for Window objects: (1) Show when the frame-spec is implied rather than explicit. (2) Move the FILTER clause out from within the OVER clause, making it a sibling of the OVER clause, to match syntax. (check-in: d6a07433 user: drh tags: trunk)

Changes

Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/treeview.c.

   313    313     if( pWin->pFilter ){
   314    314       sqlite3TreeViewItem(pView, "FILTER", 1);
   315    315       sqlite3TreeViewExpr(pView, pWin->pFilter, 0);
   316    316       sqlite3TreeViewPop(pView);
   317    317     }
   318    318     pView = sqlite3TreeViewPush(pView, more);
   319    319     if( pWin->zName ){
   320         -    sqlite3TreeViewLine(pView, "OVER %s", pWin->zName);
          320  +    sqlite3TreeViewLine(pView, "OVER %s (%p)", pWin->zName, pWin);
   321    321     }else{
   322         -    sqlite3TreeViewLine(pView, "OVER");
          322  +    sqlite3TreeViewLine(pView, "OVER (%p)", pWin);
   323    323     }
   324    324     if( pWin->zBase )    nElement++;
   325    325     if( pWin->pOrderBy ) nElement++;
   326    326     if( pWin->eFrmType ) nElement++;
   327    327     if( pWin->eExclude ) nElement++;
   328    328     if( pWin->zBase ){
   329    329       sqlite3TreeViewPush(pView, (--nElement)>0);