hhhcommon / tddl

Taobao Distributed Data Layer

tddl

Taobao Distributed Data Layer

tddl's Issues

广播表和分库分表查询问题

广播表a，分库不分表 tb_goods 拆分字段 member_id
数据库 icdb0,icdb1
icdb0 表 广播表 a

表 tb_goods

icdb1 表 tb_goods

explain
select * from a,tb_goods as b where a.id=b.id and b.member_id=35

+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+
| GROUP_NAME | SQL | PARAMS |
+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+
| MYSQL_ICDB_01 | Join
leftColumns:[A.ID]
rightColumns:[B.MEMBER_ID]
type:inner join
strategy:NEST_LOOP_JOIN
executeOn:MYSQL_ICDB_01
left:
Query from A as A
tableName:a
executeOn:MYSQL_ICDB_00
right:
Query from TB_GOODS as B
resultFilter:TB_GOODS.MEMBER_ID = 35
tableName:tb_goods
executeOn:MYSQL_ICDB_01
| NULL |
+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+
1 row in set (0.19 sec)

理论上应该 下推到 MYSQL_ICDB_01
执行 sql的，怎么会在 icdb0上查询a ，在icdb1上查询tb_goods, 然后再在tddl上join的呢