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

Sinisa Milivojevic <[email protected]>
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <[email protected]>
=?ISO-8859-2?Q?=A3ukasz_Chr=F3st?= writes:
> 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: [email protected])

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. 

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.

-- 

Sincerely,

-- 
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Full time Developer and Support Coordinator
       <___/   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/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.