like LIMIT ROWS EXAMINED, we could return if we got a hard timeout, for example:
will return if we examined >= rows_limit rows
we could create a query like:
it will return if we got >= seconds to examine the table, in this case instead of query timeout killing the query and 'dropping' the connection, we could return what we found without searching tables, only executing the temporary table features with current data, for example...
after 10 seconds we sum everything we got from "(select a from other_table)"
in others words we block the storage "other_table" reads and the query continue with the SUM() function, we create a WARNING telling that the query was returned with a timed out condition