On 28 Nov 2015, at 4:19pm, Keith Medcalf <kmedcalf at dessus.com> wrote:
> The long and the short of it is that the result is exactly correct (and > *always* entirely predictable). The /result/ is exactly correct and entirely predictable. If you consider the result to be just the thing you asked for. How you get there is exactly correct and entirely predictable if and only if you've read and understood the source code to SQLite and understand exactly the content of your database file. And the whole point of having someone else write you a DBMS is give you answers without you having to do that. If you want something that you can entirely predict you're going to have to write and debug it yourself. Simon.