Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|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|
|User & Date:||drh 2018-09-12 14:28:45|
|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 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