Re: Multi-table delete is broken in MySQL 4.0.2

2002-11-01 Thread Alexei Dets
Hi! On Friday 01 November 2002 15:03, Jon Frisby wrote: > Why not just do: > DELETE FROM MyChannels; > DELETE FROM MyPackages; > > If you're concerned about atomicity, simply acquire a lock on both > tables at once first. Exactly, it was my concern. I'm not using MySQL tables with transaction sup

RE: Multi-table delete is broken in MySQL 4.0.2

2002-11-01 Thread Jon Frisby
xpected. > Tables are very simple: MyChannels contains two int columns, > MyPackages - just one int column. > > > >How-To-Repeat: > > >Fix: > > > >Submitter-Id: > >Originator: > >Organization: > > >M

Multi-table delete is broken in MySQL 4.0.2

2002-11-01 Thread adets
How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: none >Synopsis: Multi-table delete is broken in MySQL 4.0.2 >Severity: serious >Priority: high >Category: mysql >Class: sw-bug >Rel