Hibernate Error after upgrading from 2.1.6 to 2.1.7

[syamsu-smansa]

After upgrading spring boot to 2.1.7 from 2.1.6, running application are failing due to the issue:

Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: count near line 1, column 8 [select count(new map(model as levelTingkat)) from com.jasamedika.medifirst2000.entity.LevelTingkat model left join model.id id  where id.kdProfile=:kdProfile  and model.statusEnabled=true  ]

public interface  interface LevelTingkatDao extends CrudRepository.

Query : "select new map(model as levelTingkat) " 
            + " from LevelTingkat model left join model.id id "
            + " where id.kdProfile=:kdProfile "
            + " and model.statusEnabled=true  "

method: Page<Map<String, Object>> findAllList(
            @Param("kdProfile") Integer kdProfile,
            Pageable pageable);

In new CrudRepository, it seem, has adding "count" to Query HQL, because present of Pageable parameter.

[philwebb]

This looks related to either a Spring Data JPA or Hibernate upgrade. I've opened https://jira.spring.io/browse/DATAJPA-1598 to see if the Spring Data team can help. Can you please attach your full LevelTingkatDao file to that issue. It's not currently clear if you're relying on the query generated by the method name findAllList or if you're using @Query.