Bug #22652 MySQL Administrator exits with error message
Submitted: 25 Sep 2006 5:26 Modified: 9 Oct 2006 15:04
Reporter: Slobodan Nemčev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S1 (Critical)
Version:1.2.3 rc OS:Windows (Windows XP SP2)
Assigned to: Mike Lischke CPU Architecture:Any

[25 Sep 2006 5:26] Slobodan Nemčev
Description:
When I try to edit table in database (only one table out of many tables in only one database out of seven databases), either by double clicking on it's name or by selecting it and clicking on "Edit Table" button, MySQL Administrator exits with the following error messages:

"** ERROR **: file source\myx_database_model.c: line 344: assertion failed: (!src[1] && !dst[i])
aborting..."

and

"Runtime Error!

Program: MySQLAdministrator.exe

This aplication has requested the Runtime to terminate it in an unusual way.
Please contact the aplication's support team for more information."

When I remove version 1.2.3 rc, reinstall an earlier version (ie 1.1.9) and try to open the same table, everything is ok.

How to repeat:
Try editing a table in MySQL Administator. For all the other tables Table Editor appears, for this particular table error message appears.

Suggested fix:
Reinstaling an earlier version of MySQL Administator
[25 Sep 2006 7:03] Sveta Smirnova
Thank you for the report.

Could you please provide output of SHOW CREATE TABLE statement for that particular table to error message appears.
[25 Sep 2006 23:03] MySQL Verification Team
Thank you for the bug report. Verfied trying to edit the table provided.
[26 Sep 2006 12:53] Mike Lischke
Test script with all necessary tables

Attachment: Test 20060926 1406.sql (application/octet-stream, text), 4.26 KiB.

[26 Sep 2006 13:03] Mike Lischke
I cannot repeat this problem, whatever I try. Maybe it has been fixed already. Please try again with the next release, which we plan to publish soon.
[26 Sep 2006 21:30] Slobodan Nemčev
I have restored the tables from the script supplied (http://bugs.mysql.com/file.php?id=4428) in the TEST database on the same MySQL Administrator which produced the error: I can edit the table 'stavke_na_racunima' in the TEST database, but trying to edit the same table in the original database produces the error?

I'll try with the (announced) new version and report the results...
[2 Oct 2006 8:15] Mike Lischke
Thank you Slobodan. I set the "need feedback" status so this bug entry is marked accordingly.
[4 Oct 2006 5:38] Slobodan Nemčev
I have downloaded and installed MySQLAdmin 1.2.4, but the same error is still there. However, editing the tables in the TEST database (which were created using the script provided here) produces no error.
[4 Oct 2006 6:32] Mike Lischke
Well, this sounds like something in the table DDL has changed that makes it editable. Could you please dump the entire schema (without data) and send the script to me (mikel@mysql.com)? I had to manually create other tables and might have this done differently than what you have.
[9 Oct 2006 15:04] Mike Lischke
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

PS: Slobodan, thank you for the special dump. It has helped me a lot to find the problem.