#3797 (ok 4.0.5) Exporting row selection after ORDER BY

[Julian Ladisch]

How to reproduce:

Run this in SQL tab:

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

Select the row. Click Export. Now this SQL appears:

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

The ORDER BY line before WHERE is wrong and triggers
error #1064 during export.

[Harsha]

Hi!
I have able to reproduce this.I'm looking into it.This happen when exporting a row after query which is having order by term. Normally row can export without any issue.
Thanks

[Harsha]

Hi!
I have fix the bug and i'll send a pull request now.
Thanks!

[Harsha]

Pull request-
https://github.com/phpmyadmin/phpmyadmin/pull/170

[Harsha]

Pull request according to feedback received for above pull request.

Pull request-https://github.com/phpmyadmin/phpmyadmin/pull/172

[Marc Delisle]

These pull requests were rejected.

[Michael Therrien]

Any update on this? I've seen that the problem is not apparent in 4.0.5 but 3.5.5 and 3.5.6.

[Hugues Peccatte]

Hi,

I sent a pull request here: https://github.com/phpmyadmin/phpmyadmin/pull/767

[Marc Delisle]

Hugues,
thanks for confirming that this has been fixed for 4.0