in bigquery-antipattern-recognition/src/main/java/com/google/zetasql/toolkit/antipattern/parser/visitors/whereorder/IdentifyWhereOrderVisitor.java [28:39]
public void visit(ASTNodes.ASTWhereClause whereNode) {
if(whereNode.getExpression() instanceof ASTNodes.ASTAndExpr) {
CheckAndInWhereVisitor checkAndInWhereVisitor = new CheckAndInWhereVisitor(query);
whereNode.accept(checkAndInWhereVisitor);
if(checkAndInWhereVisitor.hasSuboptimalOrder()){
int lineNum = ZetaSQLStringParsingHelper.countLine(query, whereNode.getParseLocationRange().start());
result.add(String.format(WHERE_ORDER_SUGGESTION_MESSAGE, lineNum));
}
}
super.visit(whereNode);
}