Nested query using two InnoDB tables causes 'unhalted exception'
Łukasz Chróst <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
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]) -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]