The scope of the row_count limit type

A resource limit that restricts row count applies only to single queries, not to cumulative rows returned by a query batch or transaction. See “Determining the scope of resource limits”.