MySQL Forums
Forum List  »  Optimizer & Parser

Re: mySQL 8 - view query not using outer predicate
Posted by: Jack Crawford
Date: January 11, 2021 02:06PM

Thanks but I don't think so.

I'm looking to have the predicate on the call to the outer query (the query that invokes the view) propagated to the view query.

This would allow me to change the predicates used to select records (in my client apps for example) while maintaining the same view (the same columns selected) across all uses of the view.

Without this propagation the temp table result is simply too large to be practical.

Options: ReplyQuote

Written By
Re: mySQL 8 - view query not using outer predicate
January 11, 2021 02:06PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.