On Feb 20, 2013, at 9:29 PM, Richard Hipp <d...@sqlite.org> wrote: > On Wed, Feb 20, 2013 at 3:25 PM, Petite Abeille > <petite.abei...@gmail.com>wrote: > >> >> On Feb 20, 2013, at 2:15 PM, Richard Hipp <d...@sqlite.org> wrote: >> >>> SQLite automatically adds a LIMIT 1 to a scalar subquery. >> >> Yeah… that's a bit of a death trap though… would be much more productive >> if SQLite would raise an exception instead of doing something covert and >> random... >> > > There are over one million applications that use SQLite as it is currently > implement. Perhaps you are right that the proposed behavior makes better > sense. (Or perhaps not - the case can be argued.) But how many of those > one million applications would be busted and need to be fixed? You want to > test them all?
Well… considering that such applications are already broken as is… making such defect explicit might be beneficial overall… just imagine how many hidden, potentially dangerous, bugs SQLite could uncover in one swell swoop... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
