Menu

#2905 (ok 3.2.3) Order by desc sometimes not working

fixed
1
2013-06-11
2009-07-23
No

Hi,

When I click on the column header, the order by isn't changed from asc to desc. This only fails for the functional columns, the others work fine.

SELECT p . * , from_unixtime( last_online_time ) , from_unixtime( p.ctime )
FROM `xwi_players` p
INNER JOIN xwi_serials
USING ( sid )
WHERE valid <0
AND ~ flags &2
ORDER BY from_unixtime( last_online_time ) ASC
LIMIT 0 , 30

Discussion

  • Marc Delisle

    Marc Delisle - 2009-10-24
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2009-10-24

    Fixed in subversion, thanks for reporting.

     
  • Marc Delisle

    Marc Delisle - 2009-10-24
    • priority: 5 --> 1
    • summary: Order by desc sometimes not working --> (ok 3.2.3) Order by desc sometimes not working
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2009-10-30
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed