Menu

#3912 (ok 4.0.3) Exporting row selection after ORDER BY

Latest_Git
fixed
None
1
2013-06-11
2013-05-06
No

Bug #3797
https://sourceforge.net/p/phpmyadmin/bugs/3797/
is still in Git ce94d11 committed on May 06, 2013 at 05:14.
To reproduce a minor change to the testcase is needed.

Run this in SQL tab:

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (id INT UNIQUE);
INSERT INTO t1 VALUES (1);
SELECT * FROM t1 ORDER BY id;

Select the row. Click Export. Click OK.

Now we get error #1064 because of the ORDER BY line before the WHERE clause:

SELECT *
FROM t1
ORDER BY id
WHERE (t1.id =1)
ORDER BY id

Discussion

  • Chanaka Indrajith Dharmarathna

    • assigned_to: Chanaka Indrajith Dharmarathna
     
  • Marc Delisle

    Marc Delisle - 2013-05-26
    • summary: Exporting row selection after ORDER BY --> (ok 4.0.3) Exporting row selection after ORDER BY
    • status: open --> open-fixed
    • Priority: 5 --> 1
     
  • Michal Čihař

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

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