Lines Matching defs:changes
563 ** features recently added to SQLite. We do not anticipate changes
564 ** to experimental interfaces but reserve the right to make minor changes
565 ** if experience from use "in the wild" suggest such changes are prudent.
572 ** The makefile makes some minor changes to this file (such as inserting
573 ** the version number) and changes its name to "sqlite3.h" as
749 ** thread safety, not any run-time changes to that setting made by
1313 ** of the sqlite3_vfs object changes in the transaction between
1644 ** changes to SQLite in order to tune SQLite to the specific needs of
1675 ** changes to a [database connection]. The interface is similar to
1676 ** [sqlite3_config()] except that the changes apply to a single
2089 ** and INSERT OR ABORT make no changes to the return value of this
2104 ** function is running and thus changes the last insert [rowid],
2117 ** ^(Only changes that are directly specified by the [INSERT], [UPDATE],
2118 ** or [DELETE] statement are counted. Auxiliary changes caused by
2120 ** [sqlite3_total_changes()] function to find the total number of changes
2121 ** including changes caused by triggers and foreign key actions.
2124 ** are not counted. Only real table changes are counted.
2130 ** mechanisms do not count as direct row changes.)^
2143 ** ^This function returns the number of direct row changes in the
2148 ** number of changes in the most recent INSERT, UPDATE, or DELETE
2151 ** changes in the most recently completed INSERT, UPDATE, or DELETE
2153 ** However, the number returned does not include changes
2157 ** [count_changes pragma], and the [changes() SQL function].
2159 ** If a separate thread makes changes on the same database connection
2168 ** ^This function returns the number of row changes caused by [INSERT],
2170 ** ^(The count returned by sqlite3_total_changes() includes all changes
2171 ** from all [CREATE TRIGGER | trigger] contexts and changes made by
2173 ** the count does not include changes used to implement [REPLACE] constraints,
2176 ** though if the INSTEAD OF trigger makes changes of its own, those changes
2178 ** ^The sqlite3_total_changes() function counts the changes as soon as
2185 ** If a separate thread makes changes on the same database connection
2305 ** changes will not fit into the in-memory cache. SQLite will
2313 ** forces an automatic rollback of the changes. See the
2702 ** not want the user to be able to make arbitrary changes to the
3189 ** ^If the database schema changes, instead of returning [SQLITE_SCHEMA] as it
3259 ** and only if the [prepared statement] X makes no direct changes to
3282 ** changes to the content of the database files on disk.
4282 ** the metadata when the corresponding function parameter changes
4360 ** ^The sqlite3_result_error_code() function changes the error code
4691 ** If another thread changes the autocommit status of the database
4913 ** changes in future releases of SQLite.
5430 ** rolled back by the expiration of the BLOB. Such changes will eventually
5491 ** ^(Closing the BLOB often forces the changes
5569 ** expiration of the handle, though of course those changes might
7324 ** the VDBE-level file format changes. The following macros define the
9061 ** have been filled out. If the schema changes, these column names might
9062 ** changes and so the view will need to be reset.
9129 ** The sqlite.nChange does not count changes within triggers and keeps no
9131 ** The sqlite.lsChange represents the number of changes made by the last
9134 ** context stack just like lastRowid so that the count of changes
9137 ** The sqlite.csChange keeps track of the number of current changes (since
9262 #define SQLITE_InternChanges 0x00000200 /* Uncommitted Hash table changes */
9709 ** fails and any prior changes from that one operation are backed out,
9712 ** changes due to the same operation are not backed out and no rollback
9731 #define OE_Abort 2 /* Back out changes but do no rollback transaction */
9732 #define OE_Fail 3 /* Stop the operation but leave all prior changes */
9739 #define OE_Cascade 9 /* Cascade the changes */
12335 int nChange; /* Statement changes (Vdbe.nChanges) */
12518 int nChange; /* Number of db changes made since last reset */
16778 int trace; /* True to trace changes */
17066 int trace; /* True to trace changes */
17234 ** and p->owner are equal if p->owner changes between two values
17277 ** and p->owner are equal if p->owner changes between two values
17403 int trace; /* True to trace changes */
24164 ** whenever any part of the database changes. An assertion fault will
24858 ** by making the following changes:
29670 ** changes the way database access is controlled by limiting access to a
31250 ** The following variable is (normally) set once and never changes
34811 ** ever changes to make the previous sentence incorrect.
36513 ** of the unsynced changes to a rollback journal are removed and the
36696 ** A rollback-mode pager changes to WRITER_FINISHED state from WRITER_DBMOD
37087 char dbFileVers[16]; /* Changes whenever database file changes */
37110 void (*xCodecSizeChng)(void*,int,int); /* Notify of page size changes */
38969 ** the state it was in before we started making changes.
39444 ** that snapshot for use by the reader in spite of concurrently changes by
39962 ** Make no changes if mxPage is zero or negative. And never reduce the
40604 ** test for the error state as a safeguard against future changes.
41263 ** Database changes is detected by looking at 15 bytes beginning
41869 ** making changes to a page. The caller must check the return value
42188 /* If no database changes have been made, return early. */
42359 ** updated to reflect the changes made by the current transaction and
42392 ** a hot-journal during hot-journal rollback, 0 changes will be made
42412 ** If a write transaction is open, then all changes made within the
42607 ** index iSavepoint. If it is SAVEPOINT_ROLLBACK, then rollback all changes
42664 ** not yet been opened. In this case there have been no changes to
43053 ** journalmode. Journalmode changes can only happen when the database
43301 ** database file. All changes to the database are recorded by writing
45456 ** If the database contents have changes since the previous read
47520 ** This function changes all write-locks held by Btree p into read-locks.
48926 ** the right size. This is to guard against size changes that result
49319 ** No changes are made if mxPage is 0 or negative.
49332 ** then make no changes. Always return the value of the secureDelete
49620 ** changes to the database. None of the following routines
50193 ** the disk. After the journal is safely on oxide, the changes to the
50540 ** the changes made by this write cursor would be visible to
52762 ** rollback, undoing any changes made to the parent page.
55324 ** invoked by the pager layer to report various state changes in
57643 ** few minor changes to the program.
57807 ** few minor changes to the program.
59176 ** has made changes and is in autocommit mode, then commit those
59177 ** changes. If a rollback is needed, then do the rollback.
59354 /* Rollback or commit any schema changes that occurred. */
60357 ** execution environment changes in a way that would alter the program
63133 ** then back out all changes that have occurred during this execution of the
63376 ** original and hence if the original changes so will the copy.
64021 ** persistent changes to registers P1 and P3.
64151 /* Undo any changes made by applyAffinity() to the input registers. */
65129 ** write transaction must be started before any changes can be made to the
65241 /* When the schema cookie changes, record the new cookie internally */
65245 /* Record changes in the file format */
65267 ** The cookie changes its value whenever the database schema changes.
66361 ** to guard against future changes to the code generator.
69635 ** expression node refer back to that source column. The following changes
69865 ** case, we need to return right away and not make any changes to
77241 ** if there were schema changes during the transaction or if a
77287 ** schema hash tables and therefore do not have to make any changes
77340 ** Table. No changes are made to disk by this routine.
78133 ** database changes. After each schema change, the cookie value
78134 ** changes. When a process first reads the schema it records the
78141 ** set back to prior value. But schema changes are infrequent
78629 ** to the elements of the FROM clause. But we do not want these changes
80376 ** can be checked before any changes are made to the database, it is never
81465 int count = (pParse->nested==0); /* True to count changes */
82159 ** Implementation of the changes() SQL function.
82161 ** IMP: R-62073-11209 The changes() SQL function is a wrapper
82163 ** rules for counting changes.
82165 static void changes(
83203 ** The array cannot be constant since changes are made to the
83249 FUNCTION(changes, 0, 0, 0, changes ),
83943 ** transactions are not able to rollback schema changes. */
85586 ** any ABORT Back out changes from the current command
85594 ** prior changes are retained.
86532 int (*changes)(sqlite3*);
86728 #define sqlite3_changes sqlite3_api->changes
87697 ** or changes one of the flags in db->flags. Return 1 if so and 0 if not.
87964 ** secure_delete flag. The second form changes the secure_delete
88245 ** the local value does not make changes to the disk file and the default
88360 ** the local value does not make changes to the disk file and the
89504 ** make no changes to pParse->rc.
89611 ** turn means that the other connection has made uncommitted changes
89615 ** schema changes and if those schema changes are subsequently rolled
89616 ** back and different changes are made in their place, then when this
91329 ** This routine changes the values of iLimit and iOffset only if
92410 ** changes to pExpr so that it refers directly to the source table
92486 ** execution. It returns 1 if it makes changes and 0 if no flattening
94054 /* Generate code that runs whenever the GROUP BY changes.
94056 ** block. If there were no changes, this block is skipped.
99512 ** original table changes and the index and table cannot both be used
107874 ** Return the number of changes in the most recent call to sqlite3_exec().
107881 ** Return the number of changes since the database handle was opened.
108989 ** Make no changes but still report the old value if the
109767 ** Make no changes if X==0. Return the value of the pending byte
116294 ** hash-table. Any changes made to the database are reverted by SQLite.