Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL)
-
None
-
10.0.24
Description
Output:
=====
mysql> create table t1(c1 int);
|
Query OK, 0 rows affected (0.01 sec)
|
|
mysql> insert into t1 values(1),(2),(3),(4),(5);
|
Query OK, 5 rows affected (0.00 sec)
|
Records: 5 Duplicates: 0 Warnings: 0
|
|
mysql> select * from t1 order by c1 limit 2,1;
|
+------+
|
| c1 |
|
+------+
|
| 3 |
|
+------+
|
1 row in set (0.00 sec)
|
|
mysql> select found_rows();
|
+--------------+
|
| found_rows() |
|
+--------------+
|
| 5 |
|
+--------------+
|
1 row in set (0.00 sec)
|
|
mysql> select version();
|
+-----------------+
|
| version() |
|
+-----------------+
|
| 10.1.10-MariaDB |
|
+-----------------+
|
1 row in set (0.00 sec)
|
|
Repeat:
=====
drop table if exists t1;
|
create table t1(c1 int);
|
insert into t1 values(1),(2),(3),(4),(5);
|
select * from t1 order by c1 limit 2,1;
|
select found_rows();
|
|
Problem:
=====
3 is expected.