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 - Add to the Release Notes info about the issue #Sample DB can't be created without InnoDB
Summary: Add to the Release Notes info about the issue #Sample DB can't be created wit...
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: MySQL (show other bugs)
Version: 6.x
Hardware: All All
: P1 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-16 16:18 UTC by Roman Mostyka
Modified: 2008-10-16 17:07 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
Log file of NetBeans. (144.17 KB, text/plain)
2008-10-16 16:22 UTC, Roman Mostyka
Details

Note You need to log in before you can comment on or make changes to this bug.
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.