/ Check-in [4c0ba8be]
Login

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

Overview
Comment:Remove an unused #define from whereInt.h. Add comments describing the new sqlite3BtreeCursor() flags.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | btree-fordelete-flag
Files: files | file ages | folders
SHA1: 4c0ba8be43bb7c7100456bd8cd6921c164be31e1
User & Date: dan 2015-10-23 11:50:23
Context
2015-10-26
17:50
Provide the BTREE_FORDELETE flag to sqlite3BtreeCursor() if the cursor will be used only for deletions and seeking. check-in: 871b1c78 user: drh tags: trunk
16:31
Test that the binary record "0x01 0x00" is interpreted by OP_Column as a vector of NULL (or default) values. check-in: 5bdc3c82 user: dan tags: btree-fordelete-flag
2015-10-23
11:50
Remove an unused #define from whereInt.h. Add comments describing the new sqlite3BtreeCursor() flags. check-in: 4c0ba8be user: dan tags: btree-fordelete-flag
2015-10-22
20:54
Modifications to pass a flag to internal routine sqlite3BtreeCursor() when a cursor that is used solely for deleting b-tree entries, or for obtaining the components of keys to delete from other b-trees, is opened. check-in: cdc92919 user: dan tags: btree-fordelete-flag
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/btree.h.

   163    163   **
   164    164   */
   165    165   #define BTREE_BULKLOAD 0x00000001  /* Used to full index in sorted order */
   166    166   #define BTREE_SEEK_EQ  0x00000002  /* EQ seeks only - no range seeks */
   167    167   
   168    168   /* 
   169    169   ** Flags passed as the third argument to sqlite3BtreeCursor().
          170  +**
          171  +** For read-only cursors the wrFlag argument is always zero. For read-write
          172  +** cursors it may be set to either (BTREE_WRCSR|BTREE_FORDELETE) or
          173  +** (BTREE_WRCSR). If the BTREE_FORDELETE flag is set, then the cursor will
          174  +** only be used by SQLite for the following:
          175  +**
          176  +**   * to seek to and delete specific entries, and/or
          177  +**
          178  +**   * to read values that will be used to create keys that other
          179  +**     BTREE_FORDELETE cursors will seek to and delete.
   170    180   */
   171         -#define BTREE_WRCSR     0x00000004  /* read-write cursor */
   172         -#define BTREE_FORDELETE 0x00000008  /* Cursor is for seek/delete only */
          181  +#define BTREE_WRCSR     0x00000004     /* read-write cursor */
          182  +#define BTREE_FORDELETE 0x00000008     /* Cursor is for seek/delete only */
   173    183   
   174    184   int sqlite3BtreeCursor(
   175    185     Btree*,                              /* BTree containing table to open */
   176    186     int iTable,                          /* Index of root page */
   177    187     int wrFlag,                          /* 1 for writing.  0 for read-only */
   178    188     struct KeyInfo*,                     /* First argument to compare function */
   179    189     BtCursor *pCursor                    /* Space to write cursor structure */

Changes to src/whereInt.h.

   526    526   #define WHERE_IN_ABLE      0x00000800  /* Able to support an IN operator */
   527    527   #define WHERE_ONEROW       0x00001000  /* Selects no more than one row */
   528    528   #define WHERE_MULTI_OR     0x00002000  /* OR using multiple indices */
   529    529   #define WHERE_AUTO_INDEX   0x00004000  /* Uses an ephemeral index */
   530    530   #define WHERE_SKIPSCAN     0x00008000  /* Uses the skip-scan algorithm */
   531    531   #define WHERE_UNQ_WANTED   0x00010000  /* WHERE_ONEROW would have been helpful*/
   532    532   #define WHERE_PARTIALIDX   0x00020000  /* The automatic index is partial */
   533         -#define WHERE_FORDELETE    0x00040000  /* Table cursor is "for-delete" */