Nested query using two InnoDB tables causes "unhalted exception"

Hello,
I have got two tables (t1 and t2), both are InnoDB. Executing:
SELECT * FROM t1 WHERE c1 = (SELECT c2 from t2 where t2.c3='anything');
causes unhalted exception. It works fine for MyISAM tables.
Type of column (tested varchar and integer) has no meaning, as for me of
course.

I am using mysqld-nt from 4.1.1a-alpha binary package for win. I am
using windows XP proffesional SP1a (all major patches installed).
Error description is as follows (if any use):
Unhandled exception at 0x005789b5 in mysqld-nt.exe: 0xC0000005:
Access violation reading location 0x00000014.

--
£ukasz Artur Chróst (jid: lukost@jabber.atman.pl)

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Nested query using two InnoDB tables causes "unhalted exception"

=?ISO-8859-2=3FQ?=A3ukasz=5FChr=3DF3st?= writes:
> Hello,
> I have got two tables (t1 and t2), both are InnoDB. Executing:
> SELECT * FROM t1 WHERE c1 =3D (SELECT c2 from t2 where t2.c3=3D'a=
nything');
> causes unhalted exception. It works fine for MyISAM tables.
> Type of column (tested varchar and integer) has no meaning, as for me=
of=20
> course.
>=20
> I am using mysqld-nt from 4.1.1a-alpha binary package for win. I am=20=

> using windows XP proffesional SP1a (all major patches installed).
> Error description is as follows (if any use):
> Unhandled exception at 0x005789b5 in mysqld-nt.exe: 0xC0000005:=20=

> Access violation reading location 0x00000014.
>=20
> --
> =A3ukasz Artur Chr=F3st (jid: lukost@jabber.atman.pl)

Hi!

Thank you for writting to us.

We are very much interested in checking out this bug report.

In order to be able to repeat the bug, we need the tables invoved.=20

Please open a new bug at :

http://bugs.mysql.com

and upload your tables (or dump thereof) to the record itself.

If you can repeat the above bug with small tables, just send us a dump
with your next mail.

--=20

Sincerely,

--=20
For technical support contracts, go to https://order.mysql.com/=3Fref=3D=
msmi
__ __=5F __=5F ____ __
/ |/ /=5F __/ __/ __ \/ / Mr. Sinisa Milivojevic nisa@mysql.com>
/ /|=5F/ / // /\ \/ /=5F/ / /__ MySQL AB
/=5F/ /=5F/\=5F, /__=5F/\__=5F\=5F\__=5F/ Full time Deve=
loper and Support Coordinator
<__=5F/ www.mysql.com Larnaca, Cyprus

Meet the MySQL at User Conference ! (April 14-16, 2004)
http://www.mysql.com/uc2004/


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org