The NUM_ROWS_PRODUCED_LIMIT query option limits the number of rows
produced by a query. A query is canceled when its execution produces more rows than the
specified limit set by the NUM_ROWS_PRODUCED_LIMIT option.
This limit only applies when the results are returned to a client, for example, to a
SELECT query, but not to an INSERT query.
The default value of 0 specifies that there is no limit on the number of
rows produced.
Type: INT
Allowed values: 0 or positive numbers
Default: 0