wondering if this is a known issue in 3.6.20.
create table t1(_id integer primary key, v integer, d integer);
CREATE TRIGGER t1_trig BEFORE UPDATE ON t1
BEGIN
update t1 SET v=OLD.v+1 WHERE NEW._id=OLD._id AND NEW.d!= OLD.d;
END;
insert into t1 values(1, 1,0);
update t1 set d= 2 where _id = 1; <-- expected "v" = 2
select * FROM t1; <-- shows "v" = 1
this works fine in versions upto 3.6.16..
in 3.6.20, trigger does the right thing and updates the table. but the data
is not reflected in the table after the update statement is complete. I
didn't look at the vdbe.
anyone seen this behavior?
thanks
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
