SQLite version 3.7.11
Fedora 17
Linux 3.3.4-5.fc17.i686.PAE
The CREATE TABLE text file below is missing a comma after the first FOREIGN KEY
clause, and this should draw an error.
No error is reported, and the table is created with all three FOREIGN KEY
constraints.
$ sqlite3 test.db <test.sql
==== test.sql =================
CREATE TABLE path2file (
id INTEGER NOT NULL PRIMARY KEY,
f_id INTEGER,
p_id INTEGER,
z_id INTEGER,
mode CHAR(4),
date_stmp CHAR(10),
time_stmp CHAR(10),
FOREIGN KEY (f_id) REFERENCES file (id)
FOREIGN KEY (p_id) REFERENCES path (id),
FOREIGN KEY (z_id) REFERENCES backup_zip (id)
);
===========================
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
