Failing to retrieve all data

[mingan666]

My slim downed data structs:

type SlimAlbum struct {
	ID          uint32 `sql:"primary_key"`
	ParentID    *uint32
	CoverUUID   *string // UUID of the picture used as album cover
	CreatedAt   time.Time
}

type Picture struct {
	ID          uint32 `sql:"primary_key"`
	UUID        string // UUID v4 format
	AlbumID     uint32
	CreatedAt   time.Time

	Album SlimAlbum `alias:"PictureAlbum"`
}

my code to retrieve the data:

func (store *PictureStoreImpl) GetPictureByUuid(uuid string) (*domain.Picture, *apperror.Error) {

	pictureAlbum := Album.AS("PictureAlbum")

	stmt := SELECT(Picture.AllColumns, pictureAlbum.AllColumns).
		FROM(Picture.
			INNER_JOIN(pictureAlbum, Picture.AlbumID.EQ(pictureAlbum.ID))).
		WHERE(Picture.UUID.EQ(String(uuid)))

	var dest []domain.Picture
	debugSql := stmt.DebugSql()
	log.Printf("sql: %s", debugSql)

	err := stmt.Query(store.db, &dest)
	if err != nil {
		return nil, apperror.Wrap(apperror.InternalServerError, "Database error", "PictureStore.GetPictureByUuid", err)
	}
	if len(dest) != 1 {
		return nil, apperror.New(apperror.NotFound, "Picture "+uuid, "PictureStore.GetPictureByUuid")
	}

	return &dest[0], nil
}

the debug sql:

SELECT picture.id AS "picture.id",
     picture.uuid AS "picture.uuid",
     picture.album_id AS "picture.album_id",
     picture.created_at AS "picture.created_at",
     `PictureAlbum`.id AS "PictureAlbum.id",
     `PictureAlbum`.parent_id AS "PictureAlbum.parent_id",
     `PictureAlbum`.cover_uuid AS "PictureAlbum.cover_uuid",
     `PictureAlbum`.created_at AS "PictureAlbum.created_at"
FROM `database`.picture
     INNER JOIN `database`.album AS `PictureAlbum` ON (picture.album_id = `PictureAlbum`.id)
WHERE picture.uuid = '7b7f76c4-b72d-4bab-808f-5fe6fdd538c7';

When I run the test case against a database with a complete row I would expect all data to be returned. However, all data is returned except for the cover_uuid (which is non null in the database)

also when I run the debug sql, it returns the data as expected.