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 :/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users