Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.2.22
-
None
Description
ASC is correct:
select ID from GAMES order by RateUp АSC limit 0,1
=>ID=1
select ID from GAMES order by RateUp АSC limit 1,1
=>ID=3
DESC is wrong (#2):
select ID from GAMES order by RateUp DESC limit 0,1
=>ID=3 (correct)
select ID from GAMES order by RateUp DESC limit 1,1
=>ID=3 (wrong: must be ID=1 but it isn't)
How to repeat:
Table with two columns ID and RateUp
ID=1,RateUp=0
ID=3,RateUp=0