All that is weird is that SQLite appends a LIMIT 1 to the subquery to ensure it only returns one row. This can be seen clearly if you look at the EXPLAIN ouput.
Some other SQL engines just explode ... some throw an error. I suppose it all depends on your interpretation of "do as I mean, not as I say". Sent from Samsung Mobile -------- Original message -------- From: Petite Abeille <petite.abei...@gmail.com> Date: To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite] sqlite bug? Subquery containing like-expression in where clause with starting '%' returns no rows, but without '%' does _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
