Re: mySQL 8 - view query not using outer predicate

[Jack Crawford]

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.