Google-cloud-go: bigquery: After upgrade v 1.11.0, bigquery.RowIterator pager return empty result.

Created on 1 Oct 2020  路  5Comments  路  Source: googleapis/google-cloud-go

Client
BigQuery

Go Environment

$ go version
go version go1.13.6 darwin/amd64

Code

package main

import (
    "context"
    "fmt"

    "cloud.google.com/go/bigquery"
    "google.golang.org/api/iterator"
)

func main() {
    ctx := context.Background()
    client, _ := bigquery.NewClient(ctx, projectId)
    defer client.Close()

    query := `
          SELECT
            year, name
          FROM
            bigquery-public-data.usa_names.usa_1910_2013
          LIMIT 5;
        `
    result := client.Query(query)
    iter, err := result.Read(ctx)
    if err != nil {
        panic(err.Error())
    }

    pager := iterator.NewPager(iter, 2, "")
    nextPageToken := ""
    for {
        var rows [][]bigquery.Value
        nextPageToken, err = pager.NextPage(&rows)
        fmt.Printf("totalRows: %v, rows: %+v\n", iter.TotalRows, rows)

        if err != nil {
            panic(err.Error())
        }

        if nextPageToken == "" {
            break
        }
    }
}

Expected behavior

When cloud.google.com/go/bigquery version set to v1.10.0
pager.NextPage return TotalRows and Query Results like below.

$ go run main.go
totalRows: 5, rows: [[1910 Elsie] [1910 Annie]]
totalRows: 5, rows: [[1910 Katie] [1910 Alma]]
totalRows: 5, rows: [[1910 Thelma]]

Actual behavior

But when I set cloud.google.com/go/bigquery version to v1.11.0
pager.NextPage return empty result.

$ go run main.go
totalRows: 0, rows: []
bigquery p1 bug

All 5 comments

@hue-plu Does upgrading to v1.11.1 fix the issue?

Will investigate.

Baking a release with this now.

Released as bigquery/v1.11.2

Thank you for your quick response and fix!

Was this page helpful?
0 / 5 - 0 ratings

Related issues

rileykarson picture rileykarson  路  4Comments

GlennAmmons picture GlennAmmons  路  3Comments

dragan-cikic-shortcut picture dragan-cikic-shortcut  路  3Comments

lukaszraczylo picture lukaszraczylo  路  3Comments

eriklott picture eriklott  路  4Comments