You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@shardingsphere.apache.org by fg0711 <fg...@126.com> on 2019/11/07 03:21:16 UTC
ss 4.0 RC2 版问题
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)
Re: ss 4.0 RC2 版问题
Posted by "zhangliang@apache.org" <zh...@apache.org>.
Hello, for english only, please translate the email.
------------------
Liang Zhang (John)
Apache ShardingSphere & Dubbo
fg0711 <fg...@126.com> 于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)
>
>