mysql [localhost] {msandbox} (test) > SELECT VERSION();
+---------------------------------------+
| VERSION()                             |
+---------------------------------------+
| 5.6.13-enterprise-commercial-advanced |
+---------------------------------------+
1 row in set (0.00 sec)

mysql [localhost] {msandbox} (test) > SELECT ID, VALUE FROM LOUIS LIMIT 50,10; SELECT FOUND_ROWS();
+-----+----------------------------+
| ID  | VALUE                      |
+-----+----------------------------+
| 207 | DROP CLUSTER               |
| 123 | DROP DEFAULT               |
| 178 | DROP DIMENSION             |
|  90 | DROP FUNCTION              |
| 208 | DROP FUNCTION MAPPING      |
| 124 | DROP INDEX                 |
| 209 | DROP INDEX EXTENSION       |
| 179 | DROP LIBRARY               |
| 210 | DROP MATERIALIZED VIEW     |
| 211 | DROP MATERIALIZED VIEW LOG |
+-----+----------------------------+
10 rows in set (0.00 sec)

+--------------+
| FOUND_ROWS() |
+--------------+
|           60 |
+--------------+
1 row in set (0.00 sec)

mysql [localhost] {msandbox} (test) > SELECT ID, VALUE FROM LOUIS ORDER BY ID LIMIT 50,10; SELECT FOUND_ROWS();
+-----+-----------------------+
| ID  | VALUE                 |
+-----+-----------------------+
| 199 | CREATE OPERATOR       |
| 200 | CREATE PACKAGE        |
| 201 | CREATE PACKAGE BODY   |
| 202 | CREATE PROXY_TABLE    |
| 203 | CREATE TYPE BODY      |
| 204 | CREATE TYPE MAPPING   |
| 205 | DESCRIBE              |
| 206 | DROP ALIAS            |
| 207 | DROP CLUSTER          |
| 208 | DROP FUNCTION MAPPING |
+-----+-----------------------+
10 rows in set (0.00 sec)

+--------------+
| FOUND_ROWS() |
+--------------+
|           80 |
+--------------+
1 row in set (0.00 sec)

mysql [localhost] {msandbox} (test) > SELECT ID, VALUE FROM LOUIS LIMIT 10,10; SELECT FOUND_ROWS();
+-----+-----------------+
| ID  | VALUE           |
+-----+-----------------+
| 189 | ALTER PACKAGE   |
|  71 | ALTER PROCEDURE |
| 132 | ALTER SEQUENCE  |
|  72 | ALTER TABLE     |
|  73 | ALTER TYPE      |
| 153 | ALTER VIEW      |
| 310 | COLLMOD         |
| 317 | COMPACT         |
| 313 | COUNT           |
| 190 | CREATE ALIAS    |
+-----+-----------------+
10 rows in set (0.00 sec)

+--------------+
| FOUND_ROWS() |
+--------------+
|           20 |
+--------------+
1 row in set (0.00 sec)

mysql [localhost] {msandbox} (test) > SELECT ID, VALUE FROM LOUIS ORDER BY ID LIMIT 10,10; SELECT FOUND_ROWS();
+-----+----------------+
| ID  | VALUE          |
+-----+----------------+
|  88 | CREATE VIEW    |
|  90 | DROP FUNCTION  |
|  95 | DROP PROCEDURE |
|  96 | DROP TABLE     |
|  97 | DROP TRIGGER   |
|  98 | DROP TYPE      |
|  99 | DROP VIEW      |
| 119 | CREATE DEFAULT |
| 120 | CREATE RULE    |
| 123 | DROP DEFAULT   |
+-----+----------------+
10 rows in set (0.00 sec)

+--------------+
| FOUND_ROWS() |
+--------------+
|           80 |
+--------------+
1 row in set (0.00 sec)

ysql [localhost] {msandbox} (test) > SELECT ID, VALUE FROM LOUIS ORDER BY ID LIMIT 20,9; SELECT FOUND_ROWS();
+-----+-----------------+
| ID  | VALUE           |
+-----+-----------------+
| 124 | DROP INDEX      |
| 125 | DROP RULE       |
| 130 | ALTER INDEX     |
| 132 | ALTER SEQUENCE  |
| 136 | CREATE SEQUENCE |
| 137 | CREATE SYNONYM  |
| 140 | DROP SEQUENCE   |
| 141 | DROP SYNONYM    |
| 153 | ALTER VIEW      |
+-----+-----------------+
9 rows in set (0.00 sec)

+--------------+
| FOUND_ROWS() |
+--------------+
|           80 |
+--------------+
1 row in set (0.00 sec)

mysql [localhost] {msandbox} (test) > SELECT ID, VALUE FROM LOUIS ORDER BY ID LIMIT 20,10; SELECT FOUND_ROWS();
+-----+-----------------+
| ID  | VALUE           |
+-----+-----------------+
| 124 | DROP INDEX      |
| 125 | DROP RULE       |
| 130 | ALTER INDEX     |
| 132 | ALTER SEQUENCE  |
| 136 | CREATE SEQUENCE |
| 137 | CREATE SYNONYM  |
| 140 | DROP SEQUENCE   |
| 141 | DROP SYNONYM    |
| 153 | ALTER VIEW      |
| 159 | CREATE TYPE     |
+-----+-----------------+
10 rows in set (0.00 sec)

+--------------+
| FOUND_ROWS() |
+--------------+
|           80 |
+--------------+
1 row in set (0.00 sec)
