Hi!
I still can not reproduce your case.
I first ran this script:
create database xx;
use xx;
CREATE TABLE `t1` (
`titre` char(80) NOT NULL default '',
`numeropost` mediumint(8) unsigned NOT NULL auto_increment,
`ouvert` tinyint(1) unsigned NOT NULL default '1',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`auteur` char(35) NOT NULL default '',
`icone` tinyint(2) unsigned NOT NULL default '0',
`nbrep` mediumint(8) unsigned NOT NULL default '0',
`maxnumrep` int(10) unsigned NOT NULL default '0',
`vue` mediumint(8) unsigned NOT NULL default '0',
`lastauteur` char(35) NOT NULL default '',
`sondage` tinyint(1) NOT NULL default '0',
`next` int(10) NOT NULL default '0',
`prev` int(10) NOT NULL default '0',
`subcat` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`numeropost`),
KEY `date` (`date`),
KEY `maxnumrep` (`maxnumrep`),
KEY `auteur` (`auteur`),
KEY `sondage` (`sondage`),
KEY `subcat` (`subcat`)
) TYPE=MyISAM;
CREATE TABLE `t2` (
`mot` char(30) NOT NULL default '',
`numreponse` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`mot`,`numreponse`),
KEY `numreponse` (`numreponse`)
) TYPE=MyISAM ROW_FORMAT=FIXED;
CREATE TABLE `t3` (
`topic` mediumint(8) unsigned NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`pseudo` char(35) NOT NULL default '',
`numreponse` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`date`,`numreponse`,`topic`),
UNIQUE KEY `pseudo` (`pseudo`,`date`,`numreponse`,`topic`),
UNIQUE KEY `numreponse` (`numreponse`),
KEY `topic` (`topic`)
) TYPE=MyISAM ROW_FORMAT=FIXED;
INSERT INTO t1 (titre) VALUES ('test');
INSERT INTO t3 (topic,pseudo) VALUES (1,'joce');
INSERT INTO t2 (mot) VALUES
('test'),('joce'),('ouee');
Then I ran `mysqladmin shutdown`.
Then I ran this script :
use xx;
DELETE FROM t2,t3 USING t2 as a,t3 as
b,t1 as c WHERE b.numreponse=a.numreponse AND
b.topic=c.numeropost AND c.date<'2002-05-30';
I get 4 rows here
SELECT * FROM t2 as
a,t3 as b,t1 as c WHERE
b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-01-01'
LIMIT 0,30;
0 here .....
DELETE FROM t2,t3 USING
t2 as a,t3 as
b,t1 as c WHERE b.numreponse=a.numreponse AND
b.topic=c.numeropost AND c.date<'2002-05-30';
and 0 here ....
I ran latest mysqld 4.0.2 with these options:
--one-thread --datadir=/usr/local/var --skip-stack-trace --core-file
I also tried without --one-thread and still have got the above result.
Please check if I did something wrong.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
