Bug #22485 access violation when executing delete query
Submitted: 19 Sep 2006 17:45 Modified: 23 Oct 2006 16:53
Reporter: Peter Lavin Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.3 beta OS:Windows (xp)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any
Tags: access violation, delete query

[19 Sep 2006 17:45] Peter Lavin 
Description:
When attempting a delete query of the following format:

DELETE FROM db.t1
WHERE db.t1.id
NOT IN
(SELECT db.t2.memberid
FROM db.t2);

The following error shows up on the status bar:

Access violation at address 0058ad2c in module 'mysqlquerybrowser.exe'. Read of address 00000024.

How to repeat:
Attempt a nested delete query.

Suggested fix:
Allow delete query.
[23 Oct 2006 16:53] Vladimir Kolesnikov 
Thank you for taking the time to report a problem.  Unfortunately you are not using a current version of the product you reported a problem with -- the problem might already be fixed. Please download a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions, please change the version on this bug report to the version you tested and change the status back to "Open".  Again, thank you for your continued support of MySQL.

Peter,

I cannot repro this on QB 1.2.4. If you can, please attach the sql dump.

Thanks.
[23 Oct 2006 16:54] Vladimir Kolesnikov 
Peter,

if you can repro it on 1.2.4 please specify also OS on which the tool is run.

Thanks.
[23 Oct 2006 17:53] Peter Lavin 
I cannot reproduce this error in version 1.2.4 beta.