Bug #83138 | Delete with CTE reports unknown column | ||
---|---|---|---|
Submitted: | 25 Sep 2016 9:55 | Modified: | 25 Sep 2016 11:02 |
Reporter: | Daniël van Eeden (OCA) | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
Version: | 8.0.0-labs-opt-log | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | cte |
[25 Sep 2016 9:55]
Daniël van Eeden
[25 Sep 2016 11:02]
Daniël van Eeden
Not a bug, the correct query is: with t1_ids as (select id from t1) delete from t1 using t1 inner join t1_ids using(id) where t1.id=t1_ids.id;