Comment by vomjom

I think you misunderstand the goals of sqlite, which is why you think it's a bug and the author does not.

Sqlite doesn't intend to include a very smart query planner simply because that would make it much larger and more complex. That means it'll do stupid things for some queries sometimes, but in return, you get a small library that's quick for common queries.