Query:Val
1
2
3
4
5
6
7
8
9
10
SELECT Val
FROM tab
ORDER BY Val DESC
LIMIT 5,5
Result in 6.5.1(good!):
Result in 6.6.6( wrong! ):Val
5
4
3
2
1
New property SortedType =>Val
10
9
8
7
6
1.Transofrm query:
( DESC is absent)SELECT Val
FROM tab
ORDER BY Val
LIMIT 5,5
2. SortedType = stDescending => local sorting.
But I need all query sort and 2nd page.
How can I get it?