Home
last modified time | relevance | path

Searched refs:ROLLBACK (Results 1 – 25 of 182) sorted by relevance

12345678

/sqlite-3.40.0/test/
H A Dsavepoint.test36 ROLLBACK TO sp1;
68 ROLLBACK TO sp1;
94 ROLLBACK TO sp1;
119 ROLLBACK TO one;
131 ROLLBACK TO one;
147 ROLLBACK TO two;
159 ROLLBACK TO one;
179 ROLLBACK;
252 ROLLBACK;
918 ROLLBACK;
[all …]
H A Drollback2.test12 # This file containst tests to verify that ROLLBACK or ROLLBACK TO
44 # -rollback Use this SQL command ("ROLLBACK" or "ROLLBACK TO ...") to
52 set A(-rollback) ROLLBACK
61 catch { db eval ROLLBACK }
92 ROLLBACK TO one;
119 ROLLBACK TO one;
149 ROLLBACK TO one;
H A Davtrans.test180 ROLLBACK;
326 ROLLBACK;
343 ROLLBACK;
398 ROLLBACK;
421 ROLLBACK;
453 ROLLBACK;
483 ROLLBACK;
514 ROLLBACK;
554 ROLLBACK;
566 ROLLBACK;
[all …]
H A Dtrans.test207 ROLLBACK;
364 ROLLBACK;
381 ROLLBACK;
436 ROLLBACK;
459 ROLLBACK;
491 ROLLBACK;
521 ROLLBACK;
552 ROLLBACK;
592 ROLLBACK;
604 ROLLBACK;
[all …]
H A Dsavepoint7.test12 # Focus on the interaction between RELEASE and ROLLBACK TO with
62 db eval {SELECT * FROM t2; ROLLBACK;}
65 # However, a ROLLBACK of an inner savepoint will abort all queries, including
75 ROLLBACK TO x2;
81 } {1 {abort due to ROLLBACK} {}}
91 ROLLBACK TO x2;
96 } {1 {abort due to ROLLBACK} {}}
119 ROLLBACK TO one;
124 ROLLBACK TO twoB;
H A Dtrigger9.test65 do_test trigger9-1.2.4 { execsql { ROLLBACK } } {}
80 do_test trigger9-1.3.3 { execsql { ROLLBACK } } {}
95 do_test trigger9-1.4.3 { execsql { ROLLBACK } } {}
110 do_test trigger9-1.5.3 { execsql { ROLLBACK } } {}
125 do_test trigger9-1.6.3 { execsql { ROLLBACK } } {}
140 do_test trigger9-1.7.3 { execsql { ROLLBACK } } {}
159 ROLLBACK;
176 ROLLBACK;
190 ROLLBACK;
205 ROLLBACK;
[all …]
H A Dwherelimit2.test93 ROLLBACK;
100 ROLLBACK;
129 ROLLBACK;
136 ROLLBACK;
167 ROLLBACK;
174 ROLLBACK;
181 ROLLBACK;
188 ROLLBACK;
218 ROLLBACK;
264 ROLLBACK;
[all …]
H A Dtrigger3.test26 # Test that we can cause ROLLBACK, FAIL and ABORT correctly
37 WHEN (new.a = 3) THEN RAISE(ROLLBACK, 'Trigger rollback') END;
52 ROLLBACK;
71 ROLLBACK;
74 # ROLLBACK
89 # Verify that a ROLLBACK trigger works like a FAIL trigger if
114 ROLLBACK;
168 SELECT CASE WHEN (new.a = 1) THEN RAISE(ROLLBACK, 'View rollback')
H A Dfkey6.test69 ROLLBACK;
87 # automatically switched off at each COMMIT or ROLLBACK. Hence, the
92 ROLLBACK;
104 db eval {ROLLBACK}
136 ROLLBACK;
145 ROLLBACK;
207 do_execsql_test 3.2.6 { ROLLBACK }
H A DcorruptC.test165 catchsql {BEGIN; UPDATE t2 SET y='abcdef-uvwxyz'; ROLLBACK;}
185 catchsql {BEGIN; UPDATE t2 SET y='abcdef-uvwxyz'; ROLLBACK;}
197 catchsql {BEGIN; UPDATE t2 SET y='abcdef-uvwxyz'; ROLLBACK;}
217 catchsql {BEGIN; DELETE FROM t1 WHERE x>13; ROLLBACK;}
234 catchsql {BEGIN; DELETE FROM t1 WHERE x>13; ROLLBACK;}
246 catchsql {BEGIN; UPDATE t2 SET y='abcdef-uvwxyz'; ROLLBACK;}
258 catchsql {BEGIN; CREATE TABLE t3 AS SELECT x,3 as y FROM t2 WHERE rowid%5!=0; ROLLBACK;}
373 catchsql {BEGIN; UPDATE t1 SET y=1; ROLLBACK;}
377 catchsql {BEGIN; UPDATE t2 SET y='abcdef-uvwxyz'; ROLLBACK;}
381 catchsql {BEGIN; DELETE FROM t1 WHERE x>13; ROLLBACK;}
[all …]
H A Dconflict.test51 7 {INSERT OR ROLLBACK} 1 {} {} 0
98 7 {INSERT OR ROLLBACK} 1 {} {}
143 7 {INSERT OR ROLLBACK} 1 {} {}
184 6 ROLLBACK INSERT 1 {} {}
189 11 ROLLBACK {INSERT OR IGNORE } 0 3 1
237 11 ROLLBACK {INSERT OR IGNORE} 0 {} 1
466 e INTEGER UNIQUE ON CONFLICT ROLLBACK
642 INSERT OR ROLLBACK INTO t4 VALUES(1);
643 INSERT OR ROLLBACK INTO t4 VALUES(1);
704 ROLLBACK;
[all …]
H A Dconflict2.test51 7 {INSERT OR ROLLBACK} 1 {} {} 0
98 7 {INSERT OR ROLLBACK} 1 {} {}
143 7 {INSERT OR ROLLBACK} 1 {} {}
184 6 ROLLBACK INSERT 1 {} {}
189 11 ROLLBACK {INSERT OR IGNORE } 0 3 1
237 11 ROLLBACK {INSERT OR IGNORE} 0 {} 1
467 e INTEGER UNIQUE ON CONFLICT ROLLBACK
648 INSERT OR ROLLBACK INTO t4 VALUES(1);
649 INSERT OR ROLLBACK INTO t4 VALUES(1);
710 ROLLBACK;
[all …]
H A Dmemdb.test54 # This is used to test ROLLBACK. We gather a signature for t3, then
89 ROLLBACK;
102 ROLLBACK;
139 ROLLBACK;
170 7 {} {INSERT OR ROLLBACK} 1 {} {}
225 6 ROLLBACK {} UPDATE 1 {1 2 3 4} 0
230 11 ROLLBACK {} {UPDATE OR IGNORE} 0 {6 7 3 9} 1
235 16 {} {} {UPDATE OR ROLLBACK} 1 {1 2 3 4} 0
278 ROLLBACK;
320 ROLLBACK;
H A Dsavepointfault.test28 ROLLBACK TO two;
58 ROLLBACK TO two;
59 ROLLBACK TO one;
105 # ROLLBACK TO abc;
133 ROLLBACK TO abc;
H A De_insert.test58 3 "INSERT OR ROLLBACK INTO main.a1 DEFAULT VALUES" {}
59 4 "INSERT OR ROLLBACK INTO a1 DEFAULT VALUES" {}
72 17 "INSERT OR ROLLBACK INTO main.a1 VALUES(1, 2)" {}
73 18 "INSERT OR ROLLBACK INTO a1 VALUES(1, 2)" {}
86 31 "INSERT OR ROLLBACK INTO main.a1 (b, a) VALUES(1, 2)" {}
87 32 "INSERT OR ROLLBACK INTO a1 (b, a) VALUES(1, 2)" {}
100 45 "INSERT OR ROLLBACK INTO main.a1 SELECT c, b FROM a2" {}
101 46 "INSERT OR ROLLBACK INTO a1 SELECT c, b FROM a2" {}
114 59 "INSERT OR ROLLBACK INTO main.a1 (b, a) SELECT c, b FROM a2" {}
115 60 "INSERT OR ROLLBACK INTO a1 (b, a) SELECT c, b FROM a2" {}
[all …]
H A Dtemptable2.test48 ROLLBACK;
70 ROLLBACK;
82 ROLLBACK TO abc;
108 ROLLBACK;
157 ROLLBACK;
200 ROLLBACK; -- step 4
222 ROLLBACK;
H A Dfts3conf.test77 1 "INSERT OR ROLLBACK $T1" 0 1 {{a b c d} {e f g h}}
83 6 "INSERT OR ROLLBACK $T2" 1 1 {{a b c d} {e f g h}}
89 11 "UPDATE OR ROLLBACK $T3" 0 1 {{a b c d} {e f g h}}
95 16 "UPDATE OR ROLLBACK $T4" 1 1 {{a b c d} {e f g h}}
123 ROLLBACK TO a;
208 ROLLBACK TO abc;
224 ROLLBACK TO abc;
H A Dtempfault.test98 ROLLBACK TO abc;
100 ROLLBACK TO abc;
124 ROLLBACK TO abc;
126 ROLLBACK TO abc;
H A Djrnlmode3.test45 ROLLBACK;
67 ROLLBACK;
119 ROLLBACK;
141 db eval ROLLBACK
H A Dcachespill.test47 execsql ROLLBACK
64 ROLLBACK;
74 do_execsql_test 1.6 { ROLLBACK }
H A Dmemjournal2.test43 ROLLBACK TO two;
49 ROLLBACK TO two;
55 ROLLBACK TO one;
H A Dioerr2.test52 # connection. Otherwise, try a ROLLBACK, in case a transaction
63 catch {execsql ROLLBACK}
87 ROLLBACK;
117 # fail with "abort due to ROLLBACK". Now, the loop continues until the UPDATE
139 } {1 {disk I/O error}} ;# used to be "{1 {abort due to ROLLBACK}}"
/sqlite-3.40.0/ext/repair/test/
H A Dcheckfreelist01.test55 ROLLBACK;
64 ROLLBACK;
73 ROLLBACK;
82 ROLLBACK;
91 ROLLBACK;
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5vocab2.test58 ROLLBACK;
70 ROLLBACK;
122 ROLLBACK;
134 ROLLBACK;
182 ROLLBACK;
193 ROLLBACK;
H A Dfts5ai.test40 ROLLBACK TO one;
47 ROLLBACK TO one;
58 ROLLBACK TO one;

12345678