Bug 150416 - Add to the Release Notes info about the issue #Sample DB can't be created without InnoDB
Add to the Release Notes info about the issue #Sample DB can't be created wit...
Status: VERIFIED FIXED
Product: db
Classification: Unclassified
Component: MySQL
6.x
All All
: P1 (vote)
: TBD
Assigned To: David Vancouvering
issues@db
:
Depends on:
Blocks:
  Show dependency treegraph
 
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
:


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.


By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo