/ Check-in [3dbed162]
Login

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

Overview
Comment:Extra comments on fields of the Window object.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 3dbed162518a73213bbfb137c763064518fdc2daeae3952cfab39ce0e6813d3f
User & Date: drh 2019-09-14 16:21:02
Context
2019-09-14
16:44
Add the --no-rowids option to the ".recover" command. check-in: 01d71b94 user: dan tags: trunk
16:21
Extra comments on fields of the Window object. check-in: 3dbed162 user: drh tags: trunk
00:21
Fix the windows inverse function on the JSON aggregates. check-in: f464d847 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/sqliteInt.h.

  3597   3597     Expr *pStart;           /* Expression for "<expr> PRECEDING" */
  3598   3598     Expr *pEnd;             /* Expression for "<expr> FOLLOWING" */
  3599   3599     Window **ppThis;        /* Pointer to this object in Select.pWin list */
  3600   3600     Window *pNextWin;       /* Next window function belonging to this SELECT */
  3601   3601     Expr *pFilter;          /* The FILTER expression */
  3602   3602     FuncDef *pFunc;         /* The function */
  3603   3603     int iEphCsr;            /* Partition buffer or Peer buffer */
  3604         -  int regAccum;
  3605         -  int regResult;
         3604  +  int regAccum;           /* Accumulator */
         3605  +  int regResult;          /* Interim result */
  3606   3606     int csrApp;             /* Function cursor (used by min/max) */
  3607   3607     int regApp;             /* Function register (also used by min/max) */
  3608   3608     int regPart;            /* Array of registers for PARTITION BY values */
  3609   3609     Expr *pOwner;           /* Expression object this window is attached to */
  3610   3610     int nBufferCol;         /* Number of columns in buffer table */
  3611   3611     int iArgCol;            /* Offset of first argument for this function */
  3612   3612     int regOne;             /* Register containing constant value 1 */
  3613   3613     int regStartRowid;
  3614   3614     int regEndRowid;
  3615         -  u8 bExprArgs;
         3615  +  u8 bExprArgs;           /* Defer evaluation of window function arguments
         3616  +                          ** due to the SQLITE_SUBTYPE flag */
  3616   3617   };
  3617   3618   
  3618   3619   #ifndef SQLITE_OMIT_WINDOWFUNC
  3619   3620   void sqlite3WindowDelete(sqlite3*, Window*);
  3620   3621   void sqlite3WindowUnlinkFromSelect(Window*);
  3621   3622   void sqlite3WindowListDelete(sqlite3 *db, Window *p);
  3622   3623   Window *sqlite3WindowAlloc(Parse*, int, int, Expr*, int , Expr*, u8);