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?


-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to