Description:
A subquery causes crash if used on an innodb type table more then 1 row.
I am just downloaded 5.0.0 alpha version (and 4.1 alpha also), unzipped, and started mysqld-nt.exe. I used Powerdesigner 9.5.2 to generate my simple database model. This tool by default automatically add "TYPE = INNODB" to create table statements. I was migrated some MSSQL script and encountered a server crash.
Because the same query works if I insert only 1 row into the table, or create the table without innodb type, I think any other settings must be right.
I checked this on 2 machines: Windows 2000 Prof and Windows XP prof, both hungarian version.
P.s: sorry about my english...
How to repeat:
/*************************************************************************
* Create a table without innodb type
* Insert at least 2 rows
* Use a subquery: it works
*************************************************************************
*/
drop table if exists test1;
create table test1 (test int);
insert into test1 (test) values (1);
insert into test1 (test) values (2);
select (select test from test1 where test=1) test from test1;
/*************************************************************************
* Create a table with innodb type
* Insert only 1 row
* Use a subquery: it works
*************************************************************************
*/
drop table if exists test2;
create table test2 (test int) type = INNODB;
insert into test2 (test) values (1);
select (select test from test2 where test=1) test from test2;
/*************************************************************************
* Create a table with innodb type
* Insert at least 2 rows
* Use a subquery: it do not works, crash the server
*************************************************************************
*/
drop table if exists test3;
create table test3 (test int) type = INNODB;
insert into test3 (test) values (1);
insert into test3 (test) values (2);
select (select test from test3 where test=1) test from test3;