2015-11-26, 11:13
Thought this had broken before... PR5007.
This restriction existed in v5.5, so not sure what has changed in 5.7 that makes it even more restrictive...
Edit: Here we go, query optimizer changed in 5.7.6... http://dev.mysql.com/doc/relnotes/mysql/...-optimizer
Quote:You cannot delete from a table and select from the same table in a subquery.
This restriction existed in v5.5, so not sure what has changed in 5.7 that makes it even more restrictive...
Edit: Here we go, query optimizer changed in 5.7.6... http://dev.mysql.com/doc/relnotes/mysql/...-optimizer