Is postgres json_agg supported ?

[mmaryo]

Hello,

With Java 17 and Spring Boot 3 project

I'm trying to get data into an object CompleteUserTeam for this request (and if I change it to String I can see the result inside)

    @Query(value = """
            select u.*,
                   (select json_agg(t.*)
                    from team t
                    where u.id  = t.lead_id) as team
            from "user" u
            where u.tenant_id = :tenantId
            limit 50;
            """, nativeQuery = true)
    List<CompleteUser> findAllCompleteUsersByTenantId(@Param("tenantId") UUID tenantId);


public interface CompleteUser {
    UUID getId();
    String getEmail();
    String getFirst_Name();
    List<CompleteUserTeam> getTeam();
}

interface CompleteUserTeam {
    UUID getId();
    String getName();
}

There is no error in logs but the output is cut with half ok half error 500

[
    {
        "title": "CEO",
        "id": "a541c58b-8a25-4feb-8dda-46ced91c49ca",
        "initials": null,
        "avatar": "users/app/tom_rcdk52",
        "team": [
            {}
        ]
    }
]{
    "type": "about:blank",
    "title": "Internal Server Error",
    "status": 500,
    "detail": "Failed to write request",
    "instance": "/users",
    "properties": null
}

Any idea ?

[gregturn]

Basically, to debug this, you need to capture the outputs to see what the final query is that was actually sent over to Postgres. It's possible that some bits of it were lost by QueryUtils since this query is quite complex, including a correlated subquery.

If QueryUtils is losing bits of it, then you may need to leverage the same solution as suggested in #3151.

[spring-projects-issues]

If you would like us to look at this issue, please provide the requested information. If the information is not provided within the next 7 days this issue will be closed.

[spring-projects-issues]

Closing due to lack of requested feedback. If you would like us to look at this issue, please provide the requested information and we will re-open the issue.