Hie,
I use phpMyAdmin - 2.11.4 and MySQL: 5.0.45
I've found a small in the export of small Select in Latex format. It seems the export to Latex (fabulous tool anyway!) doesn't work either you add a limit to the query or not.
How to reproduce:
CREATE TABLE IF NOT EXISTS `test` (
`a` int(4) NOT NULL COMMENT 'annee',
`b` varchar(6) NOT NULL COMMENT 'lieu'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
This first query export OK:
SELECT a , count(*) FROM `test` GROUP BY a
This one not:
SELECT a , count(*) FROM `test` GROUP BY a limit 0,30
Strange isn't it? It seems that only queries with COUNT(*) AND LIMIT have problem!
Thank you very much for your GREAT work.
Regards,
François
Logged In: YES
user_id=326580
Originator: NO
seems the export adds some extra space to the query before executing, which results in a failed query
Logged In: YES
user_id=326580
Originator: NO
also see: #1861436 Export of query results with LIMIT and CONCAT_WS() Fails
http://sourceforge.net/support/tracker.php?aid=1861436
Logged In: YES
user_id=210714
Originator: NO
This bug could be more easily seen with other export types like SQL. Fixed for 2.11.5.