Lines Matching defs:changes
135 ** features recently added to SQLite. We do not anticipate changes
136 ** to experimental interfaces but reserve the right to make minor changes
137 ** if experience from use "in the wild" suggest such changes are prudent.
144 ** The makefile makes some minor changes to this file (such as inserting
145 ** the version number) and changes its name to "sqlite3.h" as
321 ** thread safety, not any run-time changes to that setting made by
1111 ** of the sqlite3_vfs object changes in the transaction between
1444 ** changes to SQLite in order to tune SQLite to the specific needs of
1475 ** changes to a [database connection]. The interface is similar to
1476 ** [sqlite3_config()] except that the changes apply to a single
1967 ** and INSERT OR ABORT make no changes to the return value of this
1982 ** function is running and thus changes the last insert [rowid],
1995 ** ^(Only changes that are directly specified by the [INSERT], [UPDATE],
1996 ** or [DELETE] statement are counted. Auxiliary changes caused by
1998 ** [sqlite3_total_changes()] function to find the total number of changes
1999 ** including changes caused by triggers and foreign key actions.
2002 ** are not counted. Only real table changes are counted.
2008 ** mechanisms do not count as direct row changes.)^
2021 ** ^This function returns the number of direct row changes in the
2026 ** number of changes in the most recent INSERT, UPDATE, or DELETE
2029 ** changes in the most recently completed INSERT, UPDATE, or DELETE
2031 ** However, the number returned does not include changes
2035 ** [count_changes pragma], and the [changes() SQL function].
2037 ** If a separate thread makes changes on the same database connection
2046 ** ^This function returns the number of row changes caused by [INSERT],
2048 ** ^(The count returned by sqlite3_total_changes() includes all changes
2049 ** from all [CREATE TRIGGER | trigger] contexts and changes made by
2051 ** the count does not include changes used to implement [REPLACE] constraints,
2054 ** though if the INSTEAD OF trigger makes changes of its own, those changes
2056 ** ^The sqlite3_total_changes() function counts the changes as soon as
2063 ** If a separate thread makes changes on the same database connection
2577 ** not want the user to be able to make arbitrary changes to the
3263 ** ^If the database schema changes, instead of returning [SQLITE_SCHEMA] as it
3333 ** and only if the [prepared statement] X makes no direct changes to
3356 ** changes to the content of the database files on disk.
4418 ** <li> when the corresponding function parameter changes, or
4503 ** ^The sqlite3_result_error_code() function changes the error code
4913 ** If another thread changes the autocommit status of the database
5182 ** changes in future releases of SQLite.
5740 ** rolled back by the expiration of the BLOB. Such changes will eventually
5804 ** ^(Closing the BLOB often forces the changes
5882 ** expiration of the handle, though of course those changes might
8400 ** the VDBE-level file format changes. The following macros define the
10373 ** have been filled out. If the schema changes, these column names might
10374 ** changes and so the view will need to be reset.
10553 #define SQLITE_InternChanges 0x00000002 /* Uncommitted Hash table changes */
10580 #define SQLITE_QueryOnly 0x02000000 /* Disable database changes */
11049 ** fails and any prior changes from that one operation are backed out,
11052 ** changes due to the same operation are not backed out and no rollback
11071 #define OE_Abort 2 /* Back out changes but do no rollback transaction */
11072 #define OE_Fail 3 /* Stop the operation but leave all prior changes */
11079 #define OE_Cascade 9 /* Cascade the changes */
14006 int nChange; /* Statement changes (Vdbe.nChanges) */
14205 int nChange; /* Number of db changes made since last reset */
18779 int trace; /* True to trace changes */
18953 ** and p->owner are equal if p->owner changes between two values
18996 ** and p->owner are equal if p->owner changes between two values
19413 volatile int trace; /* True to trace changes */
24287 ** whenever any part of the database changes. An assertion fault will
25118 ** by making the following changes:
30549 ** changes the way database access is controlled by limiting access to a
32404 ** The following variable is (normally) set once and never changes
33196 ** be returned and no changes will be made to the Win32 native heap.
38470 ** ever changes to make the previous sentence incorrect.
40349 ** of the unsynced changes to a rollback journal are removed and the
40532 ** A rollback-mode pager changes to WRITER_FINISHED state from WRITER_DBMOD
40932 char dbFileVers[16]; /* Changes whenever database file changes */
40960 void (*xCodecSizeChng)(void*,int,int); /* Notify of page size changes */
42878 ** the state it was in before we started making changes.
43369 ** that snapshot for use by the reader in spite of concurrently changes by
43935 ** Make no changes if mxPage is zero or negative. And never reduce the
44672 ** test for the error state as a safeguard against future changes.
45400 ** Database changes is detected by looking at 15 bytes beginning
46043 ** making changes to a page. The caller must check the return value
46372 /* If no database changes have been made, return early. */
46512 ** updated to reflect the changes made by the current transaction and
46545 ** a hot-journal during hot-journal rollback, 0 changes will be made
46565 ** If a write transaction is open, then all changes made within the
46787 ** index iSavepoint. If it is SAVEPOINT_ROLLBACK, then rollback all changes
46844 ** not yet been opened. In this case there have been no changes to
47261 ** journalmode. Journalmode changes can only happen when the database
47521 ** database file. All changes to the database are recorded by writing
49760 ** If the database contents have changes since the previous read
51978 ** This function changes all write-locks held by Btree p into read-locks.
53433 ** the right size. This is to guard against size changes that result
53869 ** No changes are made if mxPage is 0 or negative.
53882 ** then make no changes. Always return the value of the BTS_SECURE_DELETE
54214 ** changes to the database. None of the following routines
54810 ** the disk. After the journal is safely on oxide, the changes to the
55142 ** the changes made by this write cursor would be visible to
57483 ** rollback, undoing any changes made to the parent page.
60145 ** invoked by the pager layer to report various state changes in
62840 ** few minor changes to the program.
63006 ** few minor changes to the program.
64502 ** has made changes and is in autocommit mode, then commit those
64503 ** changes. If a rollback is needed, then do the rollback.
66288 ** execution environment changes in a way that would alter the program
68878 ** then back out all changes that have occurred during this execution of the
69211 ** original and hence if the original changes so will the copy.
69876 ** persistent changes to registers P1 and P3.
70027 /* Undo any changes made by applyAffinity() to the input registers. */
71043 ** active statements. A statement transaction allows the changes made by this
71050 ** The cookie changes its value whenever the database schema changes.
71193 /* When the schema cookie changes, record the new cookie internally */
71197 /* Record changes in the file format */
72259 ** to guard against future changes to the code generator.
76181 ** roll back changes made to the internal page-cache before this
76975 ** expression node refer back to that source column. The following changes
77235 ** case, we need to return right away and not make any changes to
84450 int nColTest; /* Number of columns to test for changes */
86659 ** Table. No changes are made to disk by this routine.
87524 ** database changes. After each schema change, the cookie value
87525 ** changes. When a process first reads the schema it records the
87532 ** set back to prior value. But schema changes are infrequent
88214 ** to the elements of the FROM clause. But we do not want these changes
90010 ** can be checked before any changes are made to the database, it is never
91359 int count = (pParse->nested==0); /* True to count changes */
92210 ** Implementation of the changes() SQL function.
92212 ** IMP: R-62073-11209 The changes() SQL function is a wrapper
92214 ** rules for counting changes.
92216 static void changes(
93342 ** The array cannot be constant since changes are made to the
93394 VFUNCTION(changes, 0, 0, 0, changes ),
94171 ** transactions are not able to rollback schema changes.
95901 ** any ABORT Back out changes from the current command
95909 ** changes to prior rows are retained.
97041 int (*changes)(sqlite3*);
97275 #define sqlite3_changes sqlite3_api->changes
99116 ** secure_delete flag. The second form changes the secure_delete
99429 ** the local value does not make changes to the disk file and the default
99584 ** the local value does not make changes to the disk file and the
101033 ** make no changes to pParse->rc.
101151 ** turn means that the other connection has made uncommitted changes
101155 ** schema changes and if those schema changes are subsequently rolled
101156 ** back and different changes are made in their place, then when this
103196 ** This routine changes the values of iLimit and iOffset only if
104446 ** changes to pExpr so that it refers directly to the source table
104519 ** This routine returns 1 if it makes changes and 0 if no flattening occurs.
106533 /* Generate code that runs whenever the GROUP BY changes.
106535 ** block. If there were no changes, this block is skipped.
112556 ** original table changes and the index and table cannot both be used
115288 ** changes "x IN (?)" into "x=?". */
122921 ** Return the number of changes in the most recent call to sqlite3_exec().
122928 ** Return the number of changes since the database handle was opened.
124304 ** Make no changes but still report the old value if the
125342 ** Make no changes if X==0. Return the value of the pending byte
130237 ** hash-table. Any changes made to the database are reverted by SQLite.
130473 ** PendingTermsFlush() in in case that changes.
140521 ** the space required changes depending on which node the key is to