Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
It should be possible to configure maxrows to return an error when the maximum has been reached instead of a resultset of 0 rows.
There should, for instance, be a configuration setting like:
return=empty|error|ok
with empty being the default.
Attachments
Activity
New parameter for maxsrows filter:
max_resultset_return=empty|error|ok
Default, 'empty' is to return an empty set, as the current implementation.
'err' will return an ERR reply with the input SQL statement
'ok' will return an OK packet
Currently working on the new feature:
MySQL [(none)]> select * from test.t4;
ERROR 1415 (0A000): Row limit/size exceeded for query: select * from test.t4
MySQL [(none)]> select repeat('a', 1000000);
ERROR 1415 (0A000): Row limit/size exceeded for query: select repeat('a', 1000000)
MySQL [(none)]>
Note:
error message "ERROR 1415 (0A000): Row limit/size exceeded for query: "
+
input query