Skip to content

can't scan into dest[77]: type assertion to []byte failed #2237

@junioryono

Description

@junioryono

Describe the bug
can't scan into dest[77]: type assertion to []byte failed

To Reproduce

func (s *matchParticipantsService) GetByGameIDsAndRegion(gameIDs []int64, rgn region.Region) ([]models.LeagueOfLegendsMatchParticipant, error) {
	query := `SELECT * FROM lol_match_participants WHERE game_id = ANY($1::bigint[]) AND region = $2`

	rows, err := s.pgxPool.Query(s.ctx, query, gameIDs, rgn)
	if err != nil {
		return nil, err
	}
	defer rows.Close()

	return pgx.CollectRows(rows, pgx.RowToStructByName[models.LeagueOfLegendsMatchParticipant])
}

I cannot provide the LeagueOfLegendsMatchParticipant type.

Expected behavior
pgx should successfully scan results

Actual behavior
can't scan into dest[77]: type assertion to []byte failed

Version

  • Go: go version go1.23.3 windows/amd64
  • PostgreSQL: 17.2
  • pgx: github.com/jackc/pgx/v5 v5.7.2

The error does not occur when using github.com/jackc/pgx/v5 v5.7.1

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions