使用嵌入式字段时Spring@Query jpql转换为本机sql无效

Question

给定以下类层次结构，我试图查询拥有对Charakter对象的依赖关系的CharacterDisposition。

@Entity
@Table(name = "CHARACTER_DISPOSITION")
class CharacterDisposition{
    @OneToMany
    List<CharacterSlot> slots;
}

@Entity
@Table(name = "CHARACTER_SLOT")
class CharacterSlot{
    @Embedded
    SceneCharacter sceneCharacter;
}

@Embeddable
class SceneCharacter{
    @ManyToOne
    Charakter character;
}

我在spring存储库接口中使用以下jpql查询，

@Query("SELECT cd "
        + "FROM CharacterDisposition cd "
        + "JOIN CharacterSlot cs "
        + "WHERE cs.sceneCharacter.character = :character")
List<CharacterDisposition> findCharacterDispositionWithCharacterDependency(Charakter character);

select 
  characterd0_.id as id1_24_, characterd0_1_.scene_id as scene_id2_24_ 
from character_disposition characterd0_ 
    inner join character_slot characterd0_1_ on characterd0_.id=characterd0_1_.id 
    inner join character_slot characters1_ on where characters1_.character_id=?

Answer 1

尝试以下方法-

@Query("SELECT cd "
        + "FROM CharacterDisposition cd "
        + "JOIN cd.slots cs "
        + "WHERE cs.character = :character")