@Query(countName = …) not considered

[vyshakg]

I am trying to execute some native queries using the @query annotation with Spring and I'm having the follow problem:

I have a file called: jpa-named-queries.properties where I put my queries and I have one query to get the data and one query to count the data.

Find.members.team = SELECT ct.id teamId, r.user_id userId, (SELECT SUM(rd.resume_value) FROM resume_detail rd WHERE rd.resume_id = r.id) resumeMemberValue FROM resume r INNER JOIN challenge_team ct ON r.team_id = ct.id WHERE ct.id = :teamId ORDER BY resumeMemberValue ASC
Find.members.team.count = SELECT count(resume.id) FROM resume INNER JOIN challenge_team ct ON resume.team_id = ct.id WHERE ct.id = :teamId

and I have the Repository method to use the queries:

@Query(name = "Find.members.team", 
       countName= "Find.members.team.count",  
       nativeQuery = true)
Page<TeamMemberProjection> findMembersTeamByIdWithPagination(@Param("teamId") Long id, Pageable pageable);

The problem is If I execute as shown above the queries execute are:

Hibernate: SELECT ct.id teamId, r.user_id userId, (SELECT SUM(rd.resume_value) FROM resume_detail rd WHERE rd.resume_id = r.id) resumeMemberValue FROM resume r INNER JOIN challenge_team ct ON r.team_id = ct.id WHERE ct.id = ? ORDER BY resumeMemberValue ASC limit ?
Hibernate: select count(rd) FROM resume_detail rd WHERE rd.resume_id = r.id) resumeMemberValue FROM resume r INNER JOIN challenge_team ct ON r.team_id = ct.id WHERE ct.id = ?

And thats cause a exception because the query executed makes no sense.

[schauder]

Please provide a Minimimal Reproducable Example, preferable as a Github repository. Make sure to include the database, either as an in memory database or if that is not possible using Testcontainers.

[vyshakg]

@schauder here you go springjpa - https://github.com/vyshakg/springJpa you can reproduce in this repo..
just run the spring boot server and hit the route http://localhost:8090/api/department