Menu

#3151 (ok 3.3.9) query for table "level" causes strange display

3.3.7
fixed
1
2013-06-11
2010-12-02
No

When omitting backticks around the table name "level" in the sql query box the results page displays different than in case you surrounded the table name with backticks. Example: compare SELECT * FROM level with SELECT * FROM `level`. The results page of the backtick query contains the default 30 results per page, a button to display everything and you can walk thru the table page-by-page. The results page of the non-backtick query pretends to contain the 30 default results, but actually shows *all* results. There are buttons to walk thru the "other" pages, but this is faked as well, they actually show the same content again and again. And the "display all" button is missing from the page (which makes sense as it *is* displaying all).
I first thought it might happen in all cases where I omit backticks, but it really seems to occur only if the table name is "level". I checked the reserved words list for MySQL and "level" is not on it.

Discussion

  • Kai Schätzl

    Kai Schätzl - 2010-12-02
    • summary: query for table "level" with causes strange display behavior --> query for table "level" causes strange display behavior
     
  • Marc Delisle

    Marc Delisle - 2010-12-11
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2010-12-11
    • priority: 5 --> 1
    • summary: query for table "level" causes strange display behavior --> (ok 3.3.9) query for table "level" causes strange display
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2010-12-11

    This bug was fixed in repository and will be part of a future release; thanks for reporting.

     
  • Marc Delisle

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

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