弹簧数据 JPA @query是否支持投影

Question

Spring

启动版本：1.5.10，Spring Data JPA 1.11.10

在我的MyEntityRespostory中：

 Page<MyEntityPro> findByName(String name,Pageable pageable ) // working
 @("select e from MyEntity e")
 Page<MyEntity> search1(Pageable pageable) // working
 @("select e from MyEntity e")
 Page<MyEntityPro> search2(Pageable pageable) //error-No aliases found in result tuple! Make sure your query defines aliase

我搜索错误并找到：https://jira.spring.io/browse/DATAJPA-885

Answer 1

如果使用上部查询关键字，则会导致问题。

....
@query("SELECT e FROM MyEntity") // bug
......
@query("select e from MyEntity") // working
...