Cardinality error bug in MySQL-4.1

Hi,

With the latest bk tree, I encounter the following bug :

How-to-repeat :

CREATE TABLE `threadhardwarefr7` (
`numeropost` mediumint(8) unsigned NOT NULL default '0',
`icone` tinyint(2) unsigned NOT NULL default '0',
`numreponse` int(10) unsigned NOT NULL auto_increment,
`contenu` text character set latin1 NOT NULL,
`pseudo` varchar(35) character set latin1 NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`signature` tinyint(1) unsigned NOT NULL default '0',
`ip` int(10) unsigned NOT NULL default '0',
`edit` datetime NOT NULL default '0000-00-00 00:00:00',
`pedit` varchar(35) character set latin1 NOT NULL default '',
`realip` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`numeropost`,`numreponse`),
UNIQUE KEY `numreponse` (`numreponse`),
KEY `ip` (`ip`),
KEY `date` (`date`),
KEY `pseudo` (`pseudo`,`numeropost`)
) TYPE=MyISAM

CREATE TABLE `inscrit` (
`pseudo` varchar(35) character set latin1 NOT NULL default '',
`email` varchar(60) character set latin1 NOT NULL default '',
`nbrpost_forum` mediumint(8) unsigned NOT NULL default '0',
`image_forum` varchar(50) character set latin1 NOT NULL default '',
`password` varchar(50) character set latin1 NOT NULL default '',
`signature_forum` varchar(255) character set latin1 NOT NULL default '',
`icq` int(11) unsigned NOT NULL default '0',
`homepage` varchar(50) character set latin1 NOT NULL default '',
`dateinscr` date NOT NULL default '0000-00-00',
`hobby` varchar(50) character set latin1 NOT NULL default '',
`occupation` varchar(50) character set latin1 NOT NULL default '',
`status` tinyint(1) unsigned NOT NULL default '0',
`image` tinyint(1) unsigned NOT NULL default '0',
`mailv` tinyint(1) unsigned NOT NULL default '1',
`validation` tinyint(1) unsigned NOT NULL default '0',
`IP` int(11) unsigned NOT NULL default '0',
`citation` varchar(50) character set latin1 NOT NULL default '',
`ville` varchar(50) character set latin1 NOT NULL default '',
`smilies` tinyint(1) unsigned NOT NULL default '0',
`forum` tinyint(3) unsigned NOT NULL default '0',
`js` tinyint(1) unsigned NOT NULL default '0',
`configuration` tinyint(1) unsigned NOT NULL default '0',
`zlib` tinyint(1) unsigned NOT NULL default '1',
`nbr_sondage` tinyint(4) unsigned NOT NULL default '0',
`last_sondage` date NOT NULL default '0000-00-00',
`online` tinyint(1) unsigned NOT NULL default '1',
`topicpp` tinyint(2) unsigned NOT NULL default '0',
`smiliesperso` varchar(255) character set latin1 NOT NULL default '',
`lastpost` datetime NOT NULL default '0000-00-00 00:00:00',
`birthday` date NOT NULL default '0000-00-00',
`quote` tinyint(1) unsigned NOT NULL default '1',
`oldquote` tinyint(1) unsigned NOT NULL default '0',
`modomp` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`pseudo`),
UNIQUE KEY `email` (`email`),
KEY `validation` (`validation`),
KEY `forum` (`forum`),
KEY `status` (`status`),
KEY `birthday` (`birthday`)
) TYPE=MyISAM ROW_FORMAT=DYNAMIC

SELECT
inscrit.online,icone,contenu,threadhardwarefr7.pseudo,thread hardwarefr7.date
,numreponse,signature,INET_NTOA(threadhardwarefr7.ip),INET_N TOA(threadhardwa
refr7.realip),citation,image_forum,validation,icq,homepage,s ignature_forum,c
onfiguration,edit,pedit FROM threadhardwarefr7 LEFT JOIN inscrit USING
(pseudo) WHERE numeropost='187176' ORDER BY numreponse ASC LIMIT 159,41;

ERROR 1239: Cardinality error (more/less than 1400663656 columns)

Regards,
Jocelyn


------------------------------------------------------------ ---------
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 bugs-thread13268@lists.mysql.com
To unsubscribe, e-mail