Thanks for taking the time to send in the report and thanks to all who investigated it. The robust discussion demonstrates the passion of the sqlite community, and I enjoy thinking about the various points as they are made. ________________________________ From: [Vermes Mátyás <[email protected]>] Sent: Mar 10, 2017 7:37 AM To: [SQLite mailing list <[email protected]>] Subject: [Re: [sqlite] sqlite3 feature or regression]
Thanks. Naturally I had experimented with several versions of the program, and saw that any ordering makes the new feature/error disappear. You can see it if you read the comment at the bottom of my original script. But my purpose was the opposite: demonstrate the regression. I am not interested in this thing. I do not have applications based on SQLite. Simply I think that this feature/error cannot be left in its current state, because this is in contradiction with the axiom, that the result of a query must not depend from the existence of an index. I wanted to help you with this bug report, but I cannot do more for that. > As Dan already observed, the problem results because you are modifying > an index in the middle of a scan of that index, thereby messing up the > scan. Don't do that. The safest approach is to run the query to > completion, then go back and start the loop over UPDATEs. > > If you add "ORDER BY +rowid" to the query, that forces the query to > run to completion first and then go through the sorter, before you get > any results back, which solves the problem. -- Vermes Mátyás <[email protected]> _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ---------------------------------------------------------------------- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
