On Sep 14, 2011, at 9:27 PM, Darren Duncan wrote: > Petite Abeille wrote: >> On Sep 14, 2011, at 8:55 PM, Magnus Thor Torfason wrote: >>> Now, I get a list of the jobs, and a random selection of employees. I would >>> have expected an error here. Of course, my actual query was different (this >>> is based on the Oracle example data base from very old days), but it was >>> also much more complicated, so I did not notice the error until a bit of >>> fishing around. So getting an explicit error here would have made things >>> simpler. >>> Is there a way to do that? "PRAGMA strict" was one thing I thought about >>> looking for, but I did not find any such pragma. >> Well, this is one of these, hmmm, rather unwelcome features of SQLite. No way >> around it except vigilance :/ > > Actually, I think that this *is* welcome.
Well, one person feature is another person bug :) To misquote Larry Wall: P1: I find this a interesting feature but it is not according to the common sense. Or is it a BUG? P2: Let's call it an accidental feature. :-) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users