opteryx
opteryx copied to clipboard
subquery projects aren't removed
SELECT satellite_name FROM mission_reports
AFTER OPTIMIZATION
└─ EXIT
└─ PROJECT [satellite_name]
└─ PROJECT [satellite_name]
└─ NESTED_INNER JOIN ($view-ba42.id = $view-a06f.planetId)
├─ READ ($satellites AS $view-a06f) [planetId, name]
└─ READ ($planets AS $view-ba42) [id]