MULTI-DELETE BUG when used WITH TABLE ALIASES (ver. mysql-4.1.3-beta-standard)

2004-07-19 Thread Asim Thakker
Description: Multi-delete stops working in all forms when used along with table aliases, it gives an error saying ERROR 1109 (42S02): Unknown table 'test_base' in MULTI DELETE Which definately is NOT the case. After trying all kinds of combinations I reliased that the

Re: MULTI-DELETE BUG when used WITH TABLE ALIASES (ver. mysql-4.1.3-beta-standard)

2004-07-19 Thread Garth Webb
This is expected behavior for MySQL post version 4.1. Check out: http://dev.mysql.com/doc/mysql/en/DELETE.html particularly the 'Note:' section just before the user comments. If you use table aliases you must use those aliases to refer to the tables you want to delete, not the table names