EmmyMiao87 opened a new pull request #7824:
URL: https://github.com/apache/incubator-doris/pull/7824


   # Proposed changes
   
   Issue Number: close #7823
   
   After the subquery is rewritten, the rewritten stmt needs to be reset
   (that is, the content of the first analyze semantic analysis is cleared),
   and then the rewritten stmt can be reAnalyzed.
   
   The lateral view ref in the previous implementation forgot to implement the 
reset function.
   This caused him to keep the first error message in the second analyze.
   Eventually, two duplicate tupleIds appear in the new stmt and are marked 
with different tuple.
   From the explain string, the following syntax will have an additional wrong 
join predicate.
   ```
   Query: explain select k1 from test_explode lateral view explode_split(k2, 
",") tmp as e1  where k1 in (select k3 from tbl1);
   Error equal join conjunct: `k3` = `k3`
   ```
   
   This pr mainly adds the reset function of the lateral view
   to avoid possible errors in the second analyze
   when the lateral view and subquery rewrite occur at the same time.
   


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