Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.6, 10.0.7
-
None
-
None
-
PRETTY_NAME="Debian GNU/Linux 7 (wheezy)"
NAME="Debian GNU/Linux"
VERSION_ID="7"
VERSION="7 (wheezy)"
ID=debian
ANSI_COLOR="1;31"
HOME_URL="http://www.debian.org/"
SUPPORT_URL="http://www.debian.org/support/"
BUG_REPORT_URL="http://bugs.debian.org/"
Linux version 3.2.43-grsec-sma (root@admin.sma.hu) (gcc version 4.7.2 (Debian 4.7.2-5) ) #1 SMP Mon Jun 17 14:23:20 CEST 2013PRETTY_NAME="Debian GNU/Linux 7 (wheezy)" NAME="Debian GNU/Linux" VERSION_ID="7" VERSION="7 (wheezy)" ID=debian ANSI_COLOR="1;31" HOME_URL=" http://www.debian.org/ " SUPPORT_URL=" http://www.debian.org/support/ " BUG_REPORT_URL=" http://bugs.debian.org/ " Linux version 3.2.43-grsec-sma ( root@admin.sma.hu ) (gcc version 4.7.2 (Debian 4.7.2-5) ) #1 SMP Mon Jun 17 14:23:20 CEST 2013
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.
