Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
like LIMIT ROWS EXAMINED, we could return if we got a hard timeout, for example:
SELECT ... LIMIT ROWS EXAMINED rows_limit; |
will return if we examined >= rows_limit rows
—
we could create a query like:
SELECT ... LIMIT TIME EXAMINED seconds; |
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...
select sum(a) from ( |
select a from other_table |
)
|
limit time examined 10 |
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