Shardingsphere 4.1.1 版本坑

SELECT
	COUNT(*)
FROM
	(
		SELECT
			XXX
		FROM
			XXX r
		LEFT JOIN YYY d ON r.id = d.resource_position_id
		AND d.tenant_code = '10001'
		WHERE
			1 = 1
		AND r.custom_id = ?
		AND r.is_deleted = 'N'
		AND r.tenant_code = '10001'
		GROUP BY
			r.id
	) TOTAL

 1、SelectStatementContext 初始化

    public SelectStatementContext(SelectStatement sqlStatement, GroupByContext groupByContext, OrderByContext orderByContext, ProjectionsContext projectionsContext, PaginationContext paginationContext) {
        super(sqlStatement);
        this.tablesContext = new TablesContext(sqlStatement.getSimpleTableSegments());
        this.groupByContext = groupByContext;
        this.orderByContext = orderByContext;
        this.projectionsContext = projectionsContext;
        this.paginationContext = paginationContext;
        this.containsSubquery = this.containsSubquery();
    }

2、注意

this.tablesContext = new TablesContext(sqlStatement.getSimpleTableSegments());

SelectStatement.java

public Collection<SimpleTableSegment> getSimpleTableSegments() {
        Collection<SimpleTableSegment> result = new LinkedList();
        Iterator var2 = this.tableReferences.iterator();

        while(var2.hasNext()) {
            TableReferenceSegment each = (TableReferenceSegment)var2.next();
            result.addAll(each.getTables());
        }

        return result;
    }

TableReferenceSegment.java

public Collection<Simp