MySQL Bugs: #17468: MTK does not evaluate the VALID flag

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:	Windows (Windows)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

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.

Thank you for a problem report.

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