countQuery中的spring-data-jpa SpEL，使用#{#entityname}-意外字符：“#”

Question

自所问问题后的更新

https://github.com/spring-projects/spring-data-jpa/pull/283

描述

我已经配置了spring-boot+spring-data-jpa项目。我的存储库有下一个自定义查询：

@Repository
public interface MyEntityRepository extends JpaRepository<MyEntity, String>, QueryDslPredicateExecutor<MyEntity> {
  ...
  @Query(
      value = " SELECT me.name FROM #{#entityName} me ",
      countQuery = " SELECT COUNT(me.name) FROM MyEntity me "
  )
  Page<String> findAllMyEntityNames(final Predicate predicate, final Pageable pageable);
  ...
}

countQuery = " SELECT COUNT(me.name) FROM #{#entityName} me " 

null

...
Caused by: java.lang.IllegalArgumentException: org.hibernate.QueryException: unexpected char: '#' [ SELECT COUNT(me.name) FROM #{#entityName} me ]
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1679) ~[hibernate-entitymanager-5.0.11.Final.jar:5.0.11.Final]
...
Caused by: org.hibernate.QueryException: unexpected char: '#' [ SELECT COUNT(me.name) FROM #{#entityName} me ]
...

问候，马克西姆

Answer 1

spring团队修复了这个bug:https://jira.spring.io/browse/datajpa-1163

证明位于以下位置:https://github.com/daggerk/spring-5-examples/blob/dd7e4e88d260acdc02cb4dd7de568aa9a533d4d9/spring-data-count-query-fix/src/main/java/daggerk/data/orderrepository.java#l23