You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/02/21 06:57:19 UTC
[GitHub] [incubator-shardingsphere] tristaZero opened a new issue #4397:
Join table SQL can not be rewritten correctly
tristaZero opened a new issue #4397: Join table SQL can not be rewritten correctly
URL: https://github.com/apache/incubator-shardingsphere/issues/4397
At present, SQL case below could not work well when using new parser, and the reason is that `ON t_order.order_id` is not managed.
```
<sql-case id="select_inner_join_related_with_name" value="SELECT t_order_item.* FROM t_order JOIN t_order_item ON t_order.order_id = t_order_item.order_id WHERE t_order.order_id = ?" />
```
Here is the excpetion,
```
org.h2.jdbc.JdbcSQLException: Column "t_order.order_id" not found; SQL statement:
SELECT t_order_item_0.* FROM t_order_0 JOIN t_order_item_0 ON t_order.order_id = t_order_item.order_id WHERE t_order_0.order_id = 1000 [42122-196]
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] tristaZero commented on issue #4397:
Join table SQL can not be rewritten correctly
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #4397: Join table SQL can not be rewritten correctly
URL: https://github.com/apache/incubator-shardingsphere/issues/4397#issuecomment-589619538
Ref #4390
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] tristaZero closed issue #4397: Join
table SQL can not be rewritten correctly
Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #4397: Join table SQL can not be rewritten correctly
URL: https://github.com/apache/incubator-shardingsphere/issues/4397
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services