On Mar 3, 2008, at 12:03 PM, P Kishor wrote:
> Dan,
>
>
> On 3/2/08, Dan <[EMAIL PROTECTED]> wrote:
>>
>> Hi,
>>
>> I tried this script here with the latest CVS version and
>> it didn't crash:
>>
>> CREATE TABLE pages(page_id INTEGER PRIMARY KEY, page_name TEXT,
>> page_text TEXT);
>> CREATE VIRTUAL TABLE fts_pages USING fts3(page_name, page_text);
>>
>>
>> CREATE TRIGGER delete_fts
>> AFTER DELETE ON pages
>> BEGIN
>> DELETE FROM fts_pages WHERE rowid = old.page_id;
>> END;
>>
>> CREATE TRIGGER insert_fts
>> AFTER INSERT ON pages
>> BEGIN
>> INSERT INTO fts_pages (rowid, page_text)
>> VALUES (new.page_id, new.page_text);
>> END;
>>
>> CREATE TRIGGER update_fts
>> AFTER UPDATE OF page_text ON pages
>> BEGIN
>> UPDATE fts_pages
>> SET page_text = new.page_text
>> WHERE rowid = old.page_id;
>> END;
>>
>>
>> INSERT INTO pages (page_name, page_text) VALUES ('foo', 'bar');
>>
>>
>> Can you test this in your environment?
>
> I am not sure what I should test in my environment. Did you mean to
> send me some script? Or, are you asking me to try the latest version
> from CVS?
I mean the set of SQL statements above. Create the schema and
execute a single INSERT statement. Does starting with an empty
database and feeding them to the sqlite shell cause a crash?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
