Cancelling a query (e.g. by cancelling the context passed to one of the query methods) during a call to the Scan method of the returned Rows can result in unexpected results if other queries are being made in parallel. This can result in a race condition that may overwrite the expected results with those of another query, causing the call to Scan to return either unexpected results from the other query or an error.
As noted in this issue in Go and its follow on links: https://github.com/golang/go/issues/74831 This appears to be addressed in Go v1.23.12, v1.24.7, and v1.25.0 and higher.