> I would agree that no warning is needed for for columns that don't state > any affinity, or for a non-affinity FK that refers to some PK with > affinity. > > I tend to agree with OP that an explicitly text foreign key referring to > an explicitly int primary key is probably worth a warning (perhaps from > the hypothetical "lint mode" that surfaces now and then),
I agree. So it's basically very comfortable to have such a "lazy" type checking, but a "lint mode" could help similar situations. Thanks everyone for all the answers, Tamás _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users