Bug #46303 MySQL Query Browser throws Access Violation when attempting to execute a script

• Submitted: 20 Jul 2009 10:33
• Modified: 4 Sep 2009 7:24
• Reporter: The Assimilator
• Status: No Feedback
• Category: MySQL Query Browser
• Severity: S2 (Serious)
• Version: 1.2.17
• OS: Windows (XP Pro SP2)
• CPU Architecture: Any

[20 Jul 2009 10:33] The Assimilator

Description:
The attached error appears if I try to execute the attached script in the Query Browser multiple times in succession.

Also, running the attached script does not return any resultsets.

How to repeat:
Run the attached script multiple times in a MySQL Query Browser "Script" tab.

[20 Jul 2009 10:34] The Assimilator

Screenshot showing Access Violation

Attachment: query-browser.PNG (image/png, text), 9.67 KiB.

[20 Jul 2009 10:34] The Assimilator

Script to replicate issue

Attachment: tick-sheets.sql (application/octet-stream, text), 1.05 KiB.

[20 Jul 2009 10:36] The Assimilator

Host is running MySQL 5.0.45 under CentOS 5.2.

[20 Jul 2009 11:23] MySQL Verification Team

Thank you for the bug report. I couldn't repeat with the script attached just error messages that table doesn't exists. Please provide complete dump file of the tables involved. Thanks in advance.

[3 Aug 2009 10:13] The Assimilator

Feedback provided, please attempt to reproduce.

[4 Aug 2009 7:24] Valeriy Kravchuk

I've loaded your test database into MySQL 5.0.79 on Windows XP and executed the sript 10+ times in a row from QB 1.2.17 on the same XP. No access violations. So I suspect server is (part of) a problem here. Please, upgrade server and check again. Latest server version is 5.0.84.

[4 Sep 2009 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".