Why the row affected still have no zero even field in column are not updated actually same value

func (repo *wasteTypeRepo) UpdateByID(ctx context.Context, payload model.WasteTypeUpdateWithVersionRequest) error {
fmt.Println(payload.SOURCEID)
queries := repo.pgxConfig.TrOrDB(ctx)
sql := `--sql
UPDATE waste_types SET "name" = 'bar'
`

result, err := queries.Exec(ctx, sql)
fmt.Println(result.RowsAffected())

return err
}

Start with the UpdateByID function shown in the issue and reproduce its UPDATE statement using the pgx execution path. Check the returned RowsAffected value and compare it with PostgreSQL's behavior for an update that writes the same value; done means explaining the observed result and identifying any needed documentation or code change.

Written by the indexing model from the issue text.