MySQL Bugs: #3411: incorrect tables presence check in multi-delete

Bug #3411	incorrect tables presence check in multi-delete
Submitted:	7 Apr 2004 6:25	Modified:	18 Apr 2004 9:29
Reporter:	Oleksandr Byelkin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.1	OS:	Any (all)
Assigned to:	Oleksandr Byelkin	CPU Architecture:	Any

Description:
incorrect tables presence check in multi-delete 
 
example return wrong error 

How to repeat:
create table t1 (a int, primary key (a)); 
create table t2 (a int, primary key (a)); 
create table t3 (a int, primary key (a)); 
 
delete t1,t3 from t1,t2 where t1.a=t2.a and t2.a=(select t3.a from t3 where 
t1.a=t3.a);

ChangeSet 
  1.1773 04/04/08 00:16:17 bell@sanja.is.com.ua +39 -0 
  new error for unsupported command in PS 
  fixed IN subselect with basic constant left expression 
  SQLCOM_CREATE_TABLE, SQLCOM_UPDATE_MULTI, SQLCOM_REPLACE_SELECT, 
SQLCOM_INSERT_SELECT, QLCOM_DELETE_MULTI fixed to be compatible with PS 
(BUG#3398, BUG#3406) 
  fixed multiupdate privelege check (BUG#3408) 
  fixed multiupdate tables check (BUG#3411) 
  unchecked commands now is rejected by PS protocol to avoid serever crash 
  fixed cleunup procedure to be compatible sith DO/SET (BUG#3393)

pushed