对象中多个属性使用 @Join 且 关联同一张表时数据查询异常

[wu9007]

• SQL

SELECT
	TBL_DIC_BASIC.UUID,
	TBL_DIC_BASIC.TYPE_ID,
	TBL_DIC_BASIC.PARENT_UUID,
	TBL_DIC_BASIC.NAME,
	TBL_DIC_BASIC.SPELL,
	TBL_DIC_BASIC.CODE,
	TBL_DIC_BASIC.SYSTEM_CODE,
	TBL_DIC_BASIC.OPERATOR,
	TBL_DIC_BASIC.OPERATE_TIME,
	TBL_DIC_BASIC.MEMO,
	TBL_DIC_BASIC.SORT,
	TBL_DIC_BASIC.IS_LEAF,
	TBL_DIC_STATIC.NAME AS IS_LEAF,
	TBL_DIC_BASIC.IS_NEED_CHECK,
	TBL_DIC_STATIC.NAME AS IS_NEED_CHECK,
	TBL_DIC_BASIC.WARNING_DAYS,
	TBL_DIC_BASIC.IS_ENABLE,SELECT
	TBL_DIC_BASIC.UUID,
	TBL_DIC_BASIC.TYPE_ID,
	TBL_DIC_BASIC.PARENT_UUID,
	TBL_DIC_BASIC.NAME,
	TBL_DIC_BASIC.SPELL,
	TBL_DIC_BASIC.CODE,
	TBL_DIC_BASIC.SYSTEM_CODE,
	TBL_DIC_BASIC.OPERATOR,
	TBL_DIC_BASIC.OPERATE_TIME,
	TBL_DIC_BASIC.MEMO,
	TBL_DIC_BASIC.SORT,
	TBL_DIC_BASIC.IS_LEAF,
	TBL_DIC_STATIC.NAME AS IS_LEAF,
	TBL_DIC_BASIC.IS_NEED_CHECK,
	TBL_DIC_STATIC.NAME AS IS_NEED_CHECK,
	TBL_DIC_BASIC.WARNING_DAYS,
	TBL_DIC_BASIC.IS_ENABLE,
	TBL_DIC_STATIC.NAME AS IS_ENABLE,
	TBL_DIC_BASIC.IS_QUALIFIED,
	TBL_DIC_STATIC.NAME AS IS_QUALIFIED,
	TBL_DIC_BASIC.IS_DELETED 
FROM
	TBL_DIC_BASIC
	LEFT JOIN TBL_DIC_STATIC ON TBL_DIC_BASIC.IS_LEAF = TBL_DIC_STATIC.UUID
	LEFT JOIN TBL_DIC_STATIC ON TBL_DIC_BASIC.IS_NEED_CHECK = TBL_DIC_STATIC.UUID
	LEFT JOIN TBL_DIC_STATIC ON TBL_DIC_BASIC.IS_ENABLE = TBL_DIC_STATIC.UUID
	LEFT JOIN TBL_DIC_STATIC ON TBL_DIC_BASIC.IS_QUALIFIED = TBL_DIC_STATIC.UUID 
WHERE 1=1
	TBL_DIC_BASIC.IS_DELETED = ? 
	AND TBL_DIC_BASIC.TYPE_ID = ? 
	LIMIT 0,
	13
	TBL_DIC_STATIC.NAME AS IS_ENABLE,
	TBL_DIC_BASIC.IS_QUALIFIED,
	TBL_DIC_STATIC.NAME AS IS_QUALIFIED,
	TBL_DIC_BASIC.IS_DELETED 
FROM
	TBL_DIC_BASIC
	LEFT JOIN TBL_DIC_STATIC ON TBL_DIC_BASIC.IS_LEAF = TBL_DIC_STATIC.UUID
	LEFT JOIN TBL_DIC_STATIC ON TBL_DIC_BASIC.IS_NEED_CHECK = TBL_DIC_STATIC.UUID
	LEFT JOIN TBL_DIC_STATIC ON TBL_DIC_BASIC.IS_ENABLE = TBL_DIC_STATIC.UUID
	LEFT JOIN TBL_DIC_STATIC ON TBL_DIC_BASIC.IS_QUALIFIED = TBL_DIC_STATIC.UUID 

[wu9007]

#52 添加关联别名。