[GitHub] [shardingsphere] fbin87 opened a new issue, #17068: big andPredicates collections where parse sql

[GitBox]

fbin87 opened a new issue, #17068:
URL: https://github.com/apache/shardingsphere/issues/17068

   when use sql with more where conditions in shardingsphere 4.1.1
   
   I found big collections in PredicateBuilder.mergePredicate()
   
![image](https://user-images.githubusercontent.com/42720240/164981853-875b5a48-229b-4f20-bbcc-6fbda622f22f.png)
   
   then SelectStatementContext.getAllTablesFromWhere() will take a lot of time 
to traverse AndPredicate object
   
   the sql is:
   static String SQL1 = "select * from model where id = 'a' and (name = 'a' or 
name ='b' or name ='b' or name ='b' or name ='b' or name ='b' or name ='b' or 
name ='b' or name ='b' or name ='b') and (age in (4,5,6,7,8) or height = '2' 
and (weight = 2 or weight = 2 or weight = 2 or weight = 2 or weight = 2 or 
weight = 2 or weight = 2 or weight = 2 or weight = 2 or weight = 2)) and (age 
in (4,5,6,7,8) or height = '2' and (weight = 2 or weight = 2 or weight = 2 or 
weight = 2 or weight = 2 or weight = 2 or weight = 2 or weight = 2 or weight = 
2 or weight = 2)) and (age in (4,5,6,7,8) or height = '2' and (weight = 2 or 
weight = 2 or weight = 2 or weight = 2 or weight = 2 or weight = 2 or weight = 
2 or weight = 2 or weight = 2 or weight = 2))";
   


-- 
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.

To unsubscribe, e-mail: 
notifications-unsubscr...@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org