SNOW-1657238: SnowflakeDbCommand.ExecuteNonQueryAsync returns incorrect count; only includes from first row when loading from Stage

[brtubb-patagonia]

1. What version of .NET driver are you using?
   Reproduced on 4.1.0 and 4.0.0.

2. What operating system and processor architecture are you using?
   Windows 11 on Microsoft Dev Box in Azure (reports Intel Xeon Platinum 8370C)
   Also seeing issue in Azure App Service Plan (I1V2 tier. Not sure what that runs on)

3. What version of .NET framework are you using?
   .Net 8.0

4. What did you do?
   Repro steps (all running in a console app) -

• Put >1 file in blob storage folder (stage source)
• Create temp table in Snowflake
• Load into temp table using COPY INTO from the stage folder (using ExecuteNonQueryAsync)
• Retrieve record count from ExecuteNonQueryAsync return value
• Note the incorrect record count

5. What did you expect to see?
   I'm expecting to see the number of rows loaded to the table from stage. Instead it's returning only the number of records from the first file loaded.

The record count returned is only for the first record and doesn't properly aggregate the results.

Debugging the code a bit, it looks like there is an issue reading the resultset returned. It doesn't think there is more than one result.

When digging into the ResultSetUtil.CalculateUpdateCount, which looks to handle the nuances of record counts for various operations, it is aware of both rows, as evident in the private _currentChunk variable.

6. Can you set logging to DEBUG and collect the logs?

Debug logs attached.
snowflake_dotnet4.log

7. What is your Snowflake account identifier, if any? (Optional)

[sfc-gh-dszmolka]

hi and thanks for raising this issue with us, especially for providing so much details on it! we'll take a look.

[sfc-gh-dszmolka]

PR in review: #1044