Lines Matching refs:changes

18 # [db changes] to the result of executing the SQL script.
22     do_test $tn "concat \[execsql {$sql}\] \[db changes\]" $res
28 # EVIDENCE-OF: R-58361-29089 The changes() function returns the number
74   # requirement - changes made by other connections do not show up in
79     db2 changes
82     db changes
99   do_test 1.$tn.9 { db changes } 0
104   do_test 1.$tn.11 { db changes } 0
121 # The statement above set changes() to 47. Check that none of the following
132 # EVIDENCE-OF: R-53938-27527 Only changes made directly by the INSERT,
133 # UPDATE or DELETE statement are considered - auxiliary changes caused
274 set ::changes [list]
276   set res [db changes]
277   lappend ::changes $x $res
301   set ::changes
313     INSERT INTO log VALUES(old.b || ' -> ' || new.b || ' c = ' || changes() );
317   UPDATE t1 SET b = changes();
331 # will not include any changes performed by sub-triggers, as the
344     INSERT INTO log VALUES('t2->' || changes());
349     INSERT INTO log VALUES('t3->' || changes());
354     INSERT INTO log VALUES('t2->' || changes());
359     INSERT INTO log VALUES('t3->' || changes());
364     INSERT INTO log VALUES('t2->' || changes());
369     INSERT INTO log VALUES('t3->' || changes());
392 # EVIDENCE-OF: R-43399-09409 This means that if the changes() SQL
410     /* changes() returns value from previous I/U/D in callers context */
411     INSERT INTO q1 VALUES('1:' || changes());
413     /* changes() returns value of previous I/U/D in this context */
414     INSERT INTO q3 VALUES(changes()), (2), (3);
415     INSERT INTO q1 VALUES('2:' || changes());
416     INSERT INTO q3 VALUES(changes() + 3), (changes()+4);
418     INSERT INTO q1 VALUES('3:' || changes());
420     INSERT INTO q1 VALUES('4:' || changes());
422     INSERT INTO q1 VALUES('5:' || changes());