java连接查询where_java – @Where子句在hibernate连接查询中不起...

我有2个@Where注释实体.第一个是分类;

@Where(clause = "DELETED = '0'")

public class Category extends AbstractEntity

它有以下关系;

@OneToMany(fetch = FetchType.LAZY, cascade = CascadeType.ALL, mappedBy = "category")

private Set subCategories = Sets.newHashSet();

第二个实体是SubCategory;

@Where(clause = "DELETED = '0'")

public class SubCategory extends AbstractEntity

并包含对应关系;

@ManyToOne(fetch = FetchType.LAZY)

@JoinColumn(name = "CATEGORY_ID")

private Category category;

每当我打电话给下面的Dao方法;

@Query(value = "select distinct category from Category category join fetch category.subCategories subcategories")

public List findAllCategories();

我得到了以下sql查询;

select

distinct category0_.id as id1_3_0_,

subcategor1_.id as id1_16_1_,

category0_.create_time as create2_3_0_,

category0_.create_user as create3_3_0_,

category0_.create_userip as create4_3_0_,

category0_.deleted as deleted5_3_0_,

category0_.update_time as update6_3_0_,

category0_.update_user as update7_3_0_,

category0_.update_userip as update8_3_0_,

category0_.version as version9_3_0_,

category0_.name as name10_3_0_,

subcategor1_.create_time as create2_16_1_,

subcategor1_.create_user as create3_16_1_,

subcategor1_.create_userip as create4_16_1_,

subcategor1_.deleted as deleted5_16_1_,

subcategor1_.update_time as update6_16_1_,

subcategor1_.update_user as update7_16_1_,

subcategor1_.update_userip as update8_16_1_,

subcategor1_.version as version9_16_1_,

subcategor1_.category_id as categor11_16_1_,

subcategor1_.name as name10_16_1_,

subcategor1_.category_id as categor11_3_0__,

subcategor1_.id as id1_16_0__

from

PUBLIC.t_category category0_

inner join

PUBLIC.t_sub_category subcategor1_

on category0_.id=subcategor1_.category_id

where

(

category0_.DELETED = '0'

)

你能告诉我为什么上面的查询缺乏

and subcategor1_.DELETED = ‘0’

在哪里挡？