After upgrading from spring boot 1.5.3-RELEASE to 2.7.16, the query generated by hibernate is different than before and the application is not working as expected.
The method findAllByAccessPlantsSet_AccessPlantKey_Plant_PlantIdIn is working properly in spring boot 1.5.3-RELEASE but not working in 2.7.16
Second generated query is worng. How to fix this issue ?
Below is the code
public interface UserPagingAndSortingRepository extends PagingAndSortingRepository<User, Integer> {
Page<User> findAllByAccessPlantsSet_AccessPlantKey_Plant_PlantIdIn(List<Long> plantIds, Pageable pageParam);
}
@Entity
@Table(name = "RM_Users")
public class User extends BaseEntity {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "UserId")
@Access(value = AccessType.PROPERTY)
private Long userId;
@Column(name = "UserName")
private String userName;
@Column(name = "GroupId")
private Long groupId;
@Column(name = "EmailId")
private String emailId;
@Column(name = "FirstName")
private String firstName;
@Column(name = "LastName")
private String lastName;
@Column(name = "password")
@JsonIgnore
private String password;
@Column(name = "CountryId")
private Long countryId;
@Column(name = "Status")
private String status;
@Column(name = "PlantID")
private Integer defaultPlantId;
@ManyToMany(fetch = FetchType.EAGER, cascade = { CascadeType.MERGE }, targetEntity = Group.class)
@JoinTable(name = "RM_UserGroups", joinColumns = @JoinColumn(name = USER_ID, referencedColumnName = USER_ID), inverseJoinColumns = @JoinColumn(name = GROUP_ID, referencedColumnName = GROUP_ID))
@OrderBy("id asc")
private Set<Group> groups;
@OneToMany(mappedBy = "rmUser", fetch = FetchType.EAGER, cascade = CascadeType.ALL)
private Set<AccessPlant> accessPlantsSet;
@Column(name = "ERPReferenceID")
private String erpReferenceId;
@Column(name = "PersonalID")
private String personalId;
@Transient
private String defaultLanguage;
@Column(name = "AuthUserReferenceID")
private String authUserReferenceID;
/**setter and getter of the above fields**/
}
@Entity
@Table(name = "RM_AccessPlants")
public class AccessPlant extends BaseEntity {
private static final long serialVersionUID = -5392387870562061659L;
@EmbeddedId
private AccessPlantKey accessPlantKey;
@MapsId(value = "userId")
@ManyToOne
@JoinColumn(name = "UserID", referencedColumnName = "UserId", insertable = false, updatable = false)
private User rmUser;
/**getter and setter**/
@Embeddable
public static class AccessPlantKey implements Serializable {
private static final long serialVersionUID = 8734911584517266683L;
@Column(name = "UserID")
private Long userId;
@OneToOne
@JoinColumn(name = "PlantID")
private Plant plant;
/** getter and setter**/
}
}
@Entity
@Table(name = "Mstr_Plant")
public class Plant extends BaseEntity {
private static final long serialVersionUID = 1265334950544498967L;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "PlantID")
@Access(value = AccessType.PROPERTY)
private Long plantId;
@Column(name = "PlantCode")
private String plantCode;
@Column(name = "PlantName")
private String plantName;
/** getter and setter method**/
}
below is the properly generated query from spring boot 1.5.3-RELEASE , hibernate core 5.0.12.final and hibernate-jpa-2.1-api-1.0.0.Final
Hibernate:
select
TOP(?) user0_.UserId as UserId1_9_,
user0_.Euser as Euser2_9_,
user0_.LastUpdatedon as LastUpda3_9_,
user0_.AuthUserReferenceID as AuthUser4_9_,
user0_.CountryId as CountryI5_9_,
user0_.PlantID as PlantID6_9_,
user0_.EmailId as EmailId7_9_,
user0_.ERPReferenceID as ERPRefer8_9_,
user0_.FirstName as FirstNam9_9_,
user0_.GroupId as GroupId10_9_,
user0_.LastName as LastNam11_9_,
user0_.password as passwor12_9_,
user0_.PersonalID as Persona13_9_,
user0_.Status as Status14_9_,
user0_.UserName as UserNam15_9_
from
dbo.RM_Users user0_
left outer join
dbo.RM_AccessPlants accessplan1_
on user0_.UserId=accessplan1_.UserID
where
accessplan1_.PlantID in (
?
)
2023-11-14 15:40:21.963 [http-nio-8082-exec-3] INFO c.g.i.d.m.r.p.DataSourceMultiTenantConnectionProvider.selectDataSource(37) - [DataSourceMultiTenantConnectionProvider] TargetDataSource lookupKey : getmail.lt
Hibernate:
select
groups0_.UserId as UserId1_7_0_,
groups0_.GroupId as GroupId2_7_0_,
group1_.GroupId as GroupId1_4_1_,
group1_.Euser as Euser2_4_1_,
group1_.LastUpdatedon as LastUpda3_4_1_,
group1_.DefaultGroup as DefaultG4_4_1_,
group1_.DeptId as DeptId5_4_1_,
group1_.GroupCode as GroupCod6_4_1_,
group1_.GroupDesc as GroupDes7_4_1_,
group1_.GroupName as GroupNam8_4_1_,
group1_.PlantID as PlantID9_4_1_,
group1_.Status as Status10_4_1_
from
dbo.RM_UserGroups groups0_
inner join
dbo.RM_Group group1_
on groups0_.GroupId=group1_.GroupId
where
groups0_.UserId=?
order by
group1_.GroupId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessplan0_.UserID as UserID1_1_0_,
accessplan0_.PlantID as PlantID4_1_0_,
accessplan0_.PlantID as PlantID4_1_1_,
accessplan0_.UserID as UserID1_1_1_,
accessplan0_.Euser as Euser2_1_1_,
accessplan0_.LastUpdatedon as LastUpda3_1_1_,
plant1_.PlantID as PlantID1_0_2_,
plant1_.Euser as Euser2_0_2_,
plant1_.LastUpdatedon as LastUpda3_0_2_,
plant1_.PlantCode as PlantCod4_0_2_,
plant1_.PlantName as PlantNam5_0_2_
from
dbo.RM_AccessPlants accessplan0_
inner join
dbo.Mstr_Plant plant1_
on accessplan0_.PlantID=plant1_.PlantID
where
accessplan0_.UserID=?
Hibernate:
select
groups0_.UserId as UserId1_7_0_,
groups0_.GroupId as GroupId2_7_0_,
group1_.GroupId as GroupId1_4_1_,
group1_.Euser as Euser2_4_1_,
group1_.LastUpdatedon as LastUpda3_4_1_,
group1_.DefaultGroup as DefaultG4_4_1_,
group1_.DeptId as DeptId5_4_1_,
group1_.GroupCode as GroupCod6_4_1_,
group1_.GroupDesc as GroupDes7_4_1_,
group1_.GroupName as GroupNam8_4_1_,
group1_.PlantID as PlantID9_4_1_,
group1_.Status as Status10_4_1_
from
dbo.RM_UserGroups groups0_
inner join
dbo.RM_Group group1_
on groups0_.GroupId=group1_.GroupId
where
groups0_.UserId=?
order by
group1_.GroupId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessplan0_.UserID as UserID1_1_0_,
accessplan0_.PlantID as PlantID4_1_0_,
accessplan0_.PlantID as PlantID4_1_1_,
accessplan0_.UserID as UserID1_1_1_,
accessplan0_.Euser as Euser2_1_1_,
accessplan0_.LastUpdatedon as LastUpda3_1_1_,
plant1_.PlantID as PlantID1_0_2_,
plant1_.Euser as Euser2_0_2_,
plant1_.LastUpdatedon as LastUpda3_0_2_,
plant1_.PlantCode as PlantCod4_0_2_,
plant1_.PlantName as PlantNam5_0_2_
from
dbo.RM_AccessPlants accessplan0_
inner join
dbo.Mstr_Plant plant1_
on accessplan0_.PlantID=plant1_.PlantID
where
accessplan0_.UserID=?
Hibernate:
select
groups0_.UserId as UserId1_7_0_,
groups0_.GroupId as GroupId2_7_0_,
group1_.GroupId as GroupId1_4_1_,
group1_.Euser as Euser2_4_1_,
group1_.LastUpdatedon as LastUpda3_4_1_,
group1_.DefaultGroup as DefaultG4_4_1_,
group1_.DeptId as DeptId5_4_1_,
group1_.GroupCode as GroupCod6_4_1_,
group1_.GroupDesc as GroupDes7_4_1_,
group1_.GroupName as GroupNam8_4_1_,
group1_.PlantID as PlantID9_4_1_,
group1_.Status as Status10_4_1_
from
dbo.RM_UserGroups groups0_
inner join
dbo.RM_Group group1_
on groups0_.GroupId=group1_.GroupId
where
groups0_.UserId=?
order by
group1_.GroupId asc
Hibernate:
select
accessplan0_.UserID as UserID1_1_0_,
accessplan0_.PlantID as PlantID4_1_0_,
accessplan0_.PlantID as PlantID4_1_1_,
accessplan0_.UserID as UserID1_1_1_,
accessplan0_.Euser as Euser2_1_1_,
accessplan0_.LastUpdatedon as LastUpda3_1_1_,
plant1_.PlantID as PlantID1_0_2_,
plant1_.Euser as Euser2_0_2_,
plant1_.LastUpdatedon as LastUpda3_0_2_,
plant1_.PlantCode as PlantCod4_0_2_,
plant1_.PlantName as PlantNam5_0_2_
from
dbo.RM_AccessPlants accessplan0_
inner join
dbo.Mstr_Plant plant1_
on accessplan0_.PlantID=plant1_.PlantID
where
accessplan0_.UserID=?
Hibernate:
select
groups0_.UserId as UserId1_7_0_,
groups0_.GroupId as GroupId2_7_0_,
group1_.GroupId as GroupId1_4_1_,
group1_.Euser as Euser2_4_1_,
group1_.LastUpdatedon as LastUpda3_4_1_,
group1_.DefaultGroup as DefaultG4_4_1_,
group1_.DeptId as DeptId5_4_1_,
group1_.GroupCode as GroupCod6_4_1_,
group1_.GroupDesc as GroupDes7_4_1_,
group1_.GroupName as GroupNam8_4_1_,
group1_.PlantID as PlantID9_4_1_,
group1_.Status as Status10_4_1_
from
dbo.RM_UserGroups groups0_
inner join
dbo.RM_Group group1_
on groups0_.GroupId=group1_.GroupId
where
groups0_.UserId=?
order by
group1_.GroupId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
Hibernate:
select
accessrigh0_.GroupId as GroupId1_5_0_,
accessrigh0_.AccessId as AccessId2_5_0_,
accessrigh1_.AccessId as AccessId1_2_1_,
accessrigh1_.Euser as Euser2_2_1_,
accessrigh1_.LastUpdatedon as LastUpda3_2_1_,
accessrigh1_.AccessCode as AccessCo4_2_1_,
accessrigh1_.AccessName as AccessNa5_2_1_,
accessrigh1_.DefaultRight as DefaultR6_2_1_,
accessrigh1_.ModuleId as ModuleId7_2_1_
from
dbo.RM_GroupAccessRights accessrigh0_
inner join
dbo.RM_AccessRights accessrigh1_
on accessrigh0_.AccessId=accessrigh1_.AccessId
where
accessrigh0_.GroupId=?
order by
accessrigh1_.AccessId asc
The query generated by spring boot 2.7.16 and hibernate-core-5.6.15.Final is as below