bug: `number_of_statements` has no effect on `read` statements about terraform-provider-snowsql HOT 2 CLOSED

package main

import (
	"context"
	"database/sql"
	"encoding/json"
	"fmt"
	"log"
	"os"
	"time"

	"github.com/snowflakedb/gosnowflake"
)

func main() {
	// Initialize the `statements` variable with multiple Snowflake query statement strings
	statements := `
          SHOW ROLES LIKE 'SYSADMIN';
          SHOW ROLES LIKE 'ACCOUNTADMIN';
        `

	// Set up a Snowflake connection
	cfg := &gosnowflake.Config{
		Account:   os.Getenv("SNOWFLAKE_ACCOUNT"),
		User:      os.Getenv("SNOWFLAKE_USER"),
		Password:  os.Getenv("SNOWFLAKE_PASSWORD"),
		Database:  os.Getenv("SNOWFLAKE_DATABASE"),
		Schema:    os.Getenv("SNOWFLAKE_SCHEMA"),
		Warehouse: os.Getenv("SNOWFLAKE_WAREHOUSE"),
	}
	dsn, err := gosnowflake.DSN(cfg)
	if err != nil {
		log.Fatal(err)
	}
	db, err := sql.Open("snowflake", dsn)
	if err != nil {
		log.Fatal(err)
	}
	defer db.Close()

	// Set up a context with a timeout
	ctx := context.Background()
	ctx, cancel := context.WithTimeout(ctx, 10*time.Second)
	defer cancel()

	// Query Snowflake using the WithMultiStatement method
	multiStmtCtx, err := gosnowflake.WithMultiStatement(ctx, 0)
	if err != nil {
		log.Fatal(err)
	}
	rows, err := db.QueryContext(multiStmtCtx, statements)

	if err != nil {
		log.Fatal(err)
	}
	defer rows.Close()

	// Process all the rows from all the queries and store the results in a list
	results := make([]map[string]interface{}, 0)
	processRows := func(rows *sql.Rows) error {
		for rows.Next() {
			columns, err := rows.Columns()
			if err != nil {
				return err
			}
			values := make([]interface{}, len(columns))
			for i := range columns {
				values[i] = new(interface{})
			}
			err = rows.Scan(values...)
			if err != nil {
				return err
			}
			rowMap := make(map[string]interface{})
			for i, col := range columns {
				rowMap[col] = *values[i].(*interface{})
			}
			results = append(results, rowMap)
		}
		if err := rows.Err(); err != nil {
			return err
		}
		return nil
	}

	if err := processRows(rows); err != nil {
		log.Fatal(err)
	}

	for rows.NextResultSet() {
		if err := processRows(rows); err != nil {
			log.Fatal(err)
		}
	}

	marshalledResults, _ := json.Marshal(results)
	fmt.Printf("%v", string(marshalledResults))
}