The RESULT_LIMIT parameter applies to rows returned by the information_schema.query_history function. The WHERE clause then further filters the resultset. The reason no records were returned when time range was expanded is that more queries qualified, and no query in the top 10,000 results contained the string 'TABLE_NAME'. The WHERE clause is applied after the resultset is returned by the function.