The QUERY_ROWS_RETURNED_LIMIT option of the SET command tells the query optimizer to reject queries that might otherwise consume too many resources. If the query optimizer estimates that the result set from a query will exceed the value of this option, it rejects the query with the message:
Query rejected because it exceed resource: Query_Rows_Returned_Limit
If you use this option, set it so that it only rejects queries that consume vast resources.
