On Tue, Dec 13, 2016 at 9:41 AM, Simon Slavin <slav...@bigfraud.org> wrote:
> > On 13 Dec 2016, at 3:20pm, Paul Egli <e...@sourcegear.com> wrote: > > > Why must SQLite find rows where the value is NULL? > > Because the related fields in the offspring row might have NULL in them, > and SQLite needs to know how to find the parent row for that row. > > Well if i am missing something, i still cannot see it. Based on these quotes in the docs, i assume that a NULL in the child table means that it does not have a parent. "All foreign key constraints in SQLite are handled as if MATCH SIMPLE were specified." "If "MATCH SIMPLE" is specified, then a child key is not required to correspond to any row of the parent table if one or more of the child key values are NULL." Therefore SQLite would *not *need to find a parent for that row. So i guess i am still hoping that, if possible, SQLite could be enhanced as David's question was getting at. :-) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users