hi 亮哥，
具体问题如下： 执行sql SELECT * FROM t_ware_cg_base_info as ware,t_stock_a as stock WHERE ware.ware_inside_code=stock.ware_inside_code and ware.ware_inside_code=10051; 返回结果为空 sql日志 Logic SQL: select stock.*,ware.* from t_stock_a stock , t_ware_company_base_info ware where stock.ware_inside_code=ware.ware_inside_code [INFO ] 10:04:14.733 [ShardingSphere-Command-3] ShardingSphere-SQL - SQLStatement: ShardingSelectOptimizedStatement(tables=Tables(tables=[Table(name=t_stock_a, alias=Optional.of(stock)), Table(name=t_ware_company_base_info, alias=Optional.of(ware))], schema=Optional.absent()), groupBy=org.apache.shardingsphere.core.optimize.sharding.segment.select.groupby.GroupBy@36abb2de, orderBy=org.apache.shardingsphere.core.optimize.sharding.segment.select.orderby.OrderBy@648a429, selectItems=SelectItems(startIndex=7, stopIndex=20, distinctRow=false, items=[ShorthandSelectItem(owner=Optional.of(stock)), ShorthandSelectItem(owner=Optional.of(ware))], tables=[TableSegment(startIndex=27, stopIndex=35, name=t_stock_a, quoteCharacter=NONE, owner=Optional.absent(), alias=Optional.of(stock)), TableSegment(startIndex=45, stopIndex=68, name=t_ware_company_base_info, quoteCharacter=NONE, owner=Optional.absent(), alias=Optional.of(ware))]), pagination=org.apache.shardingsphere.core.optimize.sharding.segment.select.pagination.Pagination@4ebc9919, containsSubquery=false)
