/ Check-in [2783762433]
Login

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

Overview
Comment:Improvements to the documentation for SQLITE_FCNTL_DATA_VERSION. No changes to code.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 27837624336d2883f721310bd4dceedb77085d1008af5e12557f634936d48b8c
User & Date: drh 2018-09-12 14:28:45
Context
2018-09-12
15:51
Restrict the scope of internal-use functions in alter.c. check-in: 4396914f8e user: drh tags: trunk
14:28
Improvements to the documentation for SQLITE_FCNTL_DATA_VERSION. No changes to code. check-in: 2783762433 user: drh tags: trunk
08:51
Fix an invalid pointer comparison triggered by renaming a table column when there are views with explicit column names in the schema. check-in: 572de7e4e3 user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/sqlite.h.in.

  1078   1078   **
  1079   1079   ** <li>[[SQLITE_FCNTL_DATA_VERSION]]
  1080   1080   ** The [SQLITE_FCNTL_DATA_VERSION] opcode is used to detect changes to
  1081   1081   ** a database file.  The argument is a pointer to a 32-bit unsigned integer.
  1082   1082   ** The "data version" for the pager is written into the pointer.  The
  1083   1083   ** "data version" changes whenever any change occurs to the corresponding
  1084   1084   ** database file, either through SQL statements on the same database
  1085         -** connection, or through transactions committed by separate database
         1085  +** connection or through transactions committed by separate database
  1086   1086   ** connections possibly in other processes. The [sqlite3_total_changes()]
  1087   1087   ** interface can be used to find if any database on the connection has changed,
  1088         -** but that interface response to changes on TEMP as well as MAIN and does
         1088  +** but that interface responds to changes on TEMP as well as MAIN and does
  1089   1089   ** not provide a mechanism to detect changes to MAIN only.  Also, the
  1090         -** [sqlite3_total_changes()] interface response to internal changes only and
         1090  +** [sqlite3_total_changes()] interface responds to internal changes only and
  1091   1091   ** omits changes made by other database connections.  The
  1092   1092   ** [PRAGMA data_version] command provide a mechanism to detect changes to
  1093   1093   ** a single attached database that occur due to other database connections,
  1094         -** but omits changes implemented by the database connection for which it is
         1094  +** but omits changes implemented by the database connection on which it is
  1095   1095   ** called.  This file control is the only mechanism to detect changes that
  1096         -** happen either internally or externally on a single database.
         1096  +** happen either internally or externally and that are associated with
         1097  +** a particular attached database.
  1097   1098   ** </ul>
  1098   1099   */
  1099   1100   #define SQLITE_FCNTL_LOCKSTATE               1
  1100   1101   #define SQLITE_FCNTL_GET_LOCKPROXYFILE       2
  1101   1102   #define SQLITE_FCNTL_SET_LOCKPROXYFILE       3
  1102   1103   #define SQLITE_FCNTL_LAST_ERRNO              4
  1103   1104   #define SQLITE_FCNTL_SIZE_HINT               5