Hi. I've just got a segmentation fault report with SQLite 3.8.0 from
one of the perl binding users. The following set of SQL statements
should reporduce the issue.
Regards,
Kenichi Ishigaki
CREATE TABLE "twokeys" (
"artist" integer NOT NULL,
"cd" integer NOT NULL,
PRIMARY KEY ("artist", "cd")
);
CREATE TABLE "fourkeys" (
"foo" integer NOT NULL,
"bar" integer NOT NULL,
"hello" integer NOT NULL,
"goodbye" integer NOT NULL,
"sensors" character(10) NOT NULL,
"read_count" int,
PRIMARY KEY ("foo", "bar", "hello", "goodbye")
);
CREATE TABLE "fourkeys_to_twokeys" (
"f_foo" integer NOT NULL,
"f_bar" integer NOT NULL,
"f_hello" integer NOT NULL,
"f_goodbye" integer NOT NULL,
"t_artist" integer NOT NULL,
"t_cd" integer NOT NULL,
"autopilot" character NOT NULL,
"pilot_sequence" integer,
PRIMARY KEY ("f_foo", "f_bar", "f_hello", "f_goodbye", "t_artist", "t_cd")
);
INSERT INTO fourkeys ( bar, foo, goodbye, hello, read_count, sensors)
VALUES ( 1, 1, 1, 1, 1, 1 );
INSERT INTO twokeys ( artist, cd) VALUES ( 1, 1 );
INSERT INTO fourkeys_to_twokeys ( autopilot, f_bar, f_foo, f_goodbye,
f_hello, pilot_sequence, t_artist, t_cd) VALUES ( 1, 1, 1, 1, 1, 1, 1,
1 );
DELETE FROM fourkeys_to_twokeys WHERE f_bar = 1 AND f_foo = 1 AND
f_goodbye = 1 AND f_hello = 1 AND t_artist = 1 AND t_cd = 1;
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
