Menu

#2626 (ok 2.11.5) data export to Latex and "limit"

fixed
1
2013-06-11
2008-01-16
kalispera
No

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

Discussion

  • Sebastian Mendel

    • status: open --> open-accepted
     
  • Sebastian Mendel

    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

     
  • Sebastian Mendel

    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

     
  • Marc Delisle

    Marc Delisle - 2008-01-18
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2008-01-18

    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.

     
  • Marc Delisle

    Marc Delisle - 2008-01-18
    • priority: 5 --> 1
    • summary: data export to Latex and "limit" --> (ok 2.11.5) data export to Latex and "limit"
    • status: open-accepted --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2008-03-01
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

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