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

Wrong row counter in found_rows() result

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.6, 10.0.7
    • 10.0.8
    • None
    • None

    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

        1. test.sql
          1.44 MB
          Lay András

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.