Lines Matching refs:changes

11 # Tests to make sure that values returned by changes() and total_changes()
14 # Note 1: changes() remains constant within a statement and only updates
17 # Note 2: changes() is changed within the context of a trigger much like 
20 # Note 3: changes() is not changed by a change to a view (since everything
31 # changes() set properly after insert
43         select changes(), total_changes();
47 # changes() set properly after update
51         select changes(), total_changes();
62     execsql {select changes()}
65 # changes() unchanged within an update statement
69         update t0 set x=x+changes() where x=3;
74 # changes() set properly after update on table where no rows changed
78         select changes();
82 # changes() set properly after delete from table
86         select changes();
102 # changes() changed properly after insert into table containing after trigger
109             insert into t2 values (NULL, changes(), NULL);
111             update t2 set v2=changes();
114         select changes();
118 # changes() unchanged upon entry into after insert trigger
125 # changes() changed properly by update within context of after insert trigger
132 # Total changes caused by firing the trigger above:
135 #   1 from "insert into t2 values (NULL, changes(), NULL);" +
137 #   1 from "update t2 set v2=changes();"
146 # changes() changed properly after update into table containing after trigger
152             insert into t2 values (NULL, changes(), NULL);
154             update t2 set v2=changes();
157         select changes();
161 # changes() unchanged upon entry into after update trigger
168 # changes() changed properly by delete within context of after update trigger
178 # changes() changed properly on delete from table containing before trigger
184             insert into t2 values (NULL, changes(), NULL);
186             update t2 set v2=changes();
189         select changes();
193 # changes() unchanged upon entry into before delete trigger
200 # changes() changed properly by insert within context of before delete trigger
232             insert into n1 values (NULL, changes());
234             insert into n1 values (NULL, changes());
236             insert into n1 values (NULL, changes());
239             insert into n1 values (NULL, changes());
242             insert into n2 values (NULL, changes());
244             insert into n2 values (NULL, changes());
246             insert into n2 values (NULL, changes());
248             insert into n2 values (NULL, changes());
251         select changes();
258         select changes();
265         select changes();
298     SELECT changes();
306     SELECT changes();
315     SELECT changes();