Returns only one resultset when executing Procedure

[gowthammano]

I'm using the Google.Cloud.BigQuery.V2 version="1.4.0-beta06" to execute CALL ();
My Procedure calls 2 other procedures, each of which has a resultset.
When executing the wrapper procedure via console, I can see both result sets by clicking on "VIEW RESULTS".
But via code, bqClient.ExecuteQuery returns only the second result set.

[amanda-tarafa]

I believe this might be that the API is only returning the last result set. I will confirm with the BigQuery team and update this thread with more info.

[amanda-tarafa]

I've been able to reproduce this without the need of calling procedures. When executing the code below, only one row is returned, the one corresponding to the last SELECT.

BigQueryClient client = BigQueryClient.Create(ProjectId);

string sql = "SELECT 5; SELECT 6, 7;";
BigQueryResults results = client.ExecuteQuery(sql, null).ThrowOnAnyError();

BigQueryRow row = results.Single();
Console.WriteLine($"Returned row: ({row[0]}, {row[1]})");

This is not a client library issue though, BigQueryResult is wrapping the response from jobs.getQueryResults API method to provide seemless result pagination, but not much more. The jobs.getQueryResults response is not clearly designed to support returning multiple result sets, and the API method is definetely not doing so at the moment.

This looks more like a feature request for the BigQuery API team, so I'd advise you to create a feature request for them here.
You can also take a look and vote on other open issues/feature requests here.

I'll be closing this issue for now, since I believe there's nothing we can do on the client library side. Please feel free to reopen if you believe different, or create new issues if you encounter other problems using the client library.