I did provide a sample with test data in my original post. However, I posted it here too:
http://www.sqlite.org/cvstrac/tktview?tn=4043 The tracker is obviously closed, but still, there it is :P. Don't know where else to post it. /Chris > Date: Sun, 18 Oct 2009 16:25:48 -0700 > From: dar...@darrenduncan.net > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] "x NATURAL JOIN x" BUG > > Kristoffer Danielsson wrote: > > NATURAL INNER JOIN yields a cartesian product too. Just tried it! > > Well then, *surely* that at least has to be a SQLite bug. > > That said, it would be useful for clarity if you posted to the list exactly > how > you wrote your NATURAL INNER, what the exact SQL you used was, with test data > and result, so we know you didn't just make a typo in your test. > > Use the simplest possible example that illustrates the point, such as with > Jay's > example. > > And I would expect NATURAL JOIN to default to INNER even if JOIN defaults to > CROSS, just because that makes the most sense. When people specify NATURAL, > then what they expect is INNER semantics in the general case. > > -- Darren Duncan > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _________________________________________________________________ Hitta kärleken nu i vår! http://dejting.se.msn.com/channel/index.aspx?trackingid=1002952 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users