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

Wrong row counter in found_rows() result

    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: