Dear all,
I've just read the 3.7.11 release notes. This version fixes the LEFT JOIN bug
with OR in the WHERE clause introduced in 3.7.10. Since our software is
currently based on 3.7.10 and it is not easy for us to upgrade to 3.7.11, I
just want to be sure about the bug impacts.
1. I have double checked our code and there is no LEFT JOIN at all, but there
are a lot of INNER JOINS and complex WHERE clauses with multiple column indices
and the OR operator. Is the LEFT JOIN a requirement for this bug to appear?
With other words, are we safe with 3.7.10 if no LEFT JOIN keywords are used at
all? I think that one could rewrite a LEFT JOIN query using an UNION and the
NOT EXISTS operators. Would this bug appear in this case as well?
2. A more general question. We like SQLite for its performance, robustness and
reliability. We also read the "How SQLite is tested" article, which states that
millions of SQL queries are run before any SQLite version is released. Well,
how is it possible, that a SQLite version passes these tests with something
fundamental like LEFT JOIN not working correctly?
Thanks.
Alex
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
