Menu

#1293 (in 2.6.0) LIMIT appending broken for multiple queries

Latest_Git
fixed
1
2013-06-11
2004-06-24
Anonymous
No

When you execute more queries and last one is SELECT,
it goes to browse mode, but the query is displayed
wrongly (but executed correctly). Shown query:

SELECT *
FROM `hokus`
WHERE 1 ;

SELECT *
FROM `hokus`
WHERE 1 ;

LIMIT 0 , 30

Discussion

  • Michal Čihař

    Michal Čihař - 2004-06-24

    Logged In: YES
    user_id=192186

    Actually submitted by me, sf login somehow expired meanwhile :-)

     
  • Michal Čihař

    Michal Čihař - 2004-08-16
    • assigned_to: nobody --> nijel
     
  • Michal Čihař

    Michal Čihař - 2004-08-16

    Logged In: YES
    user_id=192186

    Fixed.

     
  • Michal Čihař

    Michal Čihař - 2004-08-16
    • priority: 5 --> 1
    • summary: LIMIT appending broken when multiple queries executed --> (in 2.6.0) LIMIT appending broken for multiple queries
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2004-08-22
    • priority: 1 --> 7
    • summary: (in 2.6.0) LIMIT appending broken for multiple queries --> LIMIT appending broken for multiple queries
     
  • Marc Delisle

    Marc Delisle - 2004-08-22

    Logged In: YES
    user_id=210714

    Michal,
    the fix breaks total records counting. Now that
    $sql_limit_to_append is unset, the test at line 411 does not
    go to the intended section of code which counts total records.

    Do you have time to look at it?

     
  • Michal Čihař

    Michal Čihař - 2004-08-22

    Logged In: YES
    user_id=192186

    I will look at it, but I didn't see any other use of
    $sql_limit_to_append, so I thought it will be safe to remove it.

     
  • Michal Čihař

    Michal Čihař - 2004-08-22

    Logged In: YES
    user_id=192186

    I removed unsetting of $sql_limit_to_append, it should be
    enough.

     
  • Michal Čihař

    Michal Čihař - 2004-08-22
    • priority: 7 --> 1
    • summary: LIMIT appending broken for multiple queries --> (in 2.6.0) LIMIT appending broken for multiple queries
     
  • Alexander M. Turek

    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

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