This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 150416

Summary: Add to the Release Notes info about the issue #Sample DB can't be created without InnoDB
Product: db Reporter: Roman Mostyka <romanmostyka>
Component: MySQLAssignee: David Vancouvering <davidvc>
Status: VERIFIED FIXED    
Severity: blocker CC: jbranam
Priority: P1    
Version: 6.x   
Hardware: All   
OS: All   
Issue Type: DEFECT Exception Reporter:
Attachments: Log file of NetBeans.

Description Roman Mostyka 2008-10-16 16:18:22 UTC
1. Start MySQL with MyISAM engine.
2. Register this MySQL in IDE.
3. Rightclick it and choose "Create Database".
4. Choose some sample DB and click "OK".

Result: DB is created, but script can't be executed since MyISAM engine. Look attached message.log for detailed exception.
Comment 1 Roman Mostyka 2008-10-16 16:22:04 UTC
Created attachment 72007 [details]
Log file of NetBeans.
Comment 2 Roman Mostyka 2008-10-16 16:38:57 UTC
Probably we can add this to release notes if it's too risky to fix.
Comment 3 David Vancouvering 2008-10-16 16:39:52 UTC
Our samples use foreign keys.  MyISAM doesn't support foreign keys.  So I believe the right solution here is to provide
a release note (and maybe update the Help files) to indicate that the samples require InnoDB.

Don't you need InnoDB for Sakila?  If not, we should see what they do differently.  I'll look at Sakila, and if there's
a clear approach that doesn't enforce use of InnoDB, I'll change things to use that.  Otherwise we should release note this.

I don't believe this is a P1 because the workaround is to use InnoDB.
Comment 4 Roman Mostyka 2008-10-16 16:40:07 UTC
And of course then have it fixed in Patch 1.
Comment 5 James Branam 2008-10-16 16:50:28 UTC
I have created a Release Note entry for this on nbstaging.

I will add it to the Help topic after FCS.
Comment 6 Roman Mostyka 2008-10-16 17:04:09 UTC
Verified.
Actually real problem wasn't fixed, so I've cahnged Subject of this issue and filed new one, but P2: #150422.
Comment 7 Roman Mostyka 2008-10-16 17:07:01 UTC
Verified.
Actually real problem wasn't fixed, so I've cahnged Subject of this issue and filed new one, but P2: #150422.