Bug #20260 | mysqld crash on SELECT... LEFT JOIN... query | ||
---|---|---|---|
Submitted: | 4 Jun 2006 19:06 | Modified: | 7 Jun 2006 21:52 |
Reporter: | Vladimir Petrov | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.22 | OS: | Linux (RHEL) |
Assigned to: | Sveta Smirnova | CPU Architecture: | Any |
[4 Jun 2006 19:06]
Vladimir Petrov
[5 Jun 2006 8:02]
Sveta Smirnova
Thank you for a problem report. Could you please provide output of SHOW CREATE TABLE VB_forum; and SHOW CREATE TABLE VB_forumread;?
[5 Jun 2006 9:37]
Vladimir Petrov
SHOW CREATE TABLE VB_forum; +----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | VB_forum | CREATE TABLE `VB_forum` ( `forumid` smallint(5) unsigned NOT NULL auto_increment, `styleid` smallint(5) unsigned NOT NULL default '0', `title` varchar(100) NOT NULL default '', `title_clean` varchar(100) NOT NULL default '', `description` text, `description_clean` text, `options` int(10) unsigned NOT NULL default '0', `displayorder` smallint(6) NOT NULL default '0', `replycount` int(10) unsigned NOT NULL default '0', `lastpost` int(11) NOT NULL default '0', `lastposter` varchar(100) NOT NULL default '', `lastthread` varchar(250) NOT NULL default '', `lastthreadid` int(10) unsigned NOT NULL default '0', `lasticonid` smallint(6) NOT NULL default '0', `threadcount` mediumint(8) unsigned NOT NULL default '0', `daysprune` smallint(6) NOT NULL default '0', `newpostemail` varchar(250) NOT NULL default '', `newthreademail` varchar(250) NOT NULL default '', `parentid` smallint(6) NOT NULL default '0', `parentlist` varchar(250) NOT NULL default '', `password` varchar(50) NOT NULL default '', `link` varchar(200) NOT NULL default '', `childlist` varchar(250) NOT NULL default '', PRIMARY KEY (`forumid`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 | +----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ SHOW CREATE TABLE VB_forumread; +--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | VB_forumread | CREATE TABLE `VB_forumread` ( `userid` int(10) unsigned NOT NULL default '0', `forumid` smallint(5) unsigned NOT NULL default '0', `readtime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`forumid`,`userid`), KEY `readtime` (`readtime`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 | +--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
[7 Jun 2006 22:04]
Sveta Smirnova
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bugfix, yourself. More information about accessing the source trees is available at http://www.mysql.com/doc/en/Installing_source_tree.html
[7 Jun 2006 22:44]
Sveta Smirnova
I recreated crash in released version. Also I test against the last 5.0.23 sources and the bug does'nt exist there. Thank you for the help.