>Description:
We've got a specific UPDATE that will cause:
>How-To-Repeat:
CREATE TABLE `t` (
`a` varchar(16) NOT NULL default '',
`b` smallint(6) NOT NULL default '0',
`c` datetime NOT NULL default '-00-00 00:00:00',
`d` smallint(6) NOT NULL default '0',
) TYPE=MyISAM;
INSERT INTO
>Description:
Under some pretty specific conditions, adding a "LIMIT" clause to a query
will cause incorrect results.
>How-To-Repeat:
This bug is NOT present in 4.0.3.
CREATE TABLE `history` (
`id_pic` int(11) unsigned NOT NULL auto_increment,
`id_cam` smallint(11) unsigned NOT NULL default
>Description:
A specific query in the format of:
SELECT DISTINCT a.*, b.* FROM privatemessage LEFT JOIN b ON (b.x = a.y);
Is causing a segfault. This worked fine in the 3.23 series.
>How-To-Repeat:
DROP TABLE IF EXISTS privatemessage;
CREATE TABLE privatemessage (
privatemessageid int(10)
