I don't know. It works entirely as expected. If I move a row (via update) that I have already visited into a position where it is "yet to be visited", then I will visit it twice -- both times exactly when and where expected. If there is a row I have not visited yet and I delete it before I read it, then I won't be reading it.
There is very little confusion here and very little reliance on anything other than the application of logic. All technologies appear to be magic when those technologies are beyond the understanding. This does not demonstrate magic, but a deficit in wattage and understanding. > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Igor Tandetnik > Sent: Saturday, 13 July, 2013 07:37 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Another 2 questions about SQLite > > On 7/13/2013 1:36 AM, Keith Medcalf wrote: > > Of course, the behaviour is not actually "undefined" -- it is > perfectly determinable and entirely predictable and reasonable. > However, if one does not understand the factors which determine the > behaviour then, for you, the behaviour is undefined. In other words, > if one does not know what results are expected to be obtain and why, > then the responsibility rests with the one who is "using the force" > instead of understanding what they are doing. > > The results are undefined in the sense that the authors don't document > any particular behavior, and perhaps more importantly, don't commit to > maintaining any particular behavior in future releases. If your > program > does something that falls under undefined behavior, and it appears to > work to your liking, it does so only by accident. It relies on > internal > implementation details, subject to change without notice. > > You may of course continue to live dangerously; just don't be > surprised > when you upgrade to a newer SQLite version and you program breaks. > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
