Re: [sqlite] 3.6.23 segmentation fault with trigger and DEFAULT VALUES

2010-06-08 Thread
> Actually it's found in version 3.6.23 and fixed in the trunk of SQLite > repository but SQLite didn't have a release since then. So this bug > will be fixed in the next version. * Pavel I got it. Thank you very much indeed. ___

Re: [sqlite] 3.6.23 segmentation fault with trigger and DEFAULT VALUES

2010-06-07 Thread
This is my first time to reply email of gmane-news. so if there is anything wrong, please forgive me. >Which operating system are you running ? >Are you running your code in the command-line program or with your own program ? >If you are running your own program, are you accessing

[sqlite] 3.6.23 segmentation fault with trigger and DEFAULT VALUES

2010-06-07 Thread
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