bigquery: total rows has incorrect value

[zecke]

Client

bigquery

Environment

Go 1.22

Code and Dependencies

package main

func main() {
    // ...
    var values []bigquery.Value
    err := it.Next(&values)
    if err == iterator.Done {
        return
    }
    if err != nil {
        // TODO: Handle error.
    }
    fmt.Println(it.TotalRows)
}

Expected behavior

it.TotalRows() should have the correct value after the first call to RowIterator.Next(context.Context)

Actual behavior

When the first call of it.Next(ctx) hits the paged cache the length of the cache is returned and not the total number of rows.

https://github.com/googleapis/google-cloud-go/blob/c2ee207621b2bb5fad8e6821892eae0041f469cd/bigquery/iterator.go#L409