Debian Codegraph @

ext/session/sessionconflict2.test

raw
1 # 2026 May 18
2 #
3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
5 #
6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give.
9 #
10 #***********************************************************************
11 # This file implements regression tests for SQLite library.
12 #
13
14 if {![info exists testdir]} {
15 set testdir [file join [file dirname [info script]] .. .. test]
16 }
17 source [file join [file dirname [info script]] session_common.tcl]
18 source $testdir/tester.tcl
19 ifcapable !session {finish_test; return}
20
21 set testprefix sessionconflict2
22
23 forcedelete test.db2
24 sqlite3 db2 test.db2
25
26 do_test 1.0 {
27 do_common_sql {
28 CREATE TABLE t1(a PRIMARY KEY, b, c UNIQUE);
29 INSERT INTO t1 VALUES(1, 1, 1);
30 INSERT INTO t1 VALUES(2, 2, 2);
31 INSERT INTO t1 VALUES(3, 3, 3);
32 }
33 } {}
34
35 do_test 1.1 {
36 do_then_apply_sql {
37 UPDATE t1 SET c=NULL WHERE a=1;
38 UPDATE t1 SET c=1 WHERE a=3;
39 UPDATE t1 SET c=3 WHERE a=1;
40 }
41 } {}
42
43 do_execsql_test -db db 1.2 {
44 SELECT rowid, * FROM t1
45 } {
46 1 1 1 3
47 2 2 2 2
48 3 3 3 1
49 }
50
51 do_execsql_test -db db2 1.3 {
52 SELECT rowid, * FROM t1
53 } {
54 1 1 1 3
55 2 2 2 2
56 3 3 3 1
57 }
58
59 #--------------------------------------------------------------------------
60 reset_db
61 db2 close
62 forcedelete test.db2
63 sqlite3 db2 test.db2
64
65 do_test 2.0 {
66 do_common_sql {
67 CREATE TABLE t1(a PRIMARY KEY, b, c UNIQUE) WITHOUT ROWID;
68 INSERT INTO t1 VALUES(1, 1, 1);
69 INSERT INTO t1 VALUES(2, 2, 2);
70 INSERT INTO t1 VALUES(3, 3, 3);
71 }
72 } {}
73
74 do_test 2.1 {
75 do_then_apply_sql {
76 UPDATE t1 SET c=NULL WHERE a=1;
77 UPDATE t1 SET c=1 WHERE a=3;
78 UPDATE t1 SET c=3 WHERE a=1;
79 }
80 } {}
81
82 do_execsql_test -db db 2.2 {
83 SELECT * FROM t1
84 } {
85 1 1 3
86 2 2 2
87 3 3 1
88 }
89
90 do_execsql_test -db db2 2.3 {
91 SELECT * FROM t1
92 } {
93 1 1 3
94 2 2 2
95 3 3 1
96 }
97
98 #--------------------------------------------------------------------------
99 reset_db
100 db2 close
101 forcedelete test.db2
102 sqlite3 db2 test.db2
103
104 do_test 3.0 {
105 do_common_sql {
106 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c UNIQUE);
107 INSERT INTO t1 VALUES(1, 1, 1);
108 INSERT INTO t1 VALUES(2, 2, 2);
109 INSERT INTO t1 VALUES(3, 3, 3);
110 }
111 } {}
112
113 do_test 3.1 {
114 do_then_apply_sql {
115 UPDATE t1 SET c=NULL WHERE a=1;
116 UPDATE t1 SET c=1 WHERE a=3;
117 UPDATE t1 SET c=3 WHERE a=1;
118 }
119 } {}
120
121 do_execsql_test -db db 3.2 {
122 SELECT rowid, * FROM t1
123 } {
124 1 1 1 3
125 2 2 2 2
126 3 3 3 1
127 }
128
129 do_execsql_test -db db2 3.3 {
130 SELECT rowid, * FROM t1
131 } {
132 1 1 1 3
133 2 2 2 2
134 3 3 3 1
135 }
136
137 #-------------------------------------------------------------------------
138 db2 close
139 reset_db
140 forcedelete test.db2
141 sqlite3 db2 test.db2
142
143 set ::conflict_list [list]
144 proc xConflict {args} {
145 lappend ::conflict_list $args
146 return "OMIT"
147 }
148
149 proc do_conflict_test {tn bNoUpdateLoop script clist} {
150
151 uplevel [list do_test $tn.1 [subst -nocommands {
152 sqlite3session S db "main"
153 S attach *
154 eval {$script}
155 set ::changeset [S changeset]
156 S delete
157 }] {}]
158
159 if {$bNoUpdateLoop} {
160 uplevel [list do_test $tn.2.no {
161 set ::conflict_list [list]
162 sqlite3changeset_apply_v2 -noupdateloop db2 $::changeset xConflict
163 set ::conflict_list
164 } [list {*}$clist]]
165 } else {
166 uplevel [list do_test $tn.2 {
167 set ::conflict_list [list]
168 sqlite3changeset_apply_v2 db2 $::changeset xConflict
169 set ::conflict_list
170 } [list {*}$clist]]
171 }
172 }
173
174 do_test 4.0 {
175 do_common_sql {
176 CREATE TABLE t1(a INT PRIMARY KEY, b, c UNIQUE, d UNIQUE);
177 WITH s(i) AS (
178 SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<10
179 )
180 INSERT INTO t1 SELECT i, i, i, i FROM s;
181 }
182 } {}
183
184 proc swap {tbl pkcol valcol pk1 pk2} {
185 set val1 [db one "SELECT $valcol FROM $tbl WHERE $pkcol = \$pk1"]
186 set val2 [db one "SELECT $valcol FROM $tbl WHERE $pkcol = \$pk2"]
187
188 db eval "
189 UPDATE $tbl SET $valcol = NULL WHERE $pkcol IN (\$pk1, \$pk2);
190 UPDATE $tbl SET $valcol = \$val2 WHERE $pkcol = \$pk1;
191 UPDATE $tbl SET $valcol = \$val1 WHERE $pkcol = \$pk2;
192 "
193 }
194
195 do_conflict_test 4.1.1 0 {
196 swap t1 a c 4 5
197 swap t1 a c 2 3
198 swap t1 a c 8 1
199 } {
200 }
201
202 do_execsql_test -db db 4.1.2 {
203 SELECT a, c FROM t1
204 } {
205 1 8 2 3 3 2 4 5 5 4 6 6 7 7 8 1 9 9 10 10
206 }
207 do_execsql_test -db db2 4.1.3 {
208 SELECT a, c FROM t1
209 } {
210 1 8 2 3 3 2 4 5 5 4 6 6 7 7 8 1 9 9 10 10
211 }
212
213 do_conflict_test 4.2.1 0 {
214 swap t1 a d 10 9
215 swap t1 a d 8 7
216 swap t1 a d 7 6
217 swap t1 a d 5 4
218 swap t1 a d 4 8
219 } {
220 }
221
222 do_execsql_test -db db 4.2.2 {
223 SELECT a, d FROM t1
224 } {
225 1 1 2 2 3 3 4 7 5 4 6 8 7 6 8 5 9 10 10 9
226 }
227 do_execsql_test -db db2 4.2.3 {
228 SELECT a, d FROM t1
229 } {
230 1 1 2 2 3 3 4 7 5 4 6 8 7 6 8 5 9 10 10 9
231 }
232
233 do_execsql_test -db db2 4.3 {
234 INSERT INTO t1(a, b, c, d) VALUES(11, 11, 11, 11);
235 }
236
237 do_conflict_test 4.3.1 0 {
238 swap t1 a c 3 6
239 db eval { UPDATE t1 SET d=11 WHERE a=10; }
240 swap t1 a d 4 8
241 } {
242 {UPDATE t1 CONSTRAINT {i 10 {} {} {} {} i 9} {{} {} {} {} {} {} i 11}}
243 }
244
245 do_conflict_test 4.3.2 0 {
246 swap t1 a c 1 2
247 swap t1 a c 3 4
248 db eval { UPDATE t1 SET c=11 WHERE a=10; }
249 swap t1 a d 5 6
250 swap t1 a d 4 5
251 } {
252 {UPDATE t1 CONSTRAINT {i 10 {} {} i 10 {} {}} {{} {} {} {} i 11 {} {}}}
253 }
254
255 do_conflict_test 4.3.3 0 {
256 swap t1 a c 1 2
257 swap t1 a c 2 3
258 swap t1 a c 3 4
259 swap t1 a c 4 1
260 } {
261 }
262 db2 close
263
264 #-------------------------------------------------------------------------
265 reset_db
266 forcedelete test.db2
267 sqlite3 db2 test.db2
268
269 do_test 5.0 {
270 do_common_sql {
271 CREATE TABLE t1(a INT PRIMARY KEY, b UNIQUE);
272 INSERT INTO t1 VALUES('one', 'one');
273 INSERT INTO t1 VALUES('two', 'two');
274 INSERT INTO t1 VALUES('three', 'three');
275 INSERT INTO t1 VALUES('four', 'four');
276 INSERT INTO t1 VALUES('five', 'five');
277 }
278 } {}
279
280 do_conflict_test 5.1 1 {
281 } {
282 }
283
284 do_conflict_test 5.2 1 {
285 swap t1 a b one two
286 } {
287 {UPDATE t1 CONSTRAINT {t two t two} {{} {} t one}}
288 {UPDATE t1 CONSTRAINT {t one t one} {{} {} t two}}
289 }
290
291 do_conflict_test 5.2 0 {
292 swap t1 a b four five
293 } {
294 }
295
296
297 finish_test
298