Native query throws ArrayIndexOutOfBoundsException

[thebe14]

Hello,

In a Quarkus reactive with Panache project I have a Postgres DB that stores records in the table records. Each record has a version field, my app adds new rows for each role when something changes. Therefore I will have a collection of rows in this table representing the change history of each role (group rows by the field role). I would like a method to return the latest version of each role. This requires a native query:

SELECT * FROM test.roles
JOIN (
    SELECT DISTINCT ON (role)
        last_value(id) OVER wnd as last_id
    FROM test.roles WINDOW wnd AS (
        PARTITION BY role ORDER BY version ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
    )) as last
ON id = last_id;

This works fine if the table does not have linked entities (associations). Once I add such an association, e.g. an user field for the user that made the last change, the native query breaks. The association is defined like this on the class RoleEntity:

@Entity
@Table(name = "roles")
public class RoleEntity extends PanacheEntityBase {
      ...
      @ManyToOne(fetch = FetchType.EAGER, cascade = { CascadeType.PERSIST })
      @JoinTable(name = "role_editor_map",
            joinColumns = { @JoinColumn(name = "role_id") },
            inverseJoinColumns = { @JoinColumn(name = "user_id") })
      public UserEntity changeBy = null;
      ...
}

My native query throws java.lang.ArrayIndexOutOfBoundsException: Index -2 out of bounds for length 7 and I cannot get it to work. I traced this to ResultSetMappingImp::resolve where the fields/aliases are being built prior to returning a new JdbcValuesMappingImpl(...). First the fields of the "simple" fields of the RoleEntity class, and the last one is a long with index -2 in the aliases table. I empirically deduced that this is related to the linked UserEntity (if I remove that field it works as expected). Please help me write a native query for an entity with linked entities. Thank you!

A reproducer project is at https://github.com/thebe14/quarkus-native-query. It needs a Postgres DB with a schema called test in which it will create and populate the needed tables on first run with quarkus dev. You can use the Swagger-UI to try out the one and only API endpoint to cause the DB call.

Regards,
Levente