can use USE switch db

[labulakalia]

Describe the bug
use USE mydb can not switch mydb,
but use sqlcmd can switch

To Reproduce
Include a complete code listing that we can run to reproduce the issue.

db.ExecContext(context.Background(), "USE mydb")
db.ExecContext(context.Background(), "SELECT db_name()")

but get dbname not is mydb,
i set

sqlDb.SetMaxOpenConns(1)
sqlDb.SetMaxIdleConns(1)

Expected behavior
A clear and concise description of what you expected to happen.

Further technical details

SQL Server version: SQL Server 2019
Operating system: Docker container
Table schema

Additional context
Add any other context about the problem here.

[shueybubbles]

I don't think the database/sql model has any guarantee that subsequent calls to ExecContext or similar methods would reuse the same physical connection.

I think you need to use db.Conn(context.Background()) to get a reusable physical connection.

[labulakalia]

Thank you,I use Conn solve my problem.