#sql

How to Work Around MySQL's View Subquery Limitation (Bug #11472)

MySQL's 20-year-old view subquery restriction (Bug #11472) finally has a reported fix. Here's how to refactor views with CTEs and nested views today.