Hello, for english only, please translate the email. ------------------
Liang Zhang (John) Apache ShardingSphere & Dubbo fg0711 <[email protected]> 于2019年11月7日周四 下午5:57写道： > 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) > >
