[GitHub] [shardingsphere] wzdlagrange edited a comment on issue #9294: In 4.1.1, non-sharding-table SQL do not supported nested subquery,

[GitBox <gi...@apache.org>]

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:
users@infra.apache.org