Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5549

Wrong row counter in found_rows() result

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.6, 10.0.7
    • Fix Version/s: 10.0.8
    • Component/s: None
    • Labels:
      None
    • Environment:

      Description

      Hi!

      I'v tested the following query:

      mysql> select version();
      +-------------------------+
      | version()               |
      +-------------------------+
      | 10.0.6-MariaDB-1~wheezy |
      +-------------------------+
      1 row in set (0.00 sec)
       
      mysql>
       
      mysql> select SQL_CALC_FOUND_ROWS a.alkid from testa a,testb b where a.alkid=b.alkid and a.csoportid=3 and b.nev like'%4000%'order by a.partnumber asc limit 0,20;select found_rows();
      +-------+
      | alkid |
      +-------+
      | 33445 |
      | 34060 |
      | 35587 |
      | 34089 |
      | 34088 |
      | 32390 |
      | 34097 |
      | 35763 |
      | 14846 |
      +-------+
      9 rows in set (0.01 sec)
       
      +--------------+
      | found_rows() |
      +--------------+
      |          887 |
      +--------------+
      1 row in set (0.00 sec)
       
      mysql>

      The found rows result should be 9, not 887.

      I attached the database dump.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              LaySoft Lay András
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: