JPA项目,Encountered a duplicated sql alias

org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias

遇到重复的sql别名

在navicat里面直接使用*来查询全部没问题,但是在JPA中,如果表关联之后有重复字段是不允许的,需要给它们起别名

select stu.id as student_id,stu.name as student_name,
ter.id as teacher_id,ter.name as teacher_name
from student stu
left join teacher ter
on stu.teacher_id=ter.id