[MXS-930] MaxRows Filter Created: 2016-10-18 Updated: 2016-11-16 Resolved: 2016-11-16 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | maxrows |
| Affects Version/s: | None |
| Fix Version/s: | 2.1.0 |
| Type: | New Feature | Priority: | Major |
| Reporter: | Johan Wikman | Assignee: | Massimiliano Pinto (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | 2.1-Requirement | ||
| Sprint: | 2016-20, 2016-21 |
| Description |
|
The purpose of the filter is to put a hard limit on the maximum number of rows that will be returned to a client. Example: With following mask filter, only query result set with 150 or fewer rows will be returned to the client. If the result set is more than 150 rows, 0 rows will be returned to the client.
|
| Comments |
| Comment by Massimiliano Pinto (Inactive) [ 2016-10-26 ] | ||||
|
From user perspective the output will look like this, assiming a 30 rows limitation MySQL [(none)]> SELECT * from test.t2 limit 3;
------
------ MySQL [(none)]> SELECT * from test.t2 limit 32; MySQL [(none)]> |