* Davi Arnaut <davi@stripped> [07/10/08 16:57]:
> ChangeSet@stripped, 2007-10-08 08:38:07-03:00, davi@stripped +6 -0
> Bug#27525 table not found when using multi-table-deletes with aliases over several
> databas
>
1) There are two syntaxes of MULTI-DELETE:
DELETE <list> FROM <list> WHERE ...
and
DELETE FROM <list> USING <list> WHERE ...
Both should be fixed and covered with tests.
2) Ambiguous cases should be taken care of and covered with tests
(an error should be produced):
DELETE t1, t2 FROM db1.t1, db2.t1, t2, db2.t2 ...
3) Please also add tests that demonstrate the conflict resolution
between an assigned alias and a database name:
DELETE t1, db1.t1 FROM t2 as t1, db1.t1 -- ?
(the way the conflict is resolved should not change after
this patch).
Thanks,
--
-- Konstantin Osipov Software Developer, Moscow, Russia
-- MySQL AB, www.mysql.com The best DATABASE COMPANY in the GALAXY
