Bug #17465 View syntax translated incompletely
Submitted: 16 Feb 2006 15:09 Modified: 18 Jun 2006 21:05
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

[16 Feb 2006 15:09] Kristian Koehntopp 
Description:
The syntax for CREATE VIEW is
create view v (new1, new2, ...)
as
  select old1, old2, ... from t

Currently, MTK does not detect and generate the (new1, new2, ...) part if used. It needs to be added manually.

How to repeat:
In Oracle, create a view definition with aliases as shown, run MTK, see generated view definition. The generated view definiton is missing the (new1, new2, ...) part.

Suggested fix:
Detect this case, and translate properly.
[18 Jun 2006 21:05] 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