When using the SET QUERY LIMIT command to set the limit of the number of records returned by a query, remember to restore the query limit to unlimited if you don’t want to limit the results returned by the following queries within the current process. The said command affects all the subsequent queries made within the current process. To restore to unlimited, pass a 0 parameter to the said command: SET QUERY LIMIT(0).