/ Check-in [1ae70ad2]
Login

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);