Sqlite causes Segmentation fault on SQL insert.
Steps to reproduce:
1. create database with following schema (table/column names dosen't matter)
----- BEGIN OF SQL LISTING
create table tname ( id integer not null primary key asc autoincrement,
cname string );
create table surname ( id integer not null primary key asc autoincrement,
surname string );
create table people ( cname integer not null references cname (id),
surname integer not null references surnname (id));
create view peopleview as
select tname.cname, surname.surname from people
left outer join tname on (tname.id = people.cname)
left outer join surname on (surname.id = people.surname);
create trigger create_people instead of insert on peopleview
begin
insert into tname (cname) values (new.cname);
insert into surname (surname) values (new.surname);
end;
----- END OF SQL LISTING
2. execute sql insert statement: insert into peopleview values('John', 'Smith');
Reproductible: always.
Affected versions: sqlite-3.6.18
sqlite-3.6.17 works well.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
