Hi,
Sqlite man (https://www.sqlite.org/lang_select.html) [https://sqlite.org/images/syntax/select-stmt.gif]<https://www.sqlite.org/lang_select.html> SQLite Query Language: SELECT<https://www.sqlite.org/lang_select.html> www.sqlite.org The SELECT statement is used to query the database. The result of a SELECT is zero or more rows of data where each row has a fixed number of columns. says: "If a SELECT statement that returns more than one row does not have an ORDER BY clause, the order in which the rows are returned is undefined" There is a question: We have scenario: * database is opened in WAL mode * 10 rows have been read to container1 * database has been checkpointed * database has been closed * database has been opened on DELETE mode * 10 rows have been read to container2 Can we assume that container1 == container2 ? Or in another words can we assume that order of rows is same in this scenario? Regards, Andrii _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users