cloud-fan commented on code in PR #43614:
URL: https://github.com/apache/spark/pull/43614#discussion_r1386083113


##########
sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/analysis/CheckAnalysis.scala:
##########
@@ -156,7 +171,15 @@ trait CheckAnalysis extends PredicateHelper with 
LookupCatalog with QueryErrorsB
       // If a CTE relation is never used, it will disappear after inline. Here 
we explicitly check
       // analysis for it, to make sure the entire query plan is valid.
       try {
-        if (refCount == 0) checkAnalysis0(relation.child)
+        // If a CTE ref count is 0, the other CTE that is referencing it 
should also be
+        // checked by checkAnalysis0.
+        val visited: mutable.Map[Long, Boolean] = 
mutable.Map.empty.withDefaultValue(false)
+        cteMap.foreach { case(cteId, _) =>
+          val (_, refCount, _) = cteMap(cteId)
+          if (refCount == 0 && !visited(cteId) ) {

Review Comment:
   ```suggestion
             if (refCount == 0) {
   ```



-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to