Home
last modified time | relevance | path

Searched refs:rollback (Results 1 – 25 of 83) sorted by relevance

1234

/sqlite-3.40.0/test/
H A Drollback.test23 do_test rollback-1.1 {
35 do_test rollback-1.2 {
44 do_test rollback-1.3 {
53 do_test rollback-1.4 {
61 do_test rollback-1.5 {
72 do_test rollback-1.7 {
75 do_test rollback-1.8 {
78 do_test rollback-1.9 {
88 do_test rollback-2.1 {
132 do_test rollback-2.2 {
[all …]
H A Drollback2.test44 # -rollback Use this SQL command ("ROLLBACK" or "ROLLBACK TO ...") to
45 # rollback the transaction in the middle of the -select statment
52 set A(-rollback) ROLLBACK
67 if {$i==$iRollback} { db eval $A(-rollback) }
91 } -rollback {
118 } -rollback {
148 } -rollback {
H A Dtrigger3.test37 WHEN (new.a = 3) THEN RAISE(ROLLBACK, 'Trigger rollback') END;
81 } {1 {Trigger rollback}}
97 } {1 {Trigger rollback}}
168 SELECT CASE WHEN (new.a = 1) THEN RAISE(ROLLBACK, 'View rollback')
178 } {1 {View rollback}}
H A Dsavepoint6.test63 # rollback NAME
74 proc rollback {zName} {
183 set cmds {savepoint savepoint savepoint savepoint release rollback}
218 rollback three
219 rollback two
H A Dtkt35xx.test14 # page cache which are not in the rollback journal are reinitialized
29 # Trigger the problem using explicit rollback.
50 # Trigger the problem using statement rollback.
H A Dmalloc3.test49 # (or any other) connection opens a read transaction, hot-journal rollback
102 # the malloc() failure mandates statement rollback only. Currently, if
103 # transaction rollback is required, all other vdbe's are aborted.
125 # rollback occurs before sqlite3_step() returns, not during a subsequent
191 # back any active transaction if malloc() fails. It must rollback the statement
196 # value indicating if the statement may cause transaction rollback when
275 # also testing rollback of a DELETE from a table with an index on it.
446 # cause transaction rollback if they fail. Also query a view, to cover a bit
610 # commit - therefore a rollback occurred. Check that the
611 # rollback-hook was invoked.
[all …]
H A Dsavepoint2.test89 # Execute some SQL on the database. Then rollback to savepoint "one".
108 # More SQL changes. The rollback to savepoint "two". Check that the
118 # More SQL changes. The rollback to savepoint "two". Check that the
H A Dwalbak.test32 # walback-3.*: Backup of WAL sources into rollback destinations, and
202 # walbak-3.3.*: a database in rollback mode.
204 # walbak-3.4.*: a database in rollback mode that (initially) uses a
289 # rollback mode.
H A Djournal1.test14 # prior databases do not try to rollback into new databases.
51 # old journal should not attempt to rollback into the new
H A Dpermutations.test582 delete.test delete2.test insert.test rollback.test select1.test
598 delete.test delete2.test insert.test rollback.test select1.test
614 delete.test delete2.test insert.test rollback.test select1.test
645 rollback.test select1.test select2.test select3.test
681 rollback.test select1.test select2.test
693 delete.test delete2.test insert.test rollback.test select1.test
704 delete.test delete2.test insert.test rollback.test select1.test
715 delete.test delete2.test insert.test rollback.test select1.test
737 delete.test delete2.test insert.test rollback.test select1.test
963 rollback.test
[all …]
H A Dtempdb.test30 # Force a statement journal rollback on a database file that
43 # will cause a statement journal rollback on this non-existant
H A Dhook.test359 # Test the rollback-hook. The rollback-hook is a bit more complicated than
360 # either the commit or update hooks because a rollback can happen
369 # hook-5.5.* - Test hot-journal rollbacks. Or should the rollback hook
374 # Configure the rollback hook to increment global variable
411 # End rollback-hook testing.
415 # Test that if a commit-hook returns non-zero (causing a rollback), the
416 # rollback-hook is invoked.
H A Dzerodamage.test47 # rollback journal is not being padded.
80 # maximum rollback journal size should be much larger.
H A Dshared_err.test77 # occur if an IO error occurs during a rollback in the {SELECT * FROM t1}
189 # 3. If, after the initial IO error, SQLite tried to rollback the
269 # 3. If, after the initial IO error, SQLite tried to rollback the
416 # UPDATE: As of [5668], if the rollback fails SQLITE_CORRUPT is returned.
451 # cause transaction rollback, which would trip cursors in other statements,
H A Dsavepointfault.test80 # The following test does a really big savepoint rollback. One involving
109 # Cause a specific malloc in savepoint rollback code to fail.
H A Davtrans.test183 } {1 {cannot rollback - no transaction is active}}
246 # Check out the commit/rollback behavior of the database
676 # Test to make sure rollback restores the database back to its original
817 # of a table, make lots of modifications to that table, then do a rollback.
818 # Verify that after the rollback, the MD5 checksum is unchanged.
849 # make lots of changes to t3, then rollback and take another signature.
H A Dtrans.test210 } {1 {cannot rollback - no transaction is active}}
275 # Check out the commit/rollback behavior of the database
709 # Test to make sure rollback restores the database back to its original
875 # of a table, make lots of modifications to that table, then do a rollback.
876 # Verify that after the rollback, the MD5 checksum is unchanged.
908 # make lots of changes to t3, then rollback and take another signature.
H A Dincrvacuum3.test17 # * Truncate the database after a rollback mode commit, and
71 # Run these tests once in rollback journal mode, and once in wal mode.
H A Dmemdb.test23 # of a table, make lots of modifications to that table, then do a rollback.
24 # Verify that after the rollback, the MD5 checksum is unchanged.
55 # make lots of changes to t3, then rollback and take another signature.
H A Dpagerfault.test360 # rollback the current statement.
439 # rollback, a new cache entry must be allocated (see comments surrounding
994 # Test fault-injection and rollback when the nReserve header value
1100 # This test causes rollback of the in-memory database after CommitPhaseOne()
1330 # 1) Put the pager in ERROR state (error during rollback)
1333 # xUnlock() calls. This causes the hot-journal rollback to fail and
1338 # 4a) Stop injecting errors. Allow the rollback to succeed. Check that
H A Dcrash8.test88 # the second aborted transaction, then continuing to rollback the second
138 # Also test that SQLite will not rollback a hot-journal file with a
245 # rollback occurs.
/sqlite-3.40.0/doc/
H A Dpager-invariants.txt10 the transaction has been written into the rollback journal and
27 (2) The content of a page written into the rollback journal exactly matches
28 both the content in the database when the rollback journal was written
39 (5) All writes to the database file are synced prior to the rollback journal
52 of the unsynced changes to a rollback journal are removed and the
H A Dvfs-shm.txt1 The 5 states of an historical rollback lock as implemented by the
24 These roughly correspond to the 5 states of a rollback lock except
/sqlite-3.40.0/mptest/
H A Dcrash02.subtest3 ** script. After the database file has been set up, make a big rollback
/sqlite-3.40.0/ext/lsm1/lsm-test/
H A DREADME12 lsmtest3.c: Rollback tests. Tests that focus on the explicit rollback of

1234