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:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1 OS:Any (all)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[7 Apr 2004 6:25] Oleksandr Byelkin
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 
[7 Apr 2004 14:26] Oleksandr Byelkin
  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_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)
[18 Apr 2004 9:29] Oleksandr Byelkin