错误: 字段关联 “id“ 是不明确的

红太狼 2023-09-24 19:36 101阅读 0赞

## 1， 版本 ##

![在这里插入图片描述][739e3c3772ed4a5da126981fd4c2a274.png]

## 2，问题 ##

org.apache.ibatis.exceptions.PersistenceException: 
    ### Error querying database.  Cause: org.postgresql.util.PSQLException: 错误: 字段关联 "id" 是不明确的
      位置：331
    ### The error may exist in file [D:\ccs-fz\mm\mm-svc\target\classes\com\paas\mm\maper\ItemTypeConfigDetailMapper.map.xml]
    ### The error may involve defaultParameterMap
    ### The error occurred while setting parameters
    ### SQL: select       i.id,   d.type,  d.company_id,  d.item_type_code,  d.item_type_name,  d.item_type_name_enus,  i.ITEM_TYPE,   i.purchase_group,  i.cost_code,  i.cost_name            from mm_item_type_config_detail d      LEFT JOIN mm_item_type_config i      on d.item_type_code=i.ITEM_TYPE_CODE                WHERE 1=1           and id = ?                                                 and ( company_id like             (                'uuu'             ,                'bbbb'             ,                'uuuuu'             )               or company_id is null              )                                                                                                                and ACTIVE = 'Y' limit 10
    ### Cause: org.postgresql.util.PSQLException: 错误: 字段关联 "id" 是不明确的
      位置：331
    
    	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
    	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)

## 3，解决方法 ##

> 添加别名

![在这里插入图片描述][2cd9750c71854ddf9c14bfcca2dce54f.png]

[739e3c3772ed4a5da126981fd4c2a274.png]: https://img-blog.csdnimg.cn/739e3c3772ed4a5da126981fd4c2a274.png
[2cd9750c71854ddf9c14bfcca2dce54f.png]: https://img-blog.csdnimg.cn/2cd9750c71854ddf9c14bfcca2dce54f.png