MySQL Bugs: #9519: Access violation at address 77C478C0 in module msvcrt.dll

Bug #9519	Access violation at address 77C478C0 in module msvcrt.dll
Submitted:	31 Mar 2005 11:01	Modified:	4 Apr 2005 5:18
Reporter:	David Wright	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	MySql Server 5.0.3	OS:	Windows (Windows XP Service Pack2)
Assigned to:		CPU Architecture:	Any

Description:
While adding a table through MySql Query Browser after hitting the execute button..after adding the new table via the "Create New Table" menu.

How to repeat:
The table to be created was... (VIA Query Browser 1.1.6 and MySql Server 5.0.3)

After re-running the query browser the table is visible but viewing the columns displays "could not fetch columns"

CREATE TABLE `stock`.`InvestorAnalysis` (
  `InvestorId` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `Profit` DOUBLE(7,2) UNSIGNED ZEROFILL COMMENT 'Positive value of profits made',
  `Loss` DOUBLE(7,2) ZEROFILL UNSIGNED COMMENT 'Positive value of losses made',
  `DateCounter` SMALLINT UNSIGNED ZEROFILL NOT NULL,
  `Year` SMALLINT UNSIGNED ZEROFILL NOT NULL,
  `Active` ENUM('Yes','No') NOT NULL COMMENT '0 = Trade Day, !0 = Not a Trade Day',
  `TradeMade` ENUM('Yes','No') NOT NULL COMMENT '0 = No Trade, !0 = Trade Made',
  `BestTradeId` BIGINT UNSIGNED,
  `WorstTradeId` BIGINT UNSIGNED,
  `CounterType` ENUM('Y','M','W','D') NOT NULL COMMENT 'Y = Year, M = Month, W = Week, D = Days',
  `Gain` DOUBLE(8,2) NOT NULL COMMENT 'Signed value of overall trade results',
  PRIMARY KEY(`InvestorId`)
)
TYPE = InnoDB;

Suggested fix:
I give up on MySql. These simple features do not work what lies further under the hood. Maybe it works better under Linux? 

I have a legal version of SQL Server 2000 but I need to develop under Windows 2003 Server. Oh - well - looks like I am installing 2003 Server...

Hi,

I was unable to repeat this bug.  Can you give me step by step instructions on how to reproduce it ?

Thanks

1. Windows XP Professional.
2. Service Pack 2.
3. MySql Server 5.0.3 beta installed and service running.
4. Install MySql Query Browser 1.1.6
5. I Have no other databases except what is there after installation.
6. I created a database called 'stock'
7. I created 2 tables in the new 'stock' database via the Query Browser GUI.
8. The third table I entered is detailed in previous comments. I manually created the third table again via the Query Browser GUI.
9. Hit the 'Apply Changes' button.
10. Confirm Table edit popup appears with Create Table script as attached.
11. Hit the 'Execute' button.
12. The 'crash' occured in mysqld-nt.exe as specified and program closed after closing message box.

Downloaded latest Query Browser 1.1.7.

Tried to re-create the table via script that I saved after editing. The query browser crashes. 

If I remove all the *enum* declarations the table is created successfully.??

Probably a duplicate of #9526.