Lines Matching defs:changes
330 ** features recently added to SQLite. We do not anticipate changes
331 ** to experimental interfaces but reserve the right to make minor changes
332 ** if experience from use "in the wild" suggest such changes are prudent.
339 ** The makefile makes some minor changes to this file (such as inserting
340 ** the version number) and changes its name to "sqlite3.h" as
560 ** thread safety, not any run-time changes to that setting made by
1459 ** The [SQLITE_FCNTL_DATA_VERSION] opcode is used to detect changes to
1462 ** "data version" changes whenever any change occurs to the corresponding
1467 ** but that interface responds to changes on TEMP as well as MAIN and does
1468 ** not provide a mechanism to detect changes to MAIN only. Also, the
1469 ** [sqlite3_total_changes()] interface responds to internal changes only and
1470 ** omits changes made by other database connections. The
1471 ** [PRAGMA data_version] command provides a mechanism to detect changes to
1473 ** but omits changes implemented by the database connection on which it is
1474 ** called. This file control is the only mechanism to detect changes that
1959 ** changes to SQLite in order to tune SQLite to the specific needs of
1993 ** changes to a [database connection]. The interface is similar to
1994 ** [sqlite3_config()] except that the changes apply to a single
2571 ** If the first argument is -1, then no changes are made to state of either the
2820 ** and INSERT OR ABORT make no changes to the return value of this
2835 ** function is running and thus changes the last insert [rowid],
2865 ** ^Only changes made directly by the INSERT, UPDATE or DELETE statement are
2866 ** considered - auxiliary changes caused by [CREATE TRIGGER | triggers],
2872 ** DELETE statement run on a view is always zero. Only changes made to real
2877 ** program uses the [changes() SQL function], or if some other callback
2888 ** any changes performed by sub-triggers, as the sqlite3_changes()
2892 ** ^This means that if the changes() SQL function (or similar) is used
2899 ** If a separate thread makes changes on the same database connection
2907 ** <li> the [changes() SQL function]
2935 ** connection D. Any changes by other database connections are ignored.
2936 ** To detect changes against a database file from other database
2940 ** If a separate thread makes changes on the same database connection
2948 ** <li> the [changes() SQL function]
3430 ** not want the user to be able to make arbitrary changes to the
4473 ** ^If the database schema changes, instead of returning [SQLITE_SCHEMA] as it
4604 ** and only if the [prepared statement] X makes no direct changes to
4627 ** changes to the content of the database files on disk.
6077 ** <li> ^(when the corresponding function parameter changes)^, or
6169 ** ^The sqlite3_result_error_code() function changes the error code
6667 ** If another thread changes the autocommit status of the database
6698 ** changes the schema, including [ATTACH] or [DETACH] or calls to
6786 ** will advanced to SQLITE_TXN_WRITE if any changes occur and there are
7126 ** changes in future releases of SQLite.
7514 ** any database changes. In other words, if the xUpdate() returns
7517 ** set and xUpdate returns SQLITE_CONSTRAINT, any database changes made by
7857 ** rolled back by the expiration of the BLOB. Such changes will eventually
8008 ** expiration of the handle, though of course those changes might
8947 ** automatically regenerated due to schema changes or changes to
9374 ** changes the size of the source database or the number of pages remaining,
9375 ** those changes are not reflected in the output of sqlite3_backup_pagecount()
10414 ** ^The preupdate hook only fires for changes to real database tables; the
10415 ** preupdate hook is not invoked for changes to [virtual tables] or to
10474 ** triggers; or 2 for changes resulting from triggers called by top-level
10534 ** Subsequent changes to the database from other connections are not seen
10987 ** record changes to a database.
11088 ** Enable or disable the recording of changes by a session object. When
11089 ** enabled, a session object records changes made to the database. When
11139 ** to the session object passed as the first argument. All subsequent changes
11143 ** Or, if argument zTab is NULL, then changes are recorded for all tables
11145 ** executing "CREATE TABLE" statements) after this call is made, changes for
11155 ** no changes will be recorded in either of these scenarios.
11171 ** Even though sqlite_stat1 does not have a PRIMARY KEY, changes are
11172 ** recorded for it as if the PRIMARY KEY is (tbl,idx). Additionally, changes
11188 ** changes made to the sqlite_stat1 table. Legacy versions of the
11201 ** The second argument (xFilter) is the "filter callback". For changes to rows
11203 ** to determine whether changes to the table's rows should be tracked or not.
11204 ** If xFilter returns 0, changes are not tracked. Note that once a table is
11220 ** Obtain a changeset containing changes to the tables attached to the
11227 ** A changeset consists of zero or more INSERT, UPDATE and/or DELETE changes,
11252 ** Within a changeset generated by this function, all changes related to a
11254 ** a changeset or when applying a changeset to a database, all changes related
11257 ** to the sqlite3_session object. The order in which the changes related to
11366 ** but no changes are added to the session object. As with other session
11369 ** This function adds a set of changes to the session object that could be
11433 ** generated by the sqlite3session_changeset() function (i.e. all changes for
11444 ** CAPI3REF: Test if a changeset has recorded any changes.
11446 ** Return non-zero if no changes to attached tables have been recorded by
11448 ** more changes have been recorded, return zero.
11452 ** changeset that contains no changes. This can happen when a row in
11456 ** changeset containing zero changes.
11494 ** [sqlite3changeset_invert()] functions, all changes within the changeset
11497 ** this function, all changes that relate to a single table are visited
11551 ** Otherwise, if all changes in the changeset have already been visited,
11586 ** changes.
11787 ** This function does not change the order in which changes appear within
11893 ** Add all changes within the changeset (or patchset) in buffer pData (size
11899 ** function. Otherwise, SQLITE_ERROR is returned and no changes are added
11909 ** contain changes that apply to a single row, the final contents of the
11954 ** If the new changeset contains changes to a table that is already present
11977 ** sqlite3session_patchset() functions, all changes related to a single
11981 ** changes for tables that do not appear in the first changeset, they are
12008 ** update the "main" database attached to handle db with the changes found in
12016 ** returns zero, then no attempt is made to apply any changes to the table.
12018 ** is NULL, all changes related to the table are attempted.
12034 ** changes associated with the table are applied. A warning message is issued
12054 ** returns an illegal value, any changes already made are rolled back and
12118 ** UPDATE changes only contain values for non-primary key fields that are
12139 ** All changes made by these functions are enclosed in a savepoint transaction.
12256 ** returns CHANGESET_OMIT, the changes, including those that caused the
12294 ** is not the case, any changes applied so far are rolled back and the
12307 ** If this value is returned, any changes applied so far are rolled back
12375 ** A local change may be rebased against multiple remote changes
12647 ** changes to the sessions module in order to tune it to the specific needs
14227 ** the VDBE-level file format changes. The following macros define the
16843 ** have been filled out. If the schema changes, these column names might
16844 ** changes and so the view will need to be reset.
16880 ** bDisable changes back to zero.
17201 #define SQLITE_QueryOnly 0x00100000 /* Disable database changes */
17231 #define DBFLAG_SchemaChange 0x0001 /* Uncommitted Hash table changes */
17922 ** fails and any prior changes from that one operation are backed out,
17925 ** changes due to the same operation are not backed out and no rollback
17950 #define OE_Abort 2 /* Back out changes but do no rollback transaction */
17951 #define OE_Fail 3 /* Stop the operation but leave all prior changes */
17958 #define OE_Cascade 10 /* Cascade the changes */
22598 i64 nChange; /* Statement changes (Vdbe.nChange) */
22839 i64 nChange; /* Number of db changes made since last reset */
28199 int trace; /* True to trace changes */
28408 ** and p->owner are equal if p->owner changes between two values
28451 ** and p->owner are equal if p->owner changes between two values
28682 volatile LONG trace; /* True to trace changes */
36079 ** Maintenance reminder: if this struct changes in any way, the JSON
37026 ** whenever any part of the database changes. An assertion fault will
37739 ** by making the following changes:
38403 ** make appropriate changes here to invoke that blocking file lock. On
43769 ** changes the way database access is controlled by limiting access to a
45543 ** The following variable is (normally) set once and never changes
46362 ** be returned and no changes will be made to the Win32 native heap.
53375 ** ever changes to make the previous sentence incorrect.
53466 ** Set the suggested cache-spill value. Make no changes if if the
55266 ** To save unnecessary work, only do this when the batch number changes.
55564 ** of the unsynced changes to a rollback journal are removed and the
55747 ** A rollback-mode pager changes to WRITER_FINISHED state from WRITER_DBMOD
56164 u32 iDataVersion; /* Changes whenever database content changes */
56165 char dbFileVers[16]; /* Changes whenever database file changes */
56194 void (*xCodecSizeChng)(void*,int,int); /* Notify of page size changes */
57728 ** pager as it is in the source. This comes up when a VACUUM changes the
58254 ** the state it was in before we started making changes.
58753 ** that snapshot for use by the reader in spite of concurrently changes by
59341 ** Make no changes if mxPage is zero or negative. And never reduce the
60138 ** test for the error state as a safeguard against future changes.
60380 ** changes here, be sure to change it there as well.
60919 ** Database changes are detected by looking at 15 bytes beginning
61729 ** making changes to a page. The caller must check the return value
61995 /* If no database changes have been made, return early. */
62189 ** updated to reflect the changes made by the current transaction and
62223 ** a hot-journal during hot-journal rollback, 0 changes will be made
62243 ** If a write transaction is open, then all changes made within the
62484 ** index iSavepoint. If it is SAVEPOINT_ROLLBACK, then rollback all changes
62547 ** not yet been opened. In this case there have been no changes to
62830 ** with a page number other than iNew. This function changes the page's
62995 ** journalmode. Journalmode changes can only happen when the database
63381 ** database file. All changes to the database are recorded by writing
64732 ** changes the destination to some intermediate value before
64849 /* Verify the values of various constants. Any changes to the values
64883 ** For that matter, if the lock offset ever changes from its initial design
66375 ** If the database contents have changes since the previous read
68383 ** into this routine, we avoid unnecessary stack pointer changes
69084 ** This function changes all write-locks held by Btree p into read-locks.
71203 ** the right size. This is to guard against size changes that result
71537 ** as an argument, no changes are made to the spill size setting, so
71682 ** No changes are made if mxPage is 0 or negative.
71699 ** newFlag==(-1) No changes
72102 ** changes to the database. None of the following routines
72765 ** the disk. After the journal is safely on oxide, the changes to the
73137 ** the changes made by this write cursor would be visible to
76313 ** rollback, undoing any changes made to the parent page.
79801 ** invoked by the pager layer to report various state changes in
81584 ** no significant changes have been made to pX since the OP_SCopy.
81586 ** function for pX. Minor changes, such as adding or removing a
83342 ** coordinated with changes to mkopcodeh.tcl.
83912 ** few minor changes to the program.
85673 ** has made changes and is in autocommit mode, then commit those
85674 ** changes. If a rollback is needed, then do the rollback.
87885 ** execution environment changes in a way that would alter the program
91452 ** then back out all changes that have occurred during this execution of the
91859 ** original and hence if the original changes so will the copy.
91974 ** APIs might have caused type conversions of made other changes to
92401 ** persistent changes to registers P1 and P3.
92445 ** persistent changes to registers P1 and P3.
92605 /* Undo any changes made by applyAffinity() to the input registers. */
93095 ** changes.
94243 ** active statements. A statement transaction allows the changes made by this
94250 ** The cookie changes its value whenever the database schema changes.
94420 /* When the schema cookie changes, record the new cookie internally */
94425 /* Record changes in the file format */
95375 printf("seekHit changes from %d to %d\n", pC->seekHit, pOp->p2);
95382 printf("seekHit changes from %d to %d\n", pC->seekHit, pOp->p3);
96262 ** would fail. Should this ever change (because of changes in the code
96376 ** at the end of the btree and so no changes are made to
103144 ** journal data to roll back changes made to the internal page-cache
103883 ** expression node refer back to that source column. The following changes
104297 ** case, we need to return right away and not make any changes to
115659 int nColTest; /* Number of columns to test for changes */
118257 ** Table. No changes are made to disk by this routine.
119501 ** database changes. After each schema change, the cookie value
119502 ** changes. When a process first reads the schema it records the
119509 ** set back to prior value. But schema changes are infrequent
119514 ** the schema-version whenever the schema changes.
120576 ** to the elements of the FROM clause. But we do not want these changes
122551 ** Additional changes:
122739 ** can be checked before any changes are made to the database, it is never
124334 int count = (pParse->nested==0); /* True to count changes */
125300 ** Implementation of the changes() SQL function.
125302 ** IMP: R-32760-32347 The changes() SQL function is a wrapper
125304 ** same rules for counting changes.
125306 static void changes(
126949 ** The array cannot be constant since changes are made to the
127023 VFUNCTION(changes, 0, 0, 0, changes ),
127826 ** changes.
127889 ** transactions are not able to rollback schema changes.
128738 ** Make changes to the evolving bytecode to do affinity transformations
130094 int chngRowid /* True if UPDATE changes the rowid */
130216 ** record be generated during constraint checks to avoid affinity changes
130239 ** any ABORT Back out changes from the current command
130247 ** changes to prior rows are retained.
130485 ** OE_Fail and OE_Ignore must happen before any changes are made.
131975 int (*changes)(sqlite3*);
132332 #define sqlite3_changes sqlite3_api->changes
134830 ** secure_delete flag. The second form changes the secure_delete
135195 ** the local value does not make changes to the disk file and the default
135337 ** the local value does not make changes to the disk file and the
137632 ** make no changes to pParse->rc.
137856 ** turn means that the other connection has made uncommitted changes
137860 ** schema changes and if those schema changes are subsequently rolled
137861 ** back and different changes are made in their place, then when this
140298 ** and will break if those assumptions changes. Hence, use extreme caution
140409 ** and will break if those assumptions changes. Hence, use extreme caution
140640 ** This routine changes the values of iLimit and iOffset only if
142023 ** changes to pExpr so that it refers directly to the source table
142306 ** This routine returns 1 if it makes changes and 0 if no flattening occurs.
143243 ** (3) The inner query has a LIMIT clause (since the changes to the WHERE
143263 ** (6) Window functions make things tricky as changes to the WHERE clause
143289 ** Return 0 if no changes are made and non-zero if one or more WHERE clause
143321 ** sure no other terms are marked SF_Recursive in case something changes
145877 /* Generate code that runs whenever the GROUP BY changes.
145879 ** block. If there were no changes, this block is skipped.
152374 ** the vector on the LHS with corresponding changes to the SELECT so that
152807 ** bound string constants to blobs. This routine makes the necessary changes
157458 ** original table changes and the index and table cannot both be used
162405 " TERM_HIGHTRUTH changes ****\n"));
162764 ** to trace those changes if PRAGMA vdbe_addoptrace=on. This routine
174517 ** Return the number of changes in the most recent call to sqlite3_exec().
174533 ** Return the number of changes since the database handle was opened.
176258 ** Make no changes but still report the old value if the
177565 ** Make no changes if X==0. Return the value of the pending byte
183265 ** hash-table. Any changes made to the database are reverted by SQLite.
183526 ** PendingTermsFlush() in in case that changes.
193762 ** the space required changes depending on which node the key is to
200401 ** the last two columns in the table. Should this ever changes, be
208737 ** * Stage 1, in which changes are accumulated in an oal/wal file, and
215104 ** uncommitted changes and changes recorded in the WAL file are correctly
215562 int bIndirect; /* True if all changes are indirect */
215611 int bSkipEmpty; /* Skip noop UPDATE changes */
215695 ** Each group of changes begins with a table header:
215702 ** Followed by one or more changes to the table.
215719 ** of INSERT or DELETE changes never contain any undefined (type byte 0x00)
215733 ** A patchset is also a collection of changes. It is similar to a changeset,
215737 ** Each group of changes begins with a table header:
215744 ** Followed by one or more changes to the table.
215765 ** The records associated with INSERT changes are in the same format as for
216129 ** module does not record changes for rows with NULL values stored in
216282 ** This function is used by changeset_concat() to merge two UPDATE changes
216431 ** If required, grow the hash table used to store changes on table pTab
216863 ** includes a NULL value, exit early. Such changes are ignored by the
217344 ** Create a session object. This session object will record changes to
217452 ** Attach a table to a session. All subsequent changes made to the table
218114 SessionChange *p; /* Used to iterate through changes */
218178 ** Obtain a changeset object containing all changes recorded by the
218224 ** Obtain a patchset object containing all changes recorded by the
218268 ** Return true if there have been no changes to monitored tables recorded
218334 int bSkipEmpty /* True to skip empty UPDATE changes */
218884 ** changes in the changeset.
219600 ** Prepare statements for applying changes to the sqlite_stat1 table.
220105 ** Retry the changes accumulated in the pApply->constraints buffer.
220476 ** This function is called to merge two changes to the same row together as
220659 ** Add all changes in the changeset traversed by the iterator passed as
221020 ** or more remote UPDATE changes. The aRec/nRec buffer contains the current
221027 ** * Removing any changes to fields for which the corresponding field
234440 ** Return true if any changes were actually made, or false otherwise.
238603 ** hash-table. Any changes made to the database are reverted by SQLite.