#2970 SQL ORDER BY

fixed
nobody
5
2013-06-11
2010-01-27
Mich
No

phpMyAdmin - 2.11.9.3
* Версия MySQL-клиента: 5.0.85

I use query like
SELECT * FROM `main` WHERE text like '%русский текст%' ORDER BY `main`.`datetime` DESC

When I press column header for change sort order I get an error query
SQL: SELECT * FROM `main` WHERE text like '%русский т ORDER BY `main`.`phone` ASC

Discussion

    • status: open --> pending
     
  • I can confirm this in the MAINT_2_11_10 branch, however the 3.x branch no longer has this issue.
    I doubt this will get enough priority to get fixed.

     
  • This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

     
    • status: pending --> closed
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed --> fixed