Summary: CSV & SQL exports of query results with CONCAT() and LIMIT set fail.
Running MySQL 5.0.22, Linux FC6, using FF2.0 as browser. Ran a rather helpful query:
SELECT CONCAT_WS('+','http://www.google.com/search?q=','foo','bar') FROM table_a
It worked perfectly when viewing results in phpmyadmin. When I added LIMIT 20 or LIMIT 0,20 for test/pre-viewing purposes for the bash scripts that are gonna use it and tried to export ('Query results operations->Export') as CSV or SQL as file or direct display, i got the error seen in attached 'sql-error'. The CSV error is the HTML portion of the sql error message.
The most salient error line I could make out was/is:
#1305 - FUNCTION contacts.CONCAT_WS does not exist
#1305 - FUNCTION contacts.CONCAT does not exist
Seems, phpMyAdmin is sticking when a LIMIT is included in query, because when I remove limits (and export query form shows Dump: # of all records in record count), then it works as expected.
Very, very reproducible. LIMIT error reproduces when URL is escaped or unescaped. LIMIT error reproduces with concat_ws() and concat(). I usually export queries without LIMITs so don't know if this phenomena is related to concat or not, althought above error messages are again somewhat indicative.