MySQL Forums
Forum List  »  MySQL Workbench

Forward Engineer fails due to View Create order
Posted by: Barry Canfield
Date: December 06, 2018 03:11PM

I have upgraded to 8.0 and am now getting a problem I have not noticed previously. When I forward engineer a schema it fails while creating one of the views. When I look at this the view is based on another view that is created later during forward engineering the database.

If I edit the code to move the View to a later position, after the View it is based upon it all works. I would expect Workbench to spot the problem and order the view creation so this didn't happen - I didn't get this issue at 5.7?

Is there a way to order the list of views so they are created in the correct order??


Options: ReplyQuote

Written By
Forward Engineer fails due to View Create order
December 06, 2018 03:11PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.