Re: Cardinality error bug in MySQL-4.1

Hi!

On Fri, Dec 13, 2002 at 09:44:59AM -0000, Jocelyn Fournier wrote:
> 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)

Sorry, but I can't reproduce this on last bk repository.

--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
<___/ 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 bugs-thread13271@lists.mysql.com
To unsubscribe, e-mail