Hi, dear sqlite-list. I am a newbie with sqlite.
I found a bug lately, like this: CREATE TABLE stuff (id INTEGER PRIMARY KEY DEFAULT 1); CREATE TRIGGER stuff_insert_trg BEFORE INSERT ON stuff BEGIN SELECT * FROM stuff; END; insert into stuff DEFAULT VALUES; It will be segmentation fault. but when I do this: CREATE TABLE stuff (id INTEGER PRIMARY KEY DEFAULT 1); CREATE TRIGGER stuff_insert_trg AFTER INSERT ON stuff BEGIN SELECT * FROM stuff; END; insert into stuff DEFAULT VALUES; It will be OK. And also when I do this: CREATE TABLE stuff (id INTEGER PRIMARY KEY DEFAULT 1); CREATE TRIGGER stuff_insert_trg BEFORE INSERT ON stuff BEGIN SELECT * FROM stuff; END; insert into stuff values(1); It will be OK, too. So I think that the segmentation fault is about trigger and DEFAULT VALUES when the trigger active BEFORE INSERT and user want to insert default values. Am I right? Thanks for anyone to reply me as soon as quickly. Thanks for this great tool!!! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users