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

[Julian Ladisch]

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