in bigquery-antipattern-recognition/src/main/java/com/google/zetasql/toolkit/antipattern/parser/visitors/IdentifyInSubqueryWithoutAggVisitor.java [42:53]
public void visit(ASTInExpression node) {
if (!(node.getQuery() == null)) {
if (node.getQuery().getQueryExpr() instanceof ASTSelect) {
ASTSelect select = (ASTSelect) node.getQuery().getQueryExpr();
if ((!select.getDistinct()) && select.getGroupBy() == null) {
int lineNum = ZetaSQLStringParsingHelper.countLine(query, select.getParseLocationRange().start());
result.add(String.format(SUBQUERY_IN_WHERE_SUGGESTION_MESSAGE, lineNum));
}
}
}
super.visit(node);
}