Bug #17468 MTK does not evaluate the VALID flag
Submitted: 16 Feb 2006 15:16 Modified: 18 Jun 2006 19:48
Reporter: Kristian Koehntopp Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S3 (Non-critical)
Version:1.0.23 OS:Microsoft Windows (Windows)
Assigned to: Michael G. Zinner CPU Architecture:Any

[16 Feb 2006 15:16] Kristian Koehntopp
Description:
In Oracle, views and other objects have a flag status in all_objects. MTK does not detect this valid, and does port all views, disregarding the state of the flag.

Currently, invalid objects must be deleted manually.

How to repeat:
Create views in Oracle that Oracle  marks as invalid, check all_objects.state.

Try to migrate them. Watch them being migrated with no annotation or message. The generated SQL will not work in MySQL, either.

Suggested fix:
When migrating, check all_objects.state for VALID. If object is not VALID, either do not select it for migration, or generate it commented out, or generate an additional comment on top of the object.
[17 Feb 2006 13:41] Valeriy Kravchuk
Thank you for a problem report.
[18 Jun 2006 19:48] Michael G. Zinner
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 bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html