But it must be, according to the manual.
http://dev.mysql.com/doc/refman/5.0/en/delete.html
Here we can see
"USING table_references"
, and
"The table_references clause lists the tables involved in the join. Its syntax is described in Section 12.2.8.2, “JOIN Syntax”."
So follow to JOIN Syntax:
http://dev.mysql.com/doc/refman/5.0/en/join.html
"table_references:
table_reference [, table_reference] ...
table_reference:
table_factor
| join_table
table_factor:
tbl_name [[AS] alias] [index_hint]"
So, manual is wrong. Or implementation is wrong. It needs to change smth. Manual or code.
Right now I'm bypass this using Query rewrite technique similar to query rewrite plugin from 5.6. It's an ugly error fix (it just set full table name to all columns in query, if it see USING section), but this error is still present.