MySQL Forums
Forum List  »  Views

Creating Views problem in 5.6/5.7
Posted by: Kavitha K P
Date: June 22, 2017 02:12PM


In mysql 5.5, I have created a view(slickval) that is created based on other two views(bslick,rslick) in the database . This slickval view has 13 columns . It is running fine in this version. I am copying the same view to a database which uses 5.6 version and the view is not working anymore . I am getting time out error. The same thing happens when I use 5.7 version.

In 5.6/5.7 mysql version, in the view if i reduce the number of columns from 13 to 10 the view runs fine. For some reason, it is not able to take 13 columns which is really odd .

Is there a limitation on the number of columns a view can have in 5.6/5.7 ?

Can someone pls assist ?


Options: ReplyQuote

Written By
Creating Views problem in 5.6/5.7
June 22, 2017 02:12PM

Sorry, you can't reply to this topic. It has been closed.

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.