Debian Codegraph @

ext/session/sessionchange2.test

raw
1 # 2026 January 09
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 sessionchange2
22
23 do_test 1.1.1 {
24 sqlite3changegroup grp
25 list [catch { grp change_begin INSERT "nosuchtable" 0 } msg] $msg
26 } {1 {SQLITE_ERROR - no such table: nosuchtable}}
27
28 do_test 1.1.2 {
29 grp schema db main
30 list [catch { grp change_begin INSERT "nosuchtable" 0 } msg] $msg
31 } {1 {SQLITE_ERROR - no such table: nosuchtable}}
32
33 do_test 1.1.3 {
34 list [catch { grp change_begin_ne INSERT "nosuchtable" 0 } msg] $msg
35 } {1 SQLITE_ERROR}
36
37 do_execsql_test 1.2.1 {
38 CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
39 }
40 do_test 1.2.2 {
41 list [catch { grp change_begin 435 "t1" 0 } msg] $msg
42 } {1 SQLITE_ERROR}
43
44 #-------------------------------------------------------------------------
45 reset_db
46 do_execsql_test 2.0 {
47 CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
48 CREATE TABLE t2(a, b);
49 }
50
51 do_test 2.1.1 {
52 sqlite3changegroup grp
53 grp schema db main
54 grp change_begin INSERT "t1" 0
55 grp change_int64 new 0 55
56 grp change_int64 new 1 101
57 grp change_finish false
58 } {}
59
60 do_test 2.1.2 {
61 set C [grp output]
62 grp delete
63 changeset_to_list $C
64 } {
65 {INSERT t1 0 X. {} {i 55 i 101}}
66 }
67
68 do_test 2.2.1 {
69 sqlite3changegroup grp
70 grp schema db main
71 grp change_begin INSERT "t2" 0
72 grp change_int64 new 0 -5
73 grp change_int64 new 1 -10
74 grp change_int64 new 2 -20
75 grp change_finish false
76 } {}
77
78 do_test 2.2.2 {
79 set C [grp output]
80 grp delete
81 changeset_to_list $C
82 } {
83 {INSERT t2 0 X.. {} {i -5 i -10 i -20}}
84 }
85
86 do_test 2.2.3 {
87 sqlite3changegroup grp
88 grp schema db main
89 grp change_begin INSERT "t1" 0
90 grp change_int64 new 0 223344
91 grp change_null new 1
92 grp change_finish false
93 } {}
94
95 do_test 2.2.4 {
96 set C [grp output]
97 grp delete
98 changeset_to_list $C
99 } {
100 {INSERT t1 0 X. {} {i 223344 n {}}}
101 }
102
103 do_test 2.2.5 {
104 sqlite3changegroup grp
105 grp schema db main
106 grp change_begin DELETE "t1" 0
107
108 grp change_int64 old 0 1
109 grp change_int64 old 1 123
110
111 grp change_finish false
112 } {}
113
114 do_test 2.2.6 {
115 set C [grp output]
116 grp delete
117 changeset_to_list $C
118 } {
119 {DELETE t1 0 X. {i 1 i 123} {}}
120 }
121
122 #-------------------------------------------------------------------------
123 reset_db
124 do_execsql_test 3.0 {
125 CREATE TABLE t1(a PRIMARY KEY, b, c);
126 CREATE TABLE t2(x, y);
127 }
128
129 foreach {tn script error} {
130 1 {
131 grp change_begin UPDATE t1 0
132 } {SQLITE_ERROR - invalid change: undefined value in PK of old.* record}
133
134 2 {
135 grp change_begin UPDATE t1 0
136 grp change_int64 old 0 1234
137 grp change_int64 new 0 5678
138 } {SQLITE_ERROR - invalid change: defined value in PK of new.* record}
139
140 3 {
141 grp change_begin UPDATE t1 0
142 grp change_null old 0
143 } {SQLITE_ERROR - invalid change: null value in PK of old.* record}
144
145 4 {
146 grp change_begin UPDATE t1 0
147 grp change_int64 old 0 1234
148 grp change_int64 old 1 20
149 } {SQLITE_ERROR - invalid change: column 1 - old.* value is defined but new.* is undefined}
150
151 5 {
152 grp change_begin UPDATE t1 0
153 grp change_int64 old 0 1234
154 grp change_int64 new 1 20
155 } {SQLITE_ERROR - invalid change: column 1 - old.* value is undefined but new.* is defined}
156
157 6 {
158 grp change_begin INSERT t1 0
159 grp change_null new 0
160 grp change_int64 new 1 20
161 } {SQLITE_ERROR - invalid change: null value in PK}
162
163 7 {
164 grp change_begin INSERT t1 0
165 grp change_int64 new 1 20
166 } {SQLITE_ERROR - invalid change: column 0 is undefined}
167
168 8 {
169 grp change_begin INSERT t1 0
170 grp change_int64 new 0 20
171 } {SQLITE_ERROR - invalid change: column 1 is undefined}
172
173 9 {
174 grp change_begin DELETE t1 0
175 grp change_int64 old 0 20
176 } {SQLITE_ERROR - invalid change: column 1 is undefined}
177
178 10 {
179 grp change_begin DELETE t1 0
180 grp change_int64 old 1 20
181 } {SQLITE_ERROR - invalid change: column 0 is undefined}
182
183 } {
184 sqlite3changegroup grp
185 grp schema db main
186 eval $script
187 do_test 3.1.$tn {
188 list [catch { grp change_finish false } msg] $msg
189 } [list 1 $error]
190 grp delete
191 }
192
193 do_test 3.2.1 {
194 sqlite3changegroup grp
195 grp schema db main
196 grp change_begin DELETE t1 0
197 list [catch {grp change_int64 new 0 20} msg] $msg
198 } {1 SQLITE_ERROR}
199 do_test 3.2.2 {
200 grp change_finish true
201 grp change_begin INSERT t1 0
202 list [catch {grp change_int64 old 0 20} msg] $msg
203 } {1 SQLITE_ERROR}
204
205 grp delete
206
207 #-------------------------------------------------------------------------
208 reset_db
209 do_execsql_test 3.0 {
210 CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
211 CREATE TABLE t2(a, b);
212 }
213
214 proc do_changegroup_script_test {tn script changeset patchset} {
215
216 breakpoint
217 sqlite3changegroup grp
218 grp schema db main
219 eval $script
220 do_test $tn.1 {
221 changeset_to_list [grp output]
222 } [list {*}$changeset]
223 grp delete
224
225 sqlite3changegroup grp
226 grp config patchset 1
227 grp schema db main
228 eval $script
229 do_test $tn.2 {
230 changeset_to_list [grp output]
231 } [list {*}$patchset]
232 grp delete
233
234 }
235
236 proc do_changegroup_patchset_test {tn script patchset} {
237
238 sqlite3changegroup grp
239 grp config patchset 1
240 grp schema db main
241 eval $script
242 do_test $tn {
243 changeset_to_list [grp output]
244 } [list {*}$patchset]
245 grp delete
246
247 }
248
249 do_changegroup_script_test 3.1 {
250 grp change_begin UPDATE t1 0
251 grp change_int64 old 0 123
252 grp change_int64 old 1 456
253 grp change_int64 new 1 789
254 grp change_finish false
255
256 grp change_begin INSERT t1 0
257 grp change_int64 new 0 124
258 grp change_text new 1 hello_world
259 grp change_finish false
260
261 grp change_begin DELETE t1 0
262 grp change_int64 old 0 125
263 grp change_double old 1 45.67
264 grp change_finish false
265 } {
266 {DELETE t1 0 X. {i 125 f 45.67} {}}
267 {INSERT t1 0 X. {} {i 124 t hello_world}}
268 {UPDATE t1 0 X. {i 123 i 456} {{} {} i 789}}
269 } {
270 {DELETE t1 0 X. {i 125 {} {}} {}}
271 {INSERT t1 0 X. {} {i 124 t hello_world}}
272 {UPDATE t1 0 X. {i 123 {} {}} {{} {} i 789}}
273 }
274
275 do_changegroup_script_test 3.1.2 {
276 grp change_begin INSERT t1 0
277 grp change_int64 new 0 124
278 grp change_text new 1 hello_world
279 grp change_finish false
280 } {
281 {INSERT t1 0 X. {} {i 124 t hello_world}}
282 } {
283 {INSERT t1 0 X. {} {i 124 t hello_world}}
284 }
285
286 do_changegroup_patchset_test 3.2 {
287 grp change_begin UPDATE t1 0
288 grp change_int64 old 0 123
289 grp change_int64 new 1 789
290 grp change_finish false
291
292 grp change_begin DELETE t1 1
293 grp change_int64 old 0 122
294 grp change_finish false
295 } {
296 {DELETE t1 1 X. {i 122 {} {}} {}}
297 {UPDATE t1 0 X. {i 123 {} {}} {{} {} i 789}}
298 }
299
300 do_changegroup_patchset_test 3.3 {
301 grp change_begin DELETE t1 0
302 grp change_int64 old 0 123
303 grp change_finish false
304 } {
305 {DELETE t1 0 X. {i 123 {} {}} {}}
306 }
307
308 do_changegroup_script_test 3.4 {
309 grp change_begin INSERT t1 0
310 grp change_int64 new 0 124
311 grp change_text new 1 hello_world
312 grp change_finish false
313
314 grp change_begin DELETE t1 0
315 grp change_int64 old 0 124
316 grp change_text old 1 hello_world
317 grp change_finish false
318
319 grp change_begin INSERT t1 0
320 grp change_int64 new 0 1000
321 grp change_blob new 1 abcd
322 grp change_finish false
323
324 grp change_begin UPDATE t1 0
325 grp change_int64 old 0 1000
326 grp change_blob old 1 abcd
327 grp change_blob new 1 bcda
328 grp change_finish false
329 } {
330 {INSERT t1 0 X. {} {i 1000 b bcda}}
331 } {
332 {INSERT t1 0 X. {} {i 1000 b bcda}}
333 }
334
335 do_changegroup_script_test 3.5 {
336 grp change_begin DELETE t1 0
337 grp change_int64 old 0 1000
338 grp change_text-1 old 1 "hello world"
339 grp change_finish false
340 } {
341 {DELETE t1 0 X. {i 1000 t {hello world}} {}}
342 } {
343 {DELETE t1 0 X. {i 1000 {} {}} {}}
344 }
345
346 #-------------------------------------------------------------------------
347
348 # Calling sqlite3changegroup_change_finish() if a change has not been
349 # started is a no-op.
350 #
351 do_test 4.0 {
352 sqlite3changegroup grp
353 grp change_finish false
354 } {}
355
356 # But calling any other sqlite3changegroup_change_xxx() function if a
357 # change has not been started is a misuse.
358 #
359 foreach {tn cmd} {
360 1 { grp change_blob old 0 abcd }
361 2 { grp change_text new 1 helloworld }
362 3 { grp change_int64 old 2 12345678 }
363 4 { grp change_double new 3 12.345 }
364 5 { grp change_null old 4 }
365 } {
366 do_test 4.1.$tn {
367 list [catch $::cmd msg] $msg
368 } {1 SQLITE_MISUSE}
369 }
370 grp delete
371
372 do_execsql_test 4.2.1 {
373 CREATE TABLE t3(a, b PRIMARY KEY);
374 }
375 do_test 4.2 {
376 sqlite3changegroup grp
377 grp schema db main
378 grp change_begin INSERT t3 0
379
380 list [catch { grp change_begin INSERT t3 0 } msg] $msg
381 } {1 SQLITE_MISUSE}
382 grp delete
383
384 do_test 4.3 {
385 sqlite3changegroup grp
386 grp schema db main
387 grp change_begin UPDATE t3 0
388 } {}
389 foreach {tn cmd} {
390 1 { grp change_blob old -1 abcd }
391 2 { grp change_text new 2 helloworld }
392 } {
393 do_test 4.4.$tn {
394 list [catch $::cmd msg] $msg
395 } {1 SQLITE_RANGE}
396 }
397 grp delete
398
399 finish_test
400