/ Check-in [59814f35]
Login

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

Overview
Comment:Preupdate hook documentation fixes. No changes to code.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 59814f35d13db1f6379b9ae218b5432bc03c6197
User & Date: drh 2016-04-01 17:54:07
Context
2016-04-04
12:38
Fix harmless compiler warnings. check-in: 0213d6af user: drh tags: trunk
2016-04-03
20:45
Merge updates from trunk. check-in: 566b551e user: mistachkin tags: altShellFix
2016-04-01
17:54
Preupdate hook documentation fixes. No changes to code. check-in: 59814f35 user: drh tags: trunk
12:35
When reading an sqlite_stat1 table with missing entries for some indexes, set the default for the missing indexes after all other indexes are set so that the default values are more in line with indexes that are actually in the stat1 table. check-in: a62340dc user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/sqlite.h.in.

  5183   5183   /*
  5184   5184   ** CAPI3REF: Data Change Notification Callbacks
  5185   5185   ** METHOD: sqlite3
  5186   5186   **
  5187   5187   ** ^The sqlite3_update_hook() interface registers a callback function
  5188   5188   ** with the [database connection] identified by the first argument
  5189   5189   ** to be invoked whenever a row is updated, inserted or deleted in
  5190         -** a rowid table.
         5190  +** a [rowid table].
  5191   5191   ** ^Any callback set by a previous call to this function
  5192   5192   ** for the same database connection is overridden.
  5193   5193   **
  5194   5194   ** ^The second argument is a pointer to the function to invoke when a
  5195   5195   ** row is updated, inserted or deleted in a rowid table.
  5196   5196   ** ^The first argument to the callback is a copy of the third argument
  5197   5197   ** to sqlite3_update_hook().
................................................................................
  7913   7913   ** ^This function does not set the database handle error code or message
  7914   7914   ** returned by the [sqlite3_errcode()] and [sqlite3_errmsg()] functions.
  7915   7915   */
  7916   7916   int sqlite3_db_cacheflush(sqlite3*);
  7917   7917   
  7918   7918   /*
  7919   7919   ** CAPI3REF: The pre-update hook.
  7920         -** EXPERIMENTAL
  7921   7920   **
  7922   7921   ** ^These interfaces are only available if SQLite is compiled using the
  7923         -** [SQLITE_ENABLE_UPDATE_HOOK] compile-time option.
         7922  +** [SQLITE_ENABLE_PREUPDATE_HOOK] compile-time option.
  7924   7923   **
  7925   7924   ** ^The [sqlite3_preupdate_hook()] interface registers a callback function
  7926         -** that is invoked prior to each [INSERT], [UPDATE], and [DELETE] operation.
         7925  +** that is invoked prior to each [INSERT], [UPDATE], and [DELETE] operation
         7926  +** on a [rowid table].
  7927   7927   ** ^At most one preupdate hook may be registered at a time on a single
  7928   7928   ** [database connection]; each call to [sqlite3_preupdate_hook()] overrides
  7929   7929   ** the previous setting.
  7930   7930   ** ^The preupdate hook is disabled by invoking [sqlite3_preupdate_hook()]
  7931   7931   ** with a NULL pointer as the second parameter.
  7932   7932   ** ^The third parameter to [sqlite3_preupdate_hook()] is passed through as
  7933   7933   ** the first parameter to callbacks.
  7934   7934   **
  7935         -** ^The preupdate hook only fires for changes to real tables; the preupdate
  7936         -** hook is not invoked for changes to virtual tables.
         7935  +** ^The preupdate hook only fires for changes to [rowid tables]; the preupdate
         7936  +** hook is not invoked for changes to [virtual tables] or [WITHOUT ROWID]
         7937  +** tables.
  7937   7938   **
  7938   7939   ** ^The second parameter to the preupdate callback is a pointer to
  7939   7940   ** the [database connection] that registered the preupdate hook.
  7940   7941   ** ^The third parameter to the preupdate callback is one of the constants
  7941   7942   ** [SQLITE_INSERT], [SQLITE_DELETE], or [SQLITE_UPDATE] to indentify the
  7942   7943   ** kind of update operation that is about to occur.
  7943   7944   ** ^(The fourth parameter to the preupdate callback is the name of the