Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#3683 (ok 4.0.0-rc2) Incorrect listing of records from to count

3.5.5
fixed
Marc Delisle
1
2013-06-11
2012-09-21
Jørgen Thomsen
No

Viser poster 500 - 499 ( 11 total, forepørgsel tog 0.0017 sek)

SELECT *
FROM `kundeprodaktive`
WHERE `nr` =1394
ORDER BY `kundeprodaktive`.`produkt` ASC
LIMIT 500

Clearly it should have been 0-10 and not 500 - 499

Discussion

1 2 > >> (Page 1 of 2)
    • priority: 5 --> 3
     
  • Marc Delisle
    Marc Delisle
    2012-10-14

    Please attach an export with your table's structure and data. Also, which steps did you do to produce this query?

     
  • Marc Delisle
    Marc Delisle
    2012-10-14

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

    • status: pending --> closed-invalid
     
  • May I suggest just executing a similar SQL statement in any table.
    It shows the same behaviour everywhere I have tried it.
    Also in 3.5.5

     
    Last edit: Jørgen Thomsen 2013-01-22
  • Marc Delisle
    Marc Delisle
    2013-01-22

    • status: closed-invalid --> open
    • milestone: 3.5.2 --> 3.5.5
     
  • Marc Delisle
    Marc Delisle
    2013-01-22

    Confirmed and can be reproduced with sample database sakila and this query:

    SELECT *
    FROM film
    WHERE replacement_cost = 14.99
    ORDER BY film.description ASC
    LIMIT 500

     
    Last edit: Marc Delisle 2013-01-22
  • Marc Delisle
    Marc Delisle
    2013-04-14

    • assigned_to: Marc Delisle
     
  • Marc Delisle
    Marc Delisle
    2013-04-14

    • summary: Incorrect listing of records from to count --> (ok 4.0.0-rc2) Incorrect listing of records from to count
    • Priority: 3 --> 1
     
1 2 > >> (Page 1 of 2)