wzdlagrange edited a comment on issue #9294:
URL: https://github.com/apache/shardingsphere/issues/9294#issuecomment-772410586
> I have tested the subqueries of the example，not work in version 4.1.1.
Your reference, Duplicate with #8841
the subqueries is not contains sharding-table，
sharding-sphere parse it，finds that it does not need to be sharded, and
executes it as it is.
Why didn't he parse it in the first place?
Check whether the SQL statement contains a sharded table and then determine
whether to parse the table.
Similar to :
if(SQLString.contains(shardedTableName)){
return doSharding();
}else{
return doDefault();
}
If there are multiple sharding tables, contains each table once.
Maybe to be compatible with spaces or line breaks, use regular expressions
or other methods.
I want to know why not。
----------------------------------------------------------------
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:
[email protected]
