#3568 LIMIT 0,30 added to SQL SELECT

3.5.0
invalid
nobody
5
2013-06-11
2012-04-16
Anonymous
No

When I type a SELECT statement into the SQL box, pMA adds an unwanted "LIMIT 0,30" at the end of it.
I understand the use of this for browsing, but when I enter my own SQL I want it executed as I enter it.

Discussion

  • Marc Delisle
    Marc Delisle
    2012-04-21

    This is a safety measure and it will stay there. To be able to see all the rows, please ensure that your $cfg['ShowAll'] directive is set to true, then you'll have a "Show all" button when the result set is displayed.

     
  • Marc Delisle
    Marc Delisle
    2012-04-21

    • status: open --> pending-rejected
     
  • Marc Delisle
    Marc Delisle
    2013-01-18

    • status: pending-rejected --> closed-rejected
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-rejected --> invalid