SQLite Forum

SELECT with LIMIT OFFSET clause return unexpected result (with sample db and query)
Bisects to [check-in 2a74129a21f9745f](src:/timeline?c=2a74129a21f9745f).  I do
not believe that is the source of the problem - I think it is just a change
that enabled this particular test-case to work.  Probably the problem goes back
a lot further.