Description:
MySQL 3.23.55 and 4.0.11 official Linux MAX binaries at least crash directly
with the following sql file:
bug.sql:
---------------------------------------------------------
DROP TABLE IF EXISTS t1, t2;
CREATE TABLE t1 (
id varchar(25) NOT NULL default '',
emp_id varchar(30) NOT NULL default '',
f2 varchar(10) default NULL,
UNIQUE KEY semp (id, emp_id),
KEY id (id)
) TYPE=MyISAM;
INSERT INTO t1 VALUES ('aaa','bbb','ccc');
INSERT INTO t1 VALUES ('aaa','ddd','ccc');
CREATE TABLE t2 (
id varchar(25) NOT NULL default '',
f2 varchar(10) NOT NULL default '',
f3 float NOT NULL default '0',
PRIMARY KEY (id, f2),
FULLTEXT KEY f2 (f2)
) TYPE=MyISAM;
INSERT INTO t2 VALUES ('aaa','ccc',20);
SELECT emp.f2, lr.f3
FROM t1 AS emp
LEFT JOIN t2 AS lr USING (id, f2)
WHERE emp.emp_id = 'bbb'
AND lr.id = 'aaa';
---------------------------------------------------------
How to repeat:
start server
mysql test < bug.sql
Suggested fix:
None yet. Debugging.
Description: MySQL 3.23.55 and 4.0.11 official Linux MAX binaries at least crash directly with the following sql file: bug.sql: --------------------------------------------------------- DROP TABLE IF EXISTS t1, t2; CREATE TABLE t1 ( id varchar(25) NOT NULL default '', emp_id varchar(30) NOT NULL default '', f2 varchar(10) default NULL, UNIQUE KEY semp (id, emp_id), KEY id (id) ) TYPE=MyISAM; INSERT INTO t1 VALUES ('aaa','bbb','ccc'); INSERT INTO t1 VALUES ('aaa','ddd','ccc'); CREATE TABLE t2 ( id varchar(25) NOT NULL default '', f2 varchar(10) NOT NULL default '', f3 float NOT NULL default '0', PRIMARY KEY (id, f2), FULLTEXT KEY f2 (f2) ) TYPE=MyISAM; INSERT INTO t2 VALUES ('aaa','ccc',20); SELECT emp.f2, lr.f3 FROM t1 AS emp LEFT JOIN t2 AS lr USING (id, f2) WHERE emp.emp_id = 'bbb' AND lr.id = 'aaa'; --------------------------------------------------------- How to repeat: start server mysql test < bug.sql Suggested fix: None yet. Debugging.