JPA/Hibernate分页-使用@where对@inherity(strategy=inheritanceType.joined）进行坏计数查询

Question

@Entity 
@Table(name = "SYS_ELEMENT") 
@Inheritance(strategy = InheritanceType.JOINED) 
@DiscriminatorColumn(name = "DTYPE", discriminatorType = DiscriminatorType.STRING, length = 63) @DiscriminatorValue("Element") 
@SQLDelete(sql = "UPDATE SYS_ELEMENT SET DELETED = 1, DELETED_ID = ID, DELETED_VERSION = VERSION WHERE ID = ? AND VERSION = ? ", check = ResultCheckStyle.COUNT) 
@Where(clause="DELETED = 0" ) 
public class Element extends EntityBase  { 
}

@Entity
@Table(name = "SYS_FORM")
@DiscriminatorValue("Form")
public class Form extends Element {
}

 Pageable pageable = PageRequest.of(0, 10);
 Page page = service.findByAll(pageable);

Hibernate: 
    /* select
        count(generatedAlias0) 
    from
        Form as generatedAlias0 */ select
            count(form0_.id) as col_0_0_ 
        from
            sys_form form0_ 
        where
            (
                form0_1_.DELETED = 0
            )
2020-07-09 21:23:10.123  WARN 22464 --- [nio-8080-exec-4] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 4104, SQLState: S0001
2020-07-09 21:23:10.123 ERROR 22464 --- [nio-8080-exec-4] o.h.engine.jdbc.spi.SqlExceptionHelper   : The multi-part identifier "form0_1_.DELETED" could not be bound.
could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
org.hibernate.exception.SQLGrammarException: could not extract ResultSet
[Ljava.lang.StackTraceElement;@748df19a

根据要求，这里有一个简单的示例：

• https://github.com/caiquebispoferreira/springdatajpa
• https://github.com/gtiwari333/hibernate-inherity-joined-with-where-bug（更简单的示例）

Answer 1

这是Hibernate的一个问题。

您现在可以尝试旧的hibernate版本5.4.4.final，或者等到5.4.19发布。请注意发布日期的下列项目。

• https://hibernate.atlassian.net/browse/hhh-14112
• https://in.relation.to/hibernate-orm/