#4245 (ok 4.1.7) initial Browse query does not match sorting order

[Alexander Schuch]

phpMyAdmin stores the order of each table per user. So when the user browses a table, the sort order is used from user preferences.

The problem here is that the initial query does not reflect the search order.

1. Browse a table. The query shown will be "SELECT * FROM table".
2. Sort by column col. the query shown will be "SELECT * FROM table ORDER BY table.col ASC".
3. Leave the table and re-enter it or directly hit "Browse" again from top navigation.
4. The query show is the same as in 1. But the records are sorted according to the stored user preferences as resulting from 2.

I expect the GUI and the result set to be syncronised, regarding shown query and record order, even initially.

[Viduranga Wijesooriya]

Hi Alexander,
I was able to reproduce your problem. I will try to fix it

[Sampath Liyanage]

Hi,

I think there is another bug due to not synchronizing.

1. Browse a table. The query shown will be "SELECT * FROM table".
2. Sort by column col. so that sorting is "DESC".
3. Now go to "SQL" tab and click "go" without changing the query.
4. Now displayed query is "SELECT * FROM tablename where 1". But still the table
   is sorted in DESC order.

[Sampath Liyanage]

I made some changes and sent a pull request. With these changes now ordered table and the query are synchronized and displayed only if the user browses tables through navigation tree. Otherwise the order is remembered, but not displayed.

https://github.com/phpmyadmin/phpmyadmin/pull/872

[Marc Delisle]

Fixed with https://github.com/phpmyadmin/phpmyadmin/commit/e8fa9e533565eb2503586ce7040236a928a50de2

[Marc Delisle]

Previous fix reverted; new fix applied:
https://github.com/phpmyadmin/phpmyadmin/commit/212a7e5a7e249f18c6c4daa56be801edc176d789

[Sampath Liyanage]

I think this bug was not 100% resolved with the new fix.

1.Browse a table. The query shown will be "SELECT * FROM table".
2.Sort by a column so that sorting becomes "DESC".
3.Now go to "SQL" tab, write a query for the table that starts with "SELECT * FROM [tabel name]" without adding any "order by" field, click on "go" button.
4.Now the table is still sorted in "DESC" order. But it should not be ordered (at least it should be sorted in "ASC" order").

[Madhura Jayaratne]

@Sampath: Thank you for pointing this out. I've written to dev mailing list to get an opinion on the expected behavior of this case. Let's see what others think.