Rowids in Browse and Search might be inconsistent

Originally reported on Google Code with ID 144

Browse and Search use 2 SELECT queries. One to get the actual result, one to get the
rowids.

Problem is that rowids might change between these two queries so stuff might get inconsistent.
Example of a problem:
1. We SELECT the actual results. The values of rows 1,5 and 6 are returned.
2. somebody (else) inserts row 3.
3. We SELECT the rowids. We get 1,3,5,6.
7. We think row 5 has the id 3 and so on.

To solve this, the preferred way would be to use one query only. Alternatively, one
could use a transaction to ensure both queries are consistent.

Reported by crazy4chrissi on 2012-11-15 17:01:26

Comments (1)