Column 'status' in where clause is ambiguous

最新推荐文章于 2023-07-18 17:15:27 发布

iteye_8971

最新推荐文章于 2023-07-18 17:15:27 发布

阅读量2.3k

点赞数

分类专栏：异常大全文章标签： HQL 联表查询

本文链接：https://blog.csdn.net/iteye_8971/article/details/82651196

版权

异常大全专栏收录该内容

1 篇文章 0 订阅

订阅专栏

当你需要联表查询时，若两个表都有相同的字段是，需要为相同字段加上表别名
例如：相同字段：status ==》t.status 即可解决。
该异常出现的原因筛选联表查询，由于status直接封装到查询的实体中从而引发异常。可以让status前面添加表名重新拼装sql进行联表查询
异常如下：
org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [
select count(*) from (
    select info0_.id as id49_, info0_.infotype as infotype49_, info0_.title as title49_, info0_.subTitle as subTitle49_, info0_.content as content49_,
    info0_.type as type49_, info0_.createtime as createtime49_, info0_.publishtime as publisht8_49_, info0_.lastupdatetime as lastupda9_49_,
    info0_.views as views49_, info0_.lastViewTime as lastVie11_49_, info0_.remark as remark49_, info0_.icon as icon49_, info0_.summary as summary49_,
    info0_.source as source49_, info0_.ispoint as ispoint49_, info0_.important as important49_, info0_.support as support49_, info0_.oppose as oppose49_,
    info0_.status as status49_, info0_.sort as sort49_, info0_.sign as sign49_, info0_.keywords as keywords49_, info0_.iconintroduce as iconint24_49_,
    info0_.layouttype as layouttype49_, info0_.isreview as isreview49_, info0_.resourcestype as resourc27_49_, info0_.temp1 as temp28_49_,
    info0_.temp3 as temp29_49_, info0_.temp2 as temp30_49_, info0_.USERID as USERID49_, info0_.MEMBERID as MEMBERID49_ from T_INFO info0_,
    T_INFOANDCLASS infoandcla1_
    where info0_.id=infoandcla1_.infoid and infoandcla1_.classid=4 and status=? and resourcestype=? and (content like ?) and infotype=? and (source like ?) ) as a]
    ; Column 'status' in where clause is ambiguous;
    nested exception is com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column 'status' in where clause is ambiguous