emit_pointer_for_null_types results in left join scan error

[Smithx10]

The following results in

2024/10/11 18:20:31 can't scan into dest[8]: failed to scan array element 0: cannot scan NULL into *string

const GetUser = `-- name: GetUser :one
SELECT 
  u.uuid, u.name, u.email, u.alias, u.description, u.created_at, u.updated_at, u.deleted_at, COALESCE(array_agg(g.name), '{}')::text[] AS memberof 
FROM 
  iam_user u 
LEFT JOIN 
  iam_group_member gm ON u.uuid = gm.user_uuid 
LEFT JOIN 
  iam_group g ON gm.group_uuid = g.uuid 
WHERE 
  (
    (u.uuid = $1 AND $1 IS NOT NULL)
  OR
    (u.name = $2 AND $2 IS NOT NULL)
  )
GROUP BY 
  u.uuid
LIMIT 1
`

type GetUserParams struct {
	Uuid *uuid.UUID
	Name *string
}

type GetUserRow struct {
	Uuid        uuid.UUID
	Name        string
	Email       string
	Alias       *string
	Description *string
	CreatedAt   pgtype.Timestamptz
	UpdatedAt   pgtype.Timestamptz
	DeletedAt   pgtype.Timestamptz
	Memberof    []string
}

// generate:
// package: iam.v1
// message: target: user
func (q *Queries) GetUser(ctx context.Context, db DBTX, arg GetUserParams) (GetUserRow, error) {
	row := db.QueryRow(ctx, GetUser, arg.Uuid, arg.Name)
	var i GetUserRow
	err := row.Scan(
		&i.Uuid,
		&i.Name,
		&i.Email,
		&i.Alias,
		&i.Description,
		&i.CreatedAt,
		&i.UpdatedAt,
		&i.DeletedAt,
		&i.Memberof,
	)
	return i, err
}

-- generate:
-- package: iam.v1
-- message: target: user
-- name: GetUser :one
SELECT 
  u.*, COALESCE(array_agg(g.name), '{}')::text[] AS memberof 
FROM 
  iam_user u 
LEFT JOIN 
  iam_group_member gm ON u.uuid = gm.user_uuid 
LEFT JOIN 
  iam_group g ON gm.group_uuid = g.uuid 
WHERE 
  (
    (u.uuid = sqlc.narg('uuid') AND sqlc.narg('uuid') IS NOT NULL)
  OR
    (u.name = sqlc.narg('name') AND sqlc.narg('name') IS NOT NULL)
  )
GROUP BY 
  u.uuid
LIMIT 1;

[Smithx10]

Accidently opened this in pgx instead of sqlc .DOH!