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 <[email protected]> Date: To: General Discussion of SQLite Database <[email protected]> Subject: Re: [sqlite] sqlite bug? Subquery containing like-expression in where clause with starting '%' returns no rows, but without '%' does _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
