Search results show Edit/Delete in reversed order to the rows

[Former user]

Originally reported on Google Code with ID 263

What steps will reproduce the problem?
1. Search table phrases, on field phrase choose "LIKE %...%" and search for "%rome%"
2.
3.

What is the expected output?
Clicking on Edit/Delete for the first row to Edit/Delete the first row

What do you see instead?
Clicking on Edit/Delete on the first row Edits/Deletes the last row (reversed order)

What version of the product are you using? On what operating system? Which
Database Extension (PDO/SQLiteDatabase/SQLiteDatabase3 - see Database
structure-tab in phpLiteAdmin)?

Linux
SQLite version: 3.8.7.4
SQLite extension [?]: PDO
PHP version: 5.6.4

Please provide any additional information below.

Reported by erictsau on 2015-01-18 16:14:12

<hr> * Attachment: rome.sqlite

[Christopher Kramer]

What version are you using? 1.9.5 or a development version of 1.9.6?

I cannot reproduce this with 1.9.5. Neither with the current development version of
1.9.6 just committed. But there were bugs in the previous development version with
the search function, though I am not sure your exact problem.

Reported by crazy4chrissi on 2015-01-19 13:53:58

[Former user]

I am using version 1.9.5

Using the file attached: rome.sqlite

1. Click on [Table] phrases
2. Click Search
3. On the field/column for phrase, select the "LIKE %...%" Operator
4. In the textbox for field/column phrase, type "%rome%"
5. Click the Search button
Search results produce three records, id 12,13,57
6. Click Edit for the first record, id 12 "rome wasn't built in a day"

Results:
The edit record page for id 57 "play the fiddle while rome burns"
, which was the last record of the search results

Expected results:
The edit record page for id 12 "rome wasn't built in a day"


If it's still not quite clear then I'll wait for you to post a link for the latest
version and test for this bug and report back.

Reported by erictsau on 2015-01-20 08:16:42

[Christopher Kramer]

This issue should be fixed with 1.9.6, as the generation of IDs was rewritten to support tables without rowid (issue #240). I tried it with 1.9.6 and could not reproduce it with the rome.sqlite attached. Therefore, I consider this fixed.